在Oracle 11g中恢复RMAN Oracle 10g备份

概述我在Sun Solaris OS上有oracle 10g(10.2.0.3)的RMAN完整数据库备份,我希望在 Linux OS上的oracle 11g(11.2.0.3)上进行恢复.备份件以二进制模式手动传输到oracle 11g服务器.Oracle 11g安装在linux OS上.我只有RMAN备份,无法访问备份所在的主数据库. -rwxrwxr-x 1 mepc dba 36356096 我在Sun Solaris OS上有oracle 10g(10.2.0.3)的RMAN完整数据库备份,我希望在 Linux OS上的oracle 11g(11.2.0.3)上进行恢复.备份件以二进制模式手动传输到oracle 11g服务器.Oracle 11g安装在linux OS上.我只有RMAN备份,无法访问备份所在的主数据库.

-rwxrwxr-x 1 mepc dba   36356096 Jul 16 14:49 snapcf_MEPC.f-rwxrwxr-x 1 mepc dba  166028800 Jul 16 15:29 MEPC_full_backup_MEPC_nnnbkn9f_1_1-rwxrwxr-x 1 mepc dba  169567744 Jul 16 15:29 MEPC_full_backup_MEPC_nmnbkn9f_1_1-rwxrwxr-x 1 mepc dba  164813824 Jul 16 15:39 MEPC_full_backup_MEPC_nonbkn9f_1_1-rwxrwxr-x 1 mepc dba  144025600 Jul 16 16:06 MEPC_full_backup_MEPC_nqnbkn9f_1_1-rwxrwxr-x 1 mepc dba  168576512 Jul 16 16:09 MEPC_full_backup_MEPC_npnbkn9f_1_1-rwxrwxr-x 1 mepc dba  168649216 Jul 16 17:33 MEPC_full_backup_MEPC_o5nbkpvv_1_1-rwxrwxr-x 1 mepc dba  162847232 Jul 16 17:34 MEPC_full_backup_MEPC_o6nbkpvv_1_1-rwxrwxr-x 1 mepc dba  167351808 Jul 16 17:35 MEPC_full_backup_MEPC_o7nbkpvv_1_1-rwxrwxr-x 1 mepc dba  166838272 Jul 16 17:36 MEPC_full_backup_MEPC_o8nbkpvv_1_1-rwxrwxr-x 1 mepc dba  166876160 Jul 16 17:37 MEPC_full_backup_MEPC_o9nbkpvv_1_1-rwxrwxr-x 1 mepc dba  327606272 Jul 16 17:54 MEPC_full_backup_MEPC_o4nbknav_1_1-rwxrwxr-x 1 mepc dba  549658624 Jul 16 18:26 MEPC_full_backup_MEPC_o2nbknav_1_1-rwxrwxr-x 1 mepc dba  162984448 Jul 16 18:28 MEPC_full_backup_MEPC_oanbkpvv_1_1-rwxrwxr-x 1 mepc dba  163567616 Jul 16 18:29 MEPC_full_backup_MEPC_obnbkpvv_1_1-rwxrwxr-x 1 mepc dba  161380352 Jul 16 18:29 MEPC_full_backup_MEPC_ocnbkpvv_1_1-rwxrwxr-x 1 mepc dba 1072275456 Jul 18 13:52 MEPC_full_backup_MEPC_o3nbknav_1_1-rwxrwxr-x 1 mepc dba 1813348352 Jul 18 17:00 MEPC_full_backup_MEPC_o1nbknav_1_1-rwxrwxr-x 1 mepc dba   36438016 Jul 25 15:45 controlfile_bkup_MEPC_c-1469445140-20120522-09

备份采用上述格式.我知道从中进行备份的数据库的ORACLE_SID和dbID.

每当我尝试以下命令

mepc@tcstctmatson:/mepc_backup/May22fullbkp$rman target /Recovery Manager: Release 11.2.0.3.0 - Production on Tue Jul 31 12:14:54 2012copyright (c) 1982,2011,Oracle and/or its affiliates.  All rights reserved.connected to target database: MEPC (DBID=1595278680)RMAN> shutdown;using target database control file instead of recovery catalogdatabase closeddatabase dismountedOracle instance shut downRMAN> startup nomount;connected to target database (not started)Oracle instance startedTotal System Global Area    1071333376 bytesFixed Size                     1349732 bytesVariable Size                620758940 bytesDatabase Buffers             444596224 bytesRedo Buffers                   4628480 bytesRMAN> restore spfile to '$ORACLE_HOME/dbs/initMEPC.ora' from autobackup db_recovery_file_dest='/mepc_backup/May22fullbkp' db_name='MEPC';

通知以下错误

Starting restore at 31-Jul-12using channel ORA_disK_1recovery area destination: /mepc_backup/May22fullbkpdatabase name (or database unique name) used for search: MEPCchannel ORA_disK_1: no autoBACKUPS found in the recovery areachannel ORA_disK_1: looking for autoBACKUP on day: 20120731channel ORA_disK_1: looking for autoBACKUP on day: 20120730channel ORA_disK_1: looking for autoBACKUP on day: 20120729channel ORA_disK_1: looking for autoBACKUP on day: 20120728channel ORA_disK_1: looking for autoBACKUP on day: 20120727channel ORA_disK_1: looking for autoBACKUP on day: 20120726channel ORA_disK_1: looking for autoBACKUP on day: 20120725channel ORA_disK_1: no autoBACKUP in 7 days foundRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FolLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of restore command at 07/31/2012 12:22:06RMAN-06172: no autoBACKUP found or specifIEd handle is not a valID copy or pIEce

我也尝试通过目录恢复rman备份,并通知以下错误

List of files Which Where Not Cataloged=======================================file name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_nonbkn9f_1_1  RMAN-07517: Reason: The file header is corruptedfile name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_obnbkpvv_1_1  RMAN-07517: Reason: The file header is corruptedfile name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_ocnbkpvv_1_1  RMAN-07517: Reason: The file header is corruptedfile name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_o7nbkpvv_1_1  RMAN-07517: Reason: The file header is corruptedfile name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_o9nbkpvv_1_1  RMAN-07517: Reason: The file header is corruptedfile name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_nmnbkn9f_1_1  RMAN-07517: Reason: The file header is corruptedfile name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_nnnbkn9f_1_1  RMAN-07517: Reason: The file header is corruptedfile name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_o3nbknav_1_1  RMAN-07517: Reason: The file header is corruptedfile name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_o6nbkpvv_1_1  RMAN-07517: Reason: The file header is corruptedfile name: /mepc_backup/May22fullbkp/controlfile_bkup_MEPC_c-1469445140-20120522-09  RMAN-07517: Reason: The file header is corruptedfile name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_npnbkn9f_1_1  RMAN-07517: Reason: The file header is corruptedfile name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_oanbkpvv_1_1  RMAN-07517: Reason: The file header is corruptedfile name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_nqnbkn9f_1_1  RMAN-07517: Reason: The file header is corruptedfile name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_o1nbknav_1_1  RMAN-07517: Reason: The file header is corruptedfile name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_o5nbkpvv_1_1  RMAN-07517: Reason: The file header is corruptedfile name: /mepc_backup/May22fullbkp/snapcf_MEPC.f  RMAN-07517: Reason: The file header is corruptedfile name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_o2nbknav_1_1  RMAN-07517: Reason: The file header is corruptedfile name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_o4nbknav_1_1  RMAN-07517: Reason: The file header is corruptedfile name: /mepc_backup/May22fullbkp/MEPC_full_backup_MEPC_o8nbkpvv_1_1  RMAN-07517: Reason: The file header is corrupted

因为我检查了两台服务器上的校验和并且它是相同的,所以文件没有损坏.

请帮助我如何在Oracle 11g中恢复RMAN oracle 10g备份,让我知道我哪里出错了.

提前致谢.

解决方法 你不能做这个.
AFAIK,Solaris – 假设sparc – 和linux – 假设英特尔 – 有不同的字节序格式,这是你的问题.您可以使用迁移跨平台表空间方案.
见 Oracle® Database Backup and Recovery Reference 如果您的endian格式看起来相同,则应使用rman convert database转换数据库.在这种情况下,您可以恢复跨平台和跨版本. 总结

以上是内存溢出为你收集整理的在Oracle 11g中恢复RMAN Oracle 10g备份全部内容，希望文章能够帮你解决在Oracle 11g中恢复RMAN Oracle 10g备份所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。