Home » RDBMS Server » Backup & Recovery » DB_RECOVERY_FILE_DEST
icon5.gif  DB_RECOVERY_FILE_DEST [message #155593] Tue, 17 January 2006 09:25 Go to next message
pirione
Messages: 1
Registered: January 2006
Junior Member
Hi,
I have this problem:
ORA19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

oracle version is 10g on Linux(red hat).
The db had worked fine until I restarted it .
Some one could help me?

Report message to a moderator

Re: DB_RECOVERY_FILE_DEST [message #155674 is a reply to message #155593] Tue, 17 January 2006 23:07 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

The error is self explanatory ,

cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE


Set the DB_RECOVERY_FILE_DEST_SIZE to a valid value and then use DB_RECOVERY_FILE_DEST paramter.

you can check through the following command

SQL> show parameter db_recovery_file

Report message to a moderator

Previous Topic: Migration to Oracle 10
Next Topic: online redo logs
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 19:37:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.