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;
}
Feb 12, 2010
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment