What is the correct order of steps to perform an online database backup?
a: alter database begin backup;
b: alter database end backup;
c: Back up the database datafiles.
d: Back up the archive log files.
e: alter system switch logfile;
A.
a, b, c, d, e
B.
e, d, a, b, c
C.
a, c, b, d, e
D.
d, b, c, a, e
E.
a, c, b, e, d
Explanation:
(link)
To back up online read/write tablespaces in an open database:
1. Use the DBA_DATA_FILES data dictionary view to identify all of the data files in the tablespace.
2. ALTER TABLESPACE users BEGIN BACKUP;
3. Back up the online data files of the online tablespace with operating system commands.
4. ALTER TABLESPACE users END BACKUP;
5. ALTER SYSTEM ARCHIVE LOG CURRENT; Archive the unarchived redo logs so that the redo required to
recover the tablespace backup is archived.