单选题Examine the following RMAN script: RMAN run { debug on; allocate channel c1 type disk; backup datafile 5; } Which statement describes the purpose of the script?()AThe data file is checked for physical corruption and backed up if found clean.BThe backup of data file 5 is performed and the interactive messages during the backup are suppressed.CThe existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.DThe backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
单选题
Examine the following RMAN script: RMAN> run { debug on; allocate channel c1 type disk; backup datafile 5; } Which statement describes the purpose of the script?()
A
The data file is checked for physical corruption and backed up if found clean.
B
The backup of data file 5 is performed and the interactive messages during the backup are suppressed.
C
The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.
D
The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
参考解析
解析:
暂无解析
相关考题:
Examine the following RMAN command:RMAN CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?() A. Provide a password for the encryptionB. Set up an Oracle wallet for the encryptionC. No setup is required as it is a default encryption methodD. Both Oracle wallet and password must be set up for the encryption
Examine the following RMAN script:Which statement describes the purpose of the script?() A. The data file is checked for physical corruption and backed up if found clean.B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
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
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.
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).
Examine the following RMAN script:RMAN run {debug on;allocate channel c1 type disk;backup datafile 5;}Which statement describes the purpose of the script?() A. The data file is checked for physical corruption and backed up if found clean.B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?()A. Data files that belong to only the root containerB. Data files that belong to the root container and all the pluggable databases (PDBs)C. Data files that belong to only the root container and PDB$SEEDD. Data files that belong to the root container and all the PDBs excluding PDB$SEED
hich of the following RMAN structures can data from a datafile span?()A、RMAN backup-set pieces spanning backup sets B、RMAN backup-set pieces within a given backup sets C、RMAN backups D、RMAN channels E、None of the above
What can be done to enable the debug information for functions to be displayed when using‘ksh -x’to debug a script?()A、Run the script using ‘ksh -fx’.B、Run the script using ‘ksh -a function -x’.C、Edit the script and add ‘set -x’ at the beginning.D、Edit the script and add ‘set -x’ at the beginning of each function.
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.
Examine the following RMAN command: RMAN CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?()A、 Provide a password for the encryptionB、 Set up an Oracle wallet for the encryptionC、 No setup is required as it is a default encryption methodD、 Both Oracle wallet and password must be set up for the encryption
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
Which of the following RMAN structures can data from a datafile span?()A、 RMAN backup-set pieces spanning backup setsB、 RMAN backup-set pieces within a given backup setC、 RMAN backupsD、 RMAN channelsE、 None of the above
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
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.
多选题Examine the following command used to perform incremental level 0 backup: RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/ rman_change_track.f'; To perform incremental level 1 cumulative backup, you issued the following command: RMAN BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?()AThe block change tracking data will be used only from the next incremental 0 backup.BThe incremental backup will use change tracking data for accomplishing the backup.CThe incremental backup will not use change tracking data for accomplishing the backup.DThe block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.
单选题Examine the following RMAN command: RMAN CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which prerequisite must be met before accomplishing the backup?()AProvide a password for the encryptionBSet up an Oracle wallet for the encryptionCNo setup is required as it is a default encryption methodDBoth Oracle wallet and password must be set up for the encryption
单选题View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions: RMAN BACKUP DATABASE FILESPERSET 2; The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?()ABecause the progress is reported for each data fileBBecause the progress is reported for each backup setCBecause other RMAN sessions have issued the same BACKUP commandDBecause new data files have been added to the database while the RMAN backup is in progress
单选题Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows: RMAN RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb; } Which statement is true about the duplicate database in this scenario?()A It contains data till the last backupB It contains all data from target database until the current timeC It contains all data from only the committed transactions in the target databaseD It contains all data except that which is used by the transactions in the current online redo file of target database
单选题Assume your situation can be described as follows: x A full backup taken using RMAN is available on disk. x The current control files were NOT damaged and do not need to be restored. x All data files are damaged or lost. x The database is in NOARCHIVELOG mode. Which RMAN command would be most appropriate to use in line 3 of the following RMAN command set to restore and fully recover your database?() 1. RMAN STARTUP MOUNT 2. RMAN RESTORE DATABASE; 3. RMAN () 4. RMAN ALTER DATABASE OPEN;ARECOVER DATABASE;BSWITCH DATAFILE ALL;CRESTORE CONTROL FILE;DRECOVER DATABASE USING BACKUP CONTROL FILE;
单选题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 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.
单选题Examine the following RMAN script: RMAN run { debug on; allocate channel c1 type disk; backup datafile 5; } Which statement describes the purpose of the script?()A The data file is checked for physical corruption and backed up if found clean.B The backup of data file 5 is performed and the interactive messages during the backup are suppressed.C The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.D The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
单选题Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?()AData files that belong to only the root containerBData files that belong to the root container and all the pluggable databases (PDBs)CData files that belong to only the root container and PDB$SEEDDData files that belong to the root container and all the PDBs excluding PDB$SEED
单选题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 of the following RMAN structures can data from a datafile span?()A RMAN backup-set pieces spanning backup setsB RMAN backup-set pieces within a given backup setC RMAN backupsD RMAN channelsE None of the above
多选题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