当前位置:  数据库>oracle

Oracle 11g新版本增加对原始数据文件验证过程

    来源: 互联网  发布时间:2017-06-02

    本文导语: 打算做一个Oracle索引的专题技术笔记,因为今天帮我一个深圳的朋友做过rman的测试,在 恢复我原始数据的时候,发现存在ORA-XXXXX错误,测试结果如下:   run { allocate channel ch1 type disk; allocate channel ch2 type disk; allocate channel ch3 t...

打算做一个Oracle索引的专题技术笔记,因为今天帮我一个深圳的朋友做过rman的测试,在 恢复我原始数据的时候,发现存在ORA-XXXXX错误,测试结果如下:
 
 run {
 allocate channel ch1 type disk;
 allocate channel ch2 type disk;
 allocate channel ch3 type disk;
 allocate channel ch4 type disk;
 allocate channel ch5 type disk;
 allocate channel ch6 type disk;
 restore database;
 release channel ch1;
 release channel ch2;
 release channel ch3;
 release channel ch4;
 release channel ch5; 
release channel ch6;
 }
 备份过程:
 oracle@oracle-one ~]$ exit
 exit
 host command complete
 
RMAN> backup database plus archivelog delete input;
 

Starting backup at 13-JAN-14
 current log archived
 using channel ORA_DISK_1
 channel ORA_DISK_1: starting archived log backup set
 channel ORA_DISK_1: specifying archived log(s) in backup set
 input archived log thread=1 sequence=32 RECID=38 STAMP=835887568
 input archived log thread=1 sequence=33 RECID=43 STAMP=835983664
 input archived log thread=1 sequence=34 RECID=41 STAMP=835983651
 input archived log thread=1 sequence=35 RECID=42 STAMP=835983661
 channel ORA_DISK_1: starting piece 1 at 13-JAN-14
 channel ORA_DISK_1: finished piece 1 at 13-JAN-14
 piece handle=+DATAGROUP1/rhys/backupset/2014_01_13/annnf0_tag20140113t100050_0.302.836733655 tag=TAG20140113T100050 comment=NONE
 channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
 channel ORA_DISK_1: deleting archived log(s)
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_03/thread_1_seq_32.312.835887567 RECID=38 STAMP=835887568
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_04/thread_1_seq_33.310.835983663 RECID=43 STAMP=835983664
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_04/thread_1_seq_34.282.835983651 RECID=41 STAMP=835983651
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_04/thread_1_seq_35.297.835983653 RECID=42 STAMP=835983661
 channel ORA_DISK_1: starting archived log backup set
 channel ORA_DISK_1: specifying archived log(s) in backup set
 input archived log thread=1 sequence=1 RECID=44 STAMP=836132585
 input archived log thread=1 sequence=2 RECID=45 STAMP=836165566
 input archived log thread=1 sequence=3 RECID=46 STAMP=836176676
 input archived log thread=1 sequence=4 RECID=47 STAMP=836178950
 input archived log thread=1 sequence=5 RECID=48 STAMP=836232017
 input archived log thread=1 sequence=6 RECID=49 STAMP=836234531
 input archived log thread=1 sequence=7 RECID=50 STAMP=836237972
 input archived log thread=1 sequence=8 RECID=51 STAMP=836256318
 input archived log thread=1 sequence=9 RECID=52 STAMP=836299719
 input archived log thread=1 sequence=10 RECID=53 STAMP=836337512
 input archived log thread=1 sequence=11 RECID=54 STAMP=836494626
 input archived log thread=1 sequence=12 RECID=55 STAMP=836498150
 input archived log thread=1 sequence=13 RECID=56 STAMP=836731893
 input archived log thread=1 sequence=14 RECID=57 STAMP=836733316
 input archived log thread=1 sequence=15 RECID=58 STAMP=836733649
 channel ORA_DISK_1: starting piece 1 at 13-JAN-14
 channel ORA_DISK_1: finished piece 1 at 13-JAN-14
 piece handle=+DATAGROUP1/rhys/backupset/2014_01_13/annnf0_tag20140113t100050_0.297.836733683 tag=TAG20140113T100050 comment=NONE
 channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
 channel ORA_DISK_1: deleting archived log(s)
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_06/thread_1_seq_1.313.836132583 RECID=44 STAMP=836132585
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_06/thread_1_seq_2.314.836165563 RECID=45 STAMP=836165566
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_06/thread_1_seq_3.315.836176677 RECID=46 STAMP=836176676
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_06/thread_1_seq_4.273.836178949 RECID=47 STAMP=836178950
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_07/thread_1_seq_5.280.836232005 RECID=48 STAMP=836232017
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_07/thread_1_seq_6.278.836234531 RECID=49 STAMP=836234531
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_07/thread_1_seq_7.277.836237959 RECID=50 STAMP=836237972
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_07/thread_1_seq_8.272.836256311 RECID=51 STAMP=836256318
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_08/thread_1_seq_9.271.836299715 RECID=52 STAMP=836299719
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_08/thread_1_seq_10.308.836337507 RECID=53 STAMP=836337512
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_10/thread_1_seq_11.307.836494623 RECID=54 STAMP=836494626
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_10/thread_1_seq_12.306.836498149 RECID=55 STAMP=836498150
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_13.304.836731889 RECID=56 STAMP=836731893
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_14.305.836733317 RECID=57 STAMP=836733316
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_15.303.836733649 RECID=58 STAMP=836733649
 Finished backup at 13-JAN-14
 
Starting backup at 13-JAN-14
 using channel ORA_DISK_1
 channel ORA_DISK_1: starting full datafile backup set
 channel ORA_DISK_1: specifying datafile(s) in backup set
 input datafile file number=00001 name=+DATAGROUP1/rhys/datafile/system.257.833999503
 input datafile file number=00002 name=+DATAGROUP1/rhys/datafile/sysaux.256.833999647
 input datafile file number=00006 name=+DATAGROUP1/rhys/datafile/rhys.309.835132099
 input datafile file number=00004 name=+DATAGROUP1/rhys/datafile/users.261.833999767
 input datafile file number=00003 name=+DATAGROUP1/rhys/datafile/undotbs1.260.833999753
 input datafile file number=00005 name=+DATAGROUP1/rhys/datafile/test.dbf
 channel ORA_DISK_1: starting piece 1 at 13-JAN-14
 channel ORA_DISK_1: finished piece 1 at 13-JAN-14
 piece handle=+DATAGROUP1/rhys/backupset/2014_01_13/nnndf0_tag20140113t100212_0.303.836733737 tag=TAG20140113T100212 comment=NONE
 channel ORA_DISK_1: backup set complete, elapsed time: 00:06:26
 Finished backup at 13-JAN-14
 
Starting backup at 13-JAN-14
 current log archived
 using channel ORA_DISK_1
 channel ORA_DISK_1: starting archived log backup set
 channel ORA_DISK_1: specifying archived log(s) in backup set
 input archived log thread=1 sequence=16 RECID=59 STAMP=836734121
 channel ORA_DISK_1: starting piece 1 at 13-JAN-14
 channel ORA_DISK_1: finished piece 1 at 13-JAN-14
 piece handle=+DATAGROUP1/rhys/backupset/2014_01_13/annnf0_tag20140113t100843_0.274.836734125 tag=TAG20140113T100843 comment=NONE
 channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
 channel ORA_DISK_1: deleting archived log(s)
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_16.276.836734121 RECID=59 STAMP=836734121
 Finished backup at 13-JAN-14
 
Starting Control File and SPFILE Autobackup at 13-JAN-14
 piece handle=+DATAGROUP1/rhys/autobackup/2014_01_13/s_836734128.276.836734133 comment=NONE
 Finished Control File and SPFILE Autobackup at 13-JAN-14
 
RMAN> exit
 

Recovery Manager complete.
 恢复过程:
 [oracle@oracle-one ~]$ rman target /
 
Recovery Manager: Release 11.2.0.4.0 - Production on Mon Jan 13 20:41:18 2014
 
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
 
connected to target database: RHYS (DBID=2745484551, not open)
 
RMAN> run {
 2> allocate channel ch1 type disk;
 allocate channel ch2 type disk;
 3> 4> allocate channel ch3 type disk;
 5> allocate channel ch4 type disk;
 6> allocate channel ch5 type disk;
 7> allocate channel ch6 type disk;
 8> restore database;
 9> release channel ch1;
 10> release channel ch2;
 11> release channel ch3;
 12> release channel ch4;
 13> release channel ch5; 
14> release channel ch6;
 15> }
 
using target database control file instead of recovery catalog
 allocated channel: ch1
 channel ch1: SID=30 device type=DISK
 
allocated channel: ch2
 channel ch2: SID=29 device type=DISK
 
allocated channel: ch3
 channel ch3: SID=21 device type=DISK
 
allocated channel: ch4
 channel ch4: SID=28 device type=DISK
 
allocated channel: ch5
 channel ch5: SID=24 device type=DISK
 
allocated channel: ch6
 channel ch6: SID=23 device type=DISK
 
Starting restore at 13-JAN-14
 
channel ch1: restoring datafile 00001
 input datafile copy RECID=9 STAMP=836771958 file name=+DATAGROUP1/rhys/datafile/system.311.836735137
 destination for restore of datafile 00001: +DATAGROUP1/rhys/datafile/system.257.833999503
 channel ch2: starting datafile backup set restore
 channel ch2: specifying datafile(s) to restore from backup set
 channel ch2: restoring datafile 00004 to +DATAGROUP1/rhys/datafile/users.283.836771979
 channel ch2: restoring datafile 00005 to +DATAGROUP1/rhys/datafile/test.dbf
 channel ch2: restoring datafile 00006 to +DATAGROUP1/rhys/datafile/rhys.304.836771979
 channel ch2: reading from backup piece +DATAGROUP1/rhys/backupset/2014_01_13/nnndf0_tag20140113t100212_0.303.836733737
 channel ch3: restoring datafile 00002
 input datafile copy RECID=10 STAMP=836771958 file name=+DATAGROUP1/rhys/datafile/sysaux.279.836735137
 destination for restore of datafile 00002: +DATAGROUP1/rhys/datafile/sysaux.256.833999647
 channel ch4: restoring datafile 00003
 input datafile copy RECID=11 STAMP=836771958 file name=+DATAGROUP1/rhys/datafile/undotbs1.257.836735137
 destination for restore of datafile 00003: +DATAGROUP1/rhys/datafile/undotbs1.308.836771963
 ORA-19505: failed to identify file "+DATAGROUP1/rhys/datafile/system.311.836735137"
 ORA-17503: ksfdopn:2 Failed to open file +DATAGROUP1/rhys/datafile/system.311.836735137
 ORA-15012: ASM file '+DATAGROUP1/rhys/datafile/system.311.836735137' does not exist
 ORA-19600: input file is datafile-copy 9 (+DATAGROUP1/rhys/datafile/system.311.836735137)
 ORA-19601: output file is datafile 1 (+DATAGROUP1)
 
ORA-19505: failed to identify file "+DATAGROUP1/rhys/datafile/sysaux.279.836735137"
 ORA-17503: ksfdopn:2 Failed to open file +DATAGROUP1/rhys/datafile/sysaux.279.836735137
 ORA-15012: ASM file '+DATAGROUP1/rhys/datafile/sysaux.279.836735137' does not exist
 ORA-19600: input file is datafile-copy 10 (+DATAGROUP1/rhys/datafile/sysaux.279.836735137)
 ORA-19601: output file is datafile 2 (+DATAGROUP1)
 
ORA-19505: failed to identify file "+DATAGROUP1/rhys/datafile/undotbs1.257.836735137"
 ORA-17503: ksfdopn:2 Failed to open file +DATAGROUP1/rhys/datafile/undotbs1.257.836735137
 ORA-15012: ASM file '+DATAGROUP1/rhys/datafile/undotbs1.257.836735137' does not exist
 ORA-19600: input file is datafile-copy 11 (+DATAGROUP1/rhys/datafile/undotbs1.257.836735137)
 ORA-19601: output file is datafile 3 (+DATAGROUP1)
 
 
 
 
 
channel ch2: piece handle=+DATAGROUP1/rhys/backupset/2014_01_13/nnndf0_tag20140113t100212_0.303.836733737 tag=TAG20140113T100212
 channel ch2: restored backup piece 1
 channel ch2: restore complete, elapsed time: 00:00:35
 failover to previous backup
 
channel ch1: starting datafile backup set restore
 channel ch1: specifying datafile(s) to restore from backup set
 channel ch1: restoring datafile 00001 to +DATAGROUP1/rhys/datafile/system.257.833999503
 channel ch1: restoring datafile 00002 to +DATAGROUP1/rhys/datafile/sysaux.256.833999647
 channel ch1: restoring datafile 00003 to +DATAGROUP1/rhys/datafile/undotbs1.308.836771963
 channel ch1: reading from backup piece +DATAGROUP1/rhys/backupset/2014_01_13/nnndf0_tag20140113t100212_0.303.836733737
 channel ch1: piece handle=+DATAGROUP1/rhys/backupset/2014_01_13/nnndf0_tag20140113t100212_0.303.836733737 tag=TAG20140113T100212
 channel ch1: restored backup piece 1
 channel ch1: restore complete, elapsed time: 00:03:25
 Finished restore at 13-JAN-14
 
released channel: ch1
 
released channel: ch2
 
released channel: ch3
 
released channel: ch4
 
released channel: ch5
 
released channel: ch6
 
RMAN>
RMAN>
RMAN>
RMAN>
RMAN> recover database;
 
Starting recover at 13-JAN-14
 allocated channel: ORA_DISK_1
 channel ORA_DISK_1: SID=30 device type=DISK
 
starting media recovery
 
archived log for thread 1 with sequence 16 is already on disk as file +DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_16.275.836735655
 archived log for thread 1 with sequence 17 is already on disk as file +DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_17.260.836735657
 archived log for thread 1 with sequence 18 is already on disk as file +DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_18.261.836735659
 archived log for thread 1 with sequence 1 is already on disk as file +DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_1.305.836751051
 archived log for thread 1 with sequence 2 is already on disk as file +DATAGROUP1/rhys/onlinelog/group_2.286.833999961
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_16.275.836735655 thread=1 sequence=16
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_17.260.836735657 thread=1 sequence=17
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_18.261.836735659 thread=1 sequence=18
 archived log file name=+DATAGROUP1/rhys/archivelog/2014_01_13/thread_1_seq_1.305.836751051 thread=1 sequence=1
 archived log file name=+DATAGROUP1/rhys/onlinelog/group_2.286.833999961 thread=1 sequence=2
 media recovery complete, elapsed time: 00:00:59
 Finished recover at 13-JAN-14
 
RMAN> exit
 

Recovery Manager complete.
 [oracle@oracle-one ~]$ sqlplus / as sysdba
 
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 13 20:48:36 2014
 
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
 

Connected to:
 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
 With the Partitioning, Automatic Storage Management, OLAP, Data Mining
 and Real Application Testing options
 
SQL> alter database open;
 alter database open
 *
 ERROR at line 1:
 ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
 

SQL> alter database open resetlogs;
 
Database altered.
 
SQL>
总结:在11G新版本中增加了对原始数据文件的验证过程。


    
 
 
 
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • oracle增加表空间大小两种实现方法
  • 在linux下装oracle9i到了最后时候,提示/tmp空间不够了,怎么增加,谢谢!
  • 为Oracle增加计划任务
  • oracle删除表字段和oracle表增加字段
  • 采用容器管理的实体bean,如何处理oracle数据库自动增加的编号?
  • oracle使用sql语句增加字段示例(sql删除字段语句)
  • Oracle 12c发布简单介绍及官方下载地址
  • 在linux下安装oracle,如何设置让oracle自动启动!也就是让oracle那个服务自动启动,不是手动的
  • Oracle 数据库(oracle Database)Select 多表关联查询方式
  • 请问su oracle 和su - oracle有什么不同?
  • Oracle数据库(Oracle Database)体系结构及基本组成介绍
  • 虚拟机装Oracle R12与Oracle10g
  • 如何设置让Oracle SQL Developer显示的时间包含时分秒
  • java/j2ee iis7站长之家
  • Oracle 10g和Oracle 11g网格技术介绍
  • Oracle EBS R12 支持 Oracle Database 11g
  • oracle中如何把表中具有相同值列的多行数据合并成一行
  • SCO unix下安装oracle,但没有光盘,请大家推荐一个oracle下载站点(unix版本的)。谢谢!!!!
  • Oracle 数据库(oracle Database)性能调优技术详解
  • 请问大家用oracle数据库, 用import oracle.*;下的东西么? 还是用标准库?
  • ORACLE日期相关操作
  • Linux /$ORACLE_HOME $ORACLE_HOME
  • ORACLE数据库常用字段数据类型介绍
  • Linux系统下Oracle的启动与Oracle监听的启动
  • Oracle 12c的九大最新技术特性介绍
  • 请问在solaris下安装ORACLE,用root用户和用oracle用户安装有什么区别么?
  • ORACLE中DBMS_RANDOM随机数生成包
  • 网间Oracle的连接,远程连接Oracle服务器??


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,