多选题You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP;  How does RMAN find the control file autobackup?()Aby using the trace fileBby using the alert log fileCby using the database IDDby using the server parameter fileEby using the V$CONTROLFILE viewFby using the autobackup format configuration setting

多选题
You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP;  How does RMAN find the control file autobackup?()
A

by using the trace file

B

by using the alert log file

C

by using the database ID

D

by using the server parameter file

E

by using the V$CONTROLFILE view

F

by using the autobackup format configuration setting


参考解析

解析: 暂无解析

相关考题:

In Recovery Manager (RMAN), you set the retention policy to NONE by executing the following command:  CONFIGURE RETENTION POLICY TO NONE;  What would be the impact of this setting?()A、The retention policy is cleared.B、RMAN does not consider any backup as obsolete.C、The retention policy is set to its default setting of redundancy 1.D、The retention policy is set to its default setting of recovery window 7.

In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command:  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically? ()A、a tablespace is taken offlineB、the database instance is restartedC、a new data file is added to an existing tablespaceD、a successful backup is recorded in the RMAN repositoryE、the RMAN connection is disconnected from the target database

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?()A、 a list of all those files that have been deleted in the last two daysB、 a list of all those files that have been recovered within the last two daysC、 a list of all the expired backups and copiesD、 a list of backups and copies that are outside the range covered by the current retention policy

You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? ()(Choose two.)A、The backup piece size will be limited to 300 MBB、The RMAN uses multiplexing to perform backupC、The operation is accomplished using the default channel availableD、The RMAN parallelizes the backup although the parallelism is not set for a channel

You defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by executing the following command:  RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;  When a backup is performed, what would be the status of this backup after seven days?()A、 The backup would be marked as invalid.B、 The backup would be marked as obsolete.C、 The backup would be removed from the media.D、 The backup would be removed from the RMAN repository.

You disabled the Flashback Database feature by using the following command:  SQL ALTER DATABASE FLASHBACK OFF;  What would be the effect of this command on the existing flashback logs?()A、 Flashback logs are not deleted.B、 Flashback logs are deleted automatically.C、 Flashback logs are deleted only if you are using Recovery Manager (RMAN)D、 Flashback logs are deleted only if you are using Oracle Manager Files (OFM)E、 Flashback logs are deleted only if you are using Automatic Storage Management (ASM)

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

It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()A、cannot be used in RMANB、by starting up the database againC、by using the CATALOG command of RMAND、by using the RECOVER CATALOG command in RMANE、by re-creating the target control file to rebuild the RMAN repository

You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP;   How does RMAN find the control file autobackup?()A、 By using the trace file.B、 By using the alert log file.C、 By using the database IDD、 By using the server parameter file.E、 By using the V$CONTROLFILE view.F、 By using the autobackup format configuration setting.

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?()A、 rman TARGET / NOCATALOGB、 rman TARGET sys/passwordC、 rman TARGET sys/password AS SYSDBAD、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

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?()A、 target databaseB、 auxiliary databaseC、 third-party databaseD、 recovery catalog database

You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP;  How does RMAN find the control file autobackup?()A、by using the trace fileB、by using the alert log fileC、by using the database IDD、by using the server parameter fileE、by using the V$CONTROLFILE viewF、by using the autobackup format configuration setting

You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()A、The backup status will be marked expired in RMAN recovery catalog.B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C、The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglD、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).E、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).

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.

You observe that the senior database administrator always uses the following command when connecting to Recovery Manager (RMAN), and then starts executing commands to backup the database files: % rman target / What would be the effect of this command?()A、 RMAN would use the current operating system location to place the backup.B、 RMAN would use the control file of the target database to maintain the backup.C、 RMAN would use the recovery catalog of the target database to maintain the backup.D、 RMAN would use the control file of the target database to maintain the backup metadata.E、 RMAN would use the recovery catalog of the target database to maintain the backup metadata.

多选题In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command:  RMAN RESTORE CONTROLFILE;  Which two operations do you need to perform after restoring the control file from backup?()Ashut down and restart the instanceBadd new tempfiles to the temporary tablespaces after recoveryCperform a media recovery and open the database with the RESETLOGS optionDperform a media recovery and bring the database to NOARCHIVELOG mode

多选题You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP;   How does RMAN find the control file autobackup?()ABy using the trace file.BBy using the alert log file.CBy using the database IDDBy using the server parameter file.EBy using the V$CONTROLFILE view.FBy using the autobackup format configuration setting.

单选题You executed the following command in Recovery Manager (RMAN):  RMAN RESTORE CONTROLFILE;  Which operation must you perform before this command is executed?()A back up the control file to traceB bring database to the MOUNT stateC open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target databaseD set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

多选题You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP;  How does RMAN find the control file autobackup?()Aby using the trace fileBby using the alert log fileCby using the database IDDby using the server parameter fileEby using the V$CONTROLFILE viewFby using the autobackup format configuration setting

多选题You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? ()(Choose two.)AThe backup piece size will be limited to 300 MBBThe RMAN uses multiplexing to perform backupCThe operation is accomplished using the default channel availableDThe RMAN parallelizes the backup although the parallelism is not set for a channel

单选题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?()A rman TARGET / NOCATALOGB rman TARGET sys/passwordC rman TARGET sys/password AS SYSDBAD rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

单选题You disabled the Flashback Database feature by using the following command:  SQL ALTER DATABASE FLASHBACK OFF;  What would be the effect of this command on the existing flashback logs?()A Flashback logs are not deleted.B Flashback logs are deleted automatically.C Flashback logs are deleted only if you are using Recovery Manager (RMAN)D Flashback logs are deleted only if you are using Oracle Manager Files (OFM)E Flashback logs are deleted only if you are using Automatic Storage Management (ASM)

单选题You observe that the senior database administrator always uses the following command when connecting to Recovery Manager (RMAN), and then starts executing commands to backup the database files: % rman target / What would be the effect of this command?()A RMAN would use the current operating system location to place the backup.B RMAN would use the control file of the target database to maintain the backup.C RMAN would use the recovery catalog of the target database to maintain the backup.D RMAN would use the control file of the target database to maintain the backup metadata.E RMAN would use the recovery catalog of the target database to maintain the backup metadata.

单选题You executed the following command in Recovery Manager (RMAN):  RMAN RESTORE CONTROLFILE;  Which operation must you perform before this command is executed?()Aback up the control file to traceBbring database to the MOUNT stateCopen a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target databaseDset the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

单选题It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()Acannot be used in RMANBby starting up the database againCby using the CATALOG command of RMANDby using the RECOVER CATALOG command in RMANEby re-creating the target control file to rebuild the RMAN repository

多选题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

单选题You defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by executing the following command:  RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;  When a backup is performed, what would be the status of this backup after seven days?()AThe backup would be marked as invalid.BThe backup would be marked as obsolete.CThe backup would be removed from the media.DThe backup would be removed from the RMAN repository.

单选题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?()A target databaseB auxiliary databaseC third-party databaseD recovery catalog database