as9

QUESTION 201
Which command is used to configure RMAN to perform a compressed backup for every backup executed?

QUESTION 177
What methods are available to recover lost control files? (Choose all that apply.)

QUESTION 199
Given the following steps, which would be the correct order to create a backup of an Oracle database in ARCHIVELOG mode with control-file autobackups enabled?

a. backup archivelog all;
b. backup database all;
c. backup controlfile;
d. backup archivelog, database, controlfile delete input;
e. backup database plus archivelog delete input

QUESTION 223
What is the correct order of the following commands if you wanted to restore datafile 4, which was accidentally removed from the file system?

a. sql alter database datafile 4 online;
b. restore datafile 4;
c. recover datafile 4;
d. sql alter database datafile 4 offline;
e. startup
f. shutdown

QUESTION 209
How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?

QUESTION 193
Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?

a. shutdown immediate from RMAN
b. Log into RMAN
c. startup mount from RMAN
d. backup database
e. alter database open
f. backup database plus archivelog delete input

QUESTION 194
Which of the following most closely represents an image copy?

QUESTION 200
Which of the following statements are true about the BACKUP command? (Choose all that apply.)

QUESTION 206
If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated? (Choose all that apply.)

QUESTION 195
Which dynamic view displays the status of block-change tracking?

QUESTION 203
What is the purpose of the RMAN recovery catalog? (Choose all that apply.)

QUESTION 188
Which is the correct command to back up the database, back up the archived redo logs, and then remove the backed- up archived redo logs?

QUESTION 212
Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line? Assume that the target database is called ORCL and that the recovery catalog database is called RCAT.
Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is configured for the ORCL database. (Choose all that apply.)

QUESTION 181
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?

QUESTION 217
If you lost your entire database, including the database spfile, control files, online redo logs, and database datafiles, what kind of recovery would be required with RMAN?

QUESTION 207
You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script?

QUESTION 190
Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?

QUESTION 219
What is the end result of these commands if they are successful?
RMAN> show retention policy;
RMAN configuration parameters for database with db_unique_name
ORCL are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default Backup database
tag=gold_copy plus archivelog tag=gold_copy delete input;
Backup database tag=silver_copy plus archivelog tag=silver_copy delete input;

QUESTION 180
What does the SCN represent?

QUESTION 196
What feature comes into play to help ensure the completion of the backup should one of three backup devices fail during a backup that is using three different channels?

QUESTION 208
In what order would you execute the following steps to create a recovery catalog?
a. Issue the create catalog command.
b. Create the recovery-catalog database.
c. Create the recovery-catalog user.
d. Grant the recovery_catalog_owner privilege to the recovery-catalog user.
e. Issue the register database command from the target database.

QUESTION 186
Consider the following command:
Backup database plus archivelog delete input;
How many backup sets would be created by this command if the following were true:
Control-file a NN uto backups were enabled.
NN The size of backup sets was not restricted.
NN One channel was allocated.

QUESTION 183
During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information? (Choose all that apply.)

QUESTION 184
How is block-change tracking enabled?

QUESTION 221
True or false: RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.

QUESTION 216
Given a complete loss of your database, in what order would you need to perform the following RMAN
operations to
restore it?

a. restore controlfile
b. restore database
c. restore spfile
d. recover database
e. alter database open
f. alter database open resetlogs

QUESTION 222
You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the following commands to compete this task?
A. restore controlfile until time ,,09/30/2008:18:00:00;
til time ,,09/30/2008:18:00:00;
B. restore database un
C. restore spfile until time ,,09/30/2008:18:00:00;;
D. recover database until time ,,09/30/2008:18:00:00;
E. alter database open resetlogs;
F. alter database open;

QUESTION 179
You have lost all your online redo logs. As a result, your database has crashed. You have tried to restart the database and clear the online redo log files, but when you try to open the database you get the following error.
SQL> startup ORACLE instance started.
Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes
Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database
mounted.
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: ,,/oracle01/oradata/orcl/redo02a.log ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: ,,/oracle01/oradata/orcl/redo02.log
ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3
SQL> alter database clear logfile group 2; alter database clear logfile group 2 * ERROR at line 1:
ORA-01624: log 2 needed for crash recovery of instance orcl (thread 1)
ORA-00312: online log 2 thread 1: ,,/oracle01/oradata/orcl/redo02.log ORA-00312: online log 2 thread 1: ,,/
oracle01/oradata/orcl/redo02a.log
What steps must you take to resolve the error?

a. Issue the recover database redo logs command.
b. Issue the Startup Mount command to mount the database.C.
c. Restore the last full database backup.
d. Perform a point-in-time recovery, applying all archived redo logs that are available.
e. Restore all archived redo logs generated during and after the last full database backup.
f. Open the database using the alter database open resetlogs command.
g. Issue the alter database open command.

QUESTION 204
What privileges must be granted to allow an account to create the recovery catalog? (Choose all that apply.)

QUESTION 215
Which commands are used for RMAN database recovery? (Choose all that apply.)

QUESTION 210
The RVPC user can do which of the following? (Choose all that apply.)

QUESTION 185
What type of backup is stored in a proprietary RMAN format?

QUESTION 202
You issue the following command:
RMAN>CONFIGURE BACKUP OPTIMIZATION ON;
What is the result of this command on your backups?

QUESTION 214
Given the following RMAN commands, choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.
A. restore database;
B. recover database;
C. shutdown immediate
D. startup
E. restore archivelog all;
F. alter database open

QUESTION 187
Compressed backups work with which of the following commands?

QUESTION 220
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?

QUESTION 176
Your developers have asked you to restore the development database, which is in NOARCHIVELOG mode, back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do?

QUESTION 205
Which command do you use to create a recovery-catalog schema?

QUESTION 191
Which type of backup must be performed first with an incremental backup?

QUESTION 192
Which backup option defines a user-defined name for a backup?

QUESTION 218
Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours?

QUESTION 178
Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM
tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database:
a. Restore the three database datafiles that were lost.B.
b.Issue the Startup Mount command to mount the database.
c.Issue the alter database open command.
d.Issue the alter database open resetlogs command.
e. Recover the database using the recover database command.
f. Recover the datafiles with the recover datafile command.
g. Take the datafiles offline.
Which is the correct order of these steps in this case?

QUESTION 198
The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value? (Choose all that apply.)

QUESTION 225
Which of the following are valid until command options when attempting point-in-time recovery in RMAN? (Choose all that apply.)

QUESTION 213
What command would you issue to enable automated backups of control files?

QUESTION 189
Which of the following best describes a full backup?

QUESTION 211
Given the script
create script db_backup_datafile_script
{backup datafile and 1, and2 plus archivelog delete input;}
What is the result of running this command?
Run {execute script db_backup_datafile_script using 2;}

QUESTION 197
What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?

QUESTION 224
Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command:
RESTORE CONTROLFILE FROM AUTOBACKUP;
Which of the following statements is true? (Choose all that apply.)

QUESTION 182
You are trying to recover your database. During the recovery process, you receive the following error:ORA-00279: change 5033391 generated at 08/17/2008 06:37:40 needed for thread 1
ORA-00289: suggestion : /oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc
ORA-00280: change 5033391 for thread 1 is in sequence #11
"FirstTest, FirstPass" - www.lead2pass.com 56
Oracle 1Z0-053 Exam
ORA-00278: log file ,,/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17
/o1_mf_1_10_4bj6wnqm_.arc no longer needed for this recovery Specify log:
{=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
,,/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc
ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3
How do you respond to this error? (Choose two.)