Re: Problems starting in ARCHIVE LOG mode...

I got archiving going by doing the following in server manager:
shutdown normal;
startup exclusive mount;
alter database archivelog;
alter database open;

On Sun, 22 Aug 1999 10:29:53 +0100, "Dan Benwell" <dan_at_benwell.co.uk> wrote:

>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 - 10:40:21 CDT