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

第一医院数据库迁移的实施步骤利用RMAN备份正式库全库备份及控制文件RMANrunallocate 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; 生成数据库还原脚本restoredatafile.sql检查是否有增加数据文件 select count（*） from v$datafile；如果有增加数据库文件必须重新生成sqlplus /nologconn /as sysdbaset serveroutput on;set linesize 200spool restore_datafile.rmandeclare 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 ftpopen 192.0.12 7788 密码：xzf111017slcd /hisbak/binget “文件名”在目标库开启归档，设置归档路径Alter database archivelogAlter 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 /nologconn / as sysdbastartup nomountrestore controlfile from pathrman_controlfile_backup;alter database mountcatalog start with path清除无效备份crosscheck backup;delete expired backup;执行还原数据文件脚本restoredatafile.sqlRunset newname for datafile 1 to +HISDATA/dyyy/comm_tab08.ora ;set newname for datafile 2 to +HISDATA/dyyy/inpsick_tab208.ora ;set newname for datafile 3 to +HISDATA/dyyy/report_tab11.ora ;restore database;switch datafile all;拷贝归档Catalog start with 归档日志路径Recover database拷贝最近的几个归档日志recover database如果做不完全恢复，恢复到丢失归档前的时间点 如：srecover database until sequence=2310 thread=2;关闭changing trackalter database disable block change tracking;重启数据库修改日志的路径查看日志的路径Select member from v$logfile;生成修改日志路径的脚本select alter database rename file | member| to |+HISDATA/ |DECODE(substr(member,1,3),+DA,substr(member,7,length(member),substr(member,6,length(member)|; from v$logfile;执行脚本修改日志路径alter database rename file +FRA/dyyy/onlinelog/group_20.723.752328865 to +HISDATA/dyyy/onlinelog/group_20.723.752328865;修改数据库为最大性能模式alter database set standby database to maximize performance;打开数据库alter database open resetlogs；重建临时表空间SELECT NAME FROM V$TEMPFILE;ALTER TABLESPACE TEMP ADD TEMPFILE +HISDATA;ALTER TABLESPACE TEMP DROP TEMPFILE / temp01.dbf;拷贝归档并做归档日志的恢复Catalog start with 归档日志路径Recover database准备的IP地址模拟切换的IP地址：25 hisrac126 hisrac228 hisrac1-vip30 hisrac2-vip正式切换的IP地址：2hisrac17hisrac25hisrac1-vip8hisrac2-vip测试修改public ip 和vip1.使用“ifconfig a”命令，可以得到VIP是被绑定在eth0这个网络接口上。2.停掉所有与VIP相关的资源停止顺序：停止数据库实例；停止nodeapps。$srvctl stop database -d dyyy$srvctl stop listener$srvctl stop nodeapps -n hisrac1$srvctl stop nodeapps -n hisrac2使用“ifconfig -a”命令确认VIP已经停用如果网关地址一样可以不做修改改变两个节点的public ip 首先看一下当前的状态： $ oifcfg getif 查看IP通过以下命令修改：$ oifcfg delif -global eth0$ oifcfg setif -global eth0/:public$ oifcfg setif -global eth0/:public修改之后，我们再通过命令验证修改结果$ oifcfg getif 修改VIP地址 修改VIP需要我们用root用户：$su root#srvctl modify nodeapps -n hisrac1 -A 28 //eth0#srvctl modify nodeapps -n hisrac2 -A 30//eth0检查修改结果：#srvctl config nodeapps关闭CRS关闭CRS需要在两个节点上都运行，命令如下：#./crsctl stop crs这个命令会将RAC相关的所有服务全部停掉。修改OS IP 修改/etc/hosts和/etc/sysconfig/network-scripts/ifcfg-eth0 修改listener.ora的IP地址重启服务器后查看crs状态crs_st