Printable View
pls see the command results below, very confused why
log_archive_start can't be set as 'true'?
I've tried some command such archive log start etc..
alter system set ....
SQL>show parameter log_archive_start
NAME TYPE VALUE
log_archive_start boolean FALSE
SQL>archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination d:\oracle\arc\arc2
Oldest online log sequence 38
Next log sequence to archive 40
Current log sequence 40
hm? have you modified your pfile and/or spfile?
Someone might have run "archive log start" after you started the instance.
Try starting the database in mount mode. Then try, alter database archivelogmode. Then shutdown your database and make sure that the pfileis setup for archive.
log_archive_start = true
log_archive_dest = "E:\Oracle\oradata\sid\archive"
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
SQL>archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination d:\oracle\arc\arc2
Oldest online log sequence 38
Next log sequence to archive 40
Current log sequence 40
already in archive mode so no need to mount and change mode