Wednesday, April 16, 2008

Changing the Database Archiving Mode

1)See the current archiving mode of the database.
select log_mode from v$database;

2)Perform clean shutdown of the database.
shutdown immediate or,
shutdown transactional or,
shutdown normal

You cannot change the mode from ARCHIVELOG to NOARCHIVELOG if any datafiles need media recovery.

3)Backup the Database.

4)If you use pfile as initialization file then edit the archive destination parameter (like LOG_ARCHIVE_DEST) as your archival destination. If you use spfile ignore this step.

5)Mount the database but don't open.
STARTUP MOUNT

6)Change the archival mode and open the database.

ALTER DATABASE ARCHIVELOG
If you use spfile then you can use ALTER SYSTEM SET LOG_ARCHIVE_DEST='your location'
ALTER DATABASE OPEN;


7)Check the archival Location
archive log list

8)Shutdown and Backup the database.
SHUTDOWN IMMEDIATE

Related Documents. "ORA-16018 and ORA-16019"

No comments:

Post a Comment