FreeLists / oracle-l / Re: How to turn on Archive redo log mode for 10g

["Oracle" <all_about_oracle@xxxxxxxxxx>]

Finally yes,

I am new with 10g, 2 things that new for me
to change the path of the archive should be like this

    log_archive_dest_1='Location=C:\MyOracle\oradata\Ora10g\archive'

not like

    log_archive_dest = 'C:\MyOracle\oradata\Ora10g\archive'

Then as per Leyi suggestion log_archive_start is no longer needed

May be in the future Oracle will remove this parameter for good

------------------------------------------------------------------
SQL> show parameter log_archive_start

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------------------
log_archive_start                    boolean     FALSE

SQL> select * from v$version
  2  ;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
PL/SQL Release 10.1.0.2.0 - Production
CORE    10.1.0.2.0      Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production


SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            C:\MyOracle\oradata\Ora10g\archive
Oldest online log sequence     1
Next log sequence to archive   3
Current log sequence           3


----- Original Message ----- 
From: "Jared Still" <jkstill@xxxxxxxxx>
To: <all_about_oracle@xxxxxxxxxx>
Cc: "Leyi Zhang" <kamusis@xxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, June 01, 2005 1:48 AM
Subject: Re: How to turn on Archive redo log mode for 10g


> You have put the database in archivelog mode haven't you?
> Login as sysdba and run the command "archive log list";
>
> Jared
>
>
> On 5/26/05, Oracle <all_about_oracle@xxxxxxxxxx> wrote:
> >
> > Hi,
> > Thanks for the info, so the archive log will start automatically every
> > instance start?
> >
> > regards,
> >
> > Sin
> >
>
>
> -- 
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
> --
> http://www.freelists.org/webpage/oracle-l
>



--
http://www.freelists.org/webpage/oracle-l