RESTORE DATAFILE ’/DISK2/user_data01.dbf’
RESTORE DATAFILE ’/DISK3/user_data01.dbf’
SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’
SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’
第1题:
Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?()
A. Implement RMAN multiplexing
B. Set the DEBUG ON in the RMAN script
C. Specify the command ID in the RMAN script
D. Use a tag with the RMAN BACKUP command
第2题:
What does the minimize load database parameter mean when backing up a database?()
第3题:
A. Provide a password for the encryption
B. Set up an Oracle wallet for the encryption
C. No setup is required as it is a default encryption method
D. Both Oracle wallet and password must be set up for the encryption
第4题:
You configured the default backup device type as disk for RMAN backups. In your database,because of business requirements,you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. What must you set using the RMAN CONFIGURE command to achieve this?()
第5题:
Examine the following RMAN command: RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?()
第6题:
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).
第7题:
What does the output on this report indicate?() RMAN> report need backup; RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 Report of files with less than 1 redundant backups File #bkps Name 5 0 C:///ORACLE/ORADATA/ORCL/MY_DATA_01.DBF
第8题:
A. 4
B. 8
C. 7
D. 0
第9题:
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt: RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; After executing this command, in which of the following cases will RMAN make an auto-backup of the control file? ()
第10题:
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?()