During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information?()
A V$LOGFILE
B V$RECOVER_LOG
C V$RECOVER_DATABASE
D V$LOG_RECOVER
E V$LOG
正确答案
答案解析
相似试题
(单选题)
What is true about this statement used during import?() imp hr/hr tables= (employee, departments) file=hr.dmp ignore=y
(单选题)
You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database. Which information is NOT required during the migration process?()
(单选题)
You are using Recovery Manager (RMAN) for backup and recovery operations. Your backup and recovery policy is such that you are performing full database backup every Tuesday and Friday. You configure RMAN using the following command: RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS; All backup and archived redo logs generated during the current week are as follows: Which of the following files will be listed when issuing the REPORT OBSOLETE command on Sunday? ()
(单选题)
During the installation of Oracle Database 11g,you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?()
(单选题)
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?()
(单选题)
The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery()
(多选题)
You are trying to recover your database. During the recovery process, you receive the following error: ORA-00279: change 5033391 generated at 08/17/2008 06:37:40 needed for thread 1ORA-00289: suggestion : /oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc ORA-00280: change 5033391 for thread 1 is in sequence #11 ORA-00278: log file ,,/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_10_4bj6wnqm_.arc no longer needed for this recovery Specify log: {=suggested | filename | AUTO | CANCEL} ORA-00308: cannot open archived log ,,/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 How do you respond to this error?()
(单选题)
You are installing Oracle Database 11g on your server. During the installation Oracle UniversalInstaller (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify anoperating system group name. Which statement is true in this case()
(单选题)
You executed this command to create a temporary table: SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddateDATE, class CHAR(20)) ON COMMIT PRESERVE ROWS; Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction()