单选题Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）ARESTORE DATAFILE ’/DISK2/user_data01.dbf’BRESTORE DATAFILE ’/DISK3/user_data01.dbf’CSET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’DSET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’
单选题
Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）
A
RESTORE DATAFILE ’/DISK2/user_data01.dbf’
B
RESTORE DATAFILE ’/DISK3/user_data01.dbf’
C
SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’
D
SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’
参考解析
解析：
暂无解析
相关考题：
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?() A. Provide a password for the encryptionB. Set up an Oracle wallet for the encryptionC. No setup is required as it is a default encryption methodD. Both Oracle wallet and password must be set up for the encryption
View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process() A. 4B. 8C. 7D. 0
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 multiplexingB. Set the DEBUG ON in the RMAN scriptC. Specify the command ID in the RMAN scriptD. Use a tag with the RMAN BACKUP command
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).
What does the minimize load database parameter mean when backing up a database?（）A、RMAN will attempt to make the backup run as fast as possible without any IO limitations. B、RMAN will automatically restrict the number of channels in use to one. C、RMAN will spread the backup IO over the total duration stated in the backup command.D、RMAN will skip any datafile that currently is involved in an IO operation. RMAN will retry backing up the datafile later and an error will be raised at the end of the backup if the datafile cannot be backed up. E、Datafiles will be backed up; those having the lowest current number of IO operations will be backed up first.
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 A、 The my_data_01.dbf datafile is corrupted and needs to be restored.B、 The my_data_01.dbf datafile has not yet been backed up. This report does not imply that the data in the datafile can not be recovered.C、 The my_data_01.dbf datafile has not yet been backed up. This report implies that the data in the datafile can not be recovered.D、 The my_data_01.dbf datafile no longer meets the retention criteria for backups.E、 Datafile 5 is missing.
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？（）A、 Provide a password for the encryptionB、 Set up an Oracle wallet for the encryptionC、 No setup is required as it is a default encryption methodD、 Both Oracle wallet and password must be set up for the encryption
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？ （）A、 when you change the name of a datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block
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？（） A、 MAXSETSIZE TO 2B、 DEVICE TYPE DISK PARALLELISM 2C、 RETENTION POLICY TO REDUNDANCY 2D、 DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2
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？（）A、 2， 6， 4， 5， 3B、 1， 2， 4， 5， 3， 6C、 1， 2， 4， 6， 3D、 1， 2， 7， 5， 3， 6
You execute the following command to perform a backup by using Recovery Manager （RMAN）： RMAN run {allocate channel c1 type sbt; backup datafile 1; } The command errors out. A part of the error message is as follows： RMAN/x7f03009： failure of allocate command on c1 channel ORA/x7f19554： error allocating device， device type： SBT_TAPE， device name： What could explain why the statement failed？（）A、sbt is not a valid device type.B、Media Management Library was not loaded.C、The sbt device cannot be used for data file backups.D、No path was defined in the ALLOCATE CHANNEL command.E、The channel is currently being used by another RMAN session.
Given the script create script db_backup_datafile_script {backup datafile and 1， and2 plus archivelog delete input；} Run {execute script db_backup_datafile_script using 2；} What is the result of running this command？（） A、 The script will fail since you instructed RMAN to back up only one datafile rather than twoB、 The script will successfully back up datafile 3 without errorC、 The script will fail since it uses a substitution variable which is not supportedD、 The execute script command will prompt for the value of and2 since it’s not included in the commandE、 The script will fail because you cannot use the plus archivelog command when backing up
多选题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?（） (Choose two.)A2, 6, 4, 5, 3B1, 2, 4, 5, 3, 6C1, 2, 4, 6, 3D1, 2, 7, 5, 3, 6
多选题Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database. RMAN COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’； Which two statements are true regarding the backup created using this command？（）AThe copy of the datafile created is stored in the RMAN repository.BThe copy of the datafile created can be viewed using the LIST BACKUP command.CThe copy of the datafile created using this COPY command can be placed only on the disk.DThe copy of the datafile created is similar to the backup of the file created using the BACKUP command.EThe copy of the datafile created can be used for recovering the database using the user-managed recovery method.
单选题Examine this syntax which allocates channels during a parallel image copy： RMAN CONFIGURE DEVICE TYPE disk parallelism 4： 2 COPY 3 datafile 1 TO ‘/BACKUP/datafile1.dbf’， 4 datafile 2 TO ‘/BACKUP/datafile2.dbf’， 5 datafile 3 TO ‘/BACKUP/datafile3.dbf； RMANCOPY 2 datafile 4 TO ‘/BACKUP/datafile4.dbf’； How many channels are used？（）A0B1C3D4
单选题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?（）AProvide a password for the encryptionBSet up an Oracle wallet for the encryptionCNo setup is required as it is a default encryption methodDBoth Oracle wallet and password must be set up for the encryption
单选题Assume your situation can be described as follows： x A full backup taken using RMAN is available on disk. x The current control files were NOT damaged and do not need to be restored. x All data files are damaged or lost. x The database is in NOARCHIVELOG mode. Which RMAN command would be most appropriate to use in line 3 of the following RMAN command set to restore and fully recover your database？（） 1. RMAN STARTUP MOUNT 2. RMAN RESTORE DATABASE; 3. RMAN （） 4. RMAN ALTER DATABASE OPEN;ARECOVER DATABASE；BSWITCH DATAFILE ALL；CRESTORE CONTROL FILE；DRECOVER DATABASE USING BACKUP CONTROL FILE；
单选题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？（）A MAXSETSIZE TO 2B DEVICE TYPE DISK PARALLELISM 2C RETENTION POLICY TO REDUNDANCY 2D DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2
单选题What will be the end result of this set of RMAN commands？（） shutdown abort startup mount restore datafile 4 until time ，，09/30/2008：15：00：00； recover datafile 4 until time ，，09/29/2008：15：00：00； alter database open resetlogs；A Datafile 4 will be recovered until 9/30/2008 at 15：00 and the database will open.B The restore command will fail.C The recover command will fail.D The alter database open resetlogs command will fail.E All these commands will fail because they must be in the confines of a run block.
单选题Your database is in ARCHIVELOG mode. On Friday evening， you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager （RMAN） prompt and close the database. On Monday， the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles， HR1.DBF and HR2.DBF， both of which belong to a read/write tablespace named HR. The disk also contains a datafile， USERS.DBF， which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database， you issue the following RMAN commands： RMANRESTORE DATABASE； RMANRECOVER DATABASE； After successfully executing these RMAN commands， you issue the following statement using SQL*Plus： SQLALTER DATABASE OPEN； You receive the following errors when attempting to open the database： ORA-01157： cannot identify/lock data file 10 see DBWR trace file ORA-01110： data file 10： ’D:///USERS.DBF’ What is the cause of these errors？（）A The USERS.DBF datafile is corrupted and cannot be restored by RMAN.B The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.C The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.D The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.
单选题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.DBFA The my_data_01.dbf datafile is corrupted and needs to be restored.B The my_data_01.dbf datafile has not yet been backed up. This report does not imply that the data in the datafile can not be recovered.C The my_data_01.dbf datafile has not yet been backed up. This report implies that the data in the datafile can not be recovered.D The my_data_01.dbf datafile no longer meets the retention criteria for backups.E Datafile 5 is missing.
单选题Given the script create script db_backup_datafile_script {backup datafile and 1， and2 plus archivelog delete input；} Run {execute script db_backup_datafile_script using 2；} What is the result of running this command？（）A The script will fail since you instructed RMAN to back up only one datafile rather than twoB The script will successfully back up datafile 3 without errorC The script will fail since it uses a substitution variable which is not supportedD The execute script command will prompt for the value of and2 since it’s not included in the commandE The script will fail because you cannot use the plus archivelog command when backing up
单选题You issued the following commands to configure setting in RMAN; RMAN CONFIGURE DEVICE TYPE sbt PARALLELISM 1; RMAN CONFIGURE DEFAULT DEVICE TYPE TO sbt; RMAN CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2; Then you issued the following command to take the backup: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?（）AThe backup will terminate because the FORMAT clause was not configured for the channelBIt backs up two copies of data files to tape and disk, and two copies of archived log file on tapeCIt backs up the data files and archived log files to disk, making two copies of each data file and archived log fileDIt backs up the data files and archived log files to tape, making two copies of each data file and archived log file
多选题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？ （）Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block
多选题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？（）A2， 6， 4， 5， 3B1， 2， 4， 5， 3， 6C1， 2， 4， 6， 3D1， 2， 7， 5， 3， 6
单选题You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB. You issue the following command from the RMAN prompt to perform a backup of the tablespace： RMAN BACKUP TABLESPACE TS1 MAXSETSIZE 100M； Which statement is true about executing this command？（）A The command generates an error.B The command backs up the tablespace and creates a backup set of size 200 MBC The command backs up the tablespace and creates two backup sets of size 100 MB each.D The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.
多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile