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?()
Using the command shown here, what time format must you specify to recover the database until a point-in-time?() SQL> RECOVER DATABASE UNTIL TIME ’<time format>’;
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database?()
Examine this statement: RMAN >BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus1 DATABASE filesperset = 2; What state must the target database be in for you to use this RMAN command?()
You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of the above command?()
What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?()
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?()
You executed the following command in the Recovery Manager (RMAN): RMAN> REPORT NEED BACKUP days 3; What is the output of this command?()
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?()
The size of the largest datafile, data1.dbf, in your database is 30MB. You issued the following command: RMAN>CONFIGURE MAXSETSIZE 10MB; What will be the impact of the above setting?()
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?()
You executed the following command in Recovery Manager (RMAN): RMAN> REPORT NEED BACKUP days 3; What is the output of this command?()
You executed the following command in Recovery Manager (RMAN): RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed?()
You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database?()
You executed the following command in the Recovery Manager (RMAN): RMAN> REPORT NEED BACKUP days 3; What is the output of this command?()
You issued the following RMAN command: RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; What is NOT an impact of using the above command?()
You issue the following command: RMAN>CONFIGURE BACKUP OPTIMIZATION ON; What is the result of this command on your backups?()
You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command?()
You execute the following RMAN command in the order shown below: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do?()
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?()
You executed the following command in Recovery Manager (RMAN): RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed?()
In Recovery Manager (RMAN), you set the retention policy to NONE by executing the following command: CONFIGURE RETENTION POLICY TO NONE; What would be the impact of this setting?()
You issued the RMAN>SHOW ALL; command. The output of the command is as follows: https://assets.asklib.com/images/image2/2018080116014456210.jpg After analyzing this output, what conclusion can you draw? ()
You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command? ()