OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Re:RMAN Queries

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re:RMAN Queries [message #225528]

Tue, 20 March 2007 04:17

rtskrajan
Messages: 43
Registered: March 2007

Member

While Taking backup thru RMAN some errors displayed like below.

ORA-19809: Limit exceeded for recovery files
ORA-19804: cannot reclaim ..... bytes disk space from .... limit

Report message to a moderator

Re:RMAN Queries [message #225532 is a reply to message #225528]

Tue, 20 March 2007 04:43

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-19809: limit exceeded for recovery files
Cause: The limit for recovery files specified by the DB_RECOVERY_FILE_DEST_SIZE was exceeded.
Action: The error is accompanied by 19804. See message 19804 for further details.

ORA-19804: cannot reclaim string bytes disk space from string limit
Cause: Oracle cannot reclaim disk space of specified bytes from the DB_RECOVERY_FILE_DEST_SIZE limit.
Action: There are five possible solutions: 1) Take frequent backup of recovery area using RMAN. 2) Consider changing RMAN retention policy. 3) Consider changing RMAN archivelog deletion policy. 4) Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE. 5) Delete files from recovery area using RMAN.

Regards
Michel

Report message to a moderator

Re:RMAN Queries [message #225535 is a reply to message #225532]

Tue, 20 March 2007 04:48

rtskrajan
Messages: 43
Registered: March 2007

Member

Thank you Michel....

I changed the setting db_recovery_dest_file_size to 10g ..

Now it is working fine..

thanks a lot..

Report message to a moderator

Previous Topic:	Exp to NFS or remote server
Next Topic:	scn in oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 22:37:48 CDT 2024