96.
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
b. restore datafile 4;
c. recover datafile 4;
d. sql 'alter database datafile 4 offline';
e. startup
f. shutdown
- A.a, c, b, d
- B.d, b, c, a
- C.f, d, b, c, a, e
- D.c, a, b, d, f
- E.a, b, d, e
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| To perform the restore of datafile 4, you would first need to take the datafile offline with the alter database command. Once the datafile is offline, use the restore datafile and recover datafile commands to restore and recover the datafile in question. After the restore and recover, you will need to bring the datafile back online. |
97.
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.)
- A.The command restores only the missing control file.
- B.The command restores all the control files.
- C.The command fails because the database is running.
- D.This is the correct way to address this problem.
- E.This is not the correct way to address this problem.
- Answer & Explanation
- Report
Answer : [C, E]
Explanation :
Explanation :
| This is not the correct way to address this problem. The command will fail because the database is running. Additionally, this is not the correct way to approach the loss of one of several control files. The better way to approach this loss is to shut down the database and simply copy one of the surviving control files over to where the missing control file existed. |
98.
Which of the following are valid until command options when attempting point-in-time
recovery in RMAN? (Choose all that apply.)
- A.until time
- B.until change
- C.until sequence
- D.until SCN
- E.until commit
- Answer & Explanation
- Report
Answer : [A, C, D]
Explanation :
Explanation :
| The until time clause provides the ability to restore to a specific point in time. The until sequence clause provides the ability to restore to a specific redo log sequence number, and until SCN provides the ability to restore to a specific database SCN number. |
99.
Which of the following does the recover command not do?
- A.Restore archived redo logs.
- B.Apply archived redo logs.
- C.Restore incremental backups.
- D.Apply incremental backups.
- E.Restore datafile images.
- Answer & Explanation
- Report
Answer : [E]
Explanation :
Explanation :
| The recover command does not restore datafile images. It does restore and apply archived redo logs and incremental backup images during the recovery process. |
100.
You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP. You
want to "roll back" the data in the USERS tablespace to the way it looked yesterday. Which
tablespaces do you need to perform a point-in-time restore operation on in order to complete
this task? (Choose all that apply.)
- A.SYSTEM
- B.SYSAUX
- C.UNDO
- D.USERS
- E.TEMP
- F.TEMP
- Answer & Explanation
- Report
Answer : [A, B, C, D, E.]
Explanation :
Explanation :
| You will need to restore the datafiles associated with each tablespace in the database in order to successfully complete the point-in-time database restore operation. |
|
|
||||||||||||||||||||||||||||
