SAP 环境中 rman 异机恢复

最新推荐文章于 2021-04-13 20:00:07 发布
最新推荐文章于 2021-04-13 20:00:07 发布
阅读量185 收藏
点赞数
文章标签： 数据库 网络 php

感谢 莫贵阳提供的 备份脚本

原系统

 

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: {=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: {=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

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17315917/viewspace-732275/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17315917/viewspace-732275/

cmkbikj07770595
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
RMAN 还原与恢复
fsfsdfsdw的博客
11-08 227
RMAN 还原与恢复
oracle sap 备份,SAP 使用brtools+rman备份方法
weixin_30737027的博客
04-12 579
使用brtools+rman备份方法：rman备份是基于block级的备份，他只对有数据的blocke备份；另外，rman可以采用多channel备份，这样可以同时开多个session进行备份(当然，这需要磁带库的drive数据量与sap的.sap配置相匹配)一、准备工作1.修改initSID.utl配置文件，修改rman_channel数testracle >vi initSID.utl ...
Oracle RMAN for SAP
12-27
Oracle RMAN for SAP best practice
SAP的异机恢复 转
01-03 365
是HPUX的 SAP+Oracle9i1，安装操作系统2，备份软件安装3，创建用户和组4，恢复SAP的软件5，恢复数据6，修改主机名7，ok 恢复SAP的软件，怎么做的 使用brrestore ...
oracle rman信道,oracle技术之Rman管理命令
weixin_35749786的博客
04-13 149
一、相关查询命令1.List 当前RMAN所备份的数据库RMAN> list incarnation;汇总查询：–如果备份文件多的话多用这两个list命令可以对备份文件有个总体了解。1.1. list backup summary; –概述可用的备份B 表示backupA 表示Archivelog、 F 表示full backup、 0,1,2 表示incremental level备份A ...
rman异机恢复流程.txt
02-06
使用Rman工具异机恢复oracle数据库，实例教程 ------------------------------------- ------------------------------------- 备份方法 修改路径 恢复方法
RMAN异机恢复手册珍藏版
04-25
oracle 数据库rman大家都懂的如何在异机进行恢复完整珍藏版手册，分项给大家多多打赏。
rman恢复方案和oracle异机恢复
09-10
主要介绍了rman恢复方案和oracle异机恢复,需要的朋友可以参考下
rac rman异机恢复
10-31
最详细的单机坏境恢复rac备份集，只要按步骤一步一步操作，绝对成功
数据库异机恢复(RMAN)
05-10
数据库异机恢复(RMAN) 作为数据库管理员，数据库异机恢复是非常重要的一个话题。在生产环境中，数据库的可用性和数据的安全性是首要考虑的。RMAN（Recovery Manager）是一个强大的工具，可以帮助我们实现数据库的...
sap brtools发起oracle备份失败，tsm备份软件备份报错
congbu2030的博客
08-13 160
brtools报错信息如下： BKI4008E: File '/oracle/M51/sapdata3/sr3_11/sr3.data11' cannot be opened. Reason: errno(22)...
SAP HANA命令行方式备份恢复
热门推荐
Neo
11-22 1万+
hana数据库命令行备份和恢复 1. hana数据库分为两大类即为租户库和系统库 2. 常用命令 1>hdbsql -n localhost -i 90 -d SystemDB -u SYSTEM -p Suj000123 -x -n 表示连接的主机 -i 实例编号 -d 指定是系统库还是租户库(默认是租户库) -u 指定数据库的用户名 -p 指定数据库的密码 -x 后面可以执行相应的sql...
brtools备份与恢复
weixin_34368949的博客
05-01 393
brtools是sap自带的一个备份和恢复工具，可以单独安装，用这个工具来做备份与恢复比较方便。 一、备份过程 C:\Documents and Settings\bwdevadm>brtools BR0651I BRTOOLS 7.00 (24) BR0280I BRTOOLS time stamp: 2012-04-11 14.11.57 BR0656I Choice menu...
rman备份恢复详细方案和介绍
Brent的专栏
06-28 1万+
文档下载地址:https://download.csdn.net/download/su377486/11262567 备份工具 rman简介 RMAN（Recovery Manager）是随Oracle服务器软件一同安装的工具软件，它可以用来备份和恢复数据库文件、归档日志和控制文件，用来执行完全或不完全的数据库恢复。与传统工具相比，RMAN具有独特的优势：跳过未使...
RMAN duplicate之基于备份，具有目标连接
技术成就梦想
04-21 715
简单介绍一下，RMAN duplicate 数据库可以使用活动的数据库，也可以使用备份，基于备份的又分为具有目标连接和没有目标连接，具体如下图所示。本列中是基于RMAN备份的且具有目标连接。   目标数据库 ，即需要被duplicate的数据库   IP为192.168.221.201    实例名sap 复制数据库 ，即duplicate生成的数据库    IP为1
Oracle数据库备份与恢复 - RMAN备份
田攀的日志
07-05 8360
如果要说DBA工作中最重要的职责（没有之一），那无疑就是保证客户数据的安全和完整，可以看到几乎任何一本Oracle DBA的技术书籍一定都会把大篇幅来介绍数据库的备份与恢复，从中也可以看到备份和恢复的重要程度。eygle曾经总结了DBA生存之四大守则的第一条就是：备份重于一切我们必需知道,系统总是要崩溃的，没有有效的备份只是等哪一天死！我经常开玩笑的说,唯一会使DBA在梦中惊醒的就是,没有有效的备
IBM TSM 5.5下跨机恢复Oracle数据库
技术成就梦想
09-14 971
IBM TSM 5.5下跨机恢复Oracle数据库，通过TSM备份软件，将A机的数据库恢复到B机器上。 实验环境： A机上运行Oracle 10.2.0.4，使用TSM for database 5.5.1对oracle进行了full db备份，包含了归档日志。 B机上安装了Oracle 10.2.0.4代码。希望将A的数据库恢复到B上，因为A机硬件出现了问题。安装TSM for
adm100练习3-启动SAP
weixin_34116110的博客
01-20 199
1.使用MMC启动SAP系统。监控系统启动过程。 步骤： 1.通过桌面的快捷方式打开MMC控制台 2.在MMC树形列表中，选择中心实例节点，选择右键菜单中的启动(start)按钮启动。在中心实例启动完成之后，以同样方法启动会话实例(如果有的话) 2.在系统启动之后，那些类型的进程在操作系统级启动？ 步骤：通过进程管理器可以发现系统启动之后...
sap使用DB13和brtools发起oracle数据库备份
congbu2030的博客
08-15 384
sap版本：erp6.0 sap所使用数据库版本：oracle 11g 修改配置文件/oracle/X01/11202/dbs/initX.sap，只需修改一下几处，其他默认...
oracle rman 异机恢复单个PDB详细步骤
最新发布
03-28
以下是Oracle RMAN 异机恢复单个PDB的详细步骤： 1. 确认备份文件及目标数据库的情况。...以上就是Oracle RMAN 异机恢复单个PDB的详细步骤，需要注意的是，在恢复过程中需要仔细阅读RMAN的提示信息，及时处理错误。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值