1Z0-032
单选题The database is being restored from a closed backup. The data files， control files， password file， and parameter file are available， but the online redo logs are not. Because the online redo logs are not available， you must simulate recovery and alter
题目
until SCN
until time
until cancel
using backup control file
相似问题和答案
第1题：
You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus’ DATABASE filesperset = 2； Which components are included in the backup？（）
- A、Only the data files.
- B、Only the data files and the online logs.
- C、The data files， control files， and the online logs.
- D、The data files and control files， but not the online logs.
正确答案:D
第2题：
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（）
- A、 Database datafiles
- B、 Control files
- C、 Archived redo logs
- D、 Online redo logs
- E、 Flashback logs
正确答案:A,B,D
第3题：
A. Creating the control file for the duplicate database
B. Restoring the target data files to the duplicate database
C. Performing complete recovery using all available backups
D. Generating a new, unique DBID for the duplicate database
E. Copying the online redo log files from the target database to the duplicate database
第4题：
After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL> ALTER DATABASE OPEN； Which two statements are true（）
- A、The online redo log files and online data files are opened.
- B、All the online data file headers are checked for consistency.
- C、Instance recovery is performed before opening the database.
- D、The path and existence of all the log file members are checked
正确答案:A,B
第5题：
Which two file types must be included in a closed database backup taken with operating system commands？（）
- A、data files
- B、control file
- C、password file
- D、online redo log files
- E、initialization parameter file
正确答案:A,B
第6题：
You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement： SQL>ALTER DATABASE OPEN RESETLOGS； Which of the following options is true about using the RESETLOGS option？（）
- A、 The log sequence is reset to 0.
- B、 All the online redo logs are deleted.
- C、 All the archived redo logs from a previous incarnation become useless.
- D、 The full database backup taken from a previous incarnation can be used in future.
- E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.
正确答案:D
第7题：
After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）
- A、The online redo log files and online data files are opened.
- B、All the online data file headers are checked for consistency.
- C、Instance recovery is performed before opening the database.
- D、The path and existence of all the log file members are checked
正确答案:A,B
第8题：
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup. What would you do to recover the data file（）
- A、Take the USERS tablespace offline and re-create the lost data file.
- B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
- C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
- D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online
正确答案:C
第9题：
You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）
- A、All control files are opened
- B、All redo files are opened
- C、The password file is opened
- D、The parameter file is opened
- E、All online data files are opened
正确答案:B,E
第10题：
You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）
- A、 multiplexed control files
- B、 RMAN obsolete backups
- C、 multiplexed online redo log files
- D、 archived redo logs that have not been copied to tape
正确答案:B