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@LIFETO To: Multiple recipients of list >ORACLE-L <[EMAIL PROTECTED]> > UCH.COM> cc: (bcc: Jack van >Zanen/nlzanen1/External/MEY/NL) > Sent by: Subject: RE: How do I restore an old >RMAN backup > [EMAIL PROTECTED] > > > > > > 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. >[EMAIL PROTECTED] > > >-----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@test2 >connect catalog rman/rman_oracledba@test1 >connect auxiliary sys/oracledba@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@Kirc To: Multiple >recipients of list ORACLE-L <[EMAIL PROTECTED]> > hGruppe.de> cc: (bcc: Jack >van >Zanen/nlzanen1/External/MEY/NL) > Sent by: Subject: How do I >restore an old RMAN backup > [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).