using only the RMAN SWITCH command to set the new location for the data file
placing the database in the MOUNT state for the restore and recovery operations
using an RMAN RUN block with the SET NEWNAME and then the SWITCH command
configuring two channels: one for the restore operation and the other for the recovery operation
第1题:
The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager (RMAN) against your database: RMAN> REPORT OBSOLETE; What would you see in the output?()
第2题:
You administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()
第3题:
For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files?()
第4题:
A base catalog exists
The recovery catalog is empty
The base recovery catalog must be dropped
A target database is registered in the recovery catalog
第5题:
If the FORMAT option to the RMAN BACKUP command is specified, then RMAN creates backup pieces and image copies in the flash recovery area with names in the Oracle Managed Files (OMF) format.
If any local destinations for LOG_ARCHIVE_DEST_n are set, then archived redo logs are stored in these destinations as well as in the flash recovery area.
If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST initialization parameter, then the RMAN backup of Oracle managed datafiles (OMF) only will go to the flash recovery area by default.
If no other destination is configured for recovery files, then RMAN places the control file autobackups in the flash recovery area by default.
第6题:
back up the control file to trace
bring database to the MOUNT state
open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target database
set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
第7题:
a list of all those files that have been deleted in the last two days
a list of all those files that have been recovered within the last two days
a list of all the expired backups and copies
a list of backups and copies that are outside the range covered by the current retention policy
第8题:
stored scripts in the recovery catalog.
backups that can be deleted from disk.
backup sets and image copies are obsolete.
backups that do not have the AVAILABLE status in the RMAN repository.
第9题:
Stored scripts in the recovery catalog
Backups that can be deleted from disk
Backup sets and images copies that are obsolete
Backups that do not have the AVAILABLE status in the RMAN repository
第10题:
Stored scripts in the recovery catalog
Backups that can be deleted from disk
Backup sets and images copies that are obsolete
Backups that do not have the AVAILABLE status in the RMAN repository
第11题:
back up the control file to trace
bring database to the MOUNT state
open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target database
set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
第12题:
target database
auxiliary database
third-party database
recovery catalog database
第13题:
You want to implement the backup and recovery strategy in your database using Recovery Manager (RMAN). You have chosen the control file of the target database for the RMAN repository. Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication?()
第14题:
In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this: 1) Mount the database 2) Take the data file offline 3) Bring the data file online 4) Use the RMAN SWITCH TO command to switch the image copy 5) Apply the archived redo logs 6) Open the database 7) Use the RMAN RESTORE TO command to switch to the image copy Which two options illustrate the correct sequence of steps that you could follow?()
第15题:
You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?()
第16题:
2, 6, 4, 5, 3
1, 2, 4, 5, 3, 6
1, 2, 4, 6, 3
1, 2, 7, 5, 3, 6
第17题:
RMAN image copies.
RMAN database backups.
RMAN tablespace backups.
User-managed backups placed in the flash recovery area.
User-managed backups that have been cataloged with RMAN.
User-managed data file backups for which the pull path name is specified.
第18题:
backups that can be deleted
stored scripts in the recovery catalog
backup sets and image copies that are obsolete
only the most recent backup sets or image copies
backups that do not have the AVAILABLE status in RMAN repository
第19题:
Backup compression is disabled by default.
Backup compression can be used with both backup sets and image copies.
Backup compression cannot be enabled using the CONFIGURE command.
Backup compression works only if the COMPATIBILITY parameter is set to 9.0.0.0 or higher.
Backup compression applies to only backup sets.
Backup compression applies to only image copies.
第20题:
A base catalog exists
The recovery catalog is empty
The base recovery catalog must be dropped
A target database is registered in the recovery catalog
第21题:
stored scripts in the recovery catalog
backups that can be deleted from disk
backup sets and image copies are obsolete
backups that do not have the AVAILABLE status in the RMAN repository
第22题:
using only the RMAN SWITCH command to set the new location for the data file
placing the database in the MOUNT state for the restore and recovery operations.
using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.
configuring two channels: one for the restore operation and the other for the recovery operation
第23题:
2, 6, 4, 5, 3
1, 2, 4, 5, 3, 6
1, 2, 4, 6, 3
1, 2, 7, 5, 3, 6