Funda 2 > Log_archive - 10th May

sql> alter database archivelog 2 ; database altered. sql> archive log list; database log mode archive mode automatic archival enabled archive destination d:\oracle\ora92\rdbms oldest online log sequence 2 next log sequence to archive 4 current log sequence 4 sql> --- to change the path for back up sql> alter system set log_archive_dest='d:\bkp'; system altered. sql> show parameter log_archive; name -----------------------------------log_archive_dest log_archive_dest_1 log_archive_dest_10 log_archive_dest_2 log_archive_dest_3 log_archive_dest_4 log_archive_dest_5 log_archive_dest_6 log_archive_dest_7 log_archive_dest_8 log_archive_dest_9

type value ----------- -----------------------------string string string string string string string string string string string

name -----------------------------------log_archive_dest_state_1 log_archive_dest_state_10 log_archive_dest_state_2 log_archive_dest_state_3 log_archive_dest_state_4 log_archive_dest_state_5 log_archive_dest_state_6 log_archive_dest_state_7 log_archive_dest_state_8 log_archive_dest_state_9 log_archive_duplex_dest

type ----------string string string string string string string string string string string

value -----------------------------enable enable enable enable enable enable enable enable enable enable

name type value ------------------------------------ ----------- -----------------------------log_archive_format string arc%s.%t log_archive_max_processes integer 2 log_archive_min_succeed_dest integer 1 log_archive_start boolean true log_archive_trace integer 0 sql> ---- we want to set null value for log_archive_dest and then only we will able to change the path for log_archive_dest_1 to 10; sql> alter system set log_archive_dest_1='location='d:\bkp'; alter system set log_archive_dest_1='location='d:\bkp'

* error at line 1: ora-02065: illegal option for alter system sql> alter system set log_archive_dest_1='location='d:\bkp''; alter system set log_archive_dest_1='location='d:\bkp'' * error at line 1: ora-02065: illegal option for alter system sql> alter system set log_archive_dest_1='location'='d:\bkp'; alter system set log_archive_dest_1='location'='d:\bkp' * error at line 1: ora-00922: missing or invalid option sql> alter system set log_archive_dest_1='location=d:\bkp'; alter system set log_archive_dest_1='location=d:\bkp' * error at line 1: ora-02097: parameter cannot be modified because specified value is invalid ora-16019: cannot use log_archive_dest_1 with log_archive_dest or log_archive_duplex_dest sql> show parameter log_archive; name -----------------------------------log_archive_dest log_archive_dest_1 log_archive_dest_10 log_archive_dest_2 log_archive_dest_3 log_archive_dest_4 log_archive_dest_5 log_archive_dest_6 log_archive_dest_7 log_archive_dest_8 log_archive_dest_9

type value ----------- -----------------------------string string string string string string string string string string string

name -----------------------------------log_archive_dest_state_1 log_archive_dest_state_10 log_archive_dest_state_2 log_archive_dest_state_3 log_archive_dest_state_4 log_archive_dest_state_5 log_archive_dest_state_6 log_archive_dest_state_7 log_archive_dest_state_8 log_archive_dest_state_9 log_archive_duplex_dest

type ----------string string string string string string string string string string string

value -----------------------------enable enable enable enable enable enable enable enable enable enable

name type ------------------------------------ ----------log_archive_format string log_archive_max_processes integer log_archive_min_succeed_dest integer log_archive_start boolean log_archive_trace integer sql> alter system set log_archive_dest=' ';

value -----------------------------arc%s.%t 2 1 true 0

system altered. sql> alter system set log_archive_dest_1='location=d:\bkp'; system altered. sql> ------ bcoz we want to set null for the log_archive_dest; sql> sql> show parameter log_archive; name -----------------------------------log_archive_dest log_archive_dest_1 log_archive_dest_10 log_archive_dest_2 log_archive_dest_3 log_archive_dest_4 log_archive_dest_5 log_archive_dest_6 log_archive_dest_7 log_archive_dest_8 log_archive_dest_9

type value ----------- -----------------------------string string string string string string string string string string string

name -----------------------------------log_archive_dest_state_1 log_archive_dest_state_10 log_archive_dest_state_2 log_archive_dest_state_3 log_archive_dest_state_4 log_archive_dest_state_5 log_archive_dest_state_6 log_archive_dest_state_7 log_archive_dest_state_8 log_archive_dest_state_9 log_archive_duplex_dest

type ----------string string string string string string string string string string string

value -----------------------------enable enable enable enable enable enable enable enable enable enable

name type value ------------------------------------ ----------- -----------------------------log_archive_format string arc%s.%t log_archive_max_processes integer 2 log_archive_min_succeed_dest integer 1 log_archive_start boolean true log_archive_trace integer 0 sql> ----- we want to shutdown and startup the database then only we will able to see the changes; sql> sql> spool off;