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----- Received on Fri May 18 2007 - 02:58:58 CDT