Re: Archive log mode question

Hi John,
Which documentation? This is definitely not Oracle documentation! Basically, without RMAN or EBU, there are two ways to backup, offline or online.
Both rely on archive log mode to be on always!!!!!! Offline backup scenario includes
- execute a shutdown immediate
- execute an OS backup of all your database files, control files, redo log files, archive log files (if they are on disk, and not directly to tape) - startup the database
- delete the archive redo log files, ie the files in the directory pointed to by the LOG_ARCHIVE_DEST init<sid>.ora parameter.

Online backup scenario includes
alter tablespace <tablespace_name> begin backup; <issue whatever os command to backup the file(s) associated with that tablespace)
alter tablespace <tablespace_name> end backup; for every individual tablespace
During online backup the database is protected through archivelog ONLY!

Hth,

Sybrand Bakker, Oracle DBA

John Monson <90737.wslms0.wslm.wec.com> wrote in message news:7lad55$1n54_at_sccat.pgh.wec.com...
> I'm running Oracle8 in archive log mode. My question
> concerns backups. Documentation suggests disabling
> archive log mode, then tagging archived logs, and then
> restarting archive log mode before deleting the tagged files.
> Will my backups be usable if I delete the tagged files before
> archive log mode is restarted ?
>
> Thanks,
> John
>
>
Received on Tue Jun 29 1999 - 13:04:02 CDT