- 论坛徽章:
- 0
|
继续往下看:
现在我们还原刚才备份的那个spfile,重新创建pfile
SQL> host
$ ls
init.ora initora9.ora orapwora9 spfileora9.ora.bak
initdw.ora lkORA9 spfileora9.ora
$ cp spfileora9.ora.bak spfileora9.ora
$ exit
SQL> l
1* create pfile='/T3/ORACLE/pfile1' from spfile
SQL> /
File created.
成功!
下面我们模仿在db running过程中del掉spfile,看看会出现什么情况:
SQL> host
$ ls
init.ora initora9.ora orapwora9 spfileora9.ora.bak
initdw.ora lkORA9 spfileora9.ora
$ mv spfileora9.ora spfileora9.ora.bak2
$ exit
SQL> l
1* create pfile='/T3/ORACLE/pfile1' from spfile
SQL> /
create pfile='/T3/ORACLE/pfile1' from spfile
*
ERROR at line 1:
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
SQL>
出错,提示找不到spfile,看来当我们发出create pfile from spfile的时候他会道相应目录寻找spfile,如果有而且正确就create pfile,否则提示找不到该文件或者文件不对,即使我们用pfile启动,当我们发出create pfile from spfile的时候仍然遵循这一个原则。
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> host
$ ls
init.ora initora9.ora orapwora9 spfileora9.ora.bak
initdw.ora lkORA9 spfileora9.ora
$ mv spfileora9.ora spfileora9.ora.bak2
$ exit
SQL> startup nomount
ORACLE instance started.
Total System Global Area 219644872 bytes
Fixed Size 730056 bytes
Variable Size 201326592 bytes
Database Buffers 16777216 bytes
Redo Buffers 811008 bytes
SQL> create pfile='/T3/ORACLE/pfile1.ora' from spfile;
create pfile='/T3/ORACLE/pfile1.ora' from spfile
*
ERROR at line 1:
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
SQL> create pfile='/T3/ORACLE/pfile1.ora' from spfile='/T3/ORACLE/product/9.2.0/dbs/spfileora9.ora.bak2';
File created.
SQL> host
$ ls
init.ora initora9.ora orapwora9 spfileora9.ora.bak2
initdw.ora lkORA9 spfileora9.ora.bak
$ mv spfileora9.ora.bak2 spfileora9.ora
$ exit
SQL> create pfile='/T3/ORACLE/pfile1.ora' from spfile;
File created.
SQL> |
|