Re: RMAN

A 'ready made script' probably isn't going to help you as every back-up and recovery scenario is different. RMAN is a really neat tool. I didn't like it (or use it) in 8i, it matured somewhat in 9i and it's really come of age in 10g. That being said, the command syntax is slightly diferent in 9i and 10g, so one script might not work for both releases.

Regardless of whether or not you use RMAN, the first thing you have to do is define your backup strategy. Are you backing up to tape, disk, or a combination of both? Are you going to use a recovery catalog? What is your retention policy? Is network bandwidth an issue? Will you be using a thrid-party Media Management Layer like Tivoli Storage Manager or Veriatas NetBackup?

Once you've figured out what you want to do, then you can configure RMAN to do it. If you want to start learning how to use RMAN, I suggest you begin with some sort of 'sandbox' instance, possibly a stand-alone database you've installed on a nominally unused server or PC.

You ought to go out to OTN and get both the 9i and 10g versions of the Backup and Recovery Guide as well as the Advanced Backup and Recovery Guide. To give youself a jump start into understanding these presentations and get some 'hands-on' exercise with the tool, buy this book: http://www.oreilly.com/catalog/rman/ . It's a great introduction that willl have you perfroming simple backups in a couple of hours.

Good luck.

On 3/30/06, Dean Paul <oracledbam_at_hotmail.com> wrote:
>
> Hi,
> i want to setup RMAN for backup on Windows2000/Oracle9i and 10g.
> Let me know if any one have ready made script?
> Let me know if any good documents if you have?
> thanks
> -Seema
>
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today - it's FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l