81.
What command would you issue to enable automated backups of control files?
- A.alter database controlfile autobackup on
- B.alter system controlfile autobackup on
- C.configure controlfile autobackup on
- D.enable controlfile autobackup
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| Enable control-file autobackups by executing the command configure controlfile autobackup on. |
82.
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
b. recover database;
c. shutdown immediate
d. startup
e. restore archivelog all;
f. alter database open
- A.a, b, c, d, e, f
- B.c, b, a, d, e, f
- C.c, b, a, d, f
- D.c, a, b, d
- E.c, a, e, b, d, f
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| You would shut down the database with the shutdown immediate command before the recovery. You would then issue the restore database command followed by the recover database command. After you have recovered the database, you will want to open it with the startup command. |
83.
Which commands are used for RMAN database recovery? (Choose all that apply.)
- A.restore
- C.copy
- E.replace
- B.repair
- D.recover
- Answer & Explanation
- Report
Answer : [A, D]
Explanation :
Explanation :
| The restore command is used to restore datafiles during a database recovery. The recover command is used to apply incremental backups and archived redo logs to recover the database to the needed point in time. |
84.
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
b. restore database
c. restore spfile
d. recover database
e. alter database open
f. alter database open resetlogs
- A.b, a, c, d, e
- B.a, c, b, d, f
- C.c, a, b, d, e
- D.c, a, b, d, f
- E.e, a, b, d, c
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| In the event of complete loss of your database, you will need to first restore the database spfile. Once you have restored the database spfile, you will need to restore the database control file. Having restored the database control file, you would restore the database and then recover the database. Finally, since this would be an incomplete recovery (because you lost the entire database, the online redo logs are gone too), you would need to open the database using the alter database open resetlogs command. |
85.
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?
- A.Complete database recovery.
- B.Incomplete database recovery.
- C.Approximate database recovery.
- D.Archived database recovery.
- E.The database could not be recovered with RMAN.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| A loss of the entire database will result in a requirement for an incomplete database recovery. This is because the online redo logs would not be available to perform a complete recovery. |
|
|
||||||||||||||||||||||||||||
