Configuring the Database Archiving Mode

1.Enable archiving Mode
(1)Shutdown the database.

?View Code SQL SHUTDOWN IMMEDIATE;

(2)Start the database in Mount state.

?View Code SQL STARTUP MOUNT;

(3)Set the database in Archivelog mode by using the ALTER DATABASE command.

?View Code SQL ALTER DATABASE ARCHIVELOG;

(4)Open the database.

?View Code SQL ALTER DATABASE OPEN;

(5)Take a full backup of the database.