Wednesday, May 30, 2012

Oracle 10g:Put Database in Archive Log Mode.



1.Set the parameters.

SQL> alter system set log_archive_format='arch_%t_%s_%r.arc' SCOPE=spfile;

SQL> alter system set log_archive_dest_1='location=C:\archive' SCOPE=spfile;

SQL>alter system set log_archive_start=true scope=spfile;

2.Restart the database.

SQL>SHUT IMMEDIATE

Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.

SQL> conn / as sysdba

Connected to an idle instance.

SQL> startup mount

ORACLE instance started.
Total System Global Area  612368384 bytes
Fixed Size                  1250428 bytes
Variable Size             171969412 bytes
Database Buffers          432013312 bytes
Redo Buffers                7135232 bytes
Database mounted.

3.Start Archive log Mode.

SQL> alter database archivelog;

Database altered.

4.Open Database.

SQL> alter database open;

Database altered.


SQL> alter system switch logfile;

END;