November 2008
M T W T F S S
« Oct   Dec »
 12
3456789
10111213141516
17181920212223
24252627282930

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.