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
[ 本帖最后由 赵宇 于 2008-6-25 14:13 编辑 ]
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
![2.gif](http://www.itpub.net/images/smilies/2.gif)
*** MODULE NAME
![2.gif](http://www.itpub.net/images/smilies/2.gif)
*** SERVICE NAME
![2.gif](http://www.itpub.net/images/smilies/2.gif)
*** SESSION ID
![2.gif](http://www.itpub.net/images/smilies/2.gif)
*** 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
[ 本帖最后由 赵宇 于 2008-6-25 14:13 编辑 ]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/175005/viewspace-365951/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/175005/viewspace-365951/