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";
转载于:https://blog.51cto.com/mrdba/622344