- 论坛徽章:
- 0
|
oracle以spfile启动
SQL*Plus: Release 11.1.0.6.0 - Production on Mon Jan 11 20:57:22 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameters spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /home/oracle/product/11g/dbs/spfilesmsgdb.ora
SQL> create pfile='/home/oracle/test.ora' from spfile='//home/oracle/product/11g/dbs/spfilesmsgdb.ora';
File created.
SQL> create spfile='/dev/mapper/smsgvg-lv_spfile' from pfile='/home/oracle/test.ora';
File created.
现在我要把数据库以spfile启动的spfile指向更改到 /dev/mapper/smsgvg-lv_spfile 上,该怎么做啊? |
|