On May 17, 2:46 pm, cptkirkh <k..._at_scic.com> wrote:
> On May 17, 1:22 pm, Frank van Bortel <frank.van.bor..._at_gmail.com>
> wrote:
>
>
>
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
>
> > cptkirkh schreef:
>
> > > On May 17, 12:14 pm, Frank van Bortel <frank.van.bor..._at_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)
>
> > iD8DBQFGTJ2CLw8L4IAs830RAh1tAJ9ulByPdUPC9L9R9WMZEJ9iA6NqdwCfb9O4
> > 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.
Received on Thu May 17 2007 - 14:14:59 CDT
