SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 05:48 AM
| ||||
| ||||
 backups I run Oracle 10g on a Win 2003 server. I have backups going to one of the drives on my DB. I would like to copy those files to a tape for offsite storage. If I then had to restore the DB for any reason could I then restore those files from the tape and then restore the whole database?      |
|
02-26-2008, 05:48 AM
| |||
| |||
| Re: backups -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 cptkirkh schreef: > I run Oracle 10g on a Win 2003 server. I have backups going to one > of the drives on my DB. I would like to copy those files to a tape > for offsite storage. If I then had to restore the DB for any reason > could I then restore those files from the tape and then restore the > whole database? > Define your definition of backup. If it does not have the capital letters, A, M, N and R somewhere, further discussion is quite useless in my opinion. - -- Regards, Frank van Bortel Top-posting is one way to shut me up... -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (MingW32) iD8DBQFGTI1YLw8L4IAs830RAh+0AJ9K96368tsD3TuvOdm3FB/gKetyQACgheS4 xMa5VumiABSp9e+FiopRYxU= =Y9lX -----END PGP SIGNATURE----- |
|
02-26-2008, 05:48 AM
| |||
| |||
| Re: backups On May 17, 12:14 pm, Frank van Bortel <frank.van.bor...@gmail.com> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > cptkirkh schreef: > > > I run Oracle 10g on a Win 2003 server. I have backups going to one > > of the drives on my DB. I would like to copy those files to a tape > > for offsite storage. If I then had to restore the DB for any reason > > could I then restore those files from the tape and then restore the > > whole database? > > Define your definition of backup. If it does not > have the capital letters, A, M, N and R somewhere, > further discussion is quite useless in my opinion. > - -- > Regards, > Frank van Bortel > > Top-posting is one way to shut me up... > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.1 (MingW32) > > iD8DBQFGTI1YLw8L4IAs830RAh+0AJ9K96368tsD3TuvOdm3FB/gKetyQACgheS4 > xMa5VumiABSp9e+FiopRYxU= > =Y9lX > -----END PGP SIGNATURE----- Sorry i thought RMAN was the default for this group. I don't use RMAN to backup them up to tape. I use veritas to take the backup files to tape. |
|
02-26-2008, 05:48 AM
| |||
| |||
| Re: backups -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 cptkirkh schreef: > On May 17, 12:14 pm, Frank van Bortel <frank.van.bor...@gmail.com> > wrote: > cptkirkh schreef: > >>>> I run Oracle 10g on a Win 2003 server. I have backups going to one >>>> of the drives on my DB. I would like to copy those files to a tape >>>> for offsite storage. If I then had to restore the DB for any reason >>>> could I then restore those files from the tape and then restore the >>>> whole database? > Define your definition of backup. If it does not > have the capital letters, A, M, N and R somewhere, > further discussion is quite useless in my opinion. > Sorry i thought RMAN was the default for this group. I don't use RMAN > to backup them up to tape. I use veritas to take the backup files to > tape. OK - so you do use RMAN. Minor question: why not to tape directly? As long as you can restore them to the path you copied the RMAN generated files, there's no problem. If not, you'll have to fiddle with the RMAN location variables. - -- Regards, Frank van Bortel Top-posting is one way to shut me up... -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (MingW32) iD8DBQFGTJ2CLw8L4IAs830RAh1tAJ9ulByPdUPC9L9R9WMZEJ 9iA6NqdwCfb9O4 Y/d2WbBf7Q6DwxDgPmk3VQQ= =SIMX -----END PGP SIGNATURE----- |
|
02-26-2008, 05:48 AM
| |||
| |||
| Re: backups On May 17, 1:22 pm, Frank van Bortel <frank.van.bor...@gmail.com> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > cptkirkh schreef: > > > On May 17, 12:14 pm, Frank van Bortel <frank.van.bor...@gmail.com> > > wrote: > > cptkirkh schreef: > > >>>> I run Oracle 10g on a Win 2003 server. I have backups going to one > >>>> of the drives on my DB. I would like to copy those files to a tape > >>>> for offsite storage. If I then had to restore the DB for any reason > >>>> could I then restore those files from the tape and then restore the > >>>> whole database? > > Define your definition of backup. If it does not > > have the capital letters, A, M, N and R somewhere, > > further discussion is quite useless in my opinion. > > Sorry i thought RMAN was the default for this group. I don't use RMAN > > to backup them up to tape. I use veritas to take the backup files to > > tape. > > OK - so you do use RMAN. Minor question: why not to tape > directly? > > As long as you can restore them to the path you copied > the RMAN generated files, there's no problem. > If not, you'll have to fiddle with the RMAN location > variables. > - -- > Regards, > Frank van Bortel > > Top-posting is one way to shut me up... > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.1 (MingW32) > > iD8DBQFGTJ2CLw8L4IAs830RAh1tAJ9ulByPdUPC9L9R9WMZEJ 9iA6NqdwCfb9O4 > Y/d2WbBf7Q6DwxDgPmk3VQQ= > =SIMX > -----END PGP SIGNATURE----- Because I have 20 other servers, non oracle, to backup and RMAN can't do that. |
|
02-26-2008, 05:48 AM
| |||
| |||
| Re: backups On May 17, 1:22 pm, Frank van Bortel <frank.van.bor...@gmail.com> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > cptkirkh schreef: > > > On May 17, 12:14 pm, Frank van Bortel <frank.van.bor...@gmail.com> > > wrote: > > cptkirkh schreef: > > >>>> I run Oracle 10g on a Win 2003 server. I have backups going to one > >>>> of the drives on my DB. I would like to copy those files to a tape > >>>> for offsite storage. If I then had to restore the DB for any reason > >>>> could I then restore those files from the tape and then restore the > >>>> whole database? > > Define your definition of backup. If it does not > > have the capital letters, A, M, N and R somewhere, > > further discussion is quite useless in my opinion. > > Sorry i thought RMAN was the default for this group. I don't use RMAN > > to backup them up to tape. I use veritas to take the backup files to > > tape. > > OK - so you do use RMAN. Minor question: why not to tape > directly? > > As long as you can restore them to the path you copied > the RMAN generated files, there's no problem. > If not, you'll have to fiddle with the RMAN location > variables. > - -- > Regards, > Frank van Bortel > > Top-posting is one way to shut me up... > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.1 (MingW32) > > iD8DBQFGTJ2CLw8L4IAs830RAh1tAJ9ulByPdUPC9L9R9WMZEJ 9iA6NqdwCfb9O4 > Y/d2WbBf7Q6DwxDgPmk3VQQ= > =SIMX > -----END PGP SIGNATURE----- By path I would assume since we are talking windows to the same drive letter and folder correct? I have one other question also. If I want to practice restore functions in RMAN can I use those same backup files and restore to a new server and will that restore change any of my backups? In other words would i still be able to restore to my production server if needed? |
|
02-26-2008, 05:48 AM
| |||
| |||
| Re: backups On May 17, 2:46 pm, cptkirkh <k...@scic.com> wrote: > On May 17, 1:22 pm, Frank van Bortel <frank.van.bor...@gmail.com> > wrote: > > > > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > cptkirkh schreef: > > > > On May 17, 12:14 pm, Frank van Bortel <frank.van.bor...@gmail.com> > > > wrote: > > > cptkirkh schreef: > > > >>>> I run Oracle 10g on a Win 2003 server. I have backups going to one > > >>>> of the drives on my DB. I would like to copy those files to a tape > > >>>> for offsite storage. If I then had to restore the DB for any reason > > >>>> could I then restore those files from the tape and then restore the > > >>>> whole database? > > > Define your definition of backup. If it does not > > > have the capital letters, A, M, N and R somewhere, > > > further discussion is quite useless in my opinion. > > > Sorry i thought RMAN was the default for this group. I don't use RMAN > > > to backup them up to tape. I use veritas to take the backup files to > > > tape. > > > OK - so you do use RMAN. Minor question: why not to tape > > directly? > > > As long as you can restore them to the path you copied > > the RMAN generated files, there's no problem. > > If not, you'll have to fiddle with the RMAN location > > variables. > > - -- > > Regards, > > Frank van Bortel > > > Top-posting is one way to shut me up... > > -----BEGIN PGP SIGNATURE----- > > Version: GnuPG v1.4.1 (MingW32) > > > iD8DBQFGTJ2CLw8L4IAs830RAh1tAJ9ulByPdUPC9L9R9WMZEJ 9iA6NqdwCfb9O4 > > Y/d2WbBf7Q6DwxDgPmk3VQQ= > > =SIMX > > -----END PGP SIGNATURE----- > > By path I would assume since we are talking windows to the same drive > letter and folder correct? I have one other question also. If I want > to practice restore functions in RMAN can I use those same backup > files and restore to a new server and will that restore change any of > my backups? In other words would i still be able to restore to my > production server if needed? You can use the backup images to restore on another server assuming the backup pieces have the same fully-qualified pathname that was used on the production server. The restore operation will not change any of the backuppieces. Also, you could use RMAN backup backuppiece to make a copy of your backuppieces on disk to backup to Veritas (if you wanted). In a restore event, you then wouldn't need to restore the backuppiece to disk before RMAN could use it. |
|
02-26-2008, 05:49 AM
| ||||
| ||||
| Re: backups -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 cptkirkh schreef: > OK - so you do use RMAN. Minor question: why not to tape > directly? > > As long as you can restore them to the path you copied > the RMAN generated files, there's no problem. > If not, you'll have to fiddle with the RMAN location > variables. > By path I would assume since we are talking windows to the same drive > letter and folder correct? I have one other question also. If I want > to practice restore functions in RMAN can I use those same backup > files and restore to a new server and will that restore change any of > my backups? In other words would i still be able to restore to my > production server if needed? Same drive - yes. That is recorded in the control file of the database you made a backup of, and RMAN will try to read it in case of a restore. In case your control file is lost, too, you obviously want to restore that from the backup, too (you do have control file autobackup set to ON, haven't you?) For the practice, look up RMAN CLONE commands - it will let you do just that: restore to another server, location or name, or any combination. - -- Regards, Frank van Bortel Top-posting is one way to shut me up... -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (MingW32) iD8DBQFGTVzCLw8L4IAs830RAje/AJ9OUazqqnJcrq+paRGVexTDuoJ88ACfadHm amqCvphLy8aN0NdHsapXVq4= =cfCB -----END PGP SIGNATURE----- |
Linear Mode
