随笔分类 -  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 阅读全文
posted @ 2017-11-08 17:58 巴啦啦大魔王 阅读(124) 评论(0) 推荐(0)
摘要: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. 阅读全文
posted @ 2017-11-08 17:55 巴啦啦大魔王 阅读(143) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-08 17:50 巴啦啦大魔王 阅读(119) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-08 17:30 巴啦啦大魔王 阅读(134) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-06 23:29 巴啦啦大魔王 阅读(128) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-06 18:10 巴啦啦大魔王 阅读(128) 评论(0) 推荐(0)
摘要:When youre performing a tablespace point-in-time recovery, which tablespaces will always berestored to the auxiliary instance? (Choose all that apply. 阅读全文
posted @ 2017-11-06 18:04 巴啦啦大魔王 阅读(112) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-06 17:36 巴啦啦大魔王 阅读(145) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-06 17:25 巴啦啦大魔王 阅读(117) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-06 17:20 巴啦啦大魔王 阅读(139) 评论(0) 推荐(0)
摘要:You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:SQL> startup ORA-01078: 阅读全文
posted @ 2017-11-06 17:06 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-06 16:17 巴啦啦大魔王 阅读(105) 评论(0) 推荐(0)
摘要:Which command is used to open the database after an incomplete recovery?A. alter database openB. alter database open repairlogC. alter database open r 阅读全文
posted @ 2017-11-06 16:11 巴啦啦大魔王 阅读(102) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-06 13:38 巴啦啦大魔王 阅读(111) 评论(0) 推荐(0)