Home » RDBMS Server » Backup & Recovery » Database will not startup! db_recovery_file_dest
Database will not startup! db_recovery_file_dest [message #161453] Sat, 04 March 2006 08:48 Go to next message
lhradowy
Messages: 5
Registered: June 2005
Location: Winnipeg, Canada
Junior Member
Oracle 10g
Shutdown database for backup, everything fine
Went to startup and this message


SQL> connect / AS sysdba;
Connected to an idle instance.
SQL> startup
ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
ORA-01262: Stat failed on a file destination directory
Linux Error: 2: No such file or directory
SQL>
Re: Database will not startup! db_recovery_file_dest [message #161542 is a reply to message #161453] Mon, 06 March 2006 00:14 Go to previous message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
Check your parameter db_recovery_file_dest and confirm if it is a valid path and oracle have the privilege to write on it.

Try:
SQL> start nomount
SQL> create pfile='/tmp/init.txt' from spfile;

find db_recovery_file_dest in file /tmp/init.txt

Alex zeng | Skype me: hans9zeng
Previous Topic: Hot bkp
Next Topic: Restore tablespace to another server via RMAN to a point in time
Goto Forum:
  


Current Time: Sat Apr 20 09:11:35 CDT 2024