Jump to content
Temur

Error: control file or datafile 8 is from before the last RESETLOGS

Recommended Posts

I have a problem. I have db oracle 11g. I recovered db from a backup of past state. Appeared 2 datafiles with the names MISSING0000x.

I renamed the datafiles with command SET NEWNAME. Then I wanted to take the datafiles online, but I got the following error:

control file or datafile 8 is from before the last RESETLOGS.

What to do ?

Share this post


Link to post
Share on other sites

At second link I found out that need to RESET DATABASE. For that need control file from autobackup. I haven't recovery catalog (how to find out whether there is it or not ?).

Where is autobackup ? How can I get it ? I have only the whole database backup.

Best

Temur

 

Share this post


Link to post
Share on other sites

Thank you for your links. I have read them.

Recently I wanted to do RESET DATABASE. Oracle documentation suggests the following commands

connect target /

startup force nomount

reset database to incarnation 2

run {

set until time "date time"

restore controlfile from autobackup

alter database mount

restore database

recover database

}

alter database open resetlogs

In this view my db has given error: db not mounted. I haven't recovery catalog. So I changed: startup force mount.

Command reset database to incarnation 2 has given a result. But the command restore controlfile from autobackup 

has given an error: need to use clause TO in mount or open mode. Then I put the command startup force nomount

before the command restore controlfile from autobackup. At this time rman has given an error: db not mounted.

I don't know in what work is. Please help me !

Best

Temur

 

Share this post


Link to post
Share on other sites

Hi Temur,

What was the exact message?

Is this a production database?

If so, you need to open a severity 1service with MOSC:

http://support.oracle.com

You payed for Oracle support, you should use them!

As I noted, I cannot assist in production recoveries for liability reasons, sorry.

Good luck!

 

 

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×