随笔分类 - redo
摘要:The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?A.Inactive and cur
阅读全文
摘要:Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are bac
阅读全文
摘要:Which statement about recovering from the loss of a redo log group is true?A. If the lost redo log group is ACTIVE, you should first attempt to clear
阅读全文
摘要:The database is running in the ARCHIVELOG mode. It has three redo log groups with one membereach. One of the redo log groups has become corrupted. You
阅读全文
摘要:Your database is running in ARCHIVELOG mode.One of the data files,USERDATA01.dbf,inthe USERS tablespace is damaged and you need to recover the file un
阅读全文
摘要:You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 ='LO
阅读全文
摘要:A database has three online redo log groups with one member each. A redo log member with the status ACTICE is damages while the database is running.Wh
阅读全文
摘要:Which two statements are true about a duplicate database that is created by using the DUPLICATE command in RMAN? (Choose two.)A.It is a copy or a subs
阅读全文
摘要:Your database is using a default temporary tablespace that contains the temp01.tmp temporary file.All the users on the database use the default tempor
阅读全文
摘要:When performing a database duplication, which duplicate database parameter would you set toensure that the online redo logs are created in the correct
阅读全文
摘要:What is the result of this command? RMAN> Report need backup days 3;A. Lists all datafiles created in the last three days that are not backed up.B. Li
阅读全文
摘要:Which of the following does the recover command not do? A. Restore archived redo logs.B. Apply archived redo logs.C. Restore incremental backups.D. Ap
阅读全文
摘要:You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-fileautobackups. Which files are not backed up during the RMAN ba
阅读全文
摘要:Which is the correct command to back up the database, back up the archived redo logs, and thenremove the backed-up archived redo logs?A. backup databa
阅读全文
摘要: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 all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace com
阅读全文
摘要:Upon starting your database, you receive the following error:SQL> startup ORACLE instance started.Total System Global Area 171581440 bytes Fixed Size
阅读全文
摘要:Which files are required for a full recovery of the database in ARCHIVELOG mode? (Choose three.)A. Database datafilesB. Online redo logsC. Archived re
阅读全文
摘要:Which are the correct steps, in order, to deal with the loss of an online redo log if the database has not yet crashed?A. Issue a checkpoint.B. Shut d
阅读全文
摘要:As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your first action?A. Shut down the
阅读全文
浙公网安备 33010602011771号