RMAN恢复报错

WWJD_DBA

需要将RMAN数据从A恢复到B
A：DB版本：9.2.0.7.0 平台：AIX P5 5200-08-00
B：DB版本：9.2.0.7.0 平台：AIX P5 5300-07-01-0748
将A的备份数据拷入U盘，传到B，恢复的时候报错，如下：
bash-3.2$ rman target /

Recovery Manager: Release 9.2.0.7.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: prod (not mounted)

RMAN> restore controlfile  to '/u01/ora9a/oradata/prod02/control01.ctl' from '/dmp/backup/c-7268713-20130422-2a';

Starting restore at 11-MAY-13

using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=13 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/11/2013 18:20:28
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece
不知道是不是思路的问题，RMAN没学好...请老师指点一下，感谢！

Maclean Liu(刘相兵

直接

cp /dmp/backup/c-7268713-20130422-2a  /u01/ora9a/oradata/prod02/control01.ctl

试试

WWJD_DBA

RMAN> startup mount;

database is already started
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 05/15/2013 15:25:40
ORA-00205: error in identifying controlfile, check alert log for more info

数据库日志
Wed May 15 15:25:37 2013
alter database mount
Wed May 15 15:25:37 2013
ORA-00202: controlfile: '/u01/ora9a/oradata/prod02/control01.ctl'
Wed May 15 15:25:40 2013
ORA-205 signalled during: alter database mount...
Wed May 15 15:26:28 2013
ARC0: Thread not mounted
Wed May 15 15:26:28 2013
ARC1: Thread not mounted
Wed May 15 15:27:28 2013
ARC1: Thread not mounted

Maclean Liu(刘相兵

strings /dmp/backup/c-7268713-20130422-2a 给出输出

WWJD_DBA

Maclean Liu(刘相兵 发表于 2013-5-15 15:34
strings /dmp/backup/c-7268713-20130422-2a 给出输出

A数据库使用的是裸设备，strings显示的信息比较乱，只贴前面的吧
$ bash
bash-3.2$ strings /dmp/backup/c-7268713-20130422-2a
Z[\]
niPROD
0{h
4c

   0{h


+
*.aq_tm_processes=0
*.background_dump_dest='/oracle/admin/prod/bdump'
*.cluster_database=true
*.cluster_database_instances=2
prod01.cluster_interconnects='192.168.1.11'
prod02.cluster_interconnects='192.168.1.22'
*.compatible='9.2.0'
*.control_file_record_keep_time=30
*.control_files='/dev/rp_control01','/dev/rp_control02','/dev/rp_control03'
*.core_dump_dest='/oracle/admin/prod/cdump'
*.db_block_size=8192
*.DB_CACHE_ADVICE='on'
*.db_cache_size=2147483648
*.db_file_multiblock_read_count=16
*.db_name='prod'
*.db_writer_processes=2
*.enqueue_resources=1800
*.fast_start_mttr_target=300
prod01.instance_name='prod01'
prod02.instance_name='prod02'
prod01.instance_number=1
prod02.instance_number=2
*.java_pool_size=33554432
*.job_queue_processes=10
*.large_pool_size=67108864
prod01.local_listener='LISTENER_PROD01'
prod02.local_listener='LISTENER_PROD02'
*.log_archive_dest_1='LOCATION=/oracle/arch_log_hxpc1'
*.log_archive_dest_2='location=/oracle/arch_log_hxpc2'
*.log_archive_dest_state_1='enable'
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=true
*.log_buffer=1048576
*.log_checkpoint_interval=1000000
*.max_dump_file_size='2048M'
*.max_enabled_roles=100
*.open_cursors=500
*.parallel_automatic_tuning=FALSE
*.pga_aggregate_target=536870912
*.processes=300
*.query_rewrite_enabled='true'
*.remote_login_passwordfile='EXCLUSIVE'
prod01.remote_login_passwordfile='exclusive'
prod02.remote_login_passwordfile='exclusive'
*.resource_limit=TRUE
*.shared_pool_size=536870912
*.sort_area_size=1048576
prod01.thread=1
prod02.thread=2
*.timed_statistics=TRUE
*.undo_management='AUTO'
1.undo_retention=10800
prod01.undo_retention=10800
prod02.undo_retention=10800
prod01.undo_tablespace='UNDOTBS'
prod02.undo_tablespace='UNDOTBS2'
*.user_dump_dest='/oracle/admin/prod/udump'
*.workarea_size_policy='auto'
/dev/rp_spfile

yu5782647

RMAN-06172: no autobackup found or specified handle is not a valid copy or piece  是不是你的备份里面没有包含控制文件了吗

Maclean Liu(刘相兵

纯看内容 貌似这个文件里只有spfile备份， 没有 控制文件， stings控制文件至少能看到 数据文件名的

Maclean Liu(刘相兵

for example:

[oracle@vrh8 ~]$ strings /s01/oradata/G10R25/controlfile/o1_mf_8nx5thj5_.ctl |less
}|{z
G10R25
T0G10R25
T0G10R25
G10R25
G10R25
/s01/oradata/G10R25/onlinelog/o1_mf_3_8nx5tmft_.log
/s01/flash_recovery_area/G10R25/onlinelog/o1_mf_3_8nx5tmwd_.log
/s01/oradata/G10R25/onlinelog/o1_mf_2_8nx5tl6c_.log
/s01/flash_recovery_area/G10R25/onlinelog/o1_mf_2_8nx5tlf8_.log

liuwenqing

Maclean Liu(刘相兵 发表于 2013-5-15 16:30
for example:

[oracle@vrh8 ~]$ strings /s01/oradata/G10R25/controlfile/o1_mf_8nx5thj5_.ctl |less

看了他的备份脚本，和最终结果没有发现controlfile*的备份文件。
我再看看吧！~

liuwenqing

liuwenqing 发表于 2013-5-15 16:33
看了他的备份脚本，和最终结果没有发现controlfile*的备份文件。
我再看看吧！~ ...

典型的rman迁移 案例

WWJD_DBA

应该是没有把控制文件传过来，下周传过来恢复看看，下面是备份集信息

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
81801   Full    20G        DISK        00:15:43     22-APR-13      
  List of Datafiles in backup set 81801
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 886919853  22-APR-13 /dev/rp_undo0201
  5       Full 886919853  22-APR-13 /dev/rmis_yx
  8       Full 886919853  22-APR-13 /dev/rmis_rl
  10      Full 886919853  22-APR-13 /dev/rmis_aj
  12      Full 886919853  22-APR-13 /dev/rmis_jd
  14      Full 886919853  22-APR-13 /dev/rmis_wz
  16      Full 886919853  22-APR-13 /dev/rmis_songyu
  19      Full 886919853  22-APR-13 /dev/rh_idx_00
  20      Full 886919853  22-APR-13 /dev/rh_rpt_data_00
  22      Full 886919853  22-APR-13 /dev/rh_achv_data_00
  25      Full 886919853  22-APR-13 /dev/rmis_bzgl
  26      Full 886919853  22-APR-13 /dev/rmis_users
  28      Full 886919853  22-APR-13 /dev/rmis_hr2
  29      Full 886919853  22-APR-13 /dev/rmis_bzgl2
  30      Full 886919853  22-APR-13 /dev/rmis_kkx
  32      Full 886919853  22-APR-13 /dev/rmis_bzgl4
  33      Full 886919853  22-APR-13 /dev/rlv_pbos_data
  35      Full 886919853  22-APR-13 /dev/rp_kkx_sbd

  Backup Set Copy #1 of backup set 81801
  Device Type Elapsed Time Completion Time Tag
  ----------- ------------ --------------- ---
  DISK        00:15:43     22-APR-13       TAG20130422T152847

    List of Backup Pieces for backup set 81801 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    81812   1   AVAILABLE   /dmp/backup/database09033do7nolg_1_1.dbf
    81813   2   AVAILABLE   /dmp/backup/database09033do7nolg_2_1.dbf
    81814   3   AVAILABLE   /dmp/backup/database09033do7nolg_3_1.dbf
    81815   4   AVAILABLE   /dmp/backup/database09033do7nolg_4_1.dbf
    81816   5   AVAILABLE   /dmp/backup/database09033do7nolg_5_1.dbf
    81817   6   AVAILABLE   /dmp/backup/database09033do7nolg_6_1.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
81802   Full    11M        DISK        00:00:02     22-APR-13      
        BP Key: 81818   Status: AVAILABLE   Tag:
        Piece Name: /oracle/product/dbs/c-7268713-20130422-2a
  SPFILE Included: Modification time: 13-DEC-10

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
81803   20M        SBT_TAPE    00:02:55     22-APR-13      
        BP Key: 81819   Status: AVAILABLE   Tag: TAG20130422T155032
        Piece Name: al_82032_1_813426632

  List of Archived Logs in backup set 81803
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    56623   886911570  22-APR-13 886916770  22-APR-13
  1    56624   886916770  22-APR-13 886916948  22-APR-13
  1    56625   886916948  22-APR-13 886919824  22-APR-13
  1    56626   886919824  22-APR-13 886926430  22-APR-13
  1    56627   886926430  22-APR-13 886926607  22-APR-13
  2    56580   886911535  22-APR-13 886916756  22-APR-13
  2    56581   886916756  22-APR-13 886916881  22-APR-13
  2    56582   886916881  22-APR-13 886919821  22-APR-13
  2    56583   886919821  22-APR-13 886926433  22-APR-13
  2    56584   886926433  22-APR-13 886926438  22-APR-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
81804   Full    11M        SBT_TAPE    00:00:59     22-APR-13      
        BP Key: 81820   Status: AVAILABLE   Tag:
        Piece Name: c-7268713-20130422-2b
  SPFILE Included: Modification time: 13-DEC-10

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
81805   Full    11M        SBT_TAPE    00:00:53     22-APR-13      
        BP Key: 81821   Status: AVAILABLE   Tag: TAG20130422T155434
        Piece Name: cntrl_82034_1_813426875
  Controlfile Included: Ckp SCN: 886927247    Ckp time: 22-APR-13
需要cntrl_82034_1_813426875这个文件，但是从c-7268713-20130422-2a这个文件里面为什么也不能恢复参数文件呢？已经设置了和原环境一样的DBID，恢复的时候还是报错

RMAN> restore controlfile from '/dmp/backup/c-7268713-20130422-2a';

Starting restore at 18-MAY-13

using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/18/2013 09:16:15
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece