1.源库dbid:
TRACY (DBID=1205574469)

-backup:
RMAN> backup database format "/oracle/orabakup/%d_%t_%U";
RMAN> BACKUP ARCHIVELOG ALL format "/oracle/orabakup/%d_%t_%U";

3.目标库中
#linux下不需要这个: oradim -new -sid tracy
--为目标库搭建好oracle环境.

4.restore/recover --at target database

--restore pfile
RMAN> restore spfile to pfile "/oracle/product/10g/dbs/inittracy.ora" from "/oracle/orabakup/TRACY_755724130_0jmgmrr2_1_1";

--然后vi进去查看刚恢复的参数文件,检查里面的所有用到的目录是否均存在,如果有不存在的,需要手动建起来;否则会报错的。如下:

RMAN-00571: ===========================================================
RMAN-03002: failure of shutdown command at 07/05/2011 19:42:41
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

--create directory:
[oracle@ora2 admin]$ mkdir -p ./tracy/adump
[oracle@ora2 admin]$ mkdir -p ./tracy/bdump
[oracle@ora2 admin]$ mkdir -p ./tracy/cdump
[oracle@ora2 admin]$ mkdir -p ./tracy/udump
[oracle@ora2 oracle]$ mkdir -p ./oradata/tracy/

RMAN> startup force nomount pfile="/oracle/product/10g/dbs/inittracy.ora";


--恢复控制文件并进入到加载状态
--restore controlfile
RMAN> restore controlfile from "/oracle/orabakup/TRACY_755724130_0jmgmrr2_1_1";
RMAN> alter database mount;

--restore database
RMAN> restore database;

--recover database
RMAN> recover database;

Starting recover at 05-711
using channel ORA_DISK_1

starting media recovery

unable to find archive log
archive log thread=1 sequence=10
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/05/2011 19:52:31
RMAN-06054: media recovery requesting unknown log: thread 1 seq 10 lowscn 592201

RMAN>

--忽略上面的错误,是因为scn的问题!
RMAN> alter database open resetlogs;

database opened

RMAN>


-----now, it's OK.

--rebuild temptablespace & backup immediate...!!!

[oracle@ora2 ~]$ rman target /
RMAN> backup database format "/oracle/orabakup/%U";
RMAN> backup archivelog all format "/oracle/orabakup/%U";