Tamim DBA: Enabling the Archive Log

Showing posts with label Enabling the Archive Log. Show all posts

Monday, November 9, 2009

Enabling the Archive Log in Oracle 10g

SQL> shutdown immediate;

SQL> startup mount exclusive;

SQL> alter database archivelog;

SQL> alter database open;

SQL> SELECT group#, thread#, sequence#, archived, status, first_time
FROM v$log;

SQL> alter system switch logfile;

SQL> SELECT group#, thread#, sequence#, archived, status, first_time
FROM v$log;

SQL> alter system switch logfile;

SQL> SELECT group#, thread#, sequence#, archived, status, first_time
FROM v$log;

SQL> SELECT dbid, name FROM v$database;