Re: Redo logs backup??

> Get a copy of the Oracle Backup and Recovery Handbook by Rami Velpuri
> from Oracle Press. It is the definitive source for this subject and
> should answer all of your questions.
> .
>
> Rich Woods
> Technical Field Support Specialist, Oracle Corporation, USA
> The above statements and opinions are my own and do not
> necessarily represent those of Oracle Corporation.

Sounds like a good reference, Thanks.

I've further questions.

How long should you save archive log files?

The answer that I've gotten from Oracle in the past is "... since the last cold backup ...." I've got one database that has 7x24 requirements so the users are extremely reluctant to let me shutdown the instance.

Does an offline tablespace backup with the instance in multiuser mode count as "cold backup"?

I'd rather not administrate a series of special archive tapes if I could just keep a manageable amount of archive logs on line and have them backed up as part of the normal Unix filesystem backups.  

-- 
Ed Kulis          408-341-5561        Hal Computer Systems
Sr. Oracle DBA    ekulis_at_hal.com      Campbell, CA 95008