RMAN backup

[mooks]

Hi

I am doing testing for RMAN backup. Just a few simple questions:

1. How do I set the directory for the backup files? Everything i did a backup from RMAN, the backup set will be stored in $ORACLE_HOME/dbs.

2. Is it possible to store the backup set into another server directly thru RMAN?

Thank you for all your advices!

[TimHall]

Hi.

You need to do something like:

RMAN> configure channel device type disk format '/my/path/%d_DB_%u_%s_%p';

Take a look at this for some basic information about RMAN:

http://www.oracle-base.com/articles/...er(RMAN)9i.php

Cheers

Tim...

[mooks]

Thanks Tim! I have read the article before.. somehow and dunno why i just didn't set the path correctly!

Anyway, what about my second question? Is it possible to backup to another server?

[davey23uk]

not really no, you have to back up to local disks (now that could be an nfsmount from the other server)

[mooks]

Hi

Are there any solutions to copy the backup directly to another server besides tape backup? I appreciate any advices and help

[davey23uk]

nfsmounts the disks - but be prepared for it to be slow

[mooks]

Thanks! What about any recommended storage beside tape storage? Are there any good recommendations?

[jovery]

We use a two stage approach to our backups; we have a dedicated area on out NetApp filer which is attached as a backup partition to our servers, we use RMAN to backup directly to the filer partition and then at regular intervals our filer contents are sent to an off-site storage facility (SunGuard).

This gives me the ability to have recent backup sets easily availaible and the security of knowing that all my data is also stored in another off-site location.

As the backups are done to disk we also benefit from fast backup and restore times.

HTH

[mooks]

Thanks! In this case, do you keep all your archived logs? If you using RMAN, you will need to the sync the logs right? How often do you delete them? Upon daily backup?

Thanks for sharing!

[jovery]

How long I keep the archive logs depends on the backup cycle of the database, typically after a RMAN full backup I crosscheck and delete obsolete files which will remove unrequired archive and backup files.