随笔分类 - OCP恢复
摘要:Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOGmode? (Choose all that apply.)A. Database datafilesB. Cont
阅读全文
摘要:You have discovered that one of three control files has been lost. What steps would you follow to recover that control file?A. Shut down the database.
阅读全文
摘要:You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) and the database has crashed.What would be the appropriate order
阅读全文
摘要:Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which
阅读全文
摘要:Which of the following are true concerning block media recovery? (Choose all that apply.)A. Any gap in archive logs ends the recovery.B. If a gap in a
阅读全文
摘要:What RMAN command is used to execute a tablespace point-in-time recovery?A. recoverB. duplicateC. restoreD. copyE. None of the above You use the recov
阅读全文
摘要:When youre performing a tablespace point-in-time recovery, which tablespaces will always berestored to the auxiliary instance? (Choose all that apply.
阅读全文
摘要:What is the purpose of the recover command? (Choose all that apply.)A. Recover database datafiles from physical disk backup sets.B. Recover required i
阅读全文
摘要:What is the purpose of the until change option of the restore command?A. It allows you to select the SCN that you want to restore to. B. It allows you
阅读全文
摘要:While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount ofcorrupted data into the database. Pablo has discovered thi
阅读全文
摘要:You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:SQL> startup ORA-01078:
阅读全文
摘要:Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours.This is the only backup you have. You have lost all the ar
阅读全文
摘要:Which command is used to open the database after an incomplete recovery?A. alter database openB. alter database open repairlogC. alter database open r
阅读全文
摘要:You have lost datafiles 1 and 3 from your database, and the database has crashed. In what ordershould you perform the following steps to recover your
阅读全文
浙公网安备 33010602011771号