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 / uki
DB can be turned to archive log mode by turning the
LOGRETAIN parameter to RECOVERY and/or USEREXIT to YES. DB
will be in backup pending state which in turn requires to
be taken an offline backup to bring back the db to normal.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What purpose does the model database server? : sql server DBA
what are the performance views in an oracle rac environment?
What is the difference between dropping a database and taking a database offline? : sql server DBA
What is dcl? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
what is a user-defined lock?
what functionality does oracle provide to secure sensitive information?
Explain about your sql server dba experience? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the different types of indexes available in sql server? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is a correlated sub-query? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?