?
Solved

flash recovery area is corrupt/missing?

Posted on 2008-11-10
7
Medium Priority
?
1,319 Views
Last Modified: 2013-12-19
Hi, I had configured my flash recovery area on an external drive ( a usb drive). Now the configured drive is missing / corrupt and when I do a startup command I get the followig errror;

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>
What do I do? How can I run the following cammand to change the FRA
 
alter system set db_recovery_file_dest='\home\oracle\FRA' ?

Thanks for the help.

A

0
Comment
Question by:aej1973
  • 4
  • 3
7 Comments
 
LVL 16

Accepted Solution

by:
Richard Olutola earned 500 total points
ID: 22928711
You need to change the db_recovery_file_dest parameters in the parameter file (init<sid>.ora) and start the database using the changed pfile.

R.

0
 

Author Comment

by:aej1973
ID: 22930127
Great! Thank you.

A
0
 

Author Comment

by:aej1973
ID: 22932251
I realized that I do not have an init<SID>.ora file, the parameter file I have is spfile<SID>.ora file. What do I need to do? Thanks for thehelp.

A
0
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
LVL 16

Expert Comment

by:Richard Olutola
ID: 22932723
That is a problem. The spfile file is binary and cannot be edited.

In a deperate situation I have tried to open the spfile and copied it into a pfile (init<SID>.ora).

R.
0
 

Author Comment

by:aej1973
ID: 22939334
how do I make sure that  I also have an updated init<SID>.ora) file on my system? Thanks for the help.

A
0
 
LVL 16

Expert Comment

by:Richard Olutola
ID: 22939534
You can periodically issue the following command from sql*plus

SQL>create pfile form spfile;

This saves your server parameter file in pfile (ASCII) format. If you have problems starting the database in future you can edit the pfile and start the database using that.

R.

0
 

Author Comment

by:aej1973
ID: 22939619
Thanks a ton rolutola, that worked.

A
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses
Course of the Month16 days, 21 hours left to enroll

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question