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";