Replies to This Discussion

Permalink Reply by Harry Rivero on June 17, 2013 at 11:29am

your posting is not consistent with the error message you gave:

The error message suggestst, that you created the controlfile, did a RESTORE of the database files and then try to open the DB.

Before opening you have to recover the DB.

So the steps are:

1.) start the db nomount
2.) restore the controlfiles
3.) mount the db
4.) restore the database
5.) recover the database;
6.) alter database open (maybe with the resetlog option);

• ▶ Reply

Permalink Reply by David McMann on June 17, 2013 at 11:31am

Thank you for your help..

• ▶ Reply

Permalink Reply by Harry Rivero on June 17, 2013 at 11:31am

O.K. But if you oppose, you should also post the proper way !

(To give a reason for your opposition would help me to learn what I did wrong all the years)

• ▶ Reply

Permalink Reply by David McMann on June 17, 2013 at 11:32am

I think you are getting in wrong way
A method you provide Is correct & it worked..
So thank you once again.

• ▶ Reply

▶ Reply to Discussion