Re: How do I restore an old RMAN backup

Jack, you willing to share those scripts?

thanks, joe

Jack van Zanen wrote:

>Hi
>
>I think it will definately test the state of the backup files. If you can
>restore to a different machine I guess you can restore to original
>location.
>To be honest I have 3 tiny test databases (TEST1/2/3) that I've used to try
>all sorts of different backup and restore options and ended up with a nice
>set of test scripts (Examples that I missed in almost all the
>documentation). As far as implementing it in production, I've written the
>implementation plan but do not get the resources to testand implement at
>the moment.
>
>Jack
>
>
>
> DENNIS WILLIAMS
> <DWILLIAMS_at_LIFETO To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> UCH.COM> cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
> Sent by: Subject: RE: How do I restore an old RMAN backup
> root_at_fatcity.com
>
>
> 13-08-2002 17:48
> Please respond to
> ORACLE-L
>
>
>
>
>
>Jack - Thanks for including your script. Very helpful for RMAN novices like
>myself. Would you consider this a valid disaster recovery test? Thanks.
>
>Dennis Williams
>DBA
>Lifetouch, Inc.
>dwilliams_at_lifetouch.com
>
>
>-----Original Message-----
>Sent: Tuesday, August 13, 2002 5:43 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi
>
>
>Try
>
>
>Set until time clause in the restore (there is an issue with this I
>believe)
>
>This ,I guess, will force Rman to look for the appropriate backup.
>
>
>>From my test scripts:
>
>
>
>rman <<EOF
>connect target rman/rman_oracledba_at_test2
>connect catalog rman/rman_oracledba_at_test1
>connect auxiliary sys/oracledba_at_test3
>run {
>resync catalog;
>allocate auxiliary channel d1 type disk;
>allocate auxiliary channel d2 type disk;
># set until time "to_date('2002-01-29:15:16:53','yyyy-mm-dd:hh24:mi:ss')"
># set until time "to_date('30-JAN-2002 10:50:00','dd-mon-YYYY HH24:MI:SS')"
># set until time '31-JAN-2002 10:51:00'
>set until time 'sysdate-1/96';
># set until scn = 155534
>set newname for datafile '/data/oracle8/TEST2/systemTEST2.dbf' TO
>'/data/oracle8/TEST3/systemTEST3.dbf';
>set newname for datafile '/data/oracle8/TEST2/rbsTEST2.dbf' TO
>'/data/oracle8/TEST3/rbsTEST3.dbf';
>set newname for datafile '/data/oracle8/TEST2/tempTEST2.dbf' TO
>'/data/oracle8/TEST3/tempTEST3.dbf';
>set newname for datafile '/data/oracle8/TEST2/dataTEST2.dbf' TO
>'/data/oracle8/TEST3/dataTEST3.dbf';
>set newname for datafile '/data/oracle8//TEST2/tempTEST202.dbf' TO
>'/data/oracle8//TEST3/tempTEST302.dbf';
>sql 'alter system switch logfile';
>duplicate target database to test3
>LOGFILE
>'/data/oracle8/TEST3/redoTEST301.log' size 1M,
>'/data/oracle8/TEST3/redoTEST302.log' size 1M,
>'/data/oracle8/TEST3/redoTEST303.log' size 1M;
>}
>EOF
>
>Jack
>
>
>
>
>
>
> "Daiminger, Helmut"
>
> <Helmut.Daiminger_at_Kirc To: Multiple
>recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> hGruppe.de> cc: (bcc: Jack
>van
>Zanen/nlzanen1/External/MEY/NL)
> Sent by: Subject: How do I
>restore an old RMAN backup
> root_at_fatcity.com
>
>
>
>
>
> 13-08-2002 12:13
>
> Please respond to
>
> ORACLE-L
>
>
>
>
>
>
>
>
>Hi!
>
>
>I want to put a copy of the production database onto a test box. The deal
>is that I need to use the full backup taken on August 1st. How do I tell
>RMAN not to restore from the last backup, but use the one that was created
>almost two weeks ago?
>
>
>This is 8.1.7 on Solaris.
>
>
>Thanks,
>Helmut
>
>
>
>
>
>
>===================================================================
>De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
>uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
>vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
>derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
>Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
>volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
>voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
>verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
>worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.
>
>Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
>vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
>en het origineel en eventuele kopieën te verwijderen en te vernietigen.
>
>Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
>voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
>algemene voorwaarden worden u op verzoek kosteloos toegezonden.
>=====================================================================
>The information contained in this communication is confidential and is
>intended solely for the use of the individual or entity to whom it is
>addressed. You should not copy, disclose or distribute this communication
>without the authority of Ernst & Young. Ernst & Young is neither liable for
>the proper and complete transmission of the information contained in this
>communication nor for any delay in its receipt. Ernst & Young does not
>guarantee that the integrity of this communication has been maintained nor
>that the communication is free of viruses, interceptions or interference.
>
>If you are not the intended recipient of this communication please return
>the communication to the sender and delete and destroy all copies.
>
>In carrying out its engagements, Ernst & Young applies general terms and
>conditions, which contain a clause that limits its liability. A copy of
>these terms and conditions is available on request free of charge.
>===================================================================
>
>
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jack van Zanen
> INET: nlzanen1_at_EY.NL
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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.com
>--
>Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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).
>
>
>
>===================================================================
>De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
>uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
>vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
>derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
>Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
>volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
>voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
>verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
>worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.
>
>Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
>vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
>en het origineel en eventuele kopieën te verwijderen en te vernietigen.
>
>Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
>voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
>algemene voorwaarden worden u op verzoek kosteloos toegezonden.
>=====================================================================
>The information contained in this communication is confidential and is
>intended solely for the use of the individual or entity to whom it is
>addressed. You should not copy, disclose or distribute this communication
>without the authority of Ernst & Young. Ernst & Young is neither liable for
>the proper and complete transmission of the information contained in this
>communication nor for any delay in its receipt. Ernst & Young does not
>guarantee that the integrity of this communication has been maintained nor
>that the communication is free of viruses, interceptions or interference.
>
>If you are not the intended recipient of this communication please return
>the communication to the sender and delete and destroy all copies.
>
>In carrying out its engagements, Ernst & Young applies general terms and
>conditions, which contain a clause that limits its liability. A copy of
>these terms and conditions is available on request free of charge.
>===================================================================
>
>
>
>
>
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: jtesta_at_dmc-it.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).