Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: backups
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?
Received on Thu May 17 2007 - 13:46:47 CDT