Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Restoring DB from specific RMAN backup set.

RE: Restoring DB from specific RMAN backup set.

From: John Weatherman <john.weatherman_at_replacements.com>
Date: Thu, 19 Dec 2002 12:07:36 -0800
Message-ID: <F001.0051ED8B.20021219120736@fatcity.com> 





At 1st and 3rd?



-----Original Message-----



Sent: Thursday, December 19, 2002 2:42 PM
To: Multiple recipients of list ORACLE-L



Fortunately that is not the real SID name, had to sanitize it before I
posted.  Realized after I sent it that DB2 was not the best choice.
Where are Abbot and Costello when you need them :)



--



Paul





-----Original Message-----



Sent: Thursday, December 19, 2002 2:29 PM
To: ORACLE-L_at_fatcity.com


Cc: pheely_at_progeny.net




Paul, 



Who chose 'DB2' as a SID?



That must be confusing.



DBA1:  What are you backing up?



DBA2:  DB2


DBA1:  What?  I thought it was an Oracle database?



DBA2:  Yeah it is, DB2.



DBA1:  But if it's Oracle, why are you backing up DB2?



DBA2:  It's an Oracle database called DB2.



DBA1:  But, if you call Oracle DB2, what do you call DB2?



DBA2:  DB2.


DBA1:  ARRRGGHHHHH!!


...








"Paul Heely" <pheely_at_progeny.net>


Sent by: root_at_fatcity.com


 12/19/2002 10:17 AM


 Please respond to ORACLE-L

 


        To:     Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>

        cc: 
        Subject:        RE: Restoring DB from specific RMAN backup set.






Database is 9.0.1.4 running on Win2K.



The database called DB2 is not running in archivelog mode.



The database is being backed up using RMAN:  I.e.
set ORACLE_SID=DB2


rman target / catalog rman_at_otherdb


shutdown immediate;


startup mount;


backup database format="f:\oracle_backup\%d\%d_%U" tag full_backup;
alter database open;




I figured out what the problem was.  After I restored the controlfile
from the autobackup file I was not mounting the database before doing a
database restore.



Thanks.


--



Paul





-----Original Message-----



WILLIAMS



Sent: Thursday, December 19, 2002 11:45 AM
To: Multiple recipients of list ORACLE-L




Paul - Can you specify what you mean by "no archive log mode" and
"backed up with RMAN"? Was the database open?


   Which Oracle version?



Dennis Williams


DBA, 40%OCP



Lifetouch, Inc.


dwilliams_at_lifetouch.com 




-----Original Message-----



Sent: Thursday, December 19, 2002 9:40 AM
To: Multiple recipients of list ORACLE-L




How can I restore a database from a specific RMAN backup set?  We have a
database running in no archive log mode that is backed up with RMAN.
There is an RMAN catalog DB also.



If I look at the backup summary I see:


List of Database Incarnations


DB Key  Inc Key DB Name  DB ID            CUR Reset SCN  Reset Time


------- ------- -------- ---------------- --- ---------- ----------


37      38      DB2      1600772452       NO  1          15-NOV-02
37      256     DB2      1600772452       NO  259591     23-NOV-02
37      627     DB2      1600772452       NO  792890     11-DEC-02
37      654     DB2      1600772452       NO  792890     11-DEC-02
37      712     DB2      1600772452       NO  792890     11-DEC-02
37      680     DB2      1600772452       NO  792890     11-DEC-02
37      764     DB2      1600772452       NO  823456     11-DEC-02
37      816     DB2      1600772452       YES 823456     18-DEC-02
37      893     DB2      1600772452       NO  823456     19-DEC-02





The backup summary list looks like:


List of Backups




Key     TY LV S Device Type Completion Time #Pieces #Copies Tag


------- -- -- - ----------- --------------- ------- ------- ---


47      B  F  A DISK        15-NOV-02       1       1
63      B  F  A DISK        15-NOV-02       1       1
WORKFLOW_AND_PORTAL
306     B  F  A DISK        23-NOV-02       1       1
314     B  F  A DISK        23-NOV-02       1       1
404     B  F  A DISK        26-NOV-02       1       1
FULL_BACKUP_9014_PATCH
413     B  F  A DISK        26-NOV-02       1       1
729     B  F  A DISK        11-DEC-02       1       1
FULL_DB_INSTALLED
749     B  F  A DISK        11-DEC-02       1       1
791     B  F  A DISK        18-DEC-02       1       1       WF_TESTING
811     B  F  A DISK        18-DEC-02       1       1
867     B  F  A DISK        19-DEC-02       1       1       SW_MIGRATION
888     B  F  A DISK        19-DEC-02       1       1





I've tried resetting the database to incarnation 816, but when I restore
the control file and data files from that it is not what I think it
should be.  I end up with FULL_DB_INSTALLED.  I can restore the control
file I want from the auto backup file.  How can I then tell RMAN to
restore the data files associated with either backup set 791
(tag=WF_TESTING)?



Thanks.


--



Paul




-- 



Please see the official ORACLE-L FAQ: http://www.orafaq.net


-- 



Author: Paul Heely


  INET: pheely_at_progeny.net


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).


-- 



Please see the official ORACLE-L FAQ: http://www.orafaq.net


-- 



Author: DENNIS WILLIAMS


  INET: DWILLIAMS_at_LIFETOUCH.COM



Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).



-- 



Please see the official ORACLE-L FAQ: http://www.orafaq.net


-- 



Author: Paul Heely


  INET: pheely_at_progeny.net


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).





-- 



Please see the official ORACLE-L FAQ: http://www.orafaq.net


-- 



Author: Paul Heely


  INET: pheely_at_progeny.net


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 



Please see the official ORACLE-L FAQ: http://www.orafaq.net


-- 



Author: John Weatherman


  INET: john.weatherman_at_replacements.com


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Dec 19 2002 - 14:07:36 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US