Re: How to start ARCHIVELOG ?

In article <DCF69t.1v4_at_mecati.mecasoft.ch> from [Fri, 28 Jul 1995 09:27:28 GMT] you wrote:
|> Hi!
|>
|> I have a database created with NOARCHIVELOG option.
|> Now, I would like to start ARCHIVELOG. What I have to do exactly?
|> Here is what I've tryied:
|>
|> Parameters in initxxx.ora:
|>
|> log_archive_start = true
|> log_archive_dest = /users/oracle7/dbs/test7/arch/arch.log
|> log_archive_format = 'log%s_%t.arc'
|> log_archive_buffer_size = 32
|> log_archive_buffers = 4
|>
|>
|> As sqldba:
|>
|> sqldba> alter database close;
|> sqldba> alter database dismount;
|> sqldba> alter database mount exclusive;
|>
|> sqldba> alter database archivelog;
|>
|> sqldba> shutdown
|> sqldba> startup open test7
|>
|> sqldba> show parameters arch
|> NAME TYPE VALUE
|> -------------------------- ------- ------------------------------
|> log_archive_buffer_size integer 32
|> log_archive_buffers integer 4
|> log_archive_dest string /users/oracle7/dbs/test7/arch/arch.log
|> log_archive_format string 'log%s_%t.arc'
|> log_archive_start boolean TRUE
|>
|>
|> The /users/oracle7/dbs/test7/arch directory is still void... why ??
|> Stefano

try setting:

log_archive_dest                = /users/oracle7/dbs/test7/arch/arch

/users/oracle7/dbs/test7/arch is the destination directory and arch.... will be the names of the archive files (i did not set the log_archive_format parameter).

chris

--
Ing. Christian Kaiser     chris_at_reblaus.wu-wien.ac.at
ADV-Abteilung
Vienna University of Economics and Business Administration 

Augasse 2-6,  A-1090 Vienna, Austria		
Tel: +43 (1) 31-336 x4040
***************************************************************************
lifes a beach and then you dive
***************************************************************************

                 |\
 |\              | \                   OoOo
 \ \             \  \                  oOOo
 \  \           /     `~~~--__        oOo
 /   \___----~~'              `~~-_  o _______          __________
 \                         /// (O) `\_(__||___)________/____
 / /~~~~-, ,__.    ,      ///  __,,,,)   ||  o  ______/     \
 \/      \/    `~~~;   ,---~~-_`_= \ \---||--o-'             \
                  /   /            / /                        \
                 |_./            _/_/
                                 /;|\