Posted on Leave a comment

Clear Transaction Logs

This is how to disable archiving:

C:> sqlplus sys/@dbalias as sysdba
SQL> shutdown immediate
SQL> startup mount
SQL> alter database noarchivelog;
SQL> alter database open;
SQL> archive log list
SQL> alter system switch logfile;

Run this about 10 times, delete all archived log files and then proceed.

This is how to enable archiving:

SQL> archive log list

At this point the numbers should have incremented as many as the number of switches.

SQL> shutdown immediate

SQL> startup mount

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

SQL> archive log list

SQL> alter system switch logfile;

Run this a couple of times and you should see new archived log files.

SQL> archive log list

At this point the numbers should have incremented as many as the number of switches.

Exit SQLPlus and do an immediate full backup of the system.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.