Mengaktifkan ArchiveLOG Oracle 10g

Archive LOG sangat dibutuhkan untuk sebuah Server Database Oracle untuk mengembalikan data terdekat.

SQL> alter database archivelog;alter database archivelog*ERROR at line 1:ORA-01126: database must be mounted in this instance and not open in anyinstance
SQL> shutdown immediate;SQL> startup mount;SQL> alter database archivelog;SQL> alter database open;SQL> archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination D:\oradata\suntrn\archOldest online log sequence 23Next log sequence to archive 25Current log sequence 25