Re: Question: Backing up online databases

What platform are you on?
For HP-UX, Oracle will have an answer with the 7.1.4 release and HP OMNIBACK.
With this release, it will ease 24/7 backups. Also check into the archive logging section of your documentation.

Steve Lemme
ORACLE DBA - HP/ Systems Administrator - VMS Motorola MOS 12

In article <39mleq$cel_at_news1.shell>, sjs_at_shell.portal.com (Steve - Schow) wrote:

> Hi all,
>
> We have a situation where we need to have oracle running 24 hours/7 days
> a week and we need to obviously keep the thing backed up. I have been
> pouring through all the books trying to figure out the strategy for this,
> and there seems to be little mentioned about this scenario. Apparantly most
> people don't need to do this.
>
> Anyway, what is the best strategy for this?
>
> If I understand correctly, you must backup your tablespaces one at a time
> and then backup your control files. This can all be done while the database
> is up and running. The redo logs CANNOT be backed up while the system is
> running.
>
> Now then, If you can't back up the redo logs, then what does that mean will
> happen when the system crashes and I have to restore?
>
> Basically, what I need to know is a good strategy to provide full recoverability
> of an oracle database that never gets shutdown(or if it does, only once a
> month or so for a few minutes).
>
> -steve
>
> --
> __ __
> __ ( _/_ _ ( _ /
> __)/(- \/(- __)( /)()((/
 

-- 
When you are in it up to your ears....
Keep your mouth shut!
rp1399_at_email.sps.mot.com