数据库备份恢复--从备份中恢复pfile

 

 

操作

1.启动到nomount

[oracle@bonda1 dbs]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sun Sep 9 07:24:01 2018

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

connected to target database (not started)

RMAN> startup nomount

startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initocp.ora'

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

Total System Global Area 1068937216 bytes

Fixed Size 2260088 bytes
Variable Size 281019272 bytes
Database Buffers 780140544 bytes
Redo Buffers 5517312 bytes

 

2.指定文件名恢复参数文件

RMAN> restore spfile to pfile '/u01/pfile' from '/u01/testc-2866727024-20180909-01';