随笔分类 - OCP恢复
摘要:You execute the following command to change the status of the SALES tablespace:SQL> ALTER TABLESPACE sales OFFLINE;Which statements describe the effec
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:You executed the following commands in an RMAN session for your database instance that hasfailures:RMAN> LIST FAILURE;After some time, you executed th
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:You are managing an Oracle Database 11g database. The database is open, and you plan to performRecovery Manager (RMAN) backups. Which three statements
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?A.Inactive and cur
阅读全文
摘要:You notice that the performance of the database has degraded because of frequent checkpoints.Which two actions resolve the issue? (Choose two.)A.Disab
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文