随笔分类 - OCP恢复
摘要:Which commands are used for RMAN database recovery? (Choose all that apply.)A. restoreB. repairC. copyD. recoverE. replace The restore command is used
阅读全文
摘要: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
阅读全文
摘要:You have created a script in the recovery catalog called backup_database. Which of the followingcommands would successfully execute that script?A. run
阅读全文
摘要: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
阅读全文
摘要:Which command do you use to create a recovery-catalog schema?A. create recovery catalogB. create catalogC. build catalogD. catalog createE. mount cata
阅读全文
摘要:What privileges must be granted to allow an account to create the recovery catalog? (Choose all thatapply.)A. RECOVERY_CATALOG_OWNERB. DBAC. RESOURCED
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:Upon starting your database, you receive the following error:SQL> startup ORACLE instance started.Total System Global Area 171581440 bytes Fixed Size
阅读全文
摘要: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
阅读全文
摘要:Which files are required for a full recovery of the database in ARCHIVELOG mode? (Choose three.)A. Database datafilesB. Online redo logsC. Archived re
阅读全文
摘要:What methods of point-in-time recovery are available? (Choose all that apply.)A. Change-basedB. Cancel-basedC. Time-basedD. Sequence number-basedE. Tr
阅读全文
浙公网安备 33010602011771号