B back up the instance c back up the database d back

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: iles. B. Back up the instance. C. Back up the database. D. Back up the control file. E. Archive any unarchived online redo-logs. Answer: C Explanation: Oracle recommends DBA after a recover from the loss of the current online redo log file to perform offline backup of the entire database. Incorrect Answers: A: You need to backup offline the entire database, not just the data files. B: There is no instance backup in Oracle, only database backup, because Oracle instance itself is just set of some processes in memory. D: Backing up the control file is not enough in this situation. You need to back up the control file after any tablespace or datafiles structural changes in the Oracle database. E: You don't need to archive any unarchived online redo logs after this type pf recovery. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 709-711 Chapter 15: Advanced Topics in Data Recovery QUESTION 118: You perform an incomplete recovery using RMAN. You write the following script: RUN{ SET UNTIL TIME='yyyy-nm-dd:hh:mi:ss'; RESTORE DATABASE; RESTORE DATABASE; SQL"alter database open resetlogs"; Which comm...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online