首页 / 数据库 / MySQL / Oracle RMAN 跨平台恢复测试（Windows->Linux）

原数据库为Oracle11G 11.2.0.3，跑在64位WINDOWS上，使用RMAN做了个备份，将备份文件上传到Linux服务器上的/home/oracle/rmanbackup目录中，准备恢复到64位LINUX上，过程如下：将数据库启动到nomount状态oracle@changeme:~> sqlplus /nolog
SQL> conn / as sysdba
SQL> startup nomount
SQL> exit进入RMAN进行恢复oracle@changeme:~> rman target /Recovery Manager: Release 11.2.0.3.0 - Production on Sat Jun 29 17:39:40 2013Copyright （c） 1982, 2011, Oracle and/or its affiliates.  All rights reserved.connected to target database: CSDB （not mounted）RMAN> set DBID=3039653104executing command: SET DBID
RMAN> restore controlfile from "/home/oracle/rmanbackup/CTL_0FODDSB1_20130629";Starting restore at 29-JUN-13
using channel ORA_DISK_1channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/csdb/control01.ctl
Finished restore at 29-JUN-13RMAN> sql "alter database mount";sql statement: alter database mount
released channel: ORA_DISK_1RMAN> catalog start with "/home/oracle/rmanbackup";Starting implicit crosscheck backup at 29-JUN-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
Crosschecked 8 objects
Finished implicit crosscheck backup at 29-JUN-13Starting implicit crosscheck copy at 29-JUN-13
using channel ORA_DISK_1
Crosschecked 2 objects
Finished implicit crosscheck copy at 29-JUN-13searching for all files in the recovery area
cataloging files...
no files catalogedsearching for all files that match the pattern /home/oracle/rmanbackupList of Files Unknown to the Database
=====================================
File Name: /home/oracle/rmanbackup/ARCH_0GODDSKM_20130629
File Name: /home/oracle/rmanbackup/DB_INC0_0DODDS85_20130629
File Name: /home/oracle/rmanbackup/CTL_0FODDSB1_20130629
File Name: /home/oracle/rmanbackup/DB_INC0_0EODDSAQ_20130629Do you really want to catalog the above files （enter YES or NO）？ y
cataloging files...
cataloging doneList of Cataloged Files
=======================
File Name: /home/oracle/rmanbackup/ARCH_0GODDSKM_20130629
File Name: /home/oracle/rmanbackup/DB_INC0_0DODDS85_20130629
File Name: /home/oracle/rmanbackup/CTL_0FODDSB1_20130629
File Name: /home/oracle/rmanbackup/DB_INC0_0EODDSAQ_20130629 RMAN> run{
2> allocate channel c1 type disk;
3> set newname for datafile 1 to "/u01/app/oracle/oradata/csdb/system01.dbf";
4> set newname for datafile 2 to "/u01/app/oracle/oradata/csdb/sysaux01.dbf";
5> set newname for datafile 3 to "/u01/app/oracle/oradata/csdb/undotbs1.dbf";
6> set newname for datafile 4 to "/u01/app/oracle/oradata/csdb/users01.dbf";
7> set newname for datafile 5 to "/u01/app/oracle/oradata/csdb/example01.dbf";
8> set newname for datafile 6 to "/u01/app/oracle/oradata/csdb/undotbs2.dbf";
9> set newname for datafile 7 to "/u01/app/oracle/oradata/csdb/testtbs01.dbf";
10> restore database;
11> switch datafile all;
12> release channel c1;
13> }released channel: ORA_DISK_1
allocated channel: c1
channel c1: SID=134 device type=DISKexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEStarting restore at 29-JUN-13channel c1: starting datafile backup set restore
channel c1: specifying datafile（s） to restore from backup set
channel c1: restoring datafile 00001 to /u01/app/oracle/oradata/csdb/system01.dbf
channel c1: restoring datafile 00002 to /u01/app/oracle/oradata/csdb/sysaux01.dbf
channel c1: restoring datafile 00003 to /u01/app/oracle/oradata/csdb/undotbs1.dbf
channel c1: restoring datafile 00004 to /u01/app/oracle/oradata/csdb/users01.dbf
channel c1: restoring datafile 00005 to /u01/app/oracle/oradata/csdb/example01.dbf
channel c1: restoring datafile 00006 to /u01/app/oracle/oradata/csdb/undotbs2.dbf
channel c1: restoring datafile 00007 to /u01/app/oracle/oradata/csdb/testtbs01.dbf
channel c1: reading from backup piece /home/oracle/rmanbackup/DB_INC0_0DODDS85_20130629
channel c1: piece handle=/home/oracle/rmanbackup/DB_INC0_0DODDS85_20130629 tag=DB_INCR0
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:25
Finished restore at 29-JUN-13datafile 1 switched to datafile copy
input datafile copy RECID=15 STAMP=819395669 file name=/u01/app/oracle/oradata/csdb/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=16 STAMP=819395669 file name=/u01/app/oracle/oradata/csdb/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=17 STAMP=819395669 file name=/u01/app/oracle/oradata/csdb/undotbs1.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=18 STAMP=819395669 file name=/u01/app/oracle/oradata/csdb/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=19 STAMP=819395669 file name=/u01/app/oracle/oradata/csdb/example01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=20 STAMP=819395669 file name=/u01/app/oracle/oradata/csdb/undotbs2.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=21 STAMP=819395669 file name=/u01/app/oracle/oradata/csdb/testtbs01.dbfreleased channel: c1RMAN> run{
2> allocate channel ch1 type disk;
3> recover database;
4> release channel ch1;
5> }allocated channel: ch1
channel ch1: SID=134 device type=DISKStarting recover at 29-JUN-13starting media recoverychannel ch1: starting archived log restore to default destination
channel ch1: restoring archived log
archived log thread=1 sequence=18
channel ch1: restoring archived log
archived log thread=1 sequence=19
channel ch1: reading from backup piece /home/oracle/rmanbackup/ARCH_0GODDSKM_20130629
channel ch1: piece handle=/home/oracle/rmanbackup/ARCH_0GODDSKM_20130629 tag=ARCH
channel ch1: restored backup piece 1
channel ch1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/app/oracle/fast_recovery_area/CSDB/archivelog/2013_06_29/o1_mf_1_18_8wxctd6k_.arc thread=1 sequence=18
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/29/2013 17:56:31
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile "/u01/app/oracle/fast_recovery_area/CSDB/archivelog/2013_06_29/o1_mf_1_18_8wxctd6k_.arc"
ORA-10562: Error occurred while applying redo to data block （file# 2, block# 70876）
ORA-10564: tablespace SYSAUX
ORA-01110: data file 2: "/u01/app/oracle/oradata/csdb/sysaux01.dbf"
ORA-10561: block type "TRANSACTION MANAGED INDEX BLOCK", data object# 70514
ORA-00600: internal error code, arguments: [6122], [0], [41668], [0], [], [], [], [], [], [], [], []在最后recover阶段出错，结果证明，在ORALCE 11.2.0.3上，数据库不可以直接将RMAN备份直接从WINDOWS上恢复到LINUX，原因大概类似于Data Guard中的BUG 13104881，跨平台时的redo问题。据说从LINUX到WINDOWS可以恢复，有兴趣的朋友可以试试。相关阅读：Oracle RMAN中备份表空间名为"TEST"时需要注意的问题 http://www.linuxidc.com/Linux/2013-07/86924.htmOracle 基于 RMAN 的不完全恢复（incomplete recovery by RMAN） http://www.linuxidc.com/Linux/2013-07/86929.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12Oracle 11g RAC ASM磁盘全部丢失后的恢复SUSE11 SP2下Oracle 11g安装指南相关资讯      RMAN  RMAN跨平台恢复  Oracle RMAN跨平台 

RMAN故障一例（归档的备份，从不  （今 20:42） RMAN的FORMATA格式说明  （03月10日） Oracle 11g RMAN复制数据库的测试  （01月19日）

RMAN数据库迁移  （05月22日） 使用RMAN复制恢复开发库环境  （02月17日） Oracle 11g RMAN跨平台传输表空间  （01月19日）

本文评论 查看全部评论 （0）

表情： 姓名： 匿名字数 <div id="footbar"> 版权所有©石家庄振强科技有限公司2024 <a href="https://beian.miit.gov.cn" target="_blank">冀ICP备08103738号-5</a> <a href="/storage/sitemap.xml">网站地图</a> </div> </div> <script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/cm.js"></script> <script> var _mtj = _mtj || []; (function () { var mtj = document.createElement("script"); mtj.src = "https://node12.aizhantj.com:21233/tjjs/?k=p2tceukth5c"; var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(mtj, s); })(); </script> </body> </html>