Can you take Online Backups if the the database is running
in NOARCHIVELOG mode?

5. How do you bring the database in ARCHIVELOG mode from
NOARCHIVELOG mode?

6. You cannot shutdown the database for even some minutes,
then in which mode you should run
the database?

Answer Posted / amit bhagat

6. The database should run in Archive log mode because you
cant take online if your database is running in No archive
log mode.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a system database and what is a user database? : sql server DBA

684


how can you find out if a table can be redefined?

686


what are the performance views in an oracle rac environment?

663


How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

1733


what is the use of recording information about current session?

656






What would you do with an "in-doubt" distributed transaction?

1494


Explain about your sql server dba experience? : sql server DBA

657


how can you implement fine-grained auditing?

687


what is ora 24313?what is the procedure to exclude that error?

2195


What are the different types of upgrades that can be performed in sql server? : sql server DBA

784


Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

1921


How can you control the amount of free space in your index pages? : sql server DBA

846


what is the last version,the release date of that version and fix pack of ibm db2 udb?

1598


What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

701


What is transparent data encryption? : sql server DBA

647