目标机器
--创建备份文件目录
mkdir /u01/backup
--添加静态链接，在nomount状态也可以链接
cd /u01/oracle/network/admin
vi listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME =walnut)
(ORACLE_HOME = /u01/oracle)
(SID_NAME =walnut)
)
)
原机器
--创建备份地址
mkdir /u01/backup
--启动数据库
sqlplus /nolog
conn / as sysdba
startup
windows机器
--备份数据库
rman target sys/oracle@beijing
list backup;
show all;
configure controlfile autobackup on;
backup database plus archivelog delete input format '/u01/backup/dup_%U';
目标机器
--删除以前的数据文件
cd /u01/oracle/dbs
rm -f sp*
rm -fR pe*
rm -f hc*
rm -f lk*
rm -f ora*
rm -f snapcf*
ll
--拷贝口令文件
scp oracle@192.168.137.188:/u01/oracle/dbs/orapwwalnut .
--编辑初始化参数文件，pfile
vi initwalnut.ora
db_name='walnut'
--删除原有数据库文件
cd /u01/oradata/walnut
ll
rm -f *
cd /u01/flash_recovery_area/walnut
rm -f *
cd /u01/flash_recovery_area/WALNUT
rm -fR *
--拷贝备份文件
cd /u01/backup
scp oracle@192.168.137.188:/u01/flash_recovery_area/WALNUT/backupset/2011_09_18/o1_mf_nnndf_TAG20110918T124548_77d81yx4_.bkp .
scp oracle@192.168.137.188:/u01/backup/dup_01mmrsnk_1_1 .
scp oracle@192.168.137.188:/u01/backup/dup_03mmrsr6_1_1 .
scp oracle@192.168.137.188:/u01/flash_recovery_area/WALNUT/autobackup/2011_09_18/o1_mf_s_762180455_77d858jf_.bkp
--用pfile启动到nomount状态
conn / as sysdba
startup nomount pfile=$ORACLE_HOME/dbs/initwalnut.ora
quit
目标机器
--链接rman后进行duplicate恢复
rman auxiliary sys/oracle@shanghai
@d.txt
run {
allocate auxiliary channel dup1 type disk;
duplicate database to walnut spfile backup location '/u01/backup' nofilenamecheck
logfile
group 1 ('/u01/oradata/walnut/redo01_1.rdo','/u01/oradata/walnut/redo01_2.rdo') size 52429312,
group 2 ('/u01/oradata/walnut/redo02_1.rdo','/u01/oradata/walnut/redo02_2.rdo') size 52429312,
group 3 ('/u01/oradata/walnut/redo03_1.rdo','/u01/oradata/walnut/redo03_2.rdo') size 52429312
;
}
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/15681893/viewspace-707849/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
