How to enable ARCHIVELOG MODE in Oracle 9i

Posted by admin on Apr 3, 2009 in Archivelog Mode - 9i, Oracle |

Initially when a database is created, by default the database will always be in NOARCHIVELOG mode. In order to put it in ARCHIVELOG mode, you must do the following:
1) You have to shutdown the database


SQL>shutdown immediate;

2) Set the parameter in the pfile (i.e. init.ora).

LOG_ARCHIVE_START=TRUE

3) Create New SPFILE from Modified pfile(init.ora)

SQL> create SPFILE from PFILE;

4) Startup Database in Mount Mode

SQL> startup mount;

5) Change Database log mode from NOARCHIVELOG to ARCHIVELOG

SQL> alter database archivelog;

6) Open DB for normal use

SQL> alter database open;

7) Check the archive log status

Database log mode Archive Mode
Automatic archival Enabled
Archive destination C:\Oracle\product\RDBMS
Oldest online log sequence 0
Next log sequence to archive 1
Current log sequence 1
Default Archivelog destination is :$ORACLE_HOME/rdbms.

Comments are closed.

Copyright © 2010 Edward’s Blurg All rights reserved. Theme by Laptop Geek.