Re: Problems starting in ARCHIVE LOG mode...

From: Dan Benwell <dan_at_benwell.co.uk>
Date: Sun, 22 Aug 1999 10:29:53 +0100
Message-ID: <7poftm$b8p$1@lure.pipex.net>

Try this. I use it OK.
Change the log_archive_dest to your location.

Dan

Turning on Archive log mode

---

1. set parameters in init.ora

log_archive_start = true
log_archive_dest = e:\arch
log_archive_format = SID_%s.arch

2. shutdown database
3. startup mount
4. alter database archivelog
5. alter database open

6. archive log list ( to check )
7. put cron job to delete files older than  specific time ( check backup schedule)

Dan
Franz Hemmer <hemmer_at_postREMOVESPAM.tele.dk> wrote in message news:37c01c72.92060025_at_news.inet.tele.dk...
> Here's a cut from the alert log file:
> --------------------------------------------------------------------
> Sat Aug 21 23:32:01 1999
> alter database open
> Picked broadcast on commit scheme to generate SCNs
> Sat Aug 21 23:32:04 1999
> Thread 1 opened at log sequence 57
> Current log# 1 seq# 57 mem# 0: F:\ORACLE\ORADATA\HEMMER\REDO04.LOG
> Successful open of redo thread 1.
> Sat Aug 21 23:32:04 1999
> sql: prodding the archiver
> Sat Aug 21 23:32:04 1999
> ARC0: received prod
> Sat Aug 21 23:32:04 1999
> SMON: enabling cache recovery
> Sat Aug 21 23:32:04 1999
> ARC0: media recovery disabled
> Sat Aug 21 23:32:18 1999
> SMON: enabling tx recovery
> Sat Aug 21 23:32:21 1999
> Completed: alter database open
> --------------------------------------------------------------------
>
> What does ARC0: media recovery disabled mean?
>
> I can't get archiving going. I have set the init file to do
> archiving and tried various things (ALTER SYSTEM/DATABASE
> server manager etc.):
>
> From init.ora:
> # Uncommenting the line below will cause automatic archiving if
> archiving has
> # been enabled using ALTER DATABASE ARCHIVELOG.
> log_archive_start = true
> log_archive_dest_1 = "location=F:\Oracle\oradata\hemmer\archive"
> log_archive_format = "%%hemmer%%T%TS%S.ARC"
>
Received on Sun Aug 22 1999 - 04:29:53 CDT