把主库打开,创建一个最新的pfile,如果已经有pfile此命令会覆盖之前的pfile成为最新的pfile
- [root@slow ~]# su - oracle
- [oracle@slow ~]$ !sql
- sqlplus / as sysdba
-
- SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 9 20:15:45 2018
-
- Copyright (c) 1982, 2013, Oracle. All rights reserved.
-
- Connected to an idle instance.
-
- SQL> startup
- ORACLE instance started.
-
- Total System Global Area 521936896 bytes
- Fixed Size 2254824 bytes
- Variable Size 377489432 bytes
- Database Buffers 138412032 bytes
- Redo Buffers 3780608 bytes
- Database mounted.
- Database opened.
- SQL> create pfile from spfile;
-
- File created.
-
- SQL>
切到oracle用户$ORACLE_HOME/dbs路径下,查看刚才创建好的pifle文件,再复制一份成备库的pfile文件
- [root@slow ~]# su - oracle
- [oracle@slow ~]$ cd $ORACLE_HOME/dbs
- [oracle@slow dbs]$ ls
- hc_slow.dat init.ora initslow.ora lkSLOW orapwslow spfileslow.ora
- [oracle@slow dbs]$ ll
- total 24
- -rw-rw---- 1 oracle oinstall 1544 Jan 9 20:15 hc_slow.dat
- -rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
- -rw-r--r-- 1 oracle oinstall 731 Jan 9 20:16 initslow.ora
- -rw-r----- 1 oracle oinstall 24 Dec 24 23:10 lkSLOW
- -rw-r----- 1 oracle oinstall 1536 Dec 24 22:31 orapwslow
- -rw-r----- 1 oracle oinstall 2560 Jan 9 20:15 spfileslow.ora
- [oracle@slow dbs]$ cp initslow.ora initgotime.ora
- [oracle@slow dbs]$ ls
- hc_slow.dat initgotime.ora init.ora initslow.ora lkSLOW orapwslow spfileslow.ora
- [oracle@slow dbs]$
未完...找时间做完
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31405474/viewspace-2149951/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31405474/viewspace-2149951/