新机的rman 设置都是default 的。而且肯定没有spfile 和 controlfile 的 备份记录,请问我如何恢复spfile 和control file?
直接 restore spfile from '/rman/ctl.bk' 也报同样的错。。求助?
[oracle@localhost oradata]$ export ORACLE_SID=OUSG09
[oracle@localhost oradata]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Jul 8 14:17:06 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> set dbid=3259250034
executing command: SET DBID
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/initOUSG09.ora'
starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started
Total System Global Area 1071333376 bytes
Fixed Size 1369420 bytes
Variable Size 281021108 bytes
Database Buffers 784334848 bytes
Redo Buffers 4608000 bytes
RMAN> restore spfile to pfile '/u01/app/oracle/product/11.2.0/db_1/dbs/initOUSG09.ora' from '/rman/spfile201606.bk';
Starting restore at 08-JUL-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK
channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/08/2016 14:18:56
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
RMAN>
RMAN> restore spfile to pfile '/u01/app/oracle/product/11.2.0/db_1/dbs/initOUSG09.ora' from '/rman/full_OUSG09_20160707_9_916571048.bak';
Starting restore at 08-JUL-16
using channel ORA_DISK_1
channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/08/2016 14:21:05
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
RMAN>