多选题When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON, RMAN automatically performs a control file autobackup in which three situations?()AAt the end of every RUN block.BAfter every SET CONTROLFILE AUTOBACKUP FORMAT command.CAfter every BACKUP or COPY command issued at the RMAN prompt.DAt the end of every RUN block if the last command in the block was either BACKUP or COPY.EWhenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP nor COPY.FAfter every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT command.

多选题
When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON, RMAN automatically performs a control file autobackup in which three situations?()
A

At the end of every RUN block.

B

After every SET CONTROLFILE AUTOBACKUP FORMAT command.

C

After every BACKUP or COPY command issued at the RMAN prompt.

D

At the end of every RUN block if the last command in the block was either BACKUP or COPY.

E

Whenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP nor COPY.

F

After every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT command.


参考解析

解析: 暂无解析

相关考题:

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 SET CONTROLFILE AUTOBACKUP FORMAT command, which you can specify either within a RUN block or at the RMAN prompt, overrides the configured autobackup in the session only.  What is the order of precedence?() 1. SET within RUN  2. SET at RMAN prompt  3. CONFIGUREA、1,2,3 B、2,3,1 C、3,2,1 D、There is no precedence between RUN and the RMAN prompt. Each will override CONFIGURE in the session.

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 command would you issue to enable automated backups of control files?()  A、 alter database controlfile autobackup onB、 alter system controlfile autobackup onC、 configure controlfile autobackup onD、 enable controlfile autobackup

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 issued the following RMAN command:  RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;     What is NOT an impact of using the above command?()A、 When a successful backup is recorded in the RMAN repository, then a backup of the current control file is performed.B、 When a structural change is made to the database, then a backup of the current control file is performed.C、 When a successful backup is performed in the RMAN repository, then a backup of the spfile is performed.D、 When a structural change is made to the database, then a backup of the alert log file will be performed.

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.

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 offline.B、 The database instance is restarted.C、 A new data file is added to an existing tablespace.D、 A successful backup is recorded in the RMAN repository.E、 The RMAN connection is disconnected from the target database.

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.

What command would you issue to enable automated backups of control files? ()A、alter database controlfile autobacku onB、alter system controlfile autobackup on C、configure controlfile autobackup on D、enable controlfile autobackup

You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups.Which action should you take?()A、Set the BACKUP_TAPE_IO_SLAVES parameter to FALSEB、Set the BACKUP_TAPE_IO_SLAVES parameter to TRUEC、Use compression when performing tape backupsD、Configure multiple SBT channels

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

When CONFIGURE CONTROLFILE AUTOBACKUP is set to ON, RMAN automatically performs a control file autobackup in which three situations?()A、At the end of every RUN block. B、After every SET CONTROLFILE AUTOBACKUP FORMAT command. C、After every BACKUP or COPY command issued at the RMAN prompt. D、At the end of every RUN block if the last command in the block was either BACKUP or COPY. E、Whenever a BACKUP or COPY command within a RUN block is followed by a command that is neither BACKUP nor COPY. F、After every BACKUP or COPY command within a RUN block that is followed by the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT 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.

单选题You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?()A Set the BACKUP_TAPE_IO_SLAVES parameter to FALSEB Set the BACKUP_TAPE_IO_SLAVES parameter to TRUEC Use compression when performing tape backupsD Configure multiple SBT channels

多选题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 issued the following RMAN command:  RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;     What is NOT an impact of using the above command?()A When a successful backup is recorded in the RMAN repository, then a backup of the current control file is performed.B When a structural change is made to the database, then a backup of the current control file is performed.C When a successful backup is performed in the RMAN repository, then a backup of the spfile is performed.D When a structural change is made to the database, then a backup of the alert log file will be performed.

多选题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? ()AA tablespace is taken offline.BThe database instance is restarted.CA new data file is added to an existing tablespace.DA successful backup is recorded in the RMAN repository.EThe RMAN connection is disconnected from the target 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?()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

单选题What command would you issue to enable automated backups of control files? ()Aalter database controlfile autobacku onBalter system controlfile autobackup on Cconfigure controlfile autobackup on Denable controlfile autobackup

单选题You have configured the following:  RMAN CONFIGURE DEFAULT DEVICE TYPE TO ’sbt’; new RMAN configuration parameters:  CONFIGURE DEFAULT DEVICE TYPE TO ’sbt’; new RMAN configuration parameters are successfully stored RMAN SHOW DEVICE TYPE; RMAN configuration parameters are: CONFIGURE DEVICE TYPE SBT PARALLELISM 1; # CONFIGURE DEVICE TYPE DISK PARALLELISM 1; #  RMAN CONFIGURE DEVICE TYPE SET PARALLELISM 5;  RMAN SHOW DEVICE TYPE; RMAN configuration parameters are: CONFIGURE DEVICE TYPE SBT PARALLELISM 5; CONFIGURE DEVICE TYPE DISK PARALLELISM 1; #  How many channels are allocated to SBT?()A0, because channels have not been defined.B3, as indicated by the degree of parallelism.C1, the default value when device is configured.D5, as indicated by the last parallelism command.

多选题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? ()Aa tablespace is taken offlineBthe database instance is restartedCa new data file is added to an existing tablespaceDa successful backup is recorded in the RMAN repositoryEthe RMAN connection is disconnected from the target database

单选题What command would you issue to enable automated backups of control files?()A alter database controlfile autobackup onB alter system controlfile autobackup onC configure controlfile autobackup onD enable controlfile autobackup

单选题You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLStablespace, you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace without changing the current backup optimization setting?()A configure a default device for RMAN backupsB temporarily disable the retention policy for RMAN backupsC configure automatic channel allocation for RMAN backupsD use the CONFIGURE command to reconfigure the recovery window to 60 days

单选题The SET CONTROLFILE AUTOBACKUP FORMAT command, which you can specify either within a RUN block or at the RMAN prompt, overrides the configured autobackup in the session only.  What is the order of precedence?() 1. SET within RUN  2. SET at RMAN prompt  3. CONFIGUREA1,2,3 B2,3,1 C3,2,1 DThere is no precedence between RUN and the RMAN prompt. Each will override CONFIGURE in the session.

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

单选题You have configured the following:  RMAN CONFIGURE DEFAULT DEVICE TYPE TO ’sbt’; new RMAN configuration parameters:  CONFIGURE DEFAULT DEVICE TYPE TO ’sbt’; new RMAN configuration parameters are successfully stored RMAN SHOW DEVICE TYPE; RMAN configuration parameters are: CONFIGURE DEVICE TYPE SBT PARALLELISM 1; # CONFIGURE DEVICE TYPE DISK PARALLELISM 1; #  RMAN CONFIGURE DEVICE TYPE SET PARALLELISM 5;  RMAN SHOW DEVICE TYPE; RMAN configuration parameters are: CONFIGURE DEVICE TYPE SBT PARALLELISM 5; CONFIGURE DEVICE TYPE DISK PARALLELISM 1; #  How many channels are allocated to SBT?()A0, because channels have not been defined.B3, as indicated by the degree of parallelism.C1, the default value when device is configured.D5, as indicated by the last parallelism command.