oracle完全恢复和不完全恢复,Oracle备份/恢复案例04——不完全恢复

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

RMAN> connect rcvcat rman/rman

connected to recovery catalog database

RMAN> connect target sys/sys

connected to target database: DODO (DBID=472976704)

RMAN> run{

2> allocate channel c1 type disk;

3> backup full tag 'dbfull' format 'd:backupfull_%u_%s_%p' database

4> include current controlfile;

5> sql 'alter system archive log current';

6> release channel c1;

7> }

allocated channel: c1

channel c1: sid=18 devtype=DISK

Starting backup at 2009-01-14

channel c1: starting full datafile backupset

channel c1: specifying datafile(s) in backupset

including current controlfile in backupset

input datafile fno=00008 name=D:\ORACLE\ORADATA\DODO\WXQ_TBS.ORA

input datafile fno=00006 name=D:\ORACLE\ORADATA\DODO\USERS01.DBF

input datafile fno=00001 name=D:\ORACLE\ORADATA\DODO\SYSTEM01.DBF

input datafile fno=00002 name=D:\ORACLE\ORADATA\DODO\UNDOTBS01.DBF

input datafile fno=00007 name=D:\ORACLE\ORADATA\DODO\XDB01.DBF

input datafile fno=00004 name=D:\ORACLE\ORADATA\DODO\INDX01.DBF

input datafile fno=00003 name=D:\ORACLE\ORADATA\DODO\DRSYS01.DBF

input datafile fno=00009 name=D:\ORACLE\ORADATA\DODO\RECOVERY_TBS.ORA

input datafile fno=00005 name=D:\ORACLE\ORADATA\DODO\TOOLS01.DBF

channel c1: starting piece 1 at 2009-01-14

channel c1: finished piece 1 at 2009-01-14

piece handle=D:\DATABASE\RMAN\FULL_1UK4PBLD_62_1 comment=NONE

channel c1: backup set complete, elapsed time: 00:02:35

Finished backup at 2009-01-14

Starting Control File and SPFILE Autobackup at 2009-01-14

piece handle=D:\ORACLE\ORADATA\DODO\RMANBACK\CTL_C-472976704-20090114-01 comment=NONE

Finished Control File and SPFILE Autobackup at 2009-01-14

sql statement: alter system archive log current

released channel: c1

3、删除测试表，在删除之前，便于测试，继续插入数据并应用到归档，并获取删除前的scn号

SQL> insert into test values(2);

1 row inserted

SQL> commit;

Commit complete

SQL> select * from test;

A

----------------------

1

2

SQL> alter system switch logfile;

Statement processed.

SQL> alter system switch logfile;

Statement processed.

SQL> select max(ktuxescnw * power(2, 32) + ktuxescnb) scn from x$ktuxe;

SCN

---------------

5966020192446

SQL> drop table test;

Table dropped.

4、准备恢复到SCN 31014，先关闭数据库，然后启动到mount下

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area  135338868 bytes

Fixed Size                   453492 bytes

Variable Size             109051904 bytes

Database Buffers           25165824 bytes

Redo Buffers                 667648 bytes

Database mounted.

5、开始恢复到改变点SCN 5966020192446

RMAN> run{

2> allocate channel c1 type disk;

3> restore database;

4> recover database until scn 5966020192446;

5> sql 'ALTER DATABASE OPEN RESETLOGS';

6> release channel c1;

7> }

allocated channel: c1

channel c1: sid=12 devtype=DISK

Starting restore at 2009-01-14

channel c1: starting datafile backupset restore

channel c1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to D:\ORACLE\ORADATA\DODO\SYSTEM01.DBF

restoring datafile 00002 to D:\ORACLE\ORADATA\DODO\UNDOTBS01.DBF

restoring datafile 00003 to D:\ORACLE\ORADATA\DODO\DRSYS01.DBF

restoring datafile 00004 to D:\ORACLE\ORADATA\DODO\INDX01.DBF

restoring datafile 00005 to D:\ORACLE\ORADATA\DODO\TOOLS01.DBF

restoring datafile 00006 to D:\ORACLE\ORADATA\DODO\USERS01.DBF

restoring datafile 00007 to D:\ORACLE\ORADATA\DODO\XDB01.DBF

restoring datafile 00008 to D:\ORACLE\ORADATA\DODO\WXQ_TBS.ORA

restoring datafile 00009 to D:\ORACLE\ORADATA\DODO\RECOVERY_TBS.ORA

channel c1: restored backup piece 1

piece handle=D:\DATABASE\RMAN\FULL_1UK4PBLD_62_1 tag=DBFULL params=NULL

channel c1: restore complete

Finished restore at 2009-01-14

Starting recover at 2009-01-14

starting media recovery

archive log thread 1 sequence 55 is already on disk as file D:\ORACLE\ORADATA\DODO\ARCHIVE\1_55.DBF

archive log thread 1 sequence 56 is already on disk as file D:\ORACLE\ORADATA\DODO\ARCHIVE\1_56.DBF

archive log thread 1 sequence 57 is already on disk as file D:\ORACLE\ORADATA\DODO\ARCHIVE\1_57.DBF

archive log filename=D:\ORACLE\ORADATA\DODO\ARCHIVE\1_55.DBF thread=1 sequence=55

media recovery complete

Finished recover at 2009-01-14

sql statement: ALTER DATABASE OPEN RESETLOGS

released channel: c1

6、检查数据

SQL> select * from test;

A

---------------------

1

2

可以看到，表依然存在