多选题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?()AThe script is stored only in the control file.BThe script is stored only in the recover catalog.CThe script can be executed only by using the RMAN RUN command.DThe commands of the script can be displayed with the LIST command.EThe commands of the script can be displayed with the PRINT command.FThe commands of the script can be displayed with the REPORT command.

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


参考解析

解析: 暂无解析

相关考题:

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

In which scenario, will you issue the following command?() RMAN REPORT NEED BACKUP DAYS 7;A、 to configure RMAN to maintain backup information in the RMAN repository for seven daysB、 to configure RMAN to maintain backup information in the control file for at least seven daysC、 to display the list of files that have not been backed up for the last seven daysD、 to display the list of files that must be backed up within seven days

How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?()  A、 Issue the grant command from the SYS user (or equivalent) of the target database.B、 Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E、 Issue the grant command from RMAN when connected to the target database.

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?()A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile

What RMAN command must you use before you can back up a database using the recovery catalog?()A、 create catalogB、 install databaseC、 catalog databaseD、 merge Catalog with databaseE、 register database

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 are creating a recovery catalog for use with RMAN. You have issued these commands: SQL CREATE TABLESPACE rman_ts DATAFILE  ’/DISK1/rman_ts01.dbf’ 2 SIZE 20M 3 DEFAULT STORAGE (initial 100K next 100K pctincrease 0); SQL CREATE USER rman_db01 IDENTIFIED BY rman_db01 2 DEFAULT TABLESPACE rman_ts 3 QUOTA unlimited ON rman_ts;  Which command should you issue next?()A、RESYNC CATALOG;B、REGISTER DATABASE;C、CREATE CATALOG TABLESPACE rman_ts;D、GRANT recovery_catalog_owner TO rman_db01;

You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6:00 P.M. on Monday, you issue the following command:       RMANBACKUP DATABASE;  At 8:00 A.M. on Tuesday, you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP; command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP; command?()A、 Start the database in the MOUNT stage.B、 Back up the control file to trace.C、 Set the DBIDD、 Issue the RECOVER DATABASE command.

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 perform a backup using the following BACKUP command:   RMAN BACKUP AS COMPRESSED BACKUPSET DATABASE;   Which statement is true of this command?()  A、 A different procedure is required to restore a database from compressed backupsB、 The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed  backup sets and image copies.C、 Using this command to create backups minimizes the bandwidth consumedD、 Using this command to create backups improves the performance of the backup process

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

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.

单选题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.

单选题In which scenario, will you issue the following command?() RMAN REPORT NEED BACKUP DAYS 7;A to configure RMAN to maintain backup information in the RMAN repository for seven daysB to configure RMAN to maintain backup information in the control file for at least seven daysC to display the list of files that have not been backed up for the last seven daysD to display the list of files that must be backed up within seven days

单选题You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy:   CONFIGURE RETENTION POLICY TO REDUNDANCY 3;   Which statement is true?()A The command fails because you cannot configure a redundancy-based retention policy when backup  optimization is enabledB Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed upC Backup optimization is permanently disabledD Backup optimization is temporarily disabled because a redundancy-based retention policy is specified

单选题How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?()A Issue the grant command from the SYS user (or equivalent) of the target database.B Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.C Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E Issue the grant command from RMAN when connected to the target database.

单选题Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?()APlace the root container in ARHCHIVELOG mode.BTake the user data tablespace offline.CPlace the root container in the nomount stage.DEnsure that HR_PDB is open.

单选题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 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?()AThe script is stored only in the control file.BThe script is stored only in the recover catalog.CThe script can be executed only by using the RMAN RUN command.DThe commands of the script can be displayed with the LIST command.EThe commands of the script can be displayed with the PRINT command.FThe commands of the script can be displayed with the REPORT command.

单选题You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:   SQL startup ORA-01078: failure in processing system parameters LRM-00109:  could not open parameter file ,  C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN,   how would you respond to this error?()A Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.B Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.C Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.D Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.E Issue the restore spfile from autobackup command from the RMAN prompt.

单选题You perform a backup using the following BACKUP command: RMAN BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?()AA different procedure is required to restore a database from compressed backupsBThe AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.CUsing this command to create backups minimizes the bandwidth consumedDUsing this command to create backups improves the performance of the backup process

单选题You issue the following RMAN command to set a retention policy on a database: RMANCONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?()AAfter two days, a backup will be marked obsoleteBAfter two days, a backup will be deleted from the mediaCIf the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.DIf the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.

单选题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.

单选题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 enable block change tracking. You issue the following command:   BACKUP INCREMENTAL LEVEL 0 DATABASE;   The next day,you issue the following command:   BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;   Which statement about the use of the change tracking file is true?()A RMAN reads the block change tracking file only when it performs the incremental level 0 backup.B RMAN reads the block change tracking file when it performs both incremental backups.C RMAN reads the block change tracking file only when it performs the incremental level 1 backup.D RMAN does not read the block change tracking file when it performs either incremental backup.

单选题You are creating a recovery catalog for use with RMAN. You have issued these commands: SQL CREATE TABLESPACE rman_ts DATAFILE  ’/DISK1/rman_ts01.dbf’ 2 SIZE 20M 3 DEFAULT STORAGE (initial 100K next 100K pctincrease 0); SQL CREATE USER rman_db01 IDENTIFIED BY rman_db01 2 DEFAULT TABLESPACE rman_ts 3 QUOTA unlimited ON rman_ts;  Which command should you issue next?()ARESYNC CATALOG;BREGISTER DATABASE;CCREATE CATALOG TABLESPACE rman_ts;DGRANT recovery_catalog_owner TO rman_db01;

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

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