dg中log_archive_format参数修改

dg中log_archive_format参数修改要指定sid，否则重启后修改无效（修改的过程不会报任何错误）。如下：

SQL> show parameter log_archive_format;

NAME                                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
log_archive_format              string     %t_%s_%r.dbf
SQL> alter system set log_archive_format=' log_%t_%r_%s.dbf' scope=spfile;

System altered.

SQL> startup force
ORACLE instance started.

Total System Global Area  104857600 bytes
Fixed Size                                 1217932 bytes
Variable Size                          67111540 bytes
Database Buffers                  29360128 bytes
Redo Buffers                            7168000 bytes
Database mounted.
Database opened.
SQL> show parameter log_archive_format;

NAME                                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
log_archive_format              string     %t_%s_%r.dbf
SQL> alter system set log_archive_format=' log_%t_%r_%s.dbf' scope=spfile sid='dg1';

System altered.

SQL> startup force
ORACLE instance started.

Total System Global Area  104857600 bytes
Fixed Size                                 1217932 bytes
Variable Size                          67111540 bytes
Database Buffers                  29360128 bytes
Redo Buffers                            7168000 bytes
Database mounted.
Database opened.
SQL> show parameter log_archive_format;

NAME                                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
log_archive_format              string     log_%t_%r_%s.dbf

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7417681/viewspace-715878/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7417681/viewspace-715878/