单项选择题

A. Open the database in NORMAL modeB. Open the database……

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database.
The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）

A. Open the database in NORMAL mode
B. Open the database in read-only mode
C. Open the database in RESTRICTED mode
D. Open the database with the RESETLOGS option

<上一题目录下一题>

热门试题

单项选择题In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN: Which statement is true about the outcome?（）

A. Only one channel is allocated and the backup is created in the flash recovery area
B. Only one channel is allocated and the backup is created in the destination specified for channel
C. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

多项选择题You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?（）

A. The backup as copy can only be taken to disk
B. The backup as copy can only be taken to tape
C. Backup can be performed only when the instance is shutdown
D. Backup will constitute all used and unused blocks in the database

单项选择题Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?（）

A. 2, 4, 3
B. 1, 4, 3, 2
C. 2, 5, 4, 3, 6
D. 5, 2, 4, 3, 6
E. 1, 5, 4, 3, 6, 2

多项选择题You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）

A. All the objects of scott are moved to the Recycle Bin.
B. Any objects in the Recycle Bin belonging to scott are purged.
C. All the objects owned by scott are permanently dropped from the database.
D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

单项选择题View the Exhibit and examine the Data Pump architecture. Identify the numbered components.（）

A. 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API
B. 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader
C. 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump
D. 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pump