To recover the PROD database, you need to apply a large number of archived logs. Which command would you issue to automatically apply the archived logs when the recovery process is started?
SET AUTORECOVERY ON; You can enable automatic recovery by issuing the SET AUTORECOVERY ON command. The redo log files must be in the location specified by the LOG_ARCHIVE_DEST initialization parameter. If you do not allow the Oracle Server to perform automatic recovery, you will be prompted for the redo log file names. It is recommended that you use the RECOVER command for media failure. • You are recovering from a disk failure with Recovery Manager and need to restore the dfuser02.df file in the USER_02 tablespace while the database is online. Which command should you issue after you allocate a channel and before you restore the datafile using the RUN command? SQL “ALTER TABLESPACE user_02 OFFLINE IMMEDIATE”; Before any restore or recovery operation can be done to a tablespace in a database that is online, the tablespace must be taken offline. The SQL option allows you to issue SQL commands within Recovery Manager.
Related Questions
- To recover the PROD database, you need to apply a large number of archived logs. Which command would you issue to automatically apply the archived logs when the recovery process is started?
- prior to every backup. This is the same issue faced by all large system designers: when, in what manner, and how often does the application need to have a database backup?
- How large can SecurityGateway message database get before performance becomes an issue?
