Re: Archive log mode question

From: tmgn <tmgn_at_excite.com>
Date: Tue, 29 Jun 1999 14:34:20 -0400
Message-ID: <377911AC.7E0D5A77@excite.com>

SOrry, the Command to archive all the Log files should read
>Alter System archive log all;

-Thiru

tmgn wrote:

John would have got confused between Archiving process & Archive Log mode.
The DB should never be taken out of ArchiveLog mode unless absolutely
necessary.

ORacle does suggest (in some Books) temporarily stopping the Archiving process
for the purpose of getting a List of Archived REdolog files to be copied and
then restart the archiving using  > Alter system archive log start;

This was just to ensure that the file that is currently being written by the
ARCH process is not copied onto the Backup Destination.

This can also be avoided (ie Stopping and restarting) by
>Alter system checkpoint;
>Alter database archive log all;
# sleep 120 ....or pause or whatever...
and then doing the Physical copy of the Arch files

-Thiru

Sybrand Bakker wrote:

> 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@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:34:20 CDT