要恢复一个丢失的数据文件,而归档重做日志文件已经损坏,DBA应该执行的命令是( )。
A: RECOVER DATABASE UNTIL CANCEL;
B: RECOVER TABLESPACE system UNTIL CANCEL;
C: RECOVER DATABASE UNTIL MISSING REDOLOG;
D: RECOVER DATABASE USING BACKUP CONTROLFILE;
A: RECOVER DATABASE UNTIL CANCEL;
B: RECOVER TABLESPACE system UNTIL CANCEL;
C: RECOVER DATABASE UNTIL MISSING REDOLOG;
D: RECOVER DATABASE USING BACKUP CONTROLFILE;
举一反三
- rman列出归档文件备份集的命令是（）？ A: list backup of archivelog all B: list backup of database C: report schema D: recover database
- Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? （） A: restore datafiles until time '09/28/2008:21:03:11' B: restore database files until time '09/28/2008:18:00:00' C: restore database until time '09/28/2008:18:00:00' D: recover database until time '09/28/2008:18:00:00' E: recover database until timestamp '09/28/2008:18:00:00'
- You need to restore your database back to 9/30/2008 at 18：00. In what order would you run the following commands to compete this task？（） a. restore controlfile until time `09/30/2008：18：00：00’ b. restore database until time `09/30/2008：18：00：00’ c. restore spfile until time `09/30/2008：18：00：00’ d. recover database until time `09/30/2008：18：00：00’ e. alter database open resetlogs f. alter database open A: b， d， e B: b， d， f C: c， a， b， d， e D: c， a， b， d， f E: a， b， d， e
- In user-managed backup and recover procedures， how are data files backed up？ （） A: Using SQL commands. B: Using SQL*Plus commands. C: Using operating system commands. D: Using Recover Manager commands.
- 备份整个数据库使用（ ）命令完成。 A: BACKUP TABLESPACE B: BACKUP DATABASE C: BACKUP TABLE D: RESTORE DATABASE