1.在pfile中写入两行内容,后面的参数会覆盖之前的参数生效
一行内容是spfile的信息
另外一行是要改回的原来值
ora10g@linux5 /home/oracle$ cat $ORACLE_HOME/dbs/initora10g.ora
SPFILE= '/oracle/u01/app/oracle/product/10.2.0/db_1/dbs/spfileora10g.ora'
log_archive_start = false
2. 使用pfile启动数据库,是 log_archive_start参数生效
sys@ora10g> startup pfile = '$ORACLE_HOME/dbs/initora10g.ora';
ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecated
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1266392 bytes
Variable Size 104860968 bytes
Database Buffers 58720256 bytes
Redo Buffers 2924544 bytes
Database mounted.
Database opened.
-- The End --
一行内容是spfile的信息
另外一行是要改回的原来值
ora10g@linux5 /home/oracle$ cat $ORACLE_HOME/dbs/initora10g.ora
SPFILE= '/oracle/u01/app/oracle/product/10.2.0/db_1/dbs/spfileora10g.ora'
log_archive_start = false
2. 使用pfile启动数据库,是 log_archive_start参数生效
sys@ora10g> startup pfile = '$ORACLE_HOME/dbs/initora10g.ora';
ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecated
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1266392 bytes
Variable Size 104860968 bytes
Database Buffers 58720256 bytes
Redo Buffers 2924544 bytes
Database mounted.
Database opened.
-- The End --
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/519536/viewspace-566993/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/519536/viewspace-566993/