Sunday, May 30, 2010

Steps to Change the database mode from NOARCHIVE to ARCHIVE log mode.

## To place a database in archive log mode.

1. First shutdown the database with any one of the options apart from shutdown abort.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

2. Place the database in Mount Stage.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1241513984 bytes
Fixed Size 778976 bytes
Variable Size 333716768 bytes
Database Buffers 905969664 bytes
Redo Buffers 1048576 bytes
Database mounted.

3. Place the database in Archive mode.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

4. Now check the log_mode by using the below,
a. SQL> Archive log list

b. select log_mode from v$database.

5. Check the log_archive_dest is set properly to correct destination.

Commands Used:

1.SQL> shutdown immediate;
2.SQL> startup mount;
3.SQL> alter database archivelog;
4.SQL> alter database open;

No comments: