Home » RDBMS Server » Backup & Recovery » Need Help (Oracle 11g, Release 2, Linux)
Need Help [message #486529] Thu, 16 December 2010 04:46 Go to next message
Viren Patel
Messages: 2
Registered: December 2010
Location: Ahmedabad Gujrat India
Junior Member
Can any one help me that, How can i recover database from cold backup.

when I fired startup mount pfile='backup_directory_location/init.ora'
It will give me an error
ORA-48108: invalid value given for the diagnostic_dest init.ora parameter
ORA-48140: the specified ADR Base directory does not exist
ORA-48187: specified directory does not exist
Please see the attachment...

AND

when I give this command
startup mount pfile='backup_directory_location/spfileSID.ora'
then i get this errors
ORA-01078:failure in processing system parameters
LRM-00123:invalid character number found in the input file

Please any one help me
Thanks in advance.
  • Attachment: 1.jpg
    (Size: 82.11KB, Downloaded 1544 times)

Report message to a moderator

Re: Need Help [message #486531 is a reply to message #486529] Thu, 16 December 2010 05:01 Go to previous message
Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
ORA-48108: invalid value given for the diagnostic_dest init.ora parameter
ORA-48140: the specified ADR Base directory does not exist

Just change this parameter to point to an existing and accessible directory.

Regards
Michel

Report message to a moderator

Previous Topic: how to recover a table after dropping(using time based recovery)
Next Topic: Redo Log changes not recovered in RMAN recovery after restoring control file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Aug 29 23:32:16 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.