Re: Planning Test Backup/Recovery
ok. Thanks for answers. Regards Eriovaldo - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, March 04, 2002 11:18 AM > Eriovaldo, > > If I were you, I would create a small test database on the production > machine, and perform backup/restore of that test database to be sure that > everything is working before I would try it on a production database. > > Once you are convinced that everything works, schedule a down time where you > can test backup/restore of the production database. > > I would also keep the test db on the production box, and as a regular > monthly schedule, test backup and restore of that database - just to make > sure that it continues to work. > > Hope this helps. > > Tom Mercadante > Oracle Certified Professional > > > -Original Message- > Sent: Monday, March 04, 2002 7:48 AM > To: Multiple recipients of list ORACLE-L > > > There should not be any problem to test the backup. > However we are testing the restores to another machine, > not on the production machine. > > Yechiel Adar, Mehish Computer Services > [EMAIL PROTECTED] > > > -Original Message- > > From: Eca Eca [SMTP:[EMAIL PROTECTED]] > > Sent: Mon, March 04, 2002 1:18 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Planning Test Backup/Recovery > > > > > > Hi all : > > > > Does anyone have a planning for test backup and recovery ? > > > > I have the scripts and i am doing the backup and now we need to test it > > in production environment. > > > > I have tested it at another environment and got sucess. > > > > but at production ... it need to be very very careful ... > > > > Any sugestion ? > > > > Regards > > > > Eriovaldo > > > > > > > > > > _ > > O MSN Photos é o jeito mais fácil de compartilhar, editar e imprimir suas > > fotos preferidas: http://photos.msn.com.br/support/worldwide.aspx > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Eca Eca > > 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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC? 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: Mercadante, Thomas F > 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: Eriovaldo Andrietta 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).
RE: Planning Test Backup/Recovery - Tom
Eriovaldo, If you already have a backup script, then you need to test it on the production machine. The test db you create does not necessarily have to be the same size as the production db (init.ora params can be smaller). But what you are testing is that your backup scripts run as expected on the production machine. Your init.ora params can be smaller (like a smaller SGA) to prove that it works ok. Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, March 04, 2002 12:39 PM To: Multiple recipients of list ORACLE-L Tom : I am thinking something like that .. I have already did the test at another machine ... It worked right... but the instance was diferente ... So, in your opinion i need to create a instance, in the production machine, with the same parameters of production and apply the test there, righ ... But , how can i to create a instance with the same parameters ? Should i use the init.ora of the production instance ? Thanks. Eriovaldo >From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Planning Test Backup/Recovery >Date: Mon, 04 Mar 2002 06:18:22 -0800 > >Eriovaldo, > >If I were you, I would create a small test database on the production >machine, and perform backup/restore of that test database to be sure that >everything is working before I would try it on a production database. > >Once you are convinced that everything works, schedule a down time where >you >can test backup/restore of the production database. > >I would also keep the test db on the production box, and as a regular >monthly schedule, test backup and restore of that database - just to make >sure that it continues to work. > >Hope this helps. > >Tom Mercadante >Oracle Certified Professional > > >-Original Message- >Sent: Monday, March 04, 2002 7:48 AM >To: Multiple recipients of list ORACLE-L > > >There should not be any problem to test the backup. >However we are testing the restores to another machine, >not on the production machine. > >Yechiel Adar, Mehish Computer Services >[EMAIL PROTECTED] > > > -Original Message- > > From: Eca Eca [SMTP:[EMAIL PROTECTED]] > > Sent: Mon, March 04, 2002 1:18 PM > > To: Multiple recipients of list ORACLE-L > > Subject:Planning Test Backup/Recovery > > > > > > Hi all : > > > > Does anyone have a planning for test backup and recovery ? > > > > I have the scripts and i am doing the backup and now we need to test it > > in production environment. > > > > I have tested it at another environment and got sucess. > > > > but at production ... it need to be very very careful ... > > > > Any sugestion ? > > > > Regards > > > > Eriovaldo > > > > > > > > > > _ > > O MSN Photos é o jeito mais fácil de compartilhar, editar e imprimir >suas > > fotos preferidas: http://photos.msn.com.br/support/worldwide.aspx > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Eca Eca > > 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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC? 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: Mercadante,
RE: Planning Test Backup/Recovery - Tom
Tom : I am thinking something like that .. I have already did the test at another machine ... It worked right... but the instance was diferente ... So, in your opinion i need to create a instance, in the production machine, with the same parameters of production and apply the test there, righ ... But , how can i to create a instance with the same parameters ? Should i use the init.ora of the production instance ? Thanks. Eriovaldo >From: "Mercadante, Thomas F" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Planning Test Backup/Recovery >Date: Mon, 04 Mar 2002 06:18:22 -0800 > >Eriovaldo, > >If I were you, I would create a small test database on the production >machine, and perform backup/restore of that test database to be sure that >everything is working before I would try it on a production database. > >Once you are convinced that everything works, schedule a down time where >you >can test backup/restore of the production database. > >I would also keep the test db on the production box, and as a regular >monthly schedule, test backup and restore of that database - just to make >sure that it continues to work. > >Hope this helps. > >Tom Mercadante >Oracle Certified Professional > > >-Original Message- >Sent: Monday, March 04, 2002 7:48 AM >To: Multiple recipients of list ORACLE-L > > >There should not be any problem to test the backup. >However we are testing the restores to another machine, >not on the production machine. > >Yechiel Adar, Mehish Computer Services >[EMAIL PROTECTED] > > > -Original Message- > > From: Eca Eca [SMTP:[EMAIL PROTECTED]] > > Sent: Mon, March 04, 2002 1:18 PM > > To: Multiple recipients of list ORACLE-L > > Subject:Planning Test Backup/Recovery > > > > > > Hi all : > > > > Does anyone have a planning for test backup and recovery ? > > > > I have the scripts and i am doing the backup and now we need to test it > > in production environment. > > > > I have tested it at another environment and got sucess. > > > > but at production ... it need to be very very careful ... > > > > Any sugestion ? > > > > Regards > > > > Eriovaldo > > > > > > > > > > _ > > O MSN Photos é o jeito mais fácil de compartilhar, editar e imprimir >suas > > fotos preferidas: http://photos.msn.com.br/support/worldwide.aspx > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Eca Eca > > 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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC? 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: Mercadante, Thomas F > 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 comman
RE: Planning Test Backup/Recovery
Eriovaldo, If I were you, I would create a small test database on the production machine, and perform backup/restore of that test database to be sure that everything is working before I would try it on a production database. Once you are convinced that everything works, schedule a down time where you can test backup/restore of the production database. I would also keep the test db on the production box, and as a regular monthly schedule, test backup and restore of that database - just to make sure that it continues to work. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, March 04, 2002 7:48 AM To: Multiple recipients of list ORACLE-L There should not be any problem to test the backup. However we are testing the restores to another machine, not on the production machine. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Eca Eca [SMTP:[EMAIL PROTECTED]] > Sent: Mon, March 04, 2002 1:18 PM > To: Multiple recipients of list ORACLE-L > Subject: Planning Test Backup/Recovery > > > Hi all : > > Does anyone have a planning for test backup and recovery ? > > I have the scripts and i am doing the backup and now we need to test it > in production environment. > > I have tested it at another environment and got sucess. > > but at production ... it need to be very very careful ... > > Any sugestion ? > > Regards > > Eriovaldo > > > > > _ > O MSN Photos é o jeito mais fácil de compartilhar, editar e imprimir suas > fotos preferidas: http://photos.msn.com.br/support/worldwide.aspx > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Eca Eca > 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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC? 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: Mercadante, Thomas F 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).
RE: Planning Test Backup/Recovery
There should not be any problem to test the backup. However we are testing the restores to another machine, not on the production machine. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Eca Eca [SMTP:[EMAIL PROTECTED]] > Sent: Mon, March 04, 2002 1:18 PM > To: Multiple recipients of list ORACLE-L > Subject: Planning Test Backup/Recovery > > > Hi all : > > Does anyone have a planning for test backup and recovery ? > > I have the scripts and i am doing the backup and now we need to test it > in production environment. > > I have tested it at another environment and got sucess. > > but at production ... it need to be very very careful ... > > Any sugestion ? > > Regards > > Eriovaldo > > > > > _ > O MSN Photos é o jeito mais fácil de compartilhar, editar e imprimir suas > fotos preferidas: http://photos.msn.com.br/support/worldwide.aspx > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Eca Eca > 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: =?iso-8859-8?Q?àãø_éçéàì? 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).
