deleting files in recovery area [message #215410] |
Mon, 22 January 2007 03:19 |
koff10
Messages: 58 Registered: December 2006 Location: france
|
Member |
|
|
Hi all,
I got alert message in OEM, that my oracle database has the
recovery area full in 95 % .
So I don't know how to clean this this area or how to solve this problem.
I'm not using RMAN.
Any help welcome.
thanks
koff
|
|
|
|
|
Re: deleting files in recovery area [message #215477 is a reply to message #215459] |
Mon, 22 January 2007 07:48 |
koff10
Messages: 58 Registered: December 2006 Location: france
|
Member |
|
|
user52 wrote on Mon, 22 January 2007 13:42 | Hi,
Flash_recovery_area is used for Backup set , Archive log , flashback, Autobackup.
for delete backup from flash_recovery_area
connect to RMAN.
rman>report oboslete;
rman>delete oboslete;
or
rman>crosscheck database backup;
rman>crosscheck archivelog all;
rman>delete expired backup;
rman>delete expired archivelog all;
after that check V$RECOVERY_FILE_SIZE view
regards
Taj
|
Thanks form your answers.
As I wrote, I didn't configure RMAN in my database. so I can't use RMAN.
Is there others way to reduce size in my Flash_recovery_area ?
thanks again
koff
|
|
|
|
Re: deleting files in recovery area [message #215495 is a reply to message #215477] |
Mon, 22 January 2007 09:32 |
|
ebrian
Messages: 2794 Registered: April 2006
|
Senior Member |
|
|
You don't actually have to be backing up with RMAN to manage the flash_recovery_area. Once you have the archive logs backed up, simply issue the following:
Launch RMAN as follows:
C:\> set oracle_sid=<sid_name>
C:\> rman target /
Once in RMAN issue the following:
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
|
|
|