误删除$ORACLE_HOME/dbs下的参数文件、密码文件快速重建的方法
误删除$ORACLE_HOME/dbs下的参数文件、密码文件如何快速重建呢?其实方法很简单的,下面小编给大家分享下实现代码,具体内容如下:
[oracle@11g dbs]$ pwd /home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs [oracle@11g dbs]$ ll total 24 -rw-rw----. 1 oracle oinstall 1544 Mar 11 13:46 hc_orcl.dat -rw-r--r--. 1 oracle oinstall 2851 May 15 2009 init.ora -rw-r-----. 1 oracle oinstall 658 Feb 16 05:17 initorcl.ora -rw-r-----. 1 oracle oinstall 24 Feb 16 05:17 lkORCL -rw-r-----. 1 oracle oinstall 1536 Feb 16 05:17 orapworcl -rw-r-----. 1 oracle oinstall 3584 Mar 11 14:19 spfileorcl.ora [oracle@11g dbs]$ rm -rf * total 0 [oracle@11g dbs]$ orapwd file=/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/orapworcl password=oracle SQL> create pfile from memory; File created. [oracle@11g dbs]$ ll -rw-rw----. 1 oracle oinstall 1544 Mar 11 16:55 hc_orcl.dat -rw-r--r--. 1 oracle oinstall 5562 Mar 11 16:44 initorcl.ora -rw-r-----. 1 oracle oinstall 24 Mar 11 16:55 lkORCL -rw-r-----. 1 oracle oinstall 1536 Mar 11 16:38 orapworcl SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup; ORACLE instance started. Total System Global Area 835104768 bytes Fixed Size 2217952 bytes Variable Size 520095776 bytes Database Buffers 310378496 bytes Redo Buffers 2412544 bytes Database mounted. Database opened.
相关推荐
FightFourEggs 2020-08-16
踩风火轮的乌龟 2020-07-26
xwb 2020-07-19
lklong 2020-11-22
oraclemch 2020-11-06
shilukun 2020-10-10
周嘉笙 2020-11-09
iilegend 2020-10-19
EricRay 2020-10-16
zhuzhufxz 2020-09-16
dataminer 2020-08-17
bfcady 2020-08-16
Hody 2020-08-16
数据库设计 2020-08-16
Seandba 2020-08-16
Omega 2020-08-16
zjyzz 2020-08-16
yanghuatong 2020-08-16