随笔分类 -  OCP恢复

摘要:Which commands are used for RMAN database recovery? (Choose all that apply.)A. restoreB. repairC. copyD. recoverE. replace The restore command is used 阅读全文
posted @ 2017-11-10 14:07 巴啦啦大魔王 阅读(140) 评论(0) 推荐(0)
摘要:In what order would you execute the following steps to create a recovery catalog?A. Issue the create catalog command.B. Create the recovery-catalog da 阅读全文
posted @ 2017-11-10 12:28 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
摘要:You have created a script in the recovery catalog called backup_database. Which of the followingcommands would successfully execute that script?A. run 阅读全文
posted @ 2017-11-10 12:25 巴啦啦大魔王 阅读(80) 评论(0) 推荐(0)
摘要:If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated? (Choose all that 阅读全文
posted @ 2017-11-10 12:19 巴啦啦大魔王 阅读(84) 评论(0) 推荐(0)
摘要:Which command do you use to create a recovery-catalog schema?A. create recovery catalogB. create catalogC. build catalogD. catalog createE. mount cata 阅读全文
posted @ 2017-11-10 10:16 巴啦啦大魔王 阅读(107) 评论(0) 推荐(0)
摘要:What privileges must be granted to allow an account to create the recovery catalog? (Choose all thatapply.)A. RECOVERY_CATALOG_OWNERB. DBAC. RESOURCED 阅读全文
posted @ 2017-11-09 18:28 巴啦啦大魔王 阅读(96) 评论(0) 推荐(0)
摘要:What is the purpose of the RMAN recovery catalog? (Choose all that apply.)A. It must be used because all RMAN-related backup and recovery metadata inf 阅读全文
posted @ 2017-11-09 18:24 巴啦啦大魔王 阅读(85) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 16:31 巴啦啦大魔王 阅读(133) 评论(0) 推荐(0)
摘要:You are trying to recover your database. During the recovery process, you receive the following error:ORA-00279: change 5033391 generated at 08/17/200 阅读全文
posted @ 2017-11-09 16:27 巴啦啦大魔王 阅读(143) 评论(0) 推荐(0)
摘要:You have lost datafile 4 from your database.Which is typically the fastest way to restore your database?A. Restore and recover the datafile. B. Restor 阅读全文
posted @ 2017-11-09 16:21 巴啦啦大魔王 阅读(100) 评论(0) 推荐(0)
摘要:You have lost all your online redo logs. As a result, your database has crashed. You have tried to restart the database and clear the online redo log 阅读全文
posted @ 2017-11-09 16:14 巴啦啦大魔王 阅读(189) 评论(0) 推荐(0)
摘要:Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to theSYSTEM tablespace and two are assigned to the USERS tables 阅读全文
posted @ 2017-11-09 16:05 巴啦啦大魔王 阅读(137) 评论(0) 推荐(0)
摘要:What methods are available to recover lost control files? (Choose all that apply.)A. Backup control file.B. Emergency control file.C. The create contr 阅读全文
posted @ 2017-11-09 16:03 巴啦啦大魔王 阅读(127) 评论(0) 推荐(0)
摘要:Your developers have asked you to restore the development database, which is in NOARCHIVELOG mode, back to last Tuesday the 20th. Your last backup is 阅读全文
posted @ 2017-11-09 15:59 巴啦啦大魔王 阅读(159) 评论(0) 推荐(0)
摘要:You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace com 阅读全文
posted @ 2017-11-09 15:55 巴啦啦大魔王 阅读(115) 评论(0) 推荐(0)
摘要:A user sends you an email with the following error message: create table idtable(id number) *ERROR at line 1: ORA- 01110: data file 4: ,,/oracle01/ora 阅读全文
posted @ 2017-11-09 09:13 巴啦啦大魔王 阅读(111) 评论(0) 推荐(0)
摘要:Upon starting your database, you receive the following error:SQL> startup ORACLE instance started.Total System Global Area 171581440 bytes Fixed Size 阅读全文
posted @ 2017-11-08 18:29 巴啦啦大魔王 阅读(202) 评论(0) 推荐(0)
摘要:What is the proper procedure to recover a lost tempfile?A. Restore the backup copy of the tempfile from the backup media.B. Re-create the tempfile wit 阅读全文
posted @ 2017-11-08 18:19 巴啦啦大魔王 阅读(113) 评论(0) 推荐(0)
摘要:Which files are required for a full recovery of the database in ARCHIVELOG mode? (Choose three.)A. Database datafilesB. Online redo logsC. Archived re 阅读全文
posted @ 2017-11-08 18:15 巴啦啦大魔王 阅读(101) 评论(0) 推荐(0)
摘要:What methods of point-in-time recovery are available? (Choose all that apply.)A. Change-basedB. Cancel-basedC. Time-basedD. Sequence number-basedE. Tr 阅读全文
posted @ 2017-11-08 18:13 巴啦啦大魔王 阅读(136) 评论(0) 推荐(0)