Archive Log

Steps in changing database from no archive mode to archive mode:

sql/>shutdown normal/immediate/transactional (You can use any value)

sql/>startup mount

sql/>alter database archivelog

sql/>alter database open

Go for Full Database backup


Keep in mind a user must have ALTER SYSTEM PRIVILEGE to alter the archivelog mode of the database.

Setting the database in Archivelog mode doesnot enable the Archiver (ARCN) process!

AUTOMATIC & MANUAL Archiving

Set the parameter file for LOG_ARCHIVE_START=TRUE

Hmm mean while you can do multiple arcn process

LOG_ARCHIVE_MAX_PROCESSES

And a maximum of ten ARCN processes can be specified and its dynamic

Sql/>alter system set LOG_ARCHIVE_MAX_PROCESSES=3;

Well if you find more about this let me know.