随笔分类 -  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 阅读全文
posted @ 2017-12-08 10:44 巴啦啦大魔王 阅读(100) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-16 16:54 巴啦啦大魔王 阅读(107) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-16 16:27 巴啦啦大魔王 阅读(143) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 17:39 巴啦啦大魔王 阅读(83) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 17:20 巴啦啦大魔王 阅读(163) 评论(0) 推荐(0)
摘要:You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 ='LO 阅读全文
posted @ 2017-11-15 17:04 巴啦啦大魔王 阅读(89) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 14:12 巴啦啦大魔王 阅读(123) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 13:53 巴啦啦大魔王 阅读(145) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 13:52 巴啦啦大魔王 阅读(152) 评论(0) 推荐(0)
摘要:When performing a database duplication, which duplicate database parameter would you set toensure that the online redo logs are created in the correct 阅读全文
posted @ 2017-11-13 10:39 巴啦啦大魔王 阅读(69) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 18:19 巴啦啦大魔王 阅读(72) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 15:54 巴啦啦大魔王 阅读(102) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 14:53 巴啦啦大魔王 阅读(128) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-09 17:05 巴啦啦大魔王 阅读(108) 评论(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 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)
摘要: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)
摘要: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)
摘要: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 阅读全文
posted @ 2017-11-08 18:07 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-08 17:42 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)