Posts

Showing posts from May 30, 2012

Oracle 10g:Put Database in Archive Log Mode.

Image
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; D