Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Server > DBPITR and ORA-...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 14 Topic 16497 of 16853
Post > Topic >>

DBPITR and ORA-16005 Error: database requires recovery.

by "gbahut@[EMAIL PROTECTED] " <gbahut@[EMAIL PROTECTED] > May 2, 2008 at 10:04 AM

Hi,

 I am trying to test database point in time recovery scenarios in
which I want to Open read-only the database before using RESETLOGS
clause. The test was ran on a Oracle 10gR2 single instance.

1) Perform backup using RMAN default channel, no recovery catalog and
having control file autobackup enabled.
RUN {
BACKUP DATABASE;
BACKUP ARCHIVELOG ALL NOT BACKED UP DELETE ALL INPUT;
}

2) Get the current SCN from V$DATABASE. Call it SCN1.

3) DROP a table. Shutdown Immediate and mount the database.

4) Perform a DBPITR up to SCN1:
RUN {
SET UNTIL SCN [SCN1];
RESTORE DATABASE;
RECOVER DATABASE;
}

5) When trying to open the database in read only mode
RMAN> SQL 'ALTER  DATABASE OPEN READ ONLY'
 The command fails with ORA-16005: database requires recovery.

I can only open the database read-write using RESETLOGS clause, but
this leave me without the chance of verifying the data before creating
a new database incarnation.

Does anyone have any clue about why is this happening?

Thanks for your help.

G. Bahut.




 14 Posts in Topic:
DBPITR and ORA-16005 Error: database requires recovery.
"gbahut@[EMAIL PROTE  2008-05-02 10:04:37 
Re: DBPITR and ORA-16005 Error: database requires recovery.
"fitzjarrell@[EMAIL   2008-05-02 10:26:27 
Re: DBPITR and ORA-16005 Error: database requires recovery.
"gbahut@[EMAIL PROTE  2008-05-02 12:53:43 
Re: DBPITR and ORA-16005 Error: database requires recovery.
"fitzjarrell@[EMAIL   2008-05-02 13:57:38 
Re: DBPITR and ORA-16005 Error: database requires recovery.
vitalisman@[EMAIL PROTECT  2008-05-05 00:52:25 
Re: DBPITR and ORA-16005 Error: database requires recovery.
"gbahut@[EMAIL PROTE  2008-05-05 01:00:48 
Re: DBPITR and ORA-16005 Error: database requires recovery.
vitalisman@[EMAIL PROTECT  2008-05-05 01:29:38 
Re: DBPITR and ORA-16005 Error: database requires recovery.
tim2boles@[EMAIL PROTECTE  2008-05-05 07:25:03 
Re: DBPITR and ORA-16005 Error: database requires recovery.
joel garry <joel-garry  2008-05-05 10:05:17 
Re: DBPITR and ORA-16005 Error: database requires recovery.
tim2boles@[EMAIL PROTECTE  2008-05-05 13:05:11 
Re: DBPITR and ORA-16005 Error: database requires recovery.
joel garry <joel-garry  2008-05-05 14:49:46 
Re: DBPITR and ORA-16005 Error: database requires recovery.
"gbahut@[EMAIL PROTE  2008-05-06 01:43:16 
Re: DBPITR and ORA-16005 Error: database requires recovery.
vitalisman@[EMAIL PROTECT  2008-05-06 02:14:36 
Re: DBPITR and ORA-16005 Error: database requires recovery.
"gbahut@[EMAIL PROTE  2008-05-06 05:07:48 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sat Jul 5 5:23:12 CDT 2008.