oracle更改归档日志路径,如何在归档模式下，更改归档日志路径

2.直接用alter语句修改归档路径，然后设置归档文件格式，在重启数据库。一般情况改完归档路径是不需要重启数据库的，直接生效.

SQL> select status from v$instance;

STATUS

------------

OPEN

SQL> archive log list;

Database log mode               Archive Mode

Automatic archival               Enabled

Archive destination               /u01/oradata/ocptest/arclog/

Oldest online log sequence     112

Next log sequence to archive   114

Current log sequence               114

SQL> alter system set log_archive_dest_1='LOCATION=/home/oracle/';

System altered.

SQL> archive log list;

Database log mode               Archive Mode

Automatic archival               Enabled

Archive destination               /home/oracle/

Oldest online log sequence     112

Next log sequence to archive   114

Current log sequence               114

SQL> alter system switch logfile;

System altered.

SQL> select name,thread#,sequence#,archived,status from v$archived_log;

NAME                                  THREAD#  SEQUENCE# ARC S

------------------------------ ---------- ---------- --- -

/u01/oradata/ocptest/arclog/1_                1         113 YES A

113_787032039.arc

/home/oracle/1_114_787032039.a                1         114 YES A

rc

SQL> alter system set log_archive_dest_1='LOCATION=/u01/oradata/ocptest/arclog/ valid_for=(all_logfiles,all_roles) db_unique_name=ocptest';

System altered.

SQL> archive log list;

Database log mode               Archive Mode

Automatic archival               Enabled

Archive destination               /u01/oradata/ocptest/arclog/

Oldest online log sequence     113

Next log sequence to archive   115

Current log sequence               115

SQL> alter system switch logfile;

System altered.

SQL> select name,thread#,sequence#,archived,status from v$archived_log;

NAME                                  THREAD#  SEQUENCE# ARC S

------------------------------ ---------- ---------- --- -

/u01/oradata/ocptest/arclog/1_                1         113 YES A

113_787032039.arc

/home/oracle/1_114_787032039.a                1         114 YES A

rc

/u01/oradata/ocptest/arclog/1_                1         115 YES A

115_787032039.arc