Nitan Jandial

• Dec 28th, 2006

 

These are points we should consider when we think abt archivelog mode starts automatic


Before stutting down the DB, just alter the parameter name "log_archive_start" into "TRUE"Issue the following statementalter system set log_archive_start=true scope=spfileshutdown the database and To mount the database not to open Issue the following statements


alter database archivelog;
alter database archive log start;


In last open the database
alter database open;


To verify the above task just execute the following statement to check whether the dabase is archivelog mode or not.


select log_mode from v$database;


It returns "archivelog" that's mean we r successfully able to start the archivelog mode


thanks and regards

Nitan Jandial

Chiranjeevi Manne

• Mar 30th, 2007

 

1. it possible to enable archive log mode while creating the database using DBCA.

2. By mentioning the required parameters like LOG_ARCHIVE_DEST, LOG_ARCHIVE_FORMAT, LOG_ARCHIVE_START in init.ora file before creating the database manually using script.

3. Once the database is created without archive log mode,
a. Shutdown the database gracefully
b. Edit the int.ora file parameters like mentioned above
c. Start the database in MOUNT mode.
d. Keep the database in archive log mode using alter database archive log;
e. Turn on the archiving by using log archive start;
f. open the database using alter database open reset logs;