sap环境rman恢复
原系统
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 5DATABASE 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 过来
这里遭遇oracle10 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
2FROM 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
old11: if upper('&&2') = 'NT' then
new11: if upper('UNIX') = 'NT' then
old18: :sDomain := upper('&&3');
new18: :sDomain := upper('SAP_EQ1');
old19: :sSapSid := upper('&&4');
new19: :sSapSid := upper('x');
old21: :sSapSid := upper('&&3');
new21: :sSapSid := upper('SAP_EQ1');
old37: :sSchema := upper('&&1');
new37: :sSchema := upper('SAPR3');
old39: if upper('&&2') = 'NT' then
new39: if upper('UNIX') = 'NT' then
old46: :sDomain := upper('&&3');
new46: :sDomain := upper('SAP_EQ1');
old47: :sSapSid := upper('&&4');
new47: :sSapSid := upper('x');
old49: :sSapSid := upper('&&3');
new49: :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
页:
[1]