| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Problems starting in ARCHIVE LOG mode...
Have you set the database to archive mode? You have to do it while the
database is mounted but not opened.
Ken
Franz Hemmer wrote:
> 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"
 |
 |