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 > Re: DBPITR and ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 6 of 14 Topic 16497 of 17024
Post > Topic >>

Re: DBPITR and ORA-16005 Error: database requires recovery.

by "gbahut@[EMAIL PROTECTED] " <gbahut@[EMAIL PROTECTED] > May 5, 2008 at 01:00 AM

> Where have you read you can open the database in READONLY mode without
> any resetlogs in this situation?

Oracle=AE Database Backup and Recovery Basics:
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/toc.htm

Sections 7.6.4 and 7.6.5.

 7.6.4 Database Point-in-Time Recovery Within the Current Incarnation.

"If the operation completes without errors, then your DBPITR has
succeeded. You can open the database read-only and perform queries as
needed to ensure that the effects of the logical corruption have been
reversed. If not, you may have chosen the wrong target SCN."

7.6.5 Options After Database Point-in-Time Recovery.

"After a successful DBPITR, your choices are:

    *  Ex****t one or more objects from your database using an Oracle
ex****t utility such as Data Pump Ex****t. You can then recover the
database to the current point in time and re-im****t the ex****ted
objects, as a way to return these objects to their state prior to the
unwanted change without abandoning all other changes.
    *   Open your database for read-write, abandoning all changes
after the target SCN. In such a case, you must open the database with
the RESETLOGS option, as shown here:
      RMAN> ALTER DATABASE OPEN RESETLOGS; "
 




 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
tan12V112 Thu Aug 21 20:45:57 CDT 2008.