Funda 2 > Log_archive 1 - 10th May

sql> show parameter archive_log 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 location=d:\bkp 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> ---t o disable the path for some log_archive_dest from 1 to 10; sql> alter system set log_archive_dest_state_1=defer; alter system set log_archive_dest_state_1=defer * error at line 1: ora-02097: parameter cannot be modified because specified value is invalid ora-16028: new log_archive_dest_state_1 causes less destinations than log_archive_min_succeed_dest requires sql> ---- we want to set null for the log_archive_dest_1; sql> alter system set log_archive_dest_1=' '; system altered. sql> alter system set log_archive_dest_state_1=defer; 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 -----------------------------defer 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> sql> sql> sql> alter system set log_archive_dest_state_2=enable; system altered. sql> ----- to enable the log_archive_state_dets; sql> ----- to set path for disable log 1; sql> alter system set log_archive_dest_1='d:\oracle'; alter system set log_archive_dest_1='d:\oracle' * error at line 1: ora-32017: failure in updating spfile ora-16179: incremental changes to "log_archive_dest_1" not allowed with spfile sql> ---- we can't set path for the doisable one sql> --- first we want to enable and then only we will able to set the path; sql> alter system set log_archive_dest_1='d:\oracle'; alter system set log_archive_dest_1='d:\oracle' *

error at line 1: ora-32017: failure in updating spfile ora-16179: incremental changes to "log_archive_dest_1" not allowed with spfile 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 -----------------------------defer 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> alter system set log_archive_dest_1=enable; alter system set log_archive_dest_1=enable * error at line 1: ora-32017: failure in updating spfile ora-16179: incremental changes to "log_archive_dest_1" not allowed with spfile sql>

alter system set log_archive_dest_state_1=enable;

system altered. sql> alter system set log_archive_dest_1='d:\oracle'; alter system set log_archive_dest_1='d:\oracle' * error at line 1:

ora-32017: failure in updating spfile ora-16179: incremental changes to "log_archive_dest_1" not allowed with spfile 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_1=' ';

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

system altered. sql>

alter system set log_archive_dest=' ';

system altered. sql> alter system set log_archive_dest_1='d:\oracle; alter system set log_archive_dest_1='d:\oracle * error at line 1: ora-01756: quoted string not properly terminated sql> alter system set log_archive_dest_1='d:\oracle'; alter system set log_archive_dest_1='d:\oracle'

* error at line 1: ora-32017: failure in updating spfile ora-16179: incremental changes to "log_archive_dest_1" not allowed with spfile 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> sql> alter system set log_archive_dest_1='location=d:\oracle'; system altered. sql> ------ we want to use the keyword location to change the path; sql> -----sql> sql> sql> ------- to change the format log_archive_format sql> sql> sql> alters system log_archive format='bkp%s.%t' scope=spfile; sp2-0734: unknown command beginning "alters sys..." - rest of line ignored.

sql> alter system log_archive format='bkp%s.%t' scope=spfile; alter system log_archive format='bkp%s.%t' scope=spfile * error at line 1: ora-02065: illegal option for alter system sql> ------- the keyword is log_archive_format not log_archive format sql> alter system set log_archive_format='bkp%s.%t' scope=spfile; 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 location=d:\oracle 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> ---sql> ----- we want to shutdown the databse and then only we can able to see the changes; sql> shutdown immediate; database closed. database dismounted. oracle instance shut down. sql> startup oracle instance started.

total system global area 135338868 fixed size 453492 variable size 109051904 database buffers 25165824 redo buffers 667648 database mounted. database opened. sql> show parameter log_archive;

bytes bytes bytes bytes bytes

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 location=d:\oracle 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 bkp%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> --------- to change the max_process for log_archive ; sql> sql> alter system set log_archive_max_process=10; alter system set log_archive_max_process=10 * error at line 1: ora-02065: illegal option for alter system sql> alter system set log_archive_max_processes=10; system altered.

sql> --- it should to be max_processes is not exceed the no of destination in log_archive; sql> sql> shoew v$parameter; sp2-0734: unknown command beginning "shoew v$pa..." - rest of line ignored. sql> show v$parameter; sp2-0735: unknown show option beginning "v$paramete..." sql> show v$parameter sp2-0735: unknown show option beginning "v$paramete..." sql> select name,issys_modifiable,ismodified from v$parameter where name like 'log'; no rows selected sql> ------------ to switch current file log file sql> sql> sql> alter system archive log current; system altered. sql> ----------- alter system archive log all; sql> alter system archive log next; alter system archive log next * error at line 1: ora-00271: there are no logs that need archiving sql> alter system archive log sequence 104; alter system archive log sequence 104 * error at line 1: ora-00260: cannot find online log sequence 104 for thread 1 sql> alter system archive log current; system altered. sql> alter system archive log current noswitch; system altered. sql> sql> alter system archive log all; alter system archive log all * error at line 1: ora-01507: database not mounted sql> archive log list ora-01507: database not mounted sql> alter database opne; alter database opne * error at line 1:

ora-02231: missing or invalid option to alter database sql> alter database open; alter database open * error at line 1: ora-01507: database not mounted sql> alter database mount; database altered. sql> alter database open; alter database open * error at line 1: ora-01531: a database already open by the instance sql> alter system archive log all; alter system archive log all * error at line 1: ora-00600: internal error code, arguments: [2130], [0], [50], [3], [], [], [], [] sql> archive log list database log mode archive mode automatic archival disabled archive destination d:\oracle oldest online log sequence 4 next log sequence to archive 0 current log sequence 6 sql> alter system set log_archive_start=true scope=spile; alter system set log_archive_start=true scope=spile * error at line 1: ora-00922: missing or invalid option sql> spool off