- Home
- Database
- Oracle 12 C
- OCP Oracle 12C Advanced Administration(1Z0-063)
46.
Which command will restore all data files to the date 9/30/2013 at 18:00 hours?
- A.RESTORE DATAFILES UNTIL TIME '09/28/2013:21:03:11';
- B.RESTORE DATABASE FILES UNTIL TIME '09/28/2013:18:00:00';
- C.RESTORE DATABASE UNTIL TIME '09/28/2013:18:00:00';
- D.RECOVER DATABASE UNTIL TIME '09/28/2013:18:00:00';
- E.RECOVER DATABASE UNTIL TIMESTAMP '09/28/2013:18:00:00';
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The RESTORE DATABASE command is used to restore database data files. The UNTIL TIME parameter is used to indicate the point in time to which you want to restore the database data files. |
47.
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;
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;
- A.Attempting to restore silver_copy will fail.
- B.Attempting to restore gold_copy will fail.
- C.Both backups will be available for restore without question.
- D.Attempting to restore gold_copy may or may not succeed.
- E.You will not be able to restore either gold_copy or silver_copy.
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| Since the retention policy is set to redundancy of 1, the gold_copy backup is not required to meet the retention criteria. Since the backup was not made in a way that will exclude or alter the retention criteria, then the gold_copy backup is no longer needed and may be removed at any time. It is possible that it will still be available for restore purposes, however. |
48.
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?
- A.Database data files
- B.Database control files
- C.Online redo logs
- D.Archived redo logs
- E.The database spfile
- F.None of the above; all these files are backed up
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The online redo logs are never backed up by Oracle no matter what kind of backup you are performing. |
49.
True or false: RMAN offers the equivalent of the SQL command ALTER DATABASE
BACKUP CONTROLFILE TO TRACE.
- A.true
- B.false
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| There is no equivalent RMAN command that creates a trace file with the CREATE CONTROLFILE statement in it. |
50.
You need to restore your database to 9/30/2013 at 18:00. In what order would you run
the following commands to compete this task?
a. RESTORE CONTROLFILE UNTIL TIME'09/30/2013:18:00:00';
b. RESTORE DATABASE UNTIL TIME'09/30/2013:18:00:00';
c. RESTORE SPFILE UNTIL TIME'09/30/2013:18:00:00';;
d. RECOVER DATABASE UNTIL TIME'09/30/2013:18:00:00';
e. ALTER DATABASE OPEN RESETLOGS;
f. ALTER DATABASE OPEN;
a. RESTORE CONTROLFILE UNTIL TIME'09/30/2013:18:00:00';
b. RESTORE DATABASE UNTIL TIME'09/30/2013:18:00:00';
c. RESTORE SPFILE UNTIL TIME'09/30/2013:18:00:00';;
d. RECOVER DATABASE UNTIL TIME'09/30/2013:18:00:00';
e. ALTER DATABASE OPEN RESETLOGS;
f. ALTER DATABASE OPEN;
- A.b, d, e
- B.b, d, f
- C.c, a, b, d, e
- D.c, a, b, d, f
- E.a, b, d, e
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| In this case, you would first issue the RESTORE DATABASE command using the UNTIL TIME option. You would then use the RECOVER DATABASE command using the same UNTIL TIME option. Finally, since this is an incomplete recovery, you would need to open your database with the ALTER DATABASE OPEN RESETLOGS command. |
|
|
||||||||||||||||||||||||||||
