单选题You run the following commands:   RMAN list expired backup; RMAN delete expired backup;   What will happen to the backup set pieces associated with the backups that appear in the list expired backup command?()A They will be renamed.B Nothing will happen to them. The backup set pieces do not exist.C They will be deleted immediately since they are not in the flash recovery area.D You will need to manually remove the physical files listed in the output of the commands.E They will become hidden files and removed 10 days later.

单选题
You run the following commands:   RMAN> list expired backup; RMAN> delete expired backup;   What will happen to the backup set pieces associated with the backups that appear in the list expired backup command?()
A

 They will be renamed.

B

 Nothing will happen to them. The backup set pieces do not exist.

C

 They will be deleted immediately since they are not in the flash recovery area.

D

 You will need to manually remove the physical files listed in the output of the commands.

E

 They will become hidden files and removed 10 days later.


参考解析

解析: 暂无解析

相关考题:

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

You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database:RMAN REPORT NEED BACKUP days 3;What would be the output of this command?()A、 a list of files that require a backup within three daysB、 a list of files that have not been backed up for three daysC、 a list of files that RMAN recommends be backed up only once in every three days, based on low volatilityD、 a list of files for which a backup has already been performed and may need a backup after three days

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

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

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

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.

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 executed the following command in the Recovery Manager (RMAN):   RMAN REPORT NEED BACKUP days 3;   What is the output of this command?()  A、 A list of files that require a backup within 3 daysB、 A list of files requiring more than 3 days of archivelogs to applyC、 A list of files that RMAN recommends be backed up only once in every three days,based on low volatilityD、 A list of files for which a backup as already been performed in the last three days and which is  required to be backed up again based on the high number of transactions performed on them

If a backup set is expired, what can you do to correct the problem?()  A、 Change the retention criteria.B、 Make the lost backup set pieces available to RMAN again.C、 Run the crosscheck command to correct the location for the backup set piece contained in the metadata.D、 Nothing. The backup set piece is lost forever.E、 Call Oracle support,their assistance is required.

You execute the following RMAN commands in the order shown below:  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do?()A、create a backup of the database and recover all corrupted blocks found in the backupB、run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the databaseC、run a backup validation to populate V$COPY_CORRUPTION view, and then list any corrupt blocks recorded in the viewD、run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view, and then repair any corrupt blocks recorded in the viewE、run a backup validation, repair any corrupt blocks found during the validation process, and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired

View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation:   RMAN RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8; BACKUP DATABASE FILESPERSET 4; }   What is the multiplexing level in the preceding backup process?()A、 4B、 8C、 7D、 0

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

单选题In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN: RMAN CONFIGURE DEVICE TYPE disk PARALLELISM 2 BACKUP TYPE TO BACKUPSET; RMAN CONFIGURE CHANNEL 1 DEVICE TYPE disk FORMAT '/home/oracle/disk1/%U'; RMAN CONFIGURE CHANNEL 2 DEVICE TYPE disk FORMAT '/home/oracle/disk2/%U'; You issue the following RMAN command to backup the database: RMAN RUN 2 { 3 ALLOCATE CHANNEL ch1 DEVICE TYPE disk; 4 BACKUP DATABASE; 5 } Which statement is true about the outcome?()AOnly one channel is allocated and the backup is created in the flash recovery areaBOnly one channel is allocated and the backup is created in the destination specified for channel 1CTwo channels are allocated and backup sets are created in the destinations specified for channels 1 and 2DThree channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

单选题If you CROSSCHECK the backup piece that was previously marked as EXPIRED but is now available, what would the status of this backup piece be in the RMAN repository?()AEXPIREDBAVAILABLECUNAVAILABLEDACCESSIBLE

单选题You executed the following command in Recovery Manager (RMAN):   RMAN REPORT NEED BACKUP days 3;   What is the output of this command?()A a list of files that require a backup within three daysB a list of files requiring more than 3 days of archive logs to applyC a list of files that RMAN recommends be backed up only once in every three days,based on low volatilityD a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

单选题You execute the following RMAN command in the order shown below: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do?()A Create a backup of the database and recover all corrupted blocks found in the backup.B Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.C Run a backup validation to populate V$COPY_CORRUPTION view, and then list any corrupt blocks recorded in the view.D Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view, and then repair any corrupt blocks recorded in the view.E Run a backup validation, repair any corrupt blocks found during the validation process, and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.

单选题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 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 execute the following Recovery Manager (RMAN) commands in he following order:   BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST;   Which two tasks are performed by these commands?()ARepair the corrupted blocks. If any. In the backup createdBPopulate VSCOPV_CORRUPTION with names of files that have corrupted blocksCBack up the database after checking whether array of the files have corrupted blocksDDiscover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION viewERepair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION

单选题You executed the following commands in an RMAN session for your database instance that has failures: RMAN LIST FAILURE; After some time, you executed the following command in the same session: RMAN ADVISE FAILURE; But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?()AIt produces a warning for new failures before advising for CRITICAL and HIGH failures.BIt ignores new failures and considers the failures listed in the last LIST FAILURE command only.CIt produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.DIt produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.

单选题You execute the following RMAN commands in the order shown below:  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do?()Acreate a backup of the database and recover all corrupted blocks found in the backupBrun a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the databaseCrun a backup validation to populate V$COPY_CORRUPTION view, and then list any corrupt blocks recorded in the viewDrun a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view, and then repair any corrupt blocks recorded in the viewErun a backup validation, repair any corrupt blocks found during the validation process, and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired

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

单选题You executed the following command in the Recovery Manager (RMAN):   RMAN REPORT NEED BACKUP days 3;   What is the output of this command?()A A list of files that require a backup within 3 daysB A list of files requiring more than 3 days of archivelogs to applyC A list of files that RMAN recommends be backed up only once in every three days,based on low volatilityD A list of files for which a backup as already been performed in the last three days and which is  required to be backed up again based on the high number of transactions performed on them

单选题You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database:  RMAN REPORT NEED BACKUP days 3;  What would be the output of this command?()Aa list of files that require a backup within three daysBa list of files that have not been backed up for three daysCa list of files that RMAN recommends be backed up only once in every three days, based on low volatilityDa list of files for which a backup has already been performed and may need a backup after three days

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