sQL> conn / as sysdba Connected to an idle instance. SQL> startup mount ORACLE instance started. Total System Global Area 146472960 bytes Fixed Size 1335080 bytes Variable Size 92274904 bytes Database Buffers 50331648 bytes Redo Buffers 2531328 bytes Database mounted. SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /u01/admin/wilson/test Oldest online log sequence 114 Next log sequence to archive 116 Current log sequence 116
SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /u01/admin/wilson/test Oldest online log sequence 116 Next log sequence to archive 118 Current log sequence 118
SQL> alter system archive log start to '/u01/admin/wilson/archdest'; System altered.
SQL> alter system set log_archive_start=true scope=spfile; System altered.
SQL> alter system archive log stop; System altered. SQL> alter system set log_archive_start=false scope=spfile; System altered.
log_archive_dest_1=”location=/archive/ mandatory” log_archive_dest_1=”location=/archive/ optional” log_archive_dest_2=”service=standy_db1”
先在/u01/admin/wilson中建立个test的文件, SQL> alter system set log_archive_dest_1="location=/u01/admin/wilson/archtest"; System altered. SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /u01/admin/wilson/archtest Oldest online log sequence 116 Next log sequence to archive 118 Current log sequence 118 显示Archive destination修改了。 SQL> alter system set log_archive_format="sun_%t_%S_%r.arc" scope=spfile; System altered. 关闭重启, SQL> show parameter archive log_archive_duplex_dest string log_archive_format string sun_%t_%S_%r.arc log_archive_local_first boolean TRUE log_archive_max_processes integer 4 log_archive_min_succeed_dest integer 1 log_archive_start boolean TRUE log_archive_trace integer 0 standby_archive_dest string ?/dbs/arch 可以看到log_archive_format 改变了。 SQL> alter system switch logfile; System altered. SQL> !ls -l /u01/admin/wilson/archtest total 7720 -rw-r----- 1 oracle oinstall 7624192 Aug 17 01:04 sun_1_0000000118_805499090.arc -rw-r----- 1 oracle oinstall 241664 Aug 17 01:10 sun_1_0000000119_805499090.arc -rw-r----- 1 oracle oinstall 5632 Aug 17 01:11 sun_1_0000000120_805499090.arc