Hướng dẫn cấu hình Database Archivelog nếu Database của bạn chưa ở chế độ Archivelog (Kiểm tra bằng lệnh như sau):

C:\Documents and Settings\Administrator>sqlplus /nolog
SQL> conn sys/sys@guru as sysdba;
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Enabled
Archive destination C:\oracle\ora92\Guru\Archive
Oldest online log sequence 32
Current log sequence 34    
    SQL> shutdown
SQL> startup mount;
SQL> alter database archivelog;
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination C:\oracle\ora92\Guru\Archive
Oldest online log sequence 32
Next log sequence to archive 34
Current log sequence 34
SQL> alter database open;
SQL> conn sys/sys@Guru as sysdba ;
SQL> alter system set log_archive_dest_1 = 'location = C:\oracle\ora92\Guru\Archive';
SQL> alter system archive log start;