单选题Which statement about using RMAN stored scripts is true?()ATo create and execute an RMAN stored script, you must use a recovery catalog.BWhen executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.CRMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.DWhen you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

单选题
Which statement about using RMAN stored scripts is true?()
A

To create and execute an RMAN stored script, you must use a recovery catalog.

B

When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.

C

RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.

D

When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.


参考解析

解析: 暂无解析

相关考题:

Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?() A. You can use RMAN stored scriptsB. Recovery is faster if data is stored in catalog in addition to the control fileC. You can store backup information of all registered databases in one placeD. Database backups are automatically deleted when they are older than the specified time period

Examine the following set of RMAN commands:Which statement is true when the RMAN RUN block Is executed?() A. The execution of the script fails because multiple channels cannot coexist.B. The script is executed and both the channels are used for the script execution.C. The new channel, CHI, is Ignored because a channel has been configured already.D. ration parameter DC1 is overridden because a new channel is allocated in RMAN RUN block.

Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed?() A. stored scripts in the recovery catalogB. backups that can be deleted from diskC. backup sets and image copies are obsoleteD. backups that do not have the AVAILABLE status in the RMAN repository RMAN

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).

Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager (RMAN).()A、 You can use RMAN stored scripts.B、 Recovery is faster if data is stored in catalog in addition to the control file.C、 You can store backup Information of all registered databases in one place.D、 Database backups are automatically deleted when they are older than the specified time period.

Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed?()A、stored scripts in the recovery catalogB、backups that can be deleted from diskC、backup sets and image copies are obsoleteD、backups that do not have the AVAILABLE status in the RMAN repository RMAN

Which of the following commands must be issued to remove a stored script from the recovery catalog?()A、DELETE SCRIPTB、ERASE SCRIPTC、REMOVE SCRIPTD、UNCATALOG SCRIPT

Which statement is true regarding virtual private catalogs?()A、A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.B、The virtual private catalog owner cannot create and modify the stored scripts.C、The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.D、To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database

Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed?() (Choose two.)A、stored scripts in the recovery catalog.B、backups that can be deleted from disk.C、backup sets and image copies are obsolete.D、backups that do not have the AVAILABLE status in the RMAN repository.

You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script?()  A、 run { open script backup_database; run script backup_database }B、 run { engage script backup_database; }C、 run { run script backup_database; }D、 Run { execute script backup_database; }E、 The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.

Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMANrepository can be listed?()A、Stored scripts in the recovery catalogB、Backups that can be deleted from diskC、Backup sets and images copies that are obsoleteD、Backups that do not have the AVAILABLE status in the RMAN repository

You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()A、It is a SQL script.B、It is a PL/SQL file.C、It is an operating system (OS) file.D、It is a Recovery Manager (RMAN) script

Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMAN repository can be listed?()A、Stored scripts in the recovery catalogB、Backups that can be deleted from diskC、Backup sets and images copies that are obsoleteD、Backups that do not have the AVAILABLE status in the RMAN repository

Which statement about using RMAN stored scripts is true?()  A、 To create and execute an RMAN stored script,you must use a recovery catalog.B、 When executing a stored script and a command fails,the remainder of the script is executed,and a message is written to the alert log file.C、 RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D、 When you execute a stored script,it always executes using the persistent channel settings previously set with the CONFIGURE command.

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).

Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).()(Choose two.)A、You can use RMAN stored scriptsB、Recovery is faster if data is stored in catalog in addition to the control fileC、You can store backup information of all registered databases in one placeD、Database backups are automatically deleted when they are older than the specified time period

You issue this RMAN command:   RMAN create script Level0Backup {   backup   incremental level 0   format ‘/u01/db01/backup/%d_%_Sp’   fileperset 5   (database include current controlfile);   sql ‘alter database archive log current’;   }  Which three statements are true about the Level0Backup script you just created?()A、The script is stored only in the control file.B、The script is stored only in the recover catalog.C、The script can be executed only by using the RMAN RUN command.D、The commands of the script can be displayed with the LIST command.E、The commands of the script can be displayed with the PRINT command.F、The commands of the script can be displayed with the REPORT command.

Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMAN repository can be listed? ()A、backups that can be deletedB、stored scripts in the recovery catalogC、backup sets and image copies that are obsoleteD、only the most recent backup sets or image copiesE、backups that do not have the AVAILABLE status in RMAN repository

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

Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN).()A、 You can use RMAN stored scriptsB、 Recovery is faster if data is stored in catalog in addition to the control fileC、 You can store backup information of all registered databases in one placeD、 Database backups are automatically deleted when they are older than the specified time period

单选题Which statement about using RMAN stored scripts is true?()A To create and execute an RMAN stored script,you must use a recovery catalog.B When executing a stored script and a command fails,the remainder of the script is executed,and a message is written to the alert log file.C RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D When you execute a stored script,it always executes using the persistent channel settings previously set with the CONFIGURE command.

单选题You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script?()A run { open script backup_database; run script backup_database }B run { engage script backup_database; }C run { run script backup_database; }D Run { execute script backup_database; }E The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.

单选题Which statement about using RMAN stored scripts is true?()ATo create and execute an RMAN stored script, you must use a recovery catalog.BWhen executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.CRMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.DWhen you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

单选题Which script must you to query to display the code associated with RMAN stored scripts?()ARC_STORED_SCRIPTBRC_STORED_SCRIPT_LINECRC_SCRIPTSDRC_STORED_LINE_SCRIPTENone of the other alternatives apply

单选题Which statement is true regarding virtual private catalogs?()A A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.B The virtual private catalog owner cannot create and modify the stored scripts.C The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.D To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.

单选题Which of the following commands must be issued to remove a stored script from the recovery catalog?()ADELETE SCRIPTBERASE SCRIPTCREMOVE SCRIPTDUNCATALOG SCRIPT

单选题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 scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()AIt is a SQL script.BIt is a PL/SQL file.CIt is an operating system (OS) file.DIt is a Recovery Manager (RMAN) script