LINUX下ORACLE利用rman备份迁移数据库.docxVIP

第一医院数据库迁移的实施步骤 利用 RMAN 备份正式库 全库备份及控制文件 RMANrun{ allocate channel c1 device type disk; sql alter system archive log current; backup as compressed backupset database format + FRA/DYYY/BACKUPSET/db_%d_%T_%U; sql alter system archive log current; backup current controlfile format + FRA/DYYY/controlfile/cntrl_%s_%p_%s; release channel c1; } 生成数据库还原脚本 restoredatafil e.sql 检查是否有增加数据文件 select count （* ） from v$datafile ；如果有增加数据库文件必须重新生成 sqlplus /nolog conn /as sysdba set serveroutput on; set linesize 200 spool restore_datafile.rman declare cursor df is select file#, name from v$datafile; begin dbms_output.put_line(run); dbms_output.put_line({); for dfrec in df loop dbms_output.put_line(set newname for datafile || dfrec.file# || to || || ;); end loop; dbms_output.put_line(restore database;); dbms_output.put_line(switch datafile all;); dbms_output.put_line(}); end; / spool off 利用 FTP 工具拷贝 RMAN 备份 远程登录到 2 ftp open 192.0.12 7788 密码： xzf111017s lcd /hisbak/ bin get 文“件名 ” 在目标库开启归档，设置归档路径 Alter database archivelog Alter system set log_archive_dest_1 = ‘ location=+HISDATA ’; 关闭节点 2 关闭节点 2 数据库 设置节点 1 cluster_database 参数为 False，设置为单实例 alter system set cluster_database = flase scope=spfile; shutdown immediate 恢复控制文件、注册备份集 rman target / sqlplus /nolog conn / as sysdba startup nomount restore controlfile from path\rman_controlfile_backup; alter database mount catalog start with path 清除无效备份 crosscheck backup; delete expired backup; 执行还原数据文件脚本 restoredatafil e.sql Run{ set newname for datafile 1 set newname for datafile 2 set newname for datafile 3 restore database;  to +HISDATA/dyyy/comm_tab08.ora ; to +HISDATA/dyyy/inpsick_tab208.ora ; to +HISDATA/dyyy/report_tab11.ora ; switch datafile all; } 拷贝归档 Catalog start with ‘归档日志路径’ Recover database 拷贝最近的几个归档日志 recover database 如果做不完全恢复，恢复到丢失归档前的时间点如： s recover database until sequence=2310 thread=2; 关闭 changing t rack alter database disable block change tracking; 重启数据库 修改日志的路径 查看日志的路径 Select member from v$logfile; 生成修改日志路径的脚本 select al