oracle恢复全备,rman 全备份恢复到新机

新机的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>

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值