Re: hot oracle backup

"zohar" <zohar100_at_inter.net.il> wrote:

]does any one have an idea of backing up oracle when its up on v5
](digital unix) without networker , only with the tools that come with
]the unix & oracle (vdump,export ... )

Yes, this is my preferred way to backup - I want all the tools I need for recovery on the Solaris CD with no license keys etc to hold me up when doing a recovery.

You need to put each tablespace in backup mode, then tar or cpio each datafile in that tablespace to tape or whatever, then go to the next tablespace. The database needs to be in "archive log mode" too, and you need to manage the archived log files.

I can e-mail you my backup script if you want it, but I would suggest you write your own so you understand it and are comfortable with it.

You MUST also read the recovery section of the admin guide, then the backup section, then the recovery section again and think about it carefully. Test your backups every now and then as well. --
 ,-,_|\ George Dau - Unix (Solaris, DEC Unix, Linux), Oracle, Internet. __

/    * \ Home: gedau_at_pobox.com         !  Any views or opinions expressed (OO)
\_,--\_/ Work: gedau_at_isa.mim.com.au    !  above may be mine, but are NOT ( \/ )
      v   WWW: http://pobox.com/~gedau !  necessarily those of M.I.M.     W--W