Home > Oracle > spfile is created in folder DB_UNKNOWN

spfile is created in folder DB_UNKNOWN

Oracle 11g / 64Bit linux / Asm

restoring spfile using rman , the spfile is located in a wrong location

+DATA1/DB_UNKNOWN/PARAMETERFILE/SPFILE.185.634235834

Solution is explained in Metalink solution in Note: 393932.1

1. Create a pfile
   SQL> create pfile='/tmp/pfile' from spfile'+DATA/DB_UNKNOWN/PARAMETERFILE/SPFILE.185.634235834';

2.
Shutdown and startup mount using the restored spfile
   SQL> startup mount force pfile=/tmp/pfile

3. Restore
the spfile again to the correct location as DB_NAME is correctly set this time.
   RMAN> restore spfile;

4. Startup again using the spfile
   SQL> startup force

Advertisements
Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: