Saturday, May 21, 2016

How to Restore spfile from RMAN Backup and Create pfile.

C:\Windows\system32>RMAN TARGET /

Recovery Manager: Release 11.2.0.1.0 - Production on Wed May 18 23:13:55 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database (not started)

RMAN> STARTUP FORCE NOMOUNT

startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'D:\APP\RAJIB.PRADHAN\PRODUCT\11.2.0\DBHOME_1\DATABASE\INITASMDB.ORA'

starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started

Total System Global Area     158662656 bytes

Fixed Size                     2173840 bytes
Variable Size                 92275824 bytes
Database Buffers              58720256 bytes
Redo Buffers                   5492736 bytes

RMAN> restore spfile from 'D:\app\rman_backup\spfile_ASMDB_16_20160519.bak';

Starting restore at 18-MAY-16
using channel ORA_DISK_1

channel ORA_DISK_1: restoring spfile from AUTOBACKUP D:\app\rman_backup\spfile_ASMDB_16_20160519.bak
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 18-MAY-16

RMAN> exit


Recovery Manager complete.

C:\Windows\system32>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Wed May 18 23:20:51 2016

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create pfile='D:\APP\RAJIB.PRADHAN\PRODUCT\11.2.0\DBHOME_1\DATABASE\INITASMDB.ORA' from spfile;

File created.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

No comments:

Post a Comment