2

I have here a database which should be quiet small. There should be around 350.000 lines of textonly data but the rdbms folder is around 50 GB. Seems way too huge to me.

I found in the rdbms folder a couple of folders (around 60 Mb) and 17.000 files starting with ARC00311.001 until ARC43183.001. The are made every hour und reaching back to 2006.

Are they some kind of logfile?? Regarding backup, should/must I backup these to? Can i delete them? What would be the drawback in doing so?

Thanks

wurlog
  • 333
  • 1
  • 4
  • 17

1 Answers1

3

It looks like these are the archived version of the redo log.

The archived log are used when you restored your database and want to recover the changes made after the backup you used to recover.

(the following commands are for Oracle 10g & 11g. They might have changed since 9i)

If you backup your database using RMAN, you can include the archived log using the following command:

RMAN> backup database plus archivelog;

You can also delete the archived log included in your backup by adding the "delete all input" statement:

RMAN> backup database plus archivelog delete all input;

Considering the numbers of files I recommend that you bounce your database, perform a full backup, delete the old archived log and purge the archive log list before. You can purge the archive log list from an RMAN prompt using the following command:

RMAN>  crosscheck archivelog all;

You should also change the folder where the archived log are stored using the following commands:

SQL> ALTER SYSTEM set log_archive_dest_1="LOCATION=x:\Whatever\The\Path" scope=spfile;
SQL> shutdown immediate;
SQL> startup;
SQL> alter system switch logfile;
Benoit
  • 3,549
  • 1
  • 19
  • 17