Re: ARCHIVELOG mode not enabling

Sam
  Hi. connect internal and then do an

        archive log start;
after shutting down the database. You have just put the database in the archivelog mode but haven't started the archiver process yet. Do that and you should be ok .

			Hope this helps.
					Tapan H Trivedi

Sam Petitto wrote:
>
> Running 8i on NT. Do I have an obvious mistake ? I went verbatim
> straight from the book:
> SVRMGR> connect internal
> SVRMGR> shutdown
> SVRMGR> startup mount
> SVRMGR> alter database archivelog
> SVRMGR> alter database open
>
> every thing responded properly until I ran the command "archive log
> list"
> Do I need to bounce the database for the change to take effect ? No
> mention of that in manual.
>
> SVRMGR> archivelog list;
> Database log mode Archive Mode
> Automatic Archival Disabled /*
> This is the problem - should be Enabled */
> Archive destination
> D:\Oracle\Ora8i\RDBMS
> Oldest online log sequence 2
> Next log sequence to archive 5
> Current log sequence 5
>
> TIA for any comments/suggestions ...
>
>
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> Sam Petitto
> Database Engineer
> Network Security Technologies, Inc.
> http://www.netsec.net
> (877)799.9380 Toll Free
> (703)561.0420 Local
> (703)561.0426 Fax
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> This electronic message contains information from Network Security
> Technologies, Inc or its
> affiliates, which may be confidential, proprietary or otherwise
> protected from disclosure. The
> information is intended to be used solely by the recipient(s) named
> above for the purposes
> intended by the originator. If you are not an intended recipient, be
> aware that any review,
> disclosure, copying, distribution or use of this transmission or its
> contents is prohibited. If
> you have received this transmission in error, please notify us
> immediately by telephone at (703)
> 561-0420, or by electronic mail at sales_at_netsec.net
>

--

›1]     \\\|///          Tapan H Trivedi


> >     \\  - -  //        Oracle Certified Professional


> >      (  @ @  )


> > __oOOo-(_)-oOOo____________________________________


> > |                                           _____  |


> > |                                          (~._.~) |


> > |Email:thtrived_at_dcss.com                   _{ Y }_ |


> > |Phone:7132188133                         ()_~~~_()|


> > |Pager:96047971                            (_)-(_) |


> > |http://www.ba.ttu.edu/~ottri                      |


> > |__________________________________________________|