How to start ARCHIVELOG ?
From: Stefano UNTERNAEHRER <unter_at_mecati.mecasoft.ch>
Date: 1995/07/28
Message-ID: <DCF69t.1v4_at_mecati.mecasoft.ch>#1/1
Date: 1995/07/28
Message-ID: <DCF69t.1v4_at_mecati.mecasoft.ch>#1/1
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
______________________| Stefano Unternaehrer |__________________________ \ Mecasoft SA | Oracle DBA | fax: +41 93 335 507 / \ 6600 Muralto | and PL/SQL, Pro*C | voice: +41 93 337 444 / \ | C, XWindow & Motif | / / | Software Developer | email: \ / Switzerland Europe |____________________________| dba,unter_at_mecasoft.ch \ /________________________) (____________________________\Received on Fri Jul 28 1995 - 00:00:00 CEST