使用过的rman备份集的变化

    在Nocatalog的情况下，硬盘上的Rman备份集在使用一次后，控制文件发生了变化。

不但备份集中控制文件的文件时间发生了变化，我猜想内容也发生了变化。

之后再次使用这个备份集进行恢复操作，遇到错误。

本文记录了这个过程，以及如何解决。



恢复orapw文件 ：

[oracle@shdemo1 dbs]$ orapwd file=orapwdevb password=123456 entries=20
[oracle@shdemo1 dbs]$
[oracle@shdemo1 dbs]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Wed May 10 15:54:49 2006

Copyright (c) 1982, 2002, Corporation.  All rights reserved.

SQL> conn sys/123456@devb as sysdba
Connected to an idle instance.
SQL> startup nomount
ORA-01031: insufficient privileges
SQL>
SQL> disc
Disconnected
SQL> conn / as sysdba
Connected to an idle instance.
SQL>
SQL> startup nomount
ORACLE instance started.

Total System Global Area   42742804 bytes
Fixed Size                   451604 bytes
Variable Size              41943040 bytes
Database Buffers             204800 bytes
Redo Buffers                 143360 bytes
SQL>


恢复 spfile:

[oracle@shdemo1 devb]$ rman nocatalog

Recovery Manager: Release 9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Corporation.  All rights reserved.

RMAN> connect target

connected to target database: devb (not mounted)
using target database controlfile instead of recovery catalog

RMAN> set DBID=1179520070

executing command: SET DBID

RMAN> restore spfile from autobackup;

Starting restore at 10-MAY-06

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=10 devtype=DISK
channel ORA_DISK_1: looking for autobackup on day: 20060510
channel ORA_DISK_1: looking for autobackup on day: 20060509
channel ORA_DISK_1: looking for autobackup on day: 20060508
channel ORA_DISK_1: looking for autobackup on day: 20060507
channel ORA_DISK_1: looking for autobackup on day: 20060506
channel ORA_DISK_1: looking for autobackup on day: 20060505
channel ORA_DISK_1: looking for autobackup on day: 20060504
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 05/10/2006 15:57:57
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

RMAN> restore spfile from '/home/oracle/backup/devb/c-1179520070-20060510-05';

Starting restore at 10-MAY-06

using channel ORA_DISK_1
channel ORA_DISK_1: autobackup found: /home/oracle/backup/devb/c-1179520070-20060510-05
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 10-MAY-06

RMAN>

[1]   

【责编:Peng】

--------------------next---------------------