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
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/