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
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