情景:将A 库转移,利用热备方式迁移到新的服务器,然后将归档日志copy到新的服务器上。应用归档日志,追平,然后resetlogs
1. Source server:
SQL>alter database begin backup;
SQL>alter database backup controlfile to ‘/tmp/controlfile’;
2. Copy datafile,spfile,backup controlfile(‘/tmp/controlfile’),archive log
from source server to new server;
注意:热备方式不能拷贝controlfile 和current log
3. Source server:
SQL>alter database end backup;
备份结束之后在源库上停止运用
SQL>alter system archive current log;
将热备开始到提停止运用的archive log都得拷贝到新机器上
注:new server的路劲和源server的路劲保持一致
在 new server上恢复数据库
4. Cp /tmp/controlfile /oradata/ora12/control01.ctl
5. SQL>startup mount;
6. SQL>recover database using backup controlfile until cancel;
利用until cancel:是因为在源server上停止运用之后利用了alter system archive current log;所有的数据都已归档,因此只要将archivelog copy到new server上即可。
7. SQL>alter database open resetlogs;
8. 开始运用
总结:整个迁移过程停机的时间从停止运用开始
RMAN方式也可以!!
全备db:
RMAN>run{
allocate channel c1 type disk;
allocate channel c2 type disk;
configure controfile autobackup on;
backup database tag 'db1' format '/u01/backup/db_%u_%s_%p.bak';
sql 'alter system archive log current';
release channel c1;
release channel c2;
}
恢复:
将archivelog copy到new server
RMAN>SET DBID=…
RMAN>startup nomount;
RMAN>restore controlfile from autobackup;
RMAN>resoter database;
RMAN>recover database until cancel;
RMAN>alter database open resetlogs;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24849178/viewspace-716010/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24849178/viewspace-716010/