spfile is created in folder DB_UNKNOWN

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


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

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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

%d bloggers like this: