oracle9i 还原,ORACLE9i_RMAN备份恢复小实验系列之七：基于恢复目录还原

准备工作

这里先建一个数据库rman(用来存放catalog)

创建表空间

SQL> create tablespace rman_ts datafile

2  'D:\oracle\oradata\rman\rman_ts.dbf' size 20m

3   autoextend on next 1m maxsize unlimited

4  extent management local uniform size 128k;

创建用户

SQL> create user rman_owner identified by rman_owner

2  default tablespace rman_ts

3  quota unlimited on rman_ts;

授权

grant connect,resource,recovery_catalog_owner to rman_owner;

登陆ora9i数据库和恢复目录数据库(rman)

D:\>rman catalog target

创建恢复目录

RMAN> create catalog tablespace rman_ts

注册在恢复目录中的数据库

RMAN> register database;

给数据库做一个备份

注意：可能需要切换副本

RMAN> list incarnation of database;

数据库 Incarnations 列表

DB 关键字  Inc 关键字 DB 名  DB ID            CUR 重置 SCN   重置时间

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

1       13      UNKNOWN   2439988007       NO  240781     2007-12-03:16:27:21

1       2       ORA9I     2439988007       YES 305031     2007-12-03:18:44:02

RMAN>  reset database to incarnation 2;

SQL> create table scott.test2(n1 number) tablespace users;

SQL> insert into scott.test2 values(1);

SQL> insert into scott.test2 values(2);

SQL> alter system switch logfile;

SQL> drop tablespace users including contents and datafiles;

SQL>  create table scott.test3(n1 number) tablespace tools;

SQL> insert into scott.test3 values(2);

SQL> shutdown abort

在 ora9iALRT.log里

Mon Dec 03 19:16:23 2007

Deleted file D:\ORACLE\ORADATA\ORA9I\USERS01.DBF

Completed: drop tablespace users including contents and dataf

恢复到2007-12-03:19:16:22的样子

RMAN> startup nomount

RMAN>

run {

set until time='2007-12-03:19:16:22';

restore controlfile;

alter database mount;

restore database;

recover database;

alter database open resetlogs;}

恢复完之后

SQL> select * from scott.test2;

N1

----------

1

SQL> select * from scott.test3;

select * from scott.test3

*

ERROR 位于第 1 行:

ORA-00942: 表或视图不存在