sap环境rman恢复

samsungsamsung

　　
　　原系统
　　
　　1准备备份
　　备份脚本

source /oracle/EP1/.cshrc

rman nocatalog target / cmdfile=/oracle/EP1/backup_scripts/backup_database_by-mgy.scr log=/backup/backup_database_by-mgy.log

run{

allocate channel c1 type disk;

allocate channel c2 type disk;

BACKUP FORMAT '/oracle/EP1/sapdata9/EP1_full_%U_%T' skip inaccessible filesperset 5  DATABASE TAG EP1_hot_db_bk;

sql 'alter system archive log current';

BACKUP FORMAT '/oracle/EP1/sapdata9/EP1_arch_%U_%T' skip inaccessible filesperset 5 ARCHIVELOG ALL ;

backup current controlfile tag='bak_ctlfile' format='/oracle/EP1/sapdata9/ctl_file_%U_%T';

backup spfile tag='spfile' format='/oracle/EP1/sapdata9/EP1_spfile_%U_%T';

release channel c2;

release channel c1;

}

　　利用备份脚本做一个完整的备份到 sapdata9 目录
　　2进入目标系统 生成 控制文件脚本
　　SQL*Plus: Release 10.2.0.2.0 - Production on Tue Jun 3 10:40:27 2008
　　
　　Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
　　
　　SQL> connect / as sysdba
　　Connected.
　　SQL> alter database backup controlfile to trace resetlogs;
　　
　　Database altered.
　　
　　SQL> alter system switch logfile;
　　
　　System altered.
　　在源系统saptrace/usertrace 下找到最新的跟踪文件，修改成CONTROL.SQL 连同 initEP1.ora 一同复制到目标系统
　　3 将 备份目录/oracle/EP1/sapdata9   nfs 共享出来
　　
　　目标系统
　　1 创建和目标系统 oracle 相同的目录 创建 EP1 到 EQ1的 连接
　　mkdir /oracle/EP1/sapdata9 /oracle/EP1/sapdata4
　　mkdir -p sysaux_1 system_1 system_2 system_3 temp_1 undo_1
　　mkdir -p sr3_1 sr3_10 sr3_11 sr3_12 sr3_13 sr3_14 sr3_15 sr3_16 sr3_17 sr3_18 sr3_19 sr3_2 sr3_20 sr3_21 sr3_22 sr3_23 sr3_24 sr3_25 sr3_26 sr3_27 sr3_28 sr3_3 sr3_4 sr3_5 sr3_6 sr3_7 sr3_8 sr3_9
　　mkdir -p sr3701x_1 sr3701x_10 sr3701x_11 sr3701x_12 sr3701x_13 sr3701x_14 sr3701x_15 sr3701x_16 sr3701x_17 sr3701x_2 sr3701x_3 sr3701x_4 sr3701x_5 sr3701x_6 sr3701x_7 sr3701x_8 sr3701x_9
　　mkdir -p sr3usr_1 sr3usr_2
　　mkdir -p sr3_29 sr3_30 sr3_31 sr3_32 sr3_33 sr3_34 sr3_35 sr3_36 sr3_37 sr3_38 sr3_39 sr3_40 sr3_41
　　
　　
　　1 将原系统nfs 共享目录 mount 过来
　　这里遭遇  oracle  10 g bug
　　处理方法如下
　　
　　http://ebsblog.blog.163.com/blog/static/12794978920098153312973/
　　http://blog.chinaunix.net/space.php?uid=10257388&do=blog&id=2967310
　　按下列参数挂载 nfs
　　1） mount -o cio,rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,noac,vers=3,timeo=600
　　sapprd01:/oracle/EP1/sapdata9 /oracle/EP1/sapdata
　　2）修改initEP1.ora 文件参数
　　*.event = '10298 trace name context forever, level 32'
　　
　　2用 initEP1.ora 启动oracle 到nomount状态
　　SQL> startup nomount pfile=/oracle/EQ1/102_64/dbs/initEP1.ora
　　ORACLE instance started.
　　
　　Total System Global Area 1.1677E+10 bytes
　　Fixed Size                  2103672 bytes
　　Variable Size            5855250056 bytes
　　Database Buffers         5804916736 bytes
　　Redo Buffers               14671872 bytes
　　3 用rman 进入 恢复 控制文件
　　sapqas01:oraep1 6> rman nocatalog target /
　　
　　Recovery Manager: Release 10.2.0.4.0 - Production on Sat Apr 21 12:38:16 2012
　　
　　Copyright (c) 1982, 2007, Oracle.  All rights reserved.
　　
　　connected to target database: EP1 (not mounted)
　　using target database control file instead of recovery catalog
　　RMAN> restore controlfile from '/oracle/ctl_file_aen8rb8g_1_1_20120419';
　　
　　Starting restore at 21-APR-12
　　allocated channel: ORA_DISK_1
　　channel ORA_DISK_1: sid=2630 devtype=DISK
　　
　　channel ORA_DISK_1: restoring control file
　　channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
　　output filename=/oracle/EP1/origlogA/cntrl/cntrlEP1.dbf
　　output filename=/oracle/EP1/origlogB/cntrl/cntrlEP1.dbf
　　output filename=/oracle/EP1/sapdata1/cntrl/cntrlEP1.dbf
　　Finished restore at 21-APR-12
　　4进入到mount 状态
　　RMAN> alter database mount;
　　5 从备份恢复数据文件
　　RMAN> restore database
　　Starting restore at 21-APR-12
　　using channel ORA_DISK_1
　　
　　channel ORA_DISK_1: starting datafile backupset restore
　　channel ORA_DISK_1: specifying datafile(s) to restore from backup set
　　restoring datafile 00024 to /oracle/EP1/sapdata3/sr3701x_2/sr3701x.data2
　　restoring datafile 00037 to /oracle/EP1/sapdata3/sr3701x_15/sr3701x.data15
　　restoring datafile 00040 to /oracle/EP1/sapdata3/sr3701x_17/sr3701x.data17
　　restoring datafile 00045 to /oracle/EP1/sapdata2/sr3_22/sr3.data22
　　restoring datafile 00058 to /oracle/EP1/sapdata5/sr3_35/sr3.data35
　　channel ORA_DISK_1: reading from backup piece /oracle/EP1/sapdata9/EP1_full_9rn8r7r8_1_1_20120419
　　channel ORA_DISK_1: restored backup piece 1
　　piece handle=/oracle/EP1/sapdata9/EP1_full_9rn8r7r8_1_1_20120419 tag=EP1_HOT_DB_BK
　　channel ORA_DISK_1: restore complete, elapsed time: 00:32:56
　　channel ORA_DISK_1: starting datafile backupset restore
　　channel ORA_DISK_1: specifying datafile(s) to restore from backup set
　　restoring datafile 00002 to /oracle/EP1/sapdata1/undo_1/undo.data1
　　restoring datafile 00022 to /oracle/EP1/sapdata2/sr3_19/sr3.data19
　　restoring datafile 00035 to /oracle/EP1/sapdata3/sr3701x_13/sr3701x.data13
　　restoring datafile 00046 to /oracle/EP1/sapdata2/sr3_23/sr3.data23
　　restoring datafile 00056 to /oracle/EP1/sapdata5/sr3_33/sr3.data33
　　channel ORA_DISK_1: reading from backup piece /oracle/EP1/sapdata9/EP1_full_9qn8r7r8_1_1_20120419
　　channel ORA_DISK_1: restored backup piece 1
　　piece handle=/oracle/EP1/sapdata9/EP1_full_9qn8r7r8_1_1_20120419 tag=EP1_HOT_DB_BK
　　channel ORA_DISK_1: restore complete, elapsed time: 00:38:45
　　channel ORA_DISK_1: starting datafile backupset restore
　　channel ORA_DISK_1: specifying datafile(s) to restore from backup set
　　restoring datafile 00005 to /oracle/EP1/sapdata2/sr3_2/sr3.data2
　　restoring datafile 00016 to /oracle/EP1/sapdata2/sr3_13/sr3.data13
　　restoring datafile 00034 to /oracle/EP1/sapdata3/sr3701x_12/sr3701x.data12
　　restoring datafile 00038 to /oracle/EP1/sapdata3/sr3701x_16/sr3701x.data16
　　restoring datafile 00048 to /oracle/EP1/sapdata2/sr3_25/sr3.data25
　　channel ORA_DISK_1: reading from backup piece /oracle/EP1/sapdata9/EP1_full_9sn8r8cj_1_1_20120419
　　channel ORA_DISK_1: restored backup piece 1
　　piece handle=/oracle/EP1/sapdata9/EP1_full_9sn8r8cj_1_1_20120419 tag=EP1_HOT_DB_BK
　　channel ORA_DISK_1: restore complete, elapsed time: 00:34:56
　　channel ORA_DISK_1: starting datafile backupset restore
　　channel ORA_DISK_1: specifying datafile(s) to restore from backup set
　　restoring datafile 00006 to /oracle/EP1/sapdata2/sr3_3/sr3.data3
　　restoring datafile 00017 to /oracle/EP1/sapdata2/sr3_14/sr3.data14
　　restoring datafile 00026 to /oracle/EP1/sapdata3/sr3701x_4/sr3701x.data4
　　restoring datafile 00029 to /oracle/EP1/sapdata3/sr3701x_7/sr3701x.data7
　　restoring datafile 00049 to /oracle/EP1/sapdata2/sr3_26/sr3.data26
　　channel ORA_DISK_1: reading from backup piece /oracle/EP1/sapdata9/EP1_full_9tn8r8ev_1_1_20120419
　　channel ORA_DISK_1: restored backup piece 1
　　piece handle=/oracle/EP1/sapdata9/EP1_full_9tn8r8ev_1_1_20120419 tag=EP1_HOT_DB_BK
　　channel ORA_DISK_1: restore complete, elapsed time: 00:33:55
　　channel ORA_DISK_1: starting datafile backupset restore
　　channel ORA_DISK_1: specifying datafile(s) to restore from backup set
　　restoring datafile 00012 to /oracle/EP1/sapdata2/sr3_9/sr3.data9
　　restoring datafile 00033 to /oracle/EP1/sapdata3/sr3701x_11/sr3701x.data11
　　restoring datafile 00041 to /oracle/EP1/sapdata2/sr3_20/sr3.data20
　　restoring datafile 00044 to /oracle/EP1/sapdata1/system_3/system.data3
　　restoring datafile 00062 to /oracle/EP1/sapdata5/sr3_39/sr3.data39
　　channel ORA_DISK_1: reading from backup piece /oracle/EP1/sapdata9/EP1_full_9un8r8ue_1_1_20120419
　　channel ORA_DISK_1: restored backup piece 1
　　piece handle=/oracle/EP1/sapdata9/EP1_full_9un8r8ue_1_1_20120419 tag=EP1_HOT_DB_BK
　　channel ORA_DISK_1: restore complete, elapsed time: 00:29:35
　　channel ORA_DISK_1: starting datafile backupset restore
　　channel ORA_DISK_1: specifying datafile(s) to restore from backup set
　　restoring datafile 00007 to /oracle/EP1/sapdata2/sr3_4/sr3.data4
　　restoring datafile 00018 to /oracle/EP1/sapdata2/sr3_15/sr3.data15
　　restoring datafile 00025 to /oracle/EP1/sapdata3/sr3701x_3/sr3701x.data3
　　restoring datafile 00030 to /oracle/EP1/sapdata3/sr3701x_8/sr3701x.data8
　　restoring datafile 00050 to /oracle/EP1/sapdata2/sr3_27/sr3.data27
　　channel ORA_DISK_1: reading from backup piece /oracle/EP1/sapdata9/EP1_full_9vn8r914_1_1_20120419
　　channel ORA_DISK_1: restored backup piece 1
　　piece handle=/oracle/EP1/sapdata9/EP1_full_9vn8r914_1_1_20120419 tag=EP1_HOT_DB_BK
　　channel ORA_DISK_1: restore complete, elapsed time: 00:33:45
　　channel ORA_DISK_1: starting datafile backupset restore
　　channel ORA_DISK_1: specifying datafile(s) to restore from backup set
　　restoring datafile 00008 to /oracle/EP1/sapdata2/sr3_5/sr3.data5
　　restoring datafile 00019 to /oracle/EP1/sapdata2/sr3_16/sr3.data16
　　restoring datafile 00023 to /oracle/EP1/sapdata3/sr3701x_1/sr3701x.data1
　　restoring datafile 00031 to /oracle/EP1/sapdata3/sr3701x_9/sr3701x.data9
　　restoring datafile 00051 to /oracle/EP1/sapdata2/sr3_28/sr3.data28
　　channel ORA_DISK_1: reading from backup piece /oracle/EP1/sapdata9/EP1_full_a0n8r9b9_1_1_20120419
　　channel ORA_DISK_1: restored backup piece 1
　　piece handle=/oracle/EP1/sapdata9/EP1_full_a0n8r9b9_1_1_20120419 tag=EP1_HOT_DB_BK
　　channel ORA_DISK_1: restore complete, elapsed time: 00:33:45
　　channel ORA_DISK_1: starting datafile backupset restore
　　channel ORA_DISK_1: specifying datafile(s) to restore from backup set
　　restoring datafile 00003 to /oracle/EP1/sapdata1/sysaux_1/sysaux.data1
　　restoring datafile 00004 to /oracle/EP1/sapdata2/sr3_1/sr3.data1
　　restoring datafile 00015 to /oracle/EP1/sapdata2/sr3_12/sr3.data12
　　restoring datafile 00047 to /oracle/EP1/sapdata2/sr3_24/sr3.data24
　　restoring datafile 00063 to /oracle/EP1/sapdata4/sr3usr_2/sr3usr.data2
　　channel ORA_DISK_1: reading from backup piece /oracle/EP1/sapdata9/EP1_full_a1n8r9i1_1_1_20120419
　　channel ORA_DISK_1: restored backup piece 1
　　piece handle=/oracle/EP1/sapdata9/EP1_full_a1n8r9i1_1_1_20120419 tag=EP1_HOT_DB_BK
　　channel ORA_DISK_1: restore complete, elapsed time: 00:31:45
　　channel ORA_DISK_1: starting datafile backupset restore
　　channel ORA_DISK_1: specifying datafile(s) to restore from backup set
　　restoring datafile 00011 to /oracle/EP1/sapdata2/sr3_8/sr3.data8
　　restoring datafile 00036 to /oracle/EP1/sapdata3/sr3701x_14/sr3701x.data14
　　restoring datafile 00042 to /oracle/EP1/sapdata2/sr3_21/sr3.data21
　　restoring datafile 00043 to /oracle/EP1/sapdata1/system_2/system.data2
　　restoring datafile 00060 to /oracle/EP1/sapdata5/sr3_37/sr3.data37
　　channel ORA_DISK_1: reading from backup piece /oracle/EP1/sapdata9/EP1_full_a2n8r9sg_1_1_20120419
　　channel ORA_DISK_1: restored backup piece 1
　　piece handle=/oracle/EP1/sapdata9/EP1_full_a2n8r9sg_1_1_20120419 tag=EP1_HOT_DB_BK
　　channel ORA_DISK_1: restore complete, elapsed time: 00:29:26
　　channel ORA_DISK_1: starting datafile backupset restore
　　channel ORA_DISK_1: specifying datafile(s) to restore from backup set
　　restoring datafile 00014 to /oracle/EP1/sapdata2/sr3_11/sr3.data11
　　restoring datafile 00039 to /oracle/EP1/sapdata4/sr3usr_1/sr3usr.data1
　　restoring datafile 00053 to /oracle/EP1/sapdata5/sr3_30/sr3.data30
　　restoring datafile 00057 to /oracle/EP1/sapdata5/sr3_34/sr3.data34
　　restoring datafile 00065 to /oracle/EP1/sapdata5/sr3_41/sr3.data41
　　channel ORA_DISK_1: reading from backup piece /oracle/EP1/sapdata9/EP1_full_a3n8ra1m_1_1_20120419
　　channel ORA_DISK_1: restored backup piece 1
　　piece handle=/oracle/EP1/sapdata9/EP1_full_a3n8ra1m_1_1_20120419 tag=EP1_HOT_DB_BK
　　channel ORA_DISK_1: restore complete, elapsed time: 00:30:35
　　channel ORA_DISK_1: starting datafile backupset restore
　　channel ORA_DISK_1: specifying datafile(s) to restore from backup set
　　restoring datafile 00001 to /oracle/EP1/sapdata1/system_1/system.data1
　　restoring datafile 00009 to /oracle/EP1/sapdata2/sr3_6/sr3.data6
　　restoring datafile 00010 to /oracle/EP1/sapdata2/sr3_7/sr3.data7
　　restoring datafile 00021 to /oracle/EP1/sapdata2/sr3_18/sr3.data18
　　restoring datafile 00027 to /oracle/EP1/sapdata3/sr3701x_5/sr3701x.data5
　　channel ORA_DISK_1: reading from backup piece /oracle/EP1/sapdata9/EP1_full_a4n8ra91_1_1_20120419
　　channel ORA_DISK_1: restored backup piece 1
　　piece handle=/oracle/EP1/sapdata9/EP1_full_a4n8ra91_1_1_20120419 tag=EP1_HOT_DB_BK
　　channel ORA_DISK_1: restore complete, elapsed time: 00:33:05
　　channel ORA_DISK_1: starting datafile backupset restore
　　channel ORA_DISK_1: specifying datafile(s) to restore from backup set
　　restoring datafile 00013 to /oracle/EP1/sapdata2/sr3_10/sr3.data10
　　restoring datafile 00028 to /oracle/EP1/sapdata3/sr3701x_6/sr3701x.data6
　　restoring datafile 00054 to /oracle/EP1/sapdata5/sr3_31/sr3.data31
　　restoring datafile 00055 to /oracle/EP1/sapdata5/sr3_32/sr3.data32
　　restoring datafile 00064 to /oracle/EP1/sapdata5/sr3_40/sr3.data40
　　channel ORA_DISK_1: reading from backup piece /oracle/EP1/sapdata9/EP1_full_a5n8raer_1_1_20120419
　　channel ORA_DISK_1: restored backup piece 1
　　piece handle=/oracle/EP1/sapdata9/EP1_full_a5n8raer_1_1_20120419 tag=EP1_HOT_DB_BK
　　channel ORA_DISK_1: restore complete, elapsed time: 00:38:56
　　channel ORA_DISK_1: starting datafile backupset restore
　　channel ORA_DISK_1: specifying datafile(s) to restore from backup set
　　restoring datafile 00020 to /oracle/EP1/sapdata2/sr3_17/sr3.data17
　　restoring datafile 00032 to /oracle/EP1/sapdata3/sr3701x_10/sr3701x.data10
　　restoring datafile 00052 to /oracle/EP1/sapdata5/sr3_29/sr3.data29
　　restoring datafile 00059 to /oracle/EP1/sapdata5/sr3_36/sr3.data36
　　restoring datafile 00061 to /oracle/EP1/sapdata5/sr3_38/sr3.data38
　　channel ORA_DISK_1: reading from backup piece /oracle/EP1/sapdata9/EP1_full_a6n8raso_1_1_20120419
　　channel ORA_DISK_1: restored backup piece 1
　　piece handle=/oracle/EP1/sapdata9/EP1_full_a6n8raso_1_1_20120419 tag=EP1_HOT_DB_BK
　　channel ORA_DISK_1: restore complete, elapsed time: 00:33:15
　　Finished restore at 22-APR-12
　　6
　　RMAN> recover database;
　　
　　Starting recover at 22-APR-12
　　using channel ORA_DISK_1
　　
　　starting media recovery
　　
　　channel ORA_DISK_1: starting archive log restore to default destination
　　channel ORA_DISK_1: restoring archive log
　　archive log thread=1 sequence=118067
　　channel ORA_DISK_1: restoring archive log
　　archive log thread=1 sequence=118068
　　channel ORA_DISK_1: restoring archive log
　　archive log thread=1 sequence=118069
　　channel ORA_DISK_1: reading from backup piece /oracle/EP1/sapdata9/EP1_arch_abn8rb85_1_1_20120419
　　channel ORA_DISK_1: restored backup piece 1
　　piece handle=/oracle/EP1/sapdata9/EP1_arch_abn8rb85_1_1_20120419 tag=TAG20120419T183956
　　channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
　　archive log filename=/oracle/EP1/oraarch/EP1arch1_118067_737031978.dbf thread=1 sequence=118067
　　archive log filename=/oracle/EP1/oraarch/EP1arch1_118068_737031978.dbf thread=1 sequence=118068
　　archive log filename=/oracle/EP1/oraarch/EP1arch1_118069_737031978.dbf thread=1 sequence=118069
　　channel ORA_DISK_1: starting archive log restore to default destination
　　channel ORA_DISK_1: restoring archive log
　　archive log thread=1 sequence=118070
　　channel ORA_DISK_1: restoring archive log
　　archive log thread=1 sequence=118071
　　channel ORA_DISK_1: restoring archive log
　　archive log thread=1 sequence=118072
　　channel ORA_DISK_1: restoring archive log
　　archive log thread=1 sequence=118073
　　channel ORA_DISK_1: reading from backup piece /oracle/EP1/sapdata9/EP1_arch_adn8rb8c_1_1_20120419
　　channel ORA_DISK_1: restored backup piece 1
　　piece handle=/oracle/EP1/sapdata9/EP1_arch_adn8rb8c_1_1_20120419 tag=TAG20120419T183956
　　channel ORA_DISK_1: restore complete, elapsed time: 00:00:08
　　archive log filename=/oracle/EP1/oraarch/EP1arch1_118070_737031978.dbf thread=1 sequence=118070
　　archive log filename=/oracle/EP1/oraarch/EP1arch1_118071_737031978.dbf thread=1 sequence=118071
　　archive log filename=/oracle/EP1/oraarch/EP1arch1_118072_737031978.dbf thread=1 sequence=118072
　　archive log filename=/oracle/EP1/oraarch/EP1arch1_118073_737031978.dbf thread=1 sequence=118073
　　unable to find archive log
　　archive log thread=1 sequence=118074
　　RMAN-00571: ===========================================================
　　RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
　　RMAN-00571: ===========================================================
　　RMAN-03002: failure of recover command at 04/22/2012 06:07:47
　　RMAN-06054: media recovery requesting unknown log: thread 1 seq 118074 lowscn 2240956647
　　7 重新生成 EQ1的 控制文件
　　在复制操作中最重要的步骤一个是需要修改参数配置中的相应实例名信息，另一个就是需要删除控制文件，并且重建控制文件时要更改 reuse database old_sid noresetlogs 为 set database new_sid resetlogs.
　　SQL> CREATE SPFILE
　　2  FROM PFILE ='/oracle/EQ1/102_64/dbs/initEQ1.ora';
　　SQL> @/oracle/EQ1/orabrcopy/CONTROL.SQL
　　SQL> alter database open resetlogs;
　　alter database open resetlogs
　　*
　　ERROR at line 1:
　　ORA-01113: file 1 needs media recovery
　　ORA-01110: data file 1: '/oracle/EQ1/sapdata1/system_1/system.data1'
　　8 打开oracle 数据库
　　SQL> shutdown immediate
　　ORA-01109: database not open
　　
　　
　　Database dismounted.
　　ORACLE instance shut down.
　　SQL> startup mount
　　ORACLE instance started.
　　
　　Total System Global Area 1.1677E+10 bytes
　　Fixed Size                  2103672 bytes
　　Variable Size            5855250056 bytes
　　Database Buffers         5804916736 bytes
　　Redo Buffers               14671872 bytes
　　Database mounted.
　　SQL> recover datafiel '/oracle/EQ1/sapdata1/system_1/system.data1'
　　ORA-00905: missing keyword
　　
　　
　　SQL> alter database open resetlogs;
　　alter database open resetlogs
　　*
　　ERROR at line 1:
　　ORA-01113: file 1 needs media recovery
　　ORA-01110: data file 1: '/oracle/EQ1/sapdata1/system_1/system.data1'
　　
　　
　　SQL> recover database until cancel;
　　ORA-00283: recovery session canceled due to errors
　　ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
　　
　　
　　SQL> recover database using backup controlfile until cancel;
　　ORA-00279: change 2240956647 generated at 04/19/2012 18:39:56 needed for thread
　　1
　　ORA-00289: suggestion : /oracle/EQ1/oraarch/EQ1arch1_118074_737031978.dbf
　　ORA-00280: change 2240956647 for thread 1 is in sequence #118074
　　
　　
　　Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
　　cncel
　　ORA-00308: cannot open archived log 'cncel'
　　ORA-27037: unable to obtain file status
　　IBM AIX RISC System/6000 Error: 2: No such file or directory
　　Additional information: 3
　　
　　
　　Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
　　CANCEL
　　Media recovery cancelled.
　　SQL> alter database open resetlogs;
　　
　　Database altered.
　　数据库恢复完成
　　
　　Sap 系统 检查
　　R3trans –d
　　发现用户密码错误
　　重置 SAPSR3
　　密码
　　SQL> select owner from dba_tables where table_name = 'SAPUSER';
　　
　　OWNER
　　------------------------------
　　OPS$EP1ADM
　　
　　SQL> SELECT USERNAME FROM DBA_USERS;
　　
　　USERNAME
　　------------------------------
　　OPS$SAPSERVICEEP1
　　MGMT_VIEW
　　OPS$EP1ADM
　　OPS$ORAEP1
　　SYS
　　SYSTEM
　　DBSNMP
　　SYSMAN
　　K3USER
　　SAPSR3
　　OUTLN
　　
　　USERNAME
　　------------------------------
　　TSMSYS
　　DIP
　　ORACLE_OCM
　　
　　14 rows selected.
　　SQL> ALTER USER SAPSR3 IDENTIFIED BY sap;
　　
　　User altered.
　　SAP 系统可以启动
　　sapqas01:/oracle/EQ1/orabrcopy#su - oraeq1
　　sapqas01:oraeq1 1> sqlplus /nolog @/oracle/EQ1/orabrcopy/ORADBUSR.SQL SAPR3 UNIX SAP_EQ1 x
　　
　　SQL*Plus: Release 10.2.0.4.0 - Production on Wed Apr 25 16:07:49 2012
　　
　　Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
　　
　　Connected.
　　old   6:   if length('&&1') = 5 then
　　new   6:   if length('SAPR3') = 5 then
　　old   7:     if substr(upper('&&1'),1,5) = 'SAPR3' then
　　new   7:     if substr(upper('SAPR3'),1,5) = 'SAPR3' then
　　old  11:       if upper('&&2') = 'NT' then
　　new  11:       if upper('UNIX') = 'NT' then
　　old  18:        :sDomain := upper('&&3');
　　new  18:        :sDomain := upper('SAP_EQ1');
　　old  19:         :sSapSid := upper('&&4');
　　new  19:         :sSapSid := upper('x');
　　old  21:         :sSapSid := upper('&&3');
　　new  21:         :sSapSid := upper('SAP_EQ1');
　　old  37:     :sSchema := upper('&&1');
　　new  37:     :sSchema := upper('SAPR3');
　　old  39:     if upper('&&2') = 'NT' then
　　new  39:     if upper('UNIX') = 'NT' then
　　old  46:       :sDomain := upper('&&3');
　　new  46:       :sDomain := upper('SAP_EQ1');
　　old  47:       :sSapSid := upper('&&4');
　　new  47:       :sSapSid := upper('x');
　　old  49:       :sSapSid := upper('&&3');
　　new  49:       :sSapSid := upper('SAP_EQ1');
　　using following Parameters:
　　.
　　.  Oracle Version:                     10.2.0.4.0
　　.  Parametervalue os_authent_prefix:   OPS$
　　.  Schema Id:                          SR3
　　.  Database User (Schema):             SAPR3
　　.  SAP R/3 Administrator:              OPS$SAP_EQ1ADM
　　.  SAP R/3 Serviceuser:                OPS$SAPSERVICESAP_EQ1
　　.
　　Connected.
　　Connected.
　　Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
　　With the Partitioning, Data Mining and Real Application Testing options