非归档模式下增量备份后的恢复

郑全

非归档模式下增量备份后的恢复

   已经使用增量备份对数据库进行备份后,数据库出现问题,某些文件不存在了,那么这时只能恢复到上次备份的时刻
1.关闭数据库
SQL> connect / as sysdba
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

2.删除数据文件
[oracle@dbserver sztech1]$ ls -ltr /oracle/app/oracle/oradata/sztech1/*.dbf
-rw-r----- 1 oracle dba  52436992 Aug 20 18:34 /oracle/app/oracle/oradata/sztech1/temp02.dbf
-rw-r----- 1 oracle dba  13115392 Aug 20 19:09 /oracle/app/oracle/oradata/sztech1/users01.dbf
-rw-r----- 1 oracle dba 110108672 Aug 20 19:09 /oracle/app/oracle/oradata/sztech1/undotbs01.dbf
-rw-r----- 1 oracle dba 922755072 Aug 20 19:09 /oracle/app/oracle/oradata/sztech1/system01.dbf
-rw-r----- 1 oracle dba 692068352 Aug 20 19:09 /oracle/app/oracle/oradata/sztech1/sysaux01.dbf
-rw-r----- 1 oracle dba  20979712 Aug 20 19:09 /oracle/app/oracle/oradata/sztech1/idx01.dbf
-rw-r----- 1 oracle dba 471867392 Aug 20 19:09 /oracle/app/oracle/oradata/sztech1/example01.dbf

[oracle@dbserver sztech1]$ rm -fr system01.dbf
[oracle@dbserver sztech1]$ rm -fr undotbs01.dbf
[oracle@dbserver sztech1]$ ls -ltr
total 1335532
-rw-r----- 1 oracle dba  52436992 Aug 20 18:34 temp02.dbf
-rw-r----- 1 oracle dba  52429312 Aug 20 19:04 redo03.log
-rw-r----- 1 oracle dba  52429312 Aug 20 19:04 redo02.log
-rw-r----- 1 oracle dba  13115392 Aug 20 19:09 users01.dbf
-rw-r----- 1 oracle dba 692068352 Aug 20 19:09 sysaux01.dbf
-rw-r----- 1 oracle dba  52429312 Aug 20 19:09 redo01.log
-rw-r----- 1 oracle dba  20979712 Aug 20 19:09 idx01.dbf
-rw-r----- 1 oracle dba 471867392 Aug 20 19:09 example01.dbf
-rw-r----- 1 oracle dba   9748480 Aug 20 19:09 control01.ctl
[oracle@dbserver sztech1]$

3.启动到mount

oracle@dbserver sztech1]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Mon Aug 20 19:11:43 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup mount; 
ORACLE instance started.

Total System Global Area  619360256 bytes
Fixed Size                  1346700 bytes
Variable Size             411042676 bytes
Database Buffers          201326592 bytes
Redo Buffers                5644288 bytes
Database mounted.

4.使用rman 登陆到数据库
oracle@dbserver sztech1]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Mon Aug 20 19:13:09 2012

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

connected to target database: SZTECH1 (DBID=3206860853, not open)

RMAN>

5.还原数据库

RMAN> restore database;

Starting restore at 20-AUG-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /oracle/app/oracle/oradata/sztech1/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /oracle/app/oracle/oradata/sztech1/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /oracle/app/oracle/oradata/sztech1/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /oracle/app/oracle/oradata/sztech1/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /oracle/app/oracle/oradata/sztech1/example01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /oracle/app/oracle/oradata/sztech1/idx01.dbf
channel ORA_DISK_1: reading from backup piece /oracle/app/oracle/fast_recovery_area/SZTECH1/backupset/2012_08_20/o1_mf_nnnd0_TAG20120820T185705_834601rt_.bkp
channel ORA_DISK_1: piece handle=/oracle/app/oracle/fast_recovery_area/SZTECH1/backupset/2012_08_20/o1_mf_nnnd0_TAG20120820T185705_834601rt_.bkp tag=TAG20120820T185705
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:15
Finished restore at 20-AUG-12

 

6.进行介质恢复

RMAN> recover database;

Starting recover at 20-AUG-12
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 1 is already on disk as file /oracle/app/oracle/oradata/sztech1/redo01.log
archived log file name=/oracle/app/oracle/oradata/sztech1/redo01.log thread=1 sequence=1
media recovery complete, elapsed time: 00:00:02
Finished recover at 20-AUG-12

7.打开数据库

RMAN> alter database open resetlogs;

database opened

 

必须使用resetlogs方式打开数据库.