随笔分类 -  OCP恢复

摘要:You execute the following command to change the status of the SALES tablespace:SQL> ALTER TABLESPACE sales OFFLINE;Which statements describe the effec 阅读全文
posted @ 2017-12-14 13:32 巴啦啦大魔王 阅读(141) 评论(0) 推荐(0) 编辑
摘要:You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occur when a database instance is started and database 阅读全文
posted @ 2017-12-12 16:55 巴啦啦大魔王 阅读(181) 评论(0) 推荐(0) 编辑
摘要:View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instance is already running. You used the following steps to sta 阅读全文
posted @ 2017-12-12 16:51 巴啦啦大魔王 阅读(121) 评论(0) 推荐(0) 编辑
摘要:After performing a clean shut down of the database instance for maintenance, you mount the database and then execute a command to open the database:SQ 阅读全文
posted @ 2017-12-12 16:39 巴啦啦大魔王 阅读(119) 评论(0) 推荐(0) 编辑
摘要:You executed the following commands in an RMAN session for your database instance that hasfailures:RMAN> LIST FAILURE;After some time, you executed th 阅读全文
posted @ 2017-12-11 13:55 巴啦啦大魔王 阅读(183) 评论(0) 推荐(0) 编辑
摘要:View the Exhibit to examine the error that occurred during the database startup. You opened an RMAN session for the database. To repair the failure, y 阅读全文
posted @ 2017-12-11 13:49 巴啦啦大魔王 阅读(234) 评论(0) 推荐(0) 编辑
摘要:Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)A.Recover from failures in the RAC environment.B.Diagnose and 阅读全文
posted @ 2017-12-11 13:29 巴啦啦大魔王 阅读(143) 评论(0) 推荐(0) 编辑
摘要:Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist?(Choose two.)A.failure when no standby database is config 阅读全文
posted @ 2017-12-11 13:25 巴啦啦大魔王 阅读(130) 评论(0) 推荐(0) 编辑
摘要:Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)A.The database files are corrupted when the database is 阅读全文
posted @ 2017-12-11 13:18 巴啦啦大魔王 阅读(140) 评论(0) 推荐(0) 编辑
摘要:You are managing an Oracle Database 11g database. The database is open, and you plan to performRecovery Manager (RMAN) backups. Which three statements 阅读全文
posted @ 2017-12-08 13:31 巴啦啦大魔王 阅读(149) 评论(0) 推荐(0) 编辑
摘要:Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice 阅读全文
posted @ 2017-12-08 13:22 巴啦啦大魔王 阅读(109) 评论(0) 推荐(0) 编辑
摘要:You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of your database to a new location. You want the Fla 阅读全文
posted @ 2017-12-08 11:16 巴啦啦大魔王 阅读(99) 评论(0) 推荐(0) 编辑
摘要: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 巴啦啦大魔王 阅读(96) 评论(0) 推荐(0) 编辑
摘要:You notice that the performance of the database has degraded because of frequent checkpoints.Which two actions resolve the issue? (Choose two.)A.Disab 阅读全文
posted @ 2017-12-08 10:42 巴啦啦大魔王 阅读(127) 评论(0) 推荐(0) 编辑
摘要:You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. T 阅读全文
posted @ 2017-12-07 18:04 巴啦啦大魔王 阅读(87) 评论(0) 推荐(0) 编辑
摘要:Given below is a list of scenarios:1) A user terminates his session abnormally.2) The connection between the server and the client application termina 阅读全文
posted @ 2017-12-07 17:59 巴啦啦大魔王 阅读(97) 评论(0) 推荐(0) 编辑
摘要:In which of the scenarios will the DBA perform recovery? (Choose all that apply.)A.The alert log file is corrupted.B.A tablespace is accidentally drop 阅读全文
posted @ 2017-12-07 15:30 巴啦啦大魔王 阅读(96) 评论(0) 推荐(0) 编辑
摘要:Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)A. The user has dropped an important table that needs to 阅读全文
posted @ 2017-11-17 10:21 巴啦啦大魔王 阅读(136) 评论(0) 推荐(0) 编辑
摘要:You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You alsohave a table named MY_TABLE in your schema. You execute t 阅读全文
posted @ 2017-11-16 16:57 巴啦啦大魔王 阅读(138) 评论(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 巴啦啦大魔王 阅读(136) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示