Home » RDBMS Server » Backup & Recovery » Re:RMAN Queries
Re:RMAN Queries [message #225528] Tue, 20 March 2007 04:17 Go to next message
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
Re:RMAN Queries [message #225532 is a reply to message #225528] Tue, 20 March 2007 04:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
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
Re:RMAN Queries [message #225535 is a reply to message #225532] Tue, 20 March 2007 04:48 Go to previous message
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..
Previous Topic: Exp to NFS or remote server
Next Topic: scn in oracle
Goto Forum:
  


Current Time: Sun Dec 11 04:37:55 CST 2016

Total time taken to generate the page: 0.03998 seconds