【赛迪网－it技术报道】完整的oracle rman备份恢复参考示例：

1、建rman库作为repository

$more createrman_db1.sh

set echo on

spool makedb1.log

create database rman

datafile '/export/home/oracle/oradata/rman_data/system.dbf' size 50m autoextend

on next 640k

logfile '/export/home/oracle/oradata/rman_data/redo0101.log' size 10m,

'/export/home/oracle/oradata/rman_data/redo0201.log' size 10m

maxdatafiles 30

maxinstances 8

maxlogfiles 64

character set us7ascii

national character set us7ascii

;

disconnect

spool off

exit

@/export/home/oracle/8.1.6/rdbms/admin/catalog.sql;

rem ********** alter system tablespace *********

alter tablespace system

default storage ( initial 64k next 64k minextents 1 maxextents unlimited pctincr

ease 50);

alter tablespace system

minimum extent 64k;

rem ********** tablespace for rollback **********

create tablespace rbs datafile '/export/home/oracle/oradata/rman_data/rbs.dbf' s

ize 50m

autoextend on next 512k

minimum extent 512k

default storage ( initial 512k next 512k minextents 10 maxextents unlimited pc

tincrease 0 );

rem ********** tablespace for temporary **********

create tablespace temp datafile '/export/home/oracle/oradata/rman_data/temp.dbf'

size 50m

autoextend on next 64k

minimum extent 64k

default storage ( initial 64k next 64k minextents 1 maxextents unlimited pctincr

ease 0) temporary;

rem **** creating four rollback segments ****************

create public rollback segment rbs_0 tablespace rbs

storage ( optimal 64000k );

alter rollback segment "rbs_0" online;

rem **** sys and system users ****************

alter user sys temporary tablespace temp;

alter user system temporary tablespace temp;

disconnect

spool off

exit

$more createrman_db3.sh

spool crdb3.log

@/export/home/oracle/8.1.6/rdbms/admin/catproc.sql

@/export/home/oracle/8.1.6/rdbms/admin/caths.sql

@/export/home/oracle/8.1.6/rdbms/admin/otrcsvr.sql

connect system/manager

@/export/home/oracle/8.1.6/sqlplus/admin/pupbld.sql

disconnect

spool off

exit

2、建repository存放的表空间和rman用户

$more createrman_db4.sh

connect internal

create tablespace rman_ts

datafile '/export/home/oracle/oradata/rman_data/rman_ts.dbf'

size 20m default storage (initial 100k next 100k pctincrease 0);

create user rman_hainan identified by rman_hainan

temporary tablespace temp

default tablespace rman_ts quota unlimited on

rman_ts;

grant recovery_catalog_owner to rman_hainan;

grant connect ,resource to rman_hainan;

3、建catalog，注册目标数据库

$more createrman_db5.sh

rman catalog rman_hainan/rman_hainan@rman msglog=rman.log

create catalog ;

exit;

rman target sys/oracle@db1

connect catalog rman_hainan/rman_hainan@rman

register database;

exit;

4、可以开始做备份了

5、做全备

$more rmanshell

. /export/home/oracle/.profile

rman rcvcat rman_hainan/rman_hainan@rman target / cmdfile /export/home/oracle/ba

ckup_level0.rcv log /export/home/oracle/backup.log

$more backup_level0.rcv

resync catalog;

run {

allocate channel t1 type disk;

backup

incremental level 0

skip inaccessible

tag hot_db_bk_level0

filesperset 3

format '/export/home/oracle/bk_%s_%p_%t.bk'

(database);

sql 'alter system archive log current';

backup

filesperset 10

format '/export/home/oracle/a1_%s_%p_%t.ac'

(archivelog all delete input);

backup

format '/export/home/oracle/df_t%t_s%s_p%p.ct'

current controlfile ;

}

6、做增备

$more rmanshell1

rman rcvcat rman_hainan/rman_hainan@rman target / cmdfile backup_level1.rcv log

backup.log

$more backup_level1.rcv

resync catalog;

run {

allocate channel t1 type disk;

backup

incremental level 1

skip inaccessible

tag hot_db_bk_level1

filesperset 3

format 'bk_%s_%p_%t.bk1'

(database);

sql 'alter system archive log current';

backup

filesperset 10

format 'a1_%s_%p_%t.ac1'

(archivelog all delete input);

backup current controlfile;

}

1、 删除旧的全备

$rman rcvcat rman_hainan/rman_hainan@rman target /

recovery manager: release 8.1.6.0.0 - production

rman-06005: connected to target database: test (dbid=1692992254)

rman-06008: connected to recovery catalog database

rman> list backupset;

rman-03022: compiling command: list

list of backup sets

key recid stamp lv set stamp set count completion time

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

38 145 399987408 0 399987406 153 11-jun-00

根据key来删除旧的备份。

rman> allocate channel for maintenance type disk;

rman> change backupset 169 delete; ----------this is the command to remove the entry & os file

做完后可以看到list backupset和操作系统的文件都没有了。

2、 恢复

（1） 将数据库启动到nomount状态：

$svrmgrl

oracle server manager release 3.1.6.0.0 - production

copyright (c) 1997, 1999, oracle corporation. all rights reserved.

oracle8i enterprise edition release 8.1.6.0.0 - 64bit production

with the partitioning option

jserver release 8.1.6.0.0 - production

svrmgr> connect internal

connected.

svrmgr> startup nomount;

oracle instance started.

total system global area 339275684 bytes

fixed size 94116 bytes

variable size 318685184 bytes

database buffers 16384000 bytes

redo buffers 4112384 bytes

svrmgr> exit

server manager complete.

（2） 恢复控制文件：

$rman rcvcat rman_hainan/rman_hainan@rman target /

recovery manager: release 8.1.6.0.0 - production

rman-06006: connected to target database: test (not mounted)

rman-06008: connected to recovery catalog database

rman> run {

2> allocate channel d1 type disk;

3> restore controlfile;

4> release channel d1;

5> }

（3） 恢复数据文件

rman> run {

2> allocate channel d1 type disk;

3> sql "alter database mount";

4> restore datafile 1;

5> restore datafile 2;

6> restore datafile 3;

7> restore datafile 4;

8> release channel d1;

9> }

（4） 恢复日志文件

rman> run {

2> set archivelog destination to '/export/home/oracle/admin/test/arch';

3> allocate channel d1 type disk;

4> restore archivelog all;

5> release channel d1;

6> }

会把所有的日志文件恢复。

（5） 根据日志做recover

$svrmgrl

oracle server manager release 3.1.6.0.0 - production

copyright (c) 1997, 1999, oracle corporation. all rights reserved.

oracle8i enterprise edition release 8.1.6.0.0 - 64bit production

with the partitioning option

jserver release 8.1.6.0.0 - production

svrmgr> connect internal

connected.

svrmgr> recover database using backup controlfile until cancel;

ora-00279: change 51054 generated at 06/11/2000 11:38:37 needed for thread 1

ora-00289: suggestion : /export/home/oracle/admin/test/arch/arch_1_3.arc

ora-00280: change 51054 for thread 1 is in sequence #3

specify log: {=suggested | filename | auto | cancel}

log applied.

ora-00279: change 51058 generated at 06/11/2000 11:38:44 needed for thread 1

ora-00289: suggestion : /export/home/oracle/admin/test/arch/arch_1_4.arc

ora-00280: change 51058 for thread 1 is in sequence #4

ora-00278: log file '/export/home/oracle/admin/test/arch/arch_1_3.arc' no longer

needed for this recovery

specify log: {=suggested | filename | auto | cancel}

log applied.

ora-00279: change 51074 generated at 06/11/2000 11:40:20 needed for thread 1

ora-00289: suggestion : /export/home/oracle/admin/test/arch/arch_1_5.arc

ora-00280: change 51074 for thread 1 is in sequence #5

ora-00278: log file '/export/home/oracle/admin/test/arch/arch_1_4.arc' no longer

needed for this recovery

specify log: {=suggested | filename | auto | cancel}

cancel

media recovery cancelled.

svrmgr> alter database open resetlogs;

statement processed.

恢复完成。

svrmgr> select table_name from user_tables;

table_name

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

bonus

dept

emp

salgrade

test

test_zmy

zmy

zmy_dept

zmy_emp

9 rows selected.

可以检查看到，所有的都恢复了，包括全备份后的事务。（只要有归档日志，都可以恢复）。

3、恢复后rman数据库的同步

$rman rcvcat rman_hainan/rman_hainan@rman target /

recovery manager: release 8.1.6.0.0 - production

rman-06005: connected to target database: test (dbid=1692992254)

rman-06008: connected to recovery catalog database

rman> reset database;

rman-03022: compiling command: reset

rman-03023: executing command: reset

rman-08006: database registered in recovery catalog

rman-03023: executing command: full resync

rman-08029: snapshot controlfile name set to default value: ?/dbs/snapcf_@.f

rman-08002: starting full resync of recovery catalog

rman-08004: full resync complete