This content has been marked as final. Show 11 replies
If you want to enable archiving:
(1) Shutdown the database.
(2) [Back it up.]
(3) startup mount;
(4) alter database archivelog;
(5) alter database open;
(6) [Back it up again.]
(6) set LOG_ARCHIVE_START=true in the init parameter file
alter system set log_archive_start=true scope=spfile
restart the instance
You should also configure LOG_ARCHIVE_DEST(_n).
Thanks, I had done the previous 5 steps. It was step 6 that was causing me problems. It looks like you can't specify the path of the archive dest all within the same line when enabling automatic archiving using with Scope=spfile. I was trying to do it in one step:
alter system archive log start to 'C:\oracle\ora92\database\dbname\archive' SCOPE=spfile;
if u wants to run ur database in archive mode. then u have to add the following parameter in init.ora file..
log_archive_start = true
log_archive_dest = 'E:\BackuporacleAppdb'--specify ur archived location
log_archive_format = 'arch%s.txt'
LOG_ARCHIVE_MAX_PROCESSES=3(how many archiver u wants to run)
take a backup
create a spfile from pfile
alter database open.
If I change to archivelog mode in Mount state using alter database archivelog;
Will that also automatically set those parameter. Take 10g for example?
By default the destination of archive log files are stored in flash recovery area without any additional configuration. In that case i also assume now that those parameter such as log_archive_start=true will also be automatically be set when the DB is set to archivelog mode (in reference of 10g).
Correct me if i'm wrong...