单选题Which step is required for recover from an instance failure? ()AStart up only.BRestore needed data files, then start up.CComplete restore from backup, then start up.DPerform point in time recovery, then start up.

单选题
Which step is required for recover from an instance failure? ()
A

Start up only.

B

Restore needed data files, then start up.

C

Complete restore from backup, then start up.

D

Perform point in time recovery, then start up.


参考解析

解析: 暂无解析

相关考题:

View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN REPAIR FAILURE;Which statement describes the consequence of the command?()A. The command performs the recovery and closes the failures.B. The command only displays the advice and the RMAN script required for repair.C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

A cluster script failed because it was unable to set the hostname, and the Cluster Manager reported the event failure. What must be done prior to sue the "HACMP Problem Determination Tools" - "Recover From Script Failure" to have the Cluster Manager resume cluster processing?()  A、 Nothing, the "Recover From Script Failure" will correct the issue.B、 Disable and re-enable the effected Ethernet adapter by using ifconfig.C、 Correct the error by setting the hostname on the effected node from the command line.D、 Verify that the clinfo daemon is running prior to executing the "recover from scriptfailure".

Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs. Which three steps should you perform to recover the control file and make the database fully operational?()A、Mount the container database (CDB) and restore the control file from the control file auto backup.B、Recover and open the CDB in NORMAL mode.C、Mount the CDB and then recover and open the database, with the RESETLOGS option.D、Open all the pluggable databases.E、Recover each pluggable database.F、Start the database instance in the nomount stage and restore the control file from control file auto backup.

Which step can be used to trap runtime script errors and recover gracefully?()A、Set  B、Call Subflow  C、On Exception Goto  D、Get Reporting Statistic

An administrator is attempting to recover from a power failure in the data center. Which of the following is the BEST way to recover the servers?()A、 Bring up the WINS server, the DNS server, then the web serverB、 Bring up the web server, the time clock server, then the DHCP serverC、 Bring up the backup tape server, the DNS server, then the web serverD、 Bring up the active directory server, the DNS server, then the web server

An administrator is reviewing the /tmp/hacmp.out after an unsuccessful fallover and notice that  the event stop_server PROD_DB failed.  Besides manually intervening,what step must be performed to return the cluster to a stable state?()  A、 Recover From HACMP Script Failure.B、 Release Locks Set By Dynamic Reconfiguration.C、 Rerun HACMP cluster verification and synchronization.D、 Restore HACMP configuration Database From Active Configuration.

When recovering from a disaster, the backup and restore operation you use is similar to the export/import configuration procedure, with one additional step. Which additional step must you take when recovering from a disaster?()A、A new WebSphere profile is required to restore the configuration.B、The restored system requires the IBM Tivoli Access Manager for e-business (TAMeb) JRTE to be manually configured against the WebSphere’s Java Runtime to allow the IBM Tivoli Federated Identity Manager (ITFIM) Runtime to function properly.C、The ITFIM Domain needs to be created manually within the Integrated Solution Console.D、The ITFIM Runtime instance needs to be re-registered with the TAMeb policy server by running the SvrSslCfg command.

You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation()A、The online redo log files and archived redo log files are required to accomplish the recovery.B、The uncommitted transaction will be committed at the next startup of the database instance.C、The uncommitted transaction is rolled back automatically at the next opening of the database.D、The DBA has to perform the recovery on the database to recover the uncommitted transaction

Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process?()A、 open the database with the RESTRICTED optionB、 open the database with the RESETLOGS optionC、 recover to the required SCN only that data file in which the error occurredD、 recover all the data files to the same system change number (SCN)

A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance?()A、Data PumpB、Oracle Net ManagerC、Oracle Enterprise ManagerD、Oracle Universal Installer (OUI)E、Database Configuration Assistant (DBCA)

In which scenario will you perform a user-managed incomplete recovery?()A、 when a table is dropped and stored in the Recycle BinB、when a table is dropped and purged from the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when you are required to view all the versions of a row of an existing table between a specific time period

What is the purpose of the recover command?() A、 Recover database datafiles from physical disk backup sets.B、 Recover required incremental backups from physical disk backup sets.C、 Recover required archived redo logs from physical disk backup sets.D、 Apply incremental backups to recover the database. E、 Apply archived redo logs to recover the database.

You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occurwhen a database instance is started and database is opened: 1. SGA is allocated. 2. Control file is read. 3. Redo log files are opened.4. Instance recovery is started. 5. Background processes are started. 6. Data file headers are checked for consistency. 7. Server parameter file or the initialization parameter file is read.  Which option has the correct order in which these steps occur()A、7, 1, 5, 2, 3, 6, 4B、1, 5, 7, 2, 3, 6; step 4 is not requiredC、7, 1, 5, 2, 3, 6; step 4 is not requiredThis document was downloaded from = http://www.amaderforum.comD、1, 2, 3, 5, 6, 4; step 7 is not required

多选题What is the purpose of the recover command?()ARecover database datafiles from physical disk backup sets.BRecover required incremental backups from physical disk backup sets.CRecover required archived redo logs from physical disk backup sets.DApply incremental backups to recover the database.EApply archived redo logs to recover the database.

单选题ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure.  Which statement is true in this situation()AThe online redo log files and archived redo log files are required to accomplish the recovery.BThe uncommitted transaction will be committed at the next startup of the database instance.CThe uncommitted transaction is rolled back automatically at the next opening of the database.DThe DBA has to perform the recovery on the database to recover the uncommitted transaction.

单选题A cluster script failed because it was unable to set the hostname, and the Cluster Manager reported the event failure. What must be done prior to sue the "HACMP Problem Determination Tools" - "Recover From Script Failure" to have the Cluster Manager resume cluster processing?()A Nothing, the Recover From Script Failure will correct the issue.B Disable and re-enable the effected Ethernet adapter by using ifconfig.C Correct the error by setting the hostname on the effected node from the command line.D Verify that the clinfo daemon is running prior to executing the recover from scriptfailure.

多选题Which three statements are true about database recovery operations?()ADamaged or lost data files are restored from backups.BRedo log file entries are used to roll forward the database.CUndo segments are used to roll back any uncommitted transactions.DTransactions that were active when the failure occurred are restarted.ETransactions that were active when the failure occurred are automatically committed during the recover procedure.

单选题When recovering from a disaster, the backup and restore operation you use is similar to the export/import configuration procedure, with one additional step. Which additional step must you take when recovering from a disaster?()AA new WebSphere profile is required to restore the configuration.BThe restored system requires the IBM Tivoli Access Manager for e-business (TAMeb) JRTE to be manually configured against the WebSphere’s Java Runtime to allow the IBM Tivoli Federated Identity Manager (ITFIM) Runtime to function properly.CThe ITFIM Domain needs to be created manually within the Integrated Solution Console.DThe ITFIM Runtime instance needs to be re-registered with the TAMeb policy server by running the SvrSslCfg command.

多选题A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance?()AData PumpBOracle Net ManagerCOracle Enterprise ManagerDOracle Universal Installer (OUI)EDatabase Configuration Assistant (DBCA)

单选题In which scenario will you perform a user-managed incomplete recovery?()A when a table is dropped and stored in the Recycle BinBwhen a table is dropped and purged from the Recycle BinC when you are required to recover an existing table to its previous stateD when you are required to view all the versions of a row of an existing table between a specific time period

单选题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 that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file()ATake the USERS tablespace offline and re-create the lost data file.BShut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.CShut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.DTake the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online

单选题The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery()AInactive and current redo log files are required to accomplish recovery.BOnline and archived redo log files are required to accomplish instance recovery.CAll redo log entries after the last checkpoint are applied from redo log files to data files.DAll redo log entries recorded in the current redo log file until the checkpoint position are applied to datafiles.

单选题An administrator is attempting to recover from a power failure in the data center. Which of the following is the BEST way to recover the servers?()A Bring up the WINS server, the DNS server, then the web serverB Bring up the web server, the time clock server, then the DHCP serverC Bring up the backup tape server, the DNS server, then the web serverD Bring up the active directory server, the DNS server, then the web server

单选题Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file()ATake the USERS tablespace offline and re-create the lost data file.BShut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.CShut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.DTake the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online.

单选题You used the IMMEDIATE option to shut down your database instance. Consider the steps that  mayoccur when a database instance is started and database is opened:  1:SGA is allocated.  2:Control file is read.  3:Redo log files are opened.  4:Instance recovery is started.  5:Background processes are started.  6:Data file headers are checked for consistency.  7:Server parameter file or the initialization parameter file is read.  Which option has the correct order in which these steps occur()A7,1,5,2,3,6,4B1,5,7,2,3,6;step 4 is not requiredC7,1,5,2,3,6;step 4 is not requiredD1,2,3,5,6,4;step 7 is not required

单选题An administrator is reviewing the /tmp/hacmp.out after an unsuccessful fallover and notice that  the event stop_server PROD_DB failed.  Besides manually intervening,what step must be performed to return the cluster to a stable state?()A Recover From HACMP Script Failure.B Release Locks Set By Dynamic Reconfiguration.C Rerun HACMP cluster verification and synchronization.D Restore HACMP configuration Database From Active Configuration.

单选题You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occurwhen a database instance is started and database is opened: 1. SGA is allocated. 2. Control file is read. 3. Redo log files are opened.4. Instance recovery is started. 5. Background processes are started. 6. Data file headers are checked for consistency. 7. Server parameter file or the initialization parameter file is read.  Which option has the correct order in which these steps occur()A7, 1, 5, 2, 3, 6, 4B1, 5, 7, 2, 3, 6; step 4 is not requiredC7, 1, 5, 2, 3, 6; step 4 is not requiredThis document was downloaded from = http://www.amaderforum.comD1, 2, 3, 5, 6, 4; step 7 is not required