Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to solve the problem of mistakenly deleting parameter files and password files in $ORACLE_HOME/dbs. It is very detailed and has a certain reference value. Interested friends must read it!

Mistakenly delete the parameter file under $ORACLE_HOME/dbs, password file how to quickly rebuild?

[oracle@11g dbs] $pwd/home/oracle/app/oracle/product/11.2.0/dbhome_1/ dbs [oracle @ 11g dbs] $lltotal 24Murr RW Muhami. 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=oracleSQL > 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 orapworclSQL > shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL > startup;ORACLE instance started.Total System Global Area 835104768 bytesFixed Size 2217952 bytesVariable Size 520095776 bytesDatabase Buffers 310378496 bytesRedo Buffers 2412544 bytesDatabase mounted.Database opened. The above is all the contents of this article entitled "how to solve the problem of mistakenly deleting parameter files and password files in $ORACLE_HOME/dbs". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.