用10.2.0.1RMAN全备恢复10.2.0.4数据库,通过RESTOREBACKUPPIECE,APPLYBACKUPPIECE解决
1.升级备份服务器的数据库到10.2.0.4
2.通过FTP把生产数据库(10.2.0.1 RAC)的RMAN的full backupset全部copy 到备份数据库上。
3.rman target / nocatalog
4.startup nomount
5.restore controlfile from 'file_path';(从生产库考过来那个控制文件的backupset);
6.检查RMAN的配置信息:
$ rman target / nocatalog
Recovery Manager: Release 10.2.0.4.0 - Production on Fri Jun 20 16:45:40 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: BAAN (DBID=3872779959, not open)
using target database control file instead of recovery catalog
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/RAC_BACKUP/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/RAC_BACKUP/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/ora/app/oracle/oracle/product/10.2.0/db_1/dbs/snapcf_baan.f'; # default
读取控制文件中的备份信息:
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
723 B 1 X DISK 16-MAR-08 1 1 NO TAG20080316T025005
724 B 1 X DISK 16-MAR-08 1 1 NO TAG20080316T030314
725 B F X DISK 16-MAR-08 1 1 NO TAG20080316T032332
726 B 0 X DISK 16-MAR-08 13 1 NO TAG20080316T025006
727 B 0 X DISK 16-MAR-08 4 1 NO TAG20080316T025006
728 B 0 X DISK 16-MAR-08 22 1 NO TAG20080316T025006
729 B F X DISK 16-MAR-08 1 1 NO TAG20080316T040123
730 B 1 X DISK 17-MAR-08 1 1 NO TAG20080317T025003
731 B 1 X DISK 17-MAR-08 1 1 NO TAG20080317T025710
732 B F X DISK 17-MAR-08 1 1 NO TAG20080317T030857
733 B 1 X DISK 18-MAR-08 1 1 NO TAG20080318T025004
734 B 1 X DISK 18-MAR-08 1 1 NO TAG20080318T025722
735 B F X DISK 18-MAR-08 1 1 NO TAG20080318T030908
736 B 1 X DISK 19-MAR-08 1 1 NO TAG20080319T025005
737 B 1 X DISK 19-MAR-08 1 1 NO TAG20080319T025722
738 B F X DISK 19-MAR-08 1 1 NO TAG20080319T030909
739 B 1 X DISK 20-MAR-08 1 1 NO TAG20080320T025005
740 B 1 X DISK 20-MAR-08 1 1 NO TAG20080320T025722
741 B F X DISK 20-MAR-08 1 1 NO TAG20080320T030909
742 B 1 X DISK 21-MAR-08 1 1 NO TAG20080321T025004
743 B 1 X DISK 21-MAR-08 1 1 NO TAG20080321T025722
744 B F X DISK 21-MAR-08 1 1 NO TAG20080321T030908
745 B A X DISK 21-MAR-08 1 1 NO TAG20080321T140135
746 B A X DISK 21-MAR-08 1 1 NO TAG20080321T140135
747 B A X DISK 21-MAR-08 1 1 NO TAG20080321T140135
748 B A A DISK 21-MAR-08 1 1 NO TAG20080321T140135
749 B A A DISK 21-MAR-08 1 1 NO TAG20080321T140135
750 B A A DISK 21-MAR-08 1 1 NO TAG20080321T140135
751 B A A DISK 21-MAR-08 1 1 NO TAG20080321T140135
752 B F A DISK 21-MAR-08 1 1 NO TAG20080321T142855
753 B A A DISK 21-MAR-08 1 1 NO TAG20080321T145058
754 B A A DISK 21-MAR-08 1 1 NO TAG20080321T145058
755 B A A DISK 21-MAR-08 1 1 NO TAG20080321T145058
756 B F A DISK 21-MAR-08 1 1 NO TAG20080321T145104
757 B A A DISK 21-MAR-08 1 1 NO TAG20080321T145751
758 B A A DISK 21-MAR-08 1 1 NO TAG20080321T145751
759 B A A DISK 21-MAR-08 1 1 NO TAG20080321T145751
760 B A A DISK 21-MAR-08 1 1 NO TAG20080321T145751
761 B A A DISK 21-MAR-08 1 1 NO TAG20080321T145751
762 B A A DISK 21-MAR-08 1 1 NO TAG20080321T145751
763 B F A DISK 21-MAR-08 1 1 NO TAG20080321T152424
764 B 1 A DISK 22-MAR-08 1 1 NO TAG20080322T025005
765 B 1 A DISK 22-MAR-08 1 1 NO TAG20080322T025722
766 B F A DISK 22-MAR-08 1 1 NO TAG20080322T030909
767 B 1 A DISK 23-MAR-08 1 1 NO TAG20080323T025005
768 B 1 A DISK 23-MAR-08 1 1 NO TAG20080323T025712
769 B F A DISK 23-MAR-08 1 1 NO TAG20080323T030859
770 B 1 A DISK 24-MAR-08 1 1 NO TAG20080324T025004
771 B 1 A DISK 24-MAR-08 1 1 NO TAG20080324T025711
772 B F A DISK 24-MAR-08 1 1 NO TAG20080324T030907
773 B 1 A DISK 25-MAR-08 1 1 NO TAG20080325T025005
774 B 1 A DISK 25-MAR-08 1 1 NO TAG20080325T025722
775 B F A DISK 25-MAR-08 1 1 NO TAG20080325T030909
776 B 1 A DISK 26-MAR-08 1 1 NO TAG20080326T025005
777 B 1 A DISK 26-MAR-08 1 1 NO TAG20080326T025733
778 B F A DISK 26-MAR-08 1 1 NO TAG20080326T030929
779 B 1 A DISK 27-MAR-08 1 1 NO TAG20080327T025006
780 B 1 A DISK 27-MAR-08 1 1 NO TAG20080327T025733
781 B F A DISK 27-MAR-08 1 1 NO TAG20080327T030930
782 B 1 A DISK 28-MAR-08 1 1 NO TAG20080328T025005
783 B 1 A DISK 28-MAR-08 1 1 NO TAG20080328T025723
784 B F A DISK 28-MAR-08 1 1 NO TAG20080328T030909
785 B 1 A DISK 29-MAR-08 1 1 NO TAG20080329T025006
786 B 1 A DISK 29-MAR-08 1 1 NO TAG20080329T025724
787 B F A DISK 29-MAR-08 1 1 NO TAG20080329T030911
788 B 1 A DISK 30-MAR-08 1 1 NO TAG20080330T025005
789 B 1 A DISK 30-MAR-08 1 1 NO TAG20080330T025722
790 B F A DISK 30-MAR-08 1 1 NO TAG20080330T030919
791 B 1 A DISK 31-MAR-08 1 1 NO TAG20080331T025003
792 B 1 A DISK 31-MAR-08 1 1 NO TAG20080331T025730
793 B F A DISK 31-MAR-08 1 1 NO TAG20080331T030927
794 B 1 A DISK 01-APR-08 1 1 NO TAG20080401T025006
795 B 1 A DISK 01-APR-08 1 1 NO TAG20080401T025724
796 B F A DISK 01-APR-08 1 1 NO TAG20080401T030921
797 B 1 A DISK 02-APR-08 1 1 NO TAG20080402T025005
798 B 1 A DISK 02-APR-08 1 1 NO TAG20080402T025722
799 B F A DISK 02-APR-08 1 1 NO TAG20080402T030909
800 B 1 A DISK 03-APR-08 1 1 NO TAG20080403T025005
801 B 1 A DISK 03-APR-08 1 1 NO TAG20080403T025712
802 B F A DISK 03-APR-08 1 1 NO TAG20080403T030859
803 B 1 A DISK 04-APR-08 1 1 NO TAG20080404T025006
804 B 1 A DISK 04-APR-08 1 1 NO TAG20080404T025723
805 B F A DISK 04-APR-08 1 1 NO TAG20080404T030910
806 B 1 A DISK 05-APR-08 1 1 NO TAG20080405T025005
807 B 1 A DISK 05-APR-08 1 1 NO TAG20080405T025712
808 B F A DISK 05-APR-08 1 1 NO TAG20080405T030859
809 B 1 A DISK 06-APR-08 1 1 NO TAG20080406T025004
810 B 1 A DISK 06-APR-08 1 1 NO TAG20080406T025711
811 B F A DISK 06-APR-08 1 1 NO TAG20080406T030858
812 B 1 A DISK 07-APR-08 1 1 NO TAG20080407T025003
813 B 1 A DISK 07-APR-08 1 1 NO TAG20080407T025721
814 B F A DISK 07-APR-08 1 1 NO TAG20080407T030917
815 B 1 A DISK 08-APR-08 1 1 NO TAG20080408T025006
816 B 1 A DISK 08-APR-08 1 1 NO TAG20080408T025723
817 B F A DISK 08-APR-08 1 1 NO TAG20080408T030909
818 B 1 A DISK 09-APR-08 1 1 NO TAG20080409T025006
819 B 1 A DISK 09-APR-08 1 1 NO TAG20080409T025723
820 B F A DISK 09-APR-08 1 1 NO TAG20080409T030910
821 B 1 A DISK 10-APR-08 1 1 NO TAG20080410T025005
822 B 1 A DISK 10-APR-08 1 1 NO TAG20080410T025722
823 B F A DISK 10-APR-08 1 1 NO TAG20080410T030909
824 B 1 A DISK 11-APR-08 1 1 NO TAG20080411T025005
825 B 1 A DISK 11-APR-08 1 1 NO TAG20080411T025723
826 B F A DISK 11-APR-08 1 1 NO TAG20080411T030920
827 B 1 A DISK 12-APR-08 1 1 NO TAG20080412T025005
828 B 1 A DISK 12-APR-08 1 1 NO TAG20080412T025723
829 B F A DISK 12-APR-08 1 1 NO TAG20080412T030919
830 B 1 A DISK 13-APR-08 1 1 NO TAG20080413T025005
831 B 1 A DISK 13-APR-08 1 1 NO TAG20080413T025722
832 B F A DISK 13-APR-08 1 1 NO TAG20080413T030909
833 B 1 A DISK 14-APR-08 1 1 NO TAG20080414T025004
834 B 1 A DISK 14-APR-08 1 1 NO TAG20080414T025721
835 B F A DISK 14-APR-08 1 1 NO TAG20080414T030908
836 B 1 A DISK 15-APR-08 1 1 NO TAG20080415T025005
837 B 1 A DISK 15-APR-08 1 1 NO TAG20080415T025723
838 B F A DISK 15-APR-08 1 1 NO TAG20080415T030919
839 B 0 A DISK 16-APR-08 13 1 NO TAG20080416T025006
840 B 0 A DISK 16-APR-08 4 1 NO TAG20080416T025006
841 B 0 A DISK 16-APR-08 22 1 NO TAG20080416T025006
尝试还原backupset 到新的datafile 位置
RMAN> run
2> {
3> set newname for datafile 1 to '/RAC_BACKUP/baan/system01.dbf';
4> set newname for datafile 2 to '/RAC_BACKUP/baan/undotbs1.dbf';
5> set newname for datafile 3 to '/RAC_BACKUP/baan/sysaux.dbf';
6> set newname for datafile 4 to '/RAC_BACKUP/baan/undotbs2.dbf';
7> set newname for datafile 5 to '/RAC_BACKUP/baan/users.dbf';
8> set newname for datafile 6 to '/RAC_BACKUP/baan/baanidx.dbf';
9> set newname for datafile 7 to '/RAC_BACKUP/baan/baandb.dbf';
10> set newname for datafile 8 to '/RAC_BACKUP/baan/statspack.dbf';
11> set newname for datafile 9 to '/RAC_BACKUP/baan/system02.dbf';
12> restore database;
13> }
出现ora-600错误,查看trace文件,出现异步IO的问题
ora/app/oracle/admin/baan/udump/baan_ora_8175.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /ora/app/oracle/oracle/product/10.2.0/db_1
System name: HP-UX
Node name: astronhp
Release: B.11.23
Version: U
Machine: ia64
Instance name: baan
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 8175, image: [email=oracle@astronhp]oracle@astronhp[/email]
Ioctl ASYNC_CONFIG error, errno = 1
*** ACTION NAME
0000064 STARTED62) 2008-06-20 18:12:07.885
*** MODULE NAME
[email=rman@astronhp]rman@astronhp[/email] (TNS V1-V3)) 2008-06-20 18:12:07.885
*** SERVICE NAME
) 2008-06-20 18:12:07.885
*** SESSION ID
1971.17) 2008-06-20 18:12:07.885
*** 2008-06-20 18:12:07.885
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []
查看metalink,按metalink的说法解决这个异步IO的问题,但是这个ora-600错误还存在:
主题: How to disable asynch_io on HP to avoid Ioctl Async_config Error Errno = 1
文档 ID: 注释:302801.1 类型: HOWTO
上次修订日期: 21-FEB-2008 状态: PUBLISHED
In this Document
Goal
Solution
References
--------------------------------------------------------------------------------
Applies to:
Oracle Server - Enterprise Edition - Version:
HP-UX Itanium
HP-UX PA-RISC (64-bit)
Goal
How to disable async_io on Oracle in HP-UX to avoid this message in trace file:
Ioctl ASYNC_CONFIG error, errno = 1
Solution
Oracle (for HP only) always uses async I/O regardless of the value of init settings
(disk_asynch_io=FALSE and filesystemio_options=none).
The parameter filesystemio_options=none doesn't work.
Oracle always opens /dev/async successfully only if the /dev/async HP-UX
device driver is properly configured for read and write. This is irrespective
of whether the DISK_ASYNC_IO parm is set to TRUE.
In 9.2 version, to inactivate ASYNCH_IO with Oracle , workaround is:
chown bin:bin /dev/async
chmod 660 /dev/async
Note:
This may impact other applications that wish to use asynch I/O
Grant dba group the MLOCK priv to avoid the Ioctl ASYNC_CONFIG trace file errors:
(1) # /usr/sbin/setprivgrp dba MLOCK
(2) # vi /etc/privgroup
This should contain dba MLOCK RTSCHED RTPRIO
(3) # cat /etc/privgroup
dba MLOCK RTSCHED RTPRIO
Starting with Oracle 10.2, these settings will stop the tracing:
disk_asynch_io=FALSE
filesystemio_options=none
# setprivgrp dba MLOCK
# vi /etc/privgroup
"/etc/privgroup" [New file]
dba MLOCK RTSCHED RTPRIO
# ls |grep as
async
asyncdsk
# ll |grep as
crw-rw-rw- 1 bin bin 101 0x000000 May 31 2007 async
crw-rw-rw- 1 bin bin 101 0x000000 May 31 2007 asyncdsk
在trace文件中看到这样的信息: c-3872779959-20080321-00 是从RAC那边考过来的rman备份的控制文件
Repeat 101 times
6000000000031BF0 00000002 02000000 0B6B6765 6164655F [.........kgeade_]
6000000000031C00 69735F30 2F632D33 38373237 37393935 [is_0/ c-387277995]
6000000000031C10 392D3230 30383033 32312D30 30000000 [ 9-20080321-00...]
6000000000031C20 00000000 00000000 00000000 00000000 [................]
Repeat 98 times
6000000000031BF0 00000002 02000000 0B6B6765 6164655F [.........kgeade_]
6000000000031C00 69735F30 5F424143 4B55505F 52455354 [is_0_BACKUP_REST]
6000000000031C10 4F524522 2C200100 00000433 31383002 [ORE", .....3180.]
6000000000031C20 0000001D 22535953 2E582444 424D535F [...."SYS.X$DBMS_]
6000000000031C30 4241434B 55505F52 4553544F 5245222C [BACKUP_RESTORE",]
6000000000031C40 20010000 00043332 30340200 00000B6B [ .....3204.....k]
6000000000031C50 67656164 655F6973 5F302F63 2D333837 [geade_is_0/c-387]
6000000000031C60 32373739 3935392D 32303038 30333231 [2779959-20080321]
6000000000031C70 2D303000 00000000 00000000 00000000 [-00.............]
6000000000031C80 00000000 00000000 00000000 00000000 [................]
开始改重做日志路径,虽然报了ora-600错误,但是路径还是修改成功了
SQL> alter database rename file '+MYASM/baan/onlinelog/group_1.280.628807911' to
2 '/ora/app/oracle/oradata/baan/redo1a.log';
alter database rename file '+MYASM/baan/onlinelog/group_1.280.628807911' to
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []
QL> select * from v$logfile order by group#;
rows will be truncated
GROUP# STATUS TYPE MEMBER
---------- ------- ------- -------------------------------------------------------------------------
1 ONLINE /ora/app/oracle/oradata/baan/redo1a.log
1 ONLINE +MYASM/baan/onlinelog/group_1.284.628809135
2 ONLINE +MYASM/baan/onlinelog/group_2.283.628808345
2 ONLINE +MYASM/baan/onlinelog/group_2.281.628807931
3 ONLINE +MYASM/baan/onlinelog/group_3.268.628808793
3 ONLINE +MYASM/baan/onlinelog/group_3.285.628809157
4 ONLINE +MYASM/baan/onlinelog/group_4.264.628808849
4 ONLINE +MYASM/baan/onlinelog/group_4.286.628809181
5 ONLINE +MYASM/baan/onlinelog/group_5.287.628809201
5 ONLINE +MYASM/baan/onlinelog/group_5.282.628808889
7 ONLINE +MYASM/baan/onlinelog/group_7.288.628809251
GROUP# STATUS TYPE MEMBER
---------- ------- ------- -------------------------------------------------------------------------
7 ONLINE +MYASM/baan/onlinelog/log7.ora
8 ONLINE +MYASM/baan/onlinelog/log8.ora
8 ONLINE +MYASM/baan/onlinelog/group_8.289.628809271
9 ONLINE +MYASM/baan/onlinelog/group_9.290.628808517
9 ONLINE +MYASM/baan/onlinelog/log9.ora
10 ONLINE +MYASM/baan/onlinelog/log10.ora
10 ONLINE +MYASM/baan/onlinelog/group_10.291.628809285
11 ONLINE +MYASM/baan/onlinelog/group_11.292.628809315
11 ONLINE +MYASM/baan/onlinelog/log11.ora
20 rows selected.
在rman中做crosscheck的时候,出现下面的错误:
/ora/app/oracle/admin/baan/bdump/baan_dbw0_27403.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /ora/app/oracle/oracle/product/10.2.0/db_1
System name: HP-UX
Node name: astronhp
Release: B.11.23
Version: U
Machine: ia64
Instance name: baan
Redo thread mounted by this instance: 1
Oracle process number: 5
Unix process pid: 27403, image: [email=oracle@astronhp]oracle@astronhp[/email] (DBW0)
*** 2008-06-23 09:58:37.835
*** SERVICE NAME
) 2008-06-23 09:58:37.835
*** SESSION ID
1982.1) 2008-06-23 09:58:37.835
2008-06-23 09:58:37.835: [ OCROSD]utgdv:2
cr loc file cannot be opened
2008-06-23 09:58:37.835: [ OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2008-06-23 09:58:37.836: [ OCRRAW]proprinit: Could not open raw device
2008-06-23 09:58:37.836: [ default]a_init:7!: Backend init unsuccessful : [33]
2008-06-23 09:58:37.836: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-01157: Message 1157 not found; No message file for product=RDBMS, facility=ORA; arguments: [1]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [+MYASM/baan
/datafile/system.266.592727231]
ORA-17503: Message 17503 not found; No message file for product=RDBMS, facility=ORA; arguments: [2] [+MYASM/baa
n/datafile/system.266.592727231]
ORA-15001: Message 15001 not found; No message file for product=RDBMS, facility=ORA; arguments: [MYASM]
ORA-15077: Message 15077 not found; No message file for product=RDBMS, facility=ORA
ORA-29701: Message 29701 not found; No message file for product=RDBMS, facility=ORA
2008-06-23 09:58:37.838: [ OCROSD]utgdv:2
cr loc file cannot be opened
2008-06-23 09:58:37.838: [ OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2.通过FTP把生产数据库(10.2.0.1 RAC)的RMAN的full backupset全部copy 到备份数据库上。
3.rman target / nocatalog
4.startup nomount
5.restore controlfile from 'file_path';(从生产库考过来那个控制文件的backupset);
6.检查RMAN的配置信息:
$ rman target / nocatalog
Recovery Manager: Release 10.2.0.4.0 - Production on Fri Jun 20 16:45:40 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: BAAN (DBID=3872779959, not open)
using target database control file instead of recovery catalog
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/RAC_BACKUP/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/RAC_BACKUP/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/ora/app/oracle/oracle/product/10.2.0/db_1/dbs/snapcf_baan.f'; # default
读取控制文件中的备份信息:
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
723 B 1 X DISK 16-MAR-08 1 1 NO TAG20080316T025005
724 B 1 X DISK 16-MAR-08 1 1 NO TAG20080316T030314
725 B F X DISK 16-MAR-08 1 1 NO TAG20080316T032332
726 B 0 X DISK 16-MAR-08 13 1 NO TAG20080316T025006
727 B 0 X DISK 16-MAR-08 4 1 NO TAG20080316T025006
728 B 0 X DISK 16-MAR-08 22 1 NO TAG20080316T025006
729 B F X DISK 16-MAR-08 1 1 NO TAG20080316T040123
730 B 1 X DISK 17-MAR-08 1 1 NO TAG20080317T025003
731 B 1 X DISK 17-MAR-08 1 1 NO TAG20080317T025710
732 B F X DISK 17-MAR-08 1 1 NO TAG20080317T030857
733 B 1 X DISK 18-MAR-08 1 1 NO TAG20080318T025004
734 B 1 X DISK 18-MAR-08 1 1 NO TAG20080318T025722
735 B F X DISK 18-MAR-08 1 1 NO TAG20080318T030908
736 B 1 X DISK 19-MAR-08 1 1 NO TAG20080319T025005
737 B 1 X DISK 19-MAR-08 1 1 NO TAG20080319T025722
738 B F X DISK 19-MAR-08 1 1 NO TAG20080319T030909
739 B 1 X DISK 20-MAR-08 1 1 NO TAG20080320T025005
740 B 1 X DISK 20-MAR-08 1 1 NO TAG20080320T025722
741 B F X DISK 20-MAR-08 1 1 NO TAG20080320T030909
742 B 1 X DISK 21-MAR-08 1 1 NO TAG20080321T025004
743 B 1 X DISK 21-MAR-08 1 1 NO TAG20080321T025722
744 B F X DISK 21-MAR-08 1 1 NO TAG20080321T030908
745 B A X DISK 21-MAR-08 1 1 NO TAG20080321T140135
746 B A X DISK 21-MAR-08 1 1 NO TAG20080321T140135
747 B A X DISK 21-MAR-08 1 1 NO TAG20080321T140135
748 B A A DISK 21-MAR-08 1 1 NO TAG20080321T140135
749 B A A DISK 21-MAR-08 1 1 NO TAG20080321T140135
750 B A A DISK 21-MAR-08 1 1 NO TAG20080321T140135
751 B A A DISK 21-MAR-08 1 1 NO TAG20080321T140135
752 B F A DISK 21-MAR-08 1 1 NO TAG20080321T142855
753 B A A DISK 21-MAR-08 1 1 NO TAG20080321T145058
754 B A A DISK 21-MAR-08 1 1 NO TAG20080321T145058
755 B A A DISK 21-MAR-08 1 1 NO TAG20080321T145058
756 B F A DISK 21-MAR-08 1 1 NO TAG20080321T145104
757 B A A DISK 21-MAR-08 1 1 NO TAG20080321T145751
758 B A A DISK 21-MAR-08 1 1 NO TAG20080321T145751
759 B A A DISK 21-MAR-08 1 1 NO TAG20080321T145751
760 B A A DISK 21-MAR-08 1 1 NO TAG20080321T145751
761 B A A DISK 21-MAR-08 1 1 NO TAG20080321T145751
762 B A A DISK 21-MAR-08 1 1 NO TAG20080321T145751
763 B F A DISK 21-MAR-08 1 1 NO TAG20080321T152424
764 B 1 A DISK 22-MAR-08 1 1 NO TAG20080322T025005
765 B 1 A DISK 22-MAR-08 1 1 NO TAG20080322T025722
766 B F A DISK 22-MAR-08 1 1 NO TAG20080322T030909
767 B 1 A DISK 23-MAR-08 1 1 NO TAG20080323T025005
768 B 1 A DISK 23-MAR-08 1 1 NO TAG20080323T025712
769 B F A DISK 23-MAR-08 1 1 NO TAG20080323T030859
770 B 1 A DISK 24-MAR-08 1 1 NO TAG20080324T025004
771 B 1 A DISK 24-MAR-08 1 1 NO TAG20080324T025711
772 B F A DISK 24-MAR-08 1 1 NO TAG20080324T030907
773 B 1 A DISK 25-MAR-08 1 1 NO TAG20080325T025005
774 B 1 A DISK 25-MAR-08 1 1 NO TAG20080325T025722
775 B F A DISK 25-MAR-08 1 1 NO TAG20080325T030909
776 B 1 A DISK 26-MAR-08 1 1 NO TAG20080326T025005
777 B 1 A DISK 26-MAR-08 1 1 NO TAG20080326T025733
778 B F A DISK 26-MAR-08 1 1 NO TAG20080326T030929
779 B 1 A DISK 27-MAR-08 1 1 NO TAG20080327T025006
780 B 1 A DISK 27-MAR-08 1 1 NO TAG20080327T025733
781 B F A DISK 27-MAR-08 1 1 NO TAG20080327T030930
782 B 1 A DISK 28-MAR-08 1 1 NO TAG20080328T025005
783 B 1 A DISK 28-MAR-08 1 1 NO TAG20080328T025723
784 B F A DISK 28-MAR-08 1 1 NO TAG20080328T030909
785 B 1 A DISK 29-MAR-08 1 1 NO TAG20080329T025006
786 B 1 A DISK 29-MAR-08 1 1 NO TAG20080329T025724
787 B F A DISK 29-MAR-08 1 1 NO TAG20080329T030911
788 B 1 A DISK 30-MAR-08 1 1 NO TAG20080330T025005
789 B 1 A DISK 30-MAR-08 1 1 NO TAG20080330T025722
790 B F A DISK 30-MAR-08 1 1 NO TAG20080330T030919
791 B 1 A DISK 31-MAR-08 1 1 NO TAG20080331T025003
792 B 1 A DISK 31-MAR-08 1 1 NO TAG20080331T025730
793 B F A DISK 31-MAR-08 1 1 NO TAG20080331T030927
794 B 1 A DISK 01-APR-08 1 1 NO TAG20080401T025006
795 B 1 A DISK 01-APR-08 1 1 NO TAG20080401T025724
796 B F A DISK 01-APR-08 1 1 NO TAG20080401T030921
797 B 1 A DISK 02-APR-08 1 1 NO TAG20080402T025005
798 B 1 A DISK 02-APR-08 1 1 NO TAG20080402T025722
799 B F A DISK 02-APR-08 1 1 NO TAG20080402T030909
800 B 1 A DISK 03-APR-08 1 1 NO TAG20080403T025005
801 B 1 A DISK 03-APR-08 1 1 NO TAG20080403T025712
802 B F A DISK 03-APR-08 1 1 NO TAG20080403T030859
803 B 1 A DISK 04-APR-08 1 1 NO TAG20080404T025006
804 B 1 A DISK 04-APR-08 1 1 NO TAG20080404T025723
805 B F A DISK 04-APR-08 1 1 NO TAG20080404T030910
806 B 1 A DISK 05-APR-08 1 1 NO TAG20080405T025005
807 B 1 A DISK 05-APR-08 1 1 NO TAG20080405T025712
808 B F A DISK 05-APR-08 1 1 NO TAG20080405T030859
809 B 1 A DISK 06-APR-08 1 1 NO TAG20080406T025004
810 B 1 A DISK 06-APR-08 1 1 NO TAG20080406T025711
811 B F A DISK 06-APR-08 1 1 NO TAG20080406T030858
812 B 1 A DISK 07-APR-08 1 1 NO TAG20080407T025003
813 B 1 A DISK 07-APR-08 1 1 NO TAG20080407T025721
814 B F A DISK 07-APR-08 1 1 NO TAG20080407T030917
815 B 1 A DISK 08-APR-08 1 1 NO TAG20080408T025006
816 B 1 A DISK 08-APR-08 1 1 NO TAG20080408T025723
817 B F A DISK 08-APR-08 1 1 NO TAG20080408T030909
818 B 1 A DISK 09-APR-08 1 1 NO TAG20080409T025006
819 B 1 A DISK 09-APR-08 1 1 NO TAG20080409T025723
820 B F A DISK 09-APR-08 1 1 NO TAG20080409T030910
821 B 1 A DISK 10-APR-08 1 1 NO TAG20080410T025005
822 B 1 A DISK 10-APR-08 1 1 NO TAG20080410T025722
823 B F A DISK 10-APR-08 1 1 NO TAG20080410T030909
824 B 1 A DISK 11-APR-08 1 1 NO TAG20080411T025005
825 B 1 A DISK 11-APR-08 1 1 NO TAG20080411T025723
826 B F A DISK 11-APR-08 1 1 NO TAG20080411T030920
827 B 1 A DISK 12-APR-08 1 1 NO TAG20080412T025005
828 B 1 A DISK 12-APR-08 1 1 NO TAG20080412T025723
829 B F A DISK 12-APR-08 1 1 NO TAG20080412T030919
830 B 1 A DISK 13-APR-08 1 1 NO TAG20080413T025005
831 B 1 A DISK 13-APR-08 1 1 NO TAG20080413T025722
832 B F A DISK 13-APR-08 1 1 NO TAG20080413T030909
833 B 1 A DISK 14-APR-08 1 1 NO TAG20080414T025004
834 B 1 A DISK 14-APR-08 1 1 NO TAG20080414T025721
835 B F A DISK 14-APR-08 1 1 NO TAG20080414T030908
836 B 1 A DISK 15-APR-08 1 1 NO TAG20080415T025005
837 B 1 A DISK 15-APR-08 1 1 NO TAG20080415T025723
838 B F A DISK 15-APR-08 1 1 NO TAG20080415T030919
839 B 0 A DISK 16-APR-08 13 1 NO TAG20080416T025006
840 B 0 A DISK 16-APR-08 4 1 NO TAG20080416T025006
841 B 0 A DISK 16-APR-08 22 1 NO TAG20080416T025006
尝试还原backupset 到新的datafile 位置
RMAN> run
2> {
3> set newname for datafile 1 to '/RAC_BACKUP/baan/system01.dbf';
4> set newname for datafile 2 to '/RAC_BACKUP/baan/undotbs1.dbf';
5> set newname for datafile 3 to '/RAC_BACKUP/baan/sysaux.dbf';
6> set newname for datafile 4 to '/RAC_BACKUP/baan/undotbs2.dbf';
7> set newname for datafile 5 to '/RAC_BACKUP/baan/users.dbf';
8> set newname for datafile 6 to '/RAC_BACKUP/baan/baanidx.dbf';
9> set newname for datafile 7 to '/RAC_BACKUP/baan/baandb.dbf';
10> set newname for datafile 8 to '/RAC_BACKUP/baan/statspack.dbf';
11> set newname for datafile 9 to '/RAC_BACKUP/baan/system02.dbf';
12> restore database;
13> }
出现ora-600错误,查看trace文件,出现异步IO的问题
ora/app/oracle/admin/baan/udump/baan_ora_8175.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /ora/app/oracle/oracle/product/10.2.0/db_1
System name: HP-UX
Node name: astronhp
Release: B.11.23
Version: U
Machine: ia64
Instance name: baan
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 8175, image: [email=oracle@astronhp]oracle@astronhp[/email]
Ioctl ASYNC_CONFIG error, errno = 1
*** ACTION NAME
![](https://i-blog.csdnimg.cn/blog_migrate/dbdd49eaed45d068acbf50849cc4df61.png)
*** MODULE NAME
![](https://i-blog.csdnimg.cn/blog_migrate/dbdd49eaed45d068acbf50849cc4df61.png)
*** SERVICE NAME
![](https://i-blog.csdnimg.cn/blog_migrate/dbdd49eaed45d068acbf50849cc4df61.png)
*** SESSION ID
![](https://i-blog.csdnimg.cn/blog_migrate/dbdd49eaed45d068acbf50849cc4df61.png)
*** 2008-06-20 18:12:07.885
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []
查看metalink,按metalink的说法解决这个异步IO的问题,但是这个ora-600错误还存在:
主题: How to disable asynch_io on HP to avoid Ioctl Async_config Error Errno = 1
文档 ID: 注释:302801.1 类型: HOWTO
上次修订日期: 21-FEB-2008 状态: PUBLISHED
In this Document
Goal
Solution
References
--------------------------------------------------------------------------------
Applies to:
Oracle Server - Enterprise Edition - Version:
HP-UX Itanium
HP-UX PA-RISC (64-bit)
Goal
How to disable async_io on Oracle in HP-UX to avoid this message in trace file:
Ioctl ASYNC_CONFIG error, errno = 1
Solution
Oracle (for HP only) always uses async I/O regardless of the value of init settings
(disk_asynch_io=FALSE and filesystemio_options=none).
The parameter filesystemio_options=none doesn't work.
Oracle always opens /dev/async successfully only if the /dev/async HP-UX
device driver is properly configured for read and write. This is irrespective
of whether the DISK_ASYNC_IO parm is set to TRUE.
In 9.2 version, to inactivate ASYNCH_IO with Oracle , workaround is:
chown bin:bin /dev/async
chmod 660 /dev/async
Note:
This may impact other applications that wish to use asynch I/O
Grant dba group the MLOCK priv to avoid the Ioctl ASYNC_CONFIG trace file errors:
(1) # /usr/sbin/setprivgrp dba MLOCK
(2) # vi /etc/privgroup
This should contain dba MLOCK RTSCHED RTPRIO
(3) # cat /etc/privgroup
dba MLOCK RTSCHED RTPRIO
Starting with Oracle 10.2, these settings will stop the tracing:
disk_asynch_io=FALSE
filesystemio_options=none
# setprivgrp dba MLOCK
# vi /etc/privgroup
"/etc/privgroup" [New file]
dba MLOCK RTSCHED RTPRIO
# ls |grep as
async
asyncdsk
# ll |grep as
crw-rw-rw- 1 bin bin 101 0x000000 May 31 2007 async
crw-rw-rw- 1 bin bin 101 0x000000 May 31 2007 asyncdsk
在trace文件中看到这样的信息: c-3872779959-20080321-00 是从RAC那边考过来的rman备份的控制文件
Repeat 101 times
6000000000031BF0 00000002 02000000 0B6B6765 6164655F [.........kgeade_]
6000000000031C00 69735F30 2F632D33 38373237 37393935 [is_0/ c-387277995]
6000000000031C10 392D3230 30383033 32312D30 30000000 [ 9-20080321-00...]
6000000000031C20 00000000 00000000 00000000 00000000 [................]
Repeat 98 times
6000000000031BF0 00000002 02000000 0B6B6765 6164655F [.........kgeade_]
6000000000031C00 69735F30 5F424143 4B55505F 52455354 [is_0_BACKUP_REST]
6000000000031C10 4F524522 2C200100 00000433 31383002 [ORE", .....3180.]
6000000000031C20 0000001D 22535953 2E582444 424D535F [...."SYS.X$DBMS_]
6000000000031C30 4241434B 55505F52 4553544F 5245222C [BACKUP_RESTORE",]
6000000000031C40 20010000 00043332 30340200 00000B6B [ .....3204.....k]
6000000000031C50 67656164 655F6973 5F302F63 2D333837 [geade_is_0/c-387]
6000000000031C60 32373739 3935392D 32303038 30333231 [2779959-20080321]
6000000000031C70 2D303000 00000000 00000000 00000000 [-00.............]
6000000000031C80 00000000 00000000 00000000 00000000 [................]
开始改重做日志路径,虽然报了ora-600错误,但是路径还是修改成功了
SQL> alter database rename file '+MYASM/baan/onlinelog/group_1.280.628807911' to
2 '/ora/app/oracle/oradata/baan/redo1a.log';
alter database rename file '+MYASM/baan/onlinelog/group_1.280.628807911' to
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []
QL> select * from v$logfile order by group#;
rows will be truncated
GROUP# STATUS TYPE MEMBER
---------- ------- ------- -------------------------------------------------------------------------
1 ONLINE /ora/app/oracle/oradata/baan/redo1a.log
1 ONLINE +MYASM/baan/onlinelog/group_1.284.628809135
2 ONLINE +MYASM/baan/onlinelog/group_2.283.628808345
2 ONLINE +MYASM/baan/onlinelog/group_2.281.628807931
3 ONLINE +MYASM/baan/onlinelog/group_3.268.628808793
3 ONLINE +MYASM/baan/onlinelog/group_3.285.628809157
4 ONLINE +MYASM/baan/onlinelog/group_4.264.628808849
4 ONLINE +MYASM/baan/onlinelog/group_4.286.628809181
5 ONLINE +MYASM/baan/onlinelog/group_5.287.628809201
5 ONLINE +MYASM/baan/onlinelog/group_5.282.628808889
7 ONLINE +MYASM/baan/onlinelog/group_7.288.628809251
GROUP# STATUS TYPE MEMBER
---------- ------- ------- -------------------------------------------------------------------------
7 ONLINE +MYASM/baan/onlinelog/log7.ora
8 ONLINE +MYASM/baan/onlinelog/log8.ora
8 ONLINE +MYASM/baan/onlinelog/group_8.289.628809271
9 ONLINE +MYASM/baan/onlinelog/group_9.290.628808517
9 ONLINE +MYASM/baan/onlinelog/log9.ora
10 ONLINE +MYASM/baan/onlinelog/log10.ora
10 ONLINE +MYASM/baan/onlinelog/group_10.291.628809285
11 ONLINE +MYASM/baan/onlinelog/group_11.292.628809315
11 ONLINE +MYASM/baan/onlinelog/log11.ora
20 rows selected.
在rman中做crosscheck的时候,出现下面的错误:
/ora/app/oracle/admin/baan/bdump/baan_dbw0_27403.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /ora/app/oracle/oracle/product/10.2.0/db_1
System name: HP-UX
Node name: astronhp
Release: B.11.23
Version: U
Machine: ia64
Instance name: baan
Redo thread mounted by this instance: 1
Oracle process number: 5
Unix process pid: 27403, image: [email=oracle@astronhp]oracle@astronhp[/email] (DBW0)
*** 2008-06-23 09:58:37.835
*** SERVICE NAME
![](https://i-blog.csdnimg.cn/blog_migrate/dbdd49eaed45d068acbf50849cc4df61.png)
*** SESSION ID
![](https://i-blog.csdnimg.cn/blog_migrate/dbdd49eaed45d068acbf50849cc4df61.png)
2008-06-23 09:58:37.835: [ OCROSD]utgdv:2
![](https://i-blog.csdnimg.cn/blog_migrate/b968e3c74f55b41e8be1caa4cbbe7ad2.png)
2008-06-23 09:58:37.835: [ OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
2008-06-23 09:58:37.836: [ OCRRAW]proprinit: Could not open raw device
2008-06-23 09:58:37.836: [ default]a_init:7!: Backend init unsuccessful : [33]
2008-06-23 09:58:37.836: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
kgxgncin: CLSS init failed with status 21
ORA-01157: Message 1157 not found; No message file for product=RDBMS, facility=ORA; arguments: [1]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [+MYASM/baan
/datafile/system.266.592727231]
ORA-17503: Message 17503 not found; No message file for product=RDBMS, facility=ORA; arguments: [2] [+MYASM/baa
n/datafile/system.266.592727231]
ORA-15001: Message 15001 not found; No message file for product=RDBMS, facility=ORA; arguments: [MYASM]
ORA-15077: Message 15077 not found; No message file for product=RDBMS, facility=ORA
ORA-29701: Message 29701 not found; No message file for product=RDBMS, facility=ORA
2008-06-23 09:58:37.838: [ OCROSD]utgdv:2
![](https://i-blog.csdnimg.cn/blog_migrate/b968e3c74f55b41e8be1caa4cbbe7ad2.png)
2008-06-23 09:58:37.838: [ OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
现在的主要问题是,不能crosscheck.尝试了用RMAN的debug跟踪:
$ rman target / debug trace /ora/app/oracle/admin/baan/udump/trace.log
Recovery Manager: Release 10.2.0.4.0 - Production on Mon Jun 23 15:34:24 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN-06568: connected to target database: BAAN (DBID=3872779959, not open)
RMAN> crosscheck backup;
RMAN-03090: Starting implicit crosscheck backup at 23-JUN-08
RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08500: channel ORA_DISK_1: sid=1971 devtype=DISK
RMAN-08030: allocated channel: ORA_DISK_2
RMAN-08500: channel ORA_DISK_2: sid=1970 devtype=DISK
RMAN-01005: ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []
RMAN-01005: ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []
查看trace.log:
DBGMISC: Node # 1 [15:34:36.032]
DBGMISC: crosscheck
DBGMISC: 1 backup
DBGMISC: 1 DBASE
DBGMISC: 2 ALSPEC
DBGMISC: 1 ALL
DBGMISC: 3 CURCF
DBGMISC: 1 NIL
DBGMISC: 4 SPFILE
DBGMISC: 1 NIL
DBGMISC: 5 Standby Controlfile
DBGMISC: 1 NIL
DBGMISC: ENTERED krmice [15:34:36.035]
DBGMISC: command to be compiled and executed is: crosscheck [15:34:36.035] (krmice)
DBGMISC: command after this command is: NONE [15:34:36.035] (krmice)
DBGMISC: current incarnation does not matter for crosscheck [15:34:36.036] (krmice)
DBGSQL: EXEC SQL AT TARGET select decode(open_mode,'MOUNTED',0,'READ WRITE',1,'READ ONLY',1,0) into :b1 fro
m v$database [15:34:36.036]
DBGSQL: sqlcode=0 [15:34:36.037]
DBGSQL: :b1 = 0
DBGMISC: EXITED krmknmtr with status implicit crosscheck backup [15:34:43.759] elapsed time [00:00:00:05.91
6]
DBGMISC: krmkdps: this_reset_scn=247810974 [15:34:43.760]
DBGMISC: krmkdps: this_reset_time=05-DEC-07 [15:34:43.760]
DBGMISC: krmkdps: untilSCN= [15:34:43.761]
DBGMISC: krmkdps: untilTime= [15:34:43.761]
DBGMISC: krmkdps: getRA_completedAfter= [15:34:43.761]
DBGMISC: krmkdps: getRA_completedBefore= [15:34:43.762]
DBGMISC: krmkdps: getRA_likePattern= [15:34:43.762]
DBGMISC: krmkdps: getRA_containerMask=15 [15:34:43.762]
DBGMISC: krmkdps: getRA_actionMask=63 [15:34:43.763]
DBGMISC: krmkdps: computeRA_allRecords0 [15:34:43.763]
DBGMISC: krmkdps: computeRA_fullBackups=1 [15:34:43.763]
DBGMISC: krmkdps: allIncarnations=0 [15:34:43.764]
RMAN-03002: failure of crosscheck command at 06/23/2008 15:35:13
RMAN-12005: error during channel cleanup
RMAN-10035: exception raised in RPC:
RMAN-10031: RPC Error: ORA-03114 occurred during call to DBMS_BACKUP_RESTORE.BACKUPCANCEL
今天用rman做report schema,又看了一下debug log:
DBGPLSQL: channel ORA_DISK_1: force: 0 [09:02:50.870] (change)
DBGRPC: krmxrpc: xc=6917529027646109448 kpurpc2 rc=600 db=target
proc=DBMS_BACKUP_RESTORE.VALIDATEBACKUPPIECE
DBGRPC: krmxrpc: xc=6917529027646109448 chid=ORA_DISK_1 increment rpc count=65
DBGMISC: ENTERED krmzlog [09:02:53.914]
DBGMISC: Message (len=0) before truncation=ORA-00600: internal error code, arguments: [kgeade_is_0], [], [
], [], [], [], [], [] [09:02:53.914] (krmzlog)
RMAN-01005: ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []
看到这样的信息,去哪能找到这个krmzlog日志呢?
$ rman target / debug trace /ora/app/oracle/admin/baan/udump/trace.log
Recovery Manager: Release 10.2.0.4.0 - Production on Mon Jun 23 15:34:24 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN-06568: connected to target database: BAAN (DBID=3872779959, not open)
RMAN> crosscheck backup;
RMAN-03090: Starting implicit crosscheck backup at 23-JUN-08
RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08500: channel ORA_DISK_1: sid=1971 devtype=DISK
RMAN-08030: allocated channel: ORA_DISK_2
RMAN-08500: channel ORA_DISK_2: sid=1970 devtype=DISK
RMAN-01005: ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []
RMAN-01005: ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []
查看trace.log:
DBGMISC: Node # 1 [15:34:36.032]
DBGMISC: crosscheck
DBGMISC: 1 backup
DBGMISC: 1 DBASE
DBGMISC: 2 ALSPEC
DBGMISC: 1 ALL
DBGMISC: 3 CURCF
DBGMISC: 1 NIL
DBGMISC: 4 SPFILE
DBGMISC: 1 NIL
DBGMISC: 5 Standby Controlfile
DBGMISC: 1 NIL
DBGMISC: ENTERED krmice [15:34:36.035]
DBGMISC: command to be compiled and executed is: crosscheck [15:34:36.035] (krmice)
DBGMISC: command after this command is: NONE [15:34:36.035] (krmice)
DBGMISC: current incarnation does not matter for crosscheck [15:34:36.036] (krmice)
DBGSQL: EXEC SQL AT TARGET select decode(open_mode,'MOUNTED',0,'READ WRITE',1,'READ ONLY',1,0) into :b1 fro
m v$database [15:34:36.036]
DBGSQL: sqlcode=0 [15:34:36.037]
DBGSQL: :b1 = 0
DBGMISC: EXITED krmknmtr with status implicit crosscheck backup [15:34:43.759] elapsed time [00:00:00:05.91
6]
DBGMISC: krmkdps: this_reset_scn=247810974 [15:34:43.760]
DBGMISC: krmkdps: this_reset_time=05-DEC-07 [15:34:43.760]
DBGMISC: krmkdps: untilSCN= [15:34:43.761]
DBGMISC: krmkdps: untilTime= [15:34:43.761]
DBGMISC: krmkdps: getRA_completedAfter= [15:34:43.761]
DBGMISC: krmkdps: getRA_completedBefore= [15:34:43.762]
DBGMISC: krmkdps: getRA_likePattern= [15:34:43.762]
DBGMISC: krmkdps: getRA_containerMask=15 [15:34:43.762]
DBGMISC: krmkdps: getRA_actionMask=63 [15:34:43.763]
DBGMISC: krmkdps: computeRA_allRecords0 [15:34:43.763]
DBGMISC: krmkdps: computeRA_fullBackups=1 [15:34:43.763]
DBGMISC: krmkdps: allIncarnations=0 [15:34:43.764]
RMAN-03002: failure of crosscheck command at 06/23/2008 15:35:13
RMAN-12005: error during channel cleanup
RMAN-10035: exception raised in RPC:
RMAN-10031: RPC Error: ORA-03114 occurred during call to DBMS_BACKUP_RESTORE.BACKUPCANCEL
今天用rman做report schema,又看了一下debug log:
DBGPLSQL: channel ORA_DISK_1: force: 0 [09:02:50.870] (change)
DBGRPC: krmxrpc: xc=6917529027646109448 kpurpc2 rc=600 db=target
proc=DBMS_BACKUP_RESTORE.VALIDATEBACKUPPIECE
DBGRPC: krmxrpc: xc=6917529027646109448 chid=ORA_DISK_1 increment rpc count=65
DBGMISC: ENTERED krmzlog [09:02:53.914]
DBGMISC: Message (len=0) before truncation=ORA-00600: internal error code, arguments: [kgeade_is_0], [], [
], [], [], [], [], [] [09:02:53.914] (krmzlog)
RMAN-01005: ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []
看到这样的信息,去哪能找到这个krmzlog日志呢?
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/87010/viewspace-376673/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/87010/viewspace-376673/