When performing an online backup, what is the proper order of the following steps?
a: Issue the ALTER DATABASE END BACKUP command.
b: Back up the archived redo logs.
c: Issue the ALTER DATABASE BEGIN BACKUP command.
d: Back up the database files.
e: Determine the beginning log sequence number.
f: Determine the ending log sequence number.
g: Force a log switch with the ALTER SYSTEM SWITCH LOGFILE command.
A.
a, b, c, d, e, f, g
B.
c, d, a, b, e, g, f
C.
f, d, b, g, a, c, e
D.
e, c, d, a, g, f, b
E.
a, f, b, g, e, c, d
Explanation:
There are two big steps to complete the online database backup:
1. Enclose with BEGIN BACKUP and END BACKUP options to use O/S file copy command to backup data
files;
Which is e, c, d, a
2. Use SWITCH LOGFILE command to archive all the online redo log. backup all the archived redo log file.
Which is g, f, b
According to Oracle document, after online backup done, you must archive the online redo log, otherwise you
will have no chance to recover the database with consistence.