Prev Question
Next Question

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.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *