Feb 12, 2010

Archive Mount Point 100% percent filled up

If your archive mount is 100% filled up.

what are the action we need to take?

Step 1 : Move some of the archive sequence to another mount point

Ex : /opt/oracle/arch/demo ---> is my archive log destination
/u01/oracle/backup ----> is the temporary destination where I m moving my archivelog files

Note : Be careful while moving the archive log files to other mount because it might
got corrupted. So do not try to move the archive log file which is in "ACTIVE"
for safer try to leave 4 to 5 archive log files from

consider you have the current log sequence is 134.so the previous archive log file sequence is 133

$ ls -ltr /opt/oracle/arch/demo/1_13*
(It will display the current archive logfile. Dont try to move this file seq starts with 131,132,133 )
$ cd /opt/oracle/arch/demo;ls -ltr 1_1*
$ mv 1_12* /u01/oracle/backup/.

Note: After moving the archive files your Database Starts works Normally

Step 2 : Now catalog the Archivelog files moved to new location

RMAN> CATALOG STARTS WITH '/u01/oracle/backup';
RMAN> CROSSCHECK ARCHIVELOG ALL;

Step 3 : Now Kick the archivelog backup (if you have script just execute that script)

RMAN> run
{
backup archivelog all delete input;
}

No comments:

Post a Comment