Home > Administration > Restore spfile to ASM Diskgroup from Autobackup Backsetup

Restore spfile to ASM Diskgroup from Autobackup Backsetup

Example to restore database vstbpro spfile from autobackup to ASM diskgroup

 1.  Rename $ORACLE_HOME/dbs/initvstbpro1.ora to initvstbpro1.ora.bkup.

(This initial parameter points to the database spfile in ASM diskgroup likes as below)


 2.  Start database in nomount

 RMAN> startup nomount

 startup failed: ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file ‘/opt/oracle/product/11g/dbs/initvstbpro1.ora’

 starting Oracle instance without parameter file for retrieval of spfile

Oracle instance started

 3.  Restore the spfile to the default location $ORACLE/dbs

 RMAN> restore spfile from ‘/bkuppool/oracle/bkup/databases/vstbpro/bkup_ctl_c-2944505036-20091208-00.dat’;

 Starting restore at 09-DEC-09

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=94 device

 channel ORA_DISK_1: restoring spfile from AUTOBACKUP /bkuppool/oracle/bkup/databases/vstbpro/bkup_ctl_c-2944505036-20091208-00.dat

channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete

Finished restore at 09-DEC-09

 4.  Verify whether the spfile spfilevstbpro1.ora is restored to $ORACLE_HOME/dbs

 5.  Shutdown instance

 RMAN> shutdown

 Oracle instance shut down

 RMAN> exit

 6.  Startup the database

 $ sqlplus ‘/as sysdba’

 SQL*Plus: Release – Production on Wed Dec 9 11:08:32 2009

 Copyright (c) 1982, 2008, Oracle.  All rights reserved.

 Connected to an idle instance.

 SQL> startup

ORACLE instance started.

 Total System Global Area  313245696 bytes

Fixed Size                  2102088 bytes

Variable Size             239078584 bytes

Database Buffers           67108864 bytes

Redo Buffers                4956160 bytes

Database mounted.

Database opened.

 7.  Create a temporary pfile /tmp/initvstbpro1.ora’

 SQL> create pfile=’/tmp/initvstbpro1.ora’ from spfile;

 File created.

 8.  Migrate the a temporary pfile /tmp/initvstbpro1.ora to ASM diskgroup as spfile file

 SQL> create spfile=’+DAT2′ from pfile=’/tmp/initvstbpro1.ora’;

 File created.

 9.  Update the spfilevstbpro.ora alias in ASM diskgroup


ASMCMD> ls -l

Type           Redund  Striped  Time             Sys  Name

PARAMETERFILE  MIRROR  COARSE   DEC 09 12:00:00  Y    spfile.284.705151055

ASMCMD> cd ..



ASMCMD> mkalias ‘+DAT2/VSTBPRO/PARAMETERFILE/spfile.284.705151055’ spfilevstbpro.ora

 10.         Shutdown the database

 SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> exit

Disconnected from Oracle Database 11g Release – 64bit Production

the Real Application Clusters option

11.         Remove the $ORACLE_HOME/dbs/spfilevstbpro1.ora

 $ cd $ORACLE_HOME/dbs

 $ rm spfilevstbpro1.ora

$ cp initvstbpro1.ora.bkup initvstbpro1.ora    

$ cat initvstbpro1.ora  


 12.         Restart the database

Categories: Administration
  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: