免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
› 论坛 › IT运维 › 存储备份 › SAP R/3 Disaster Recovery 测试步骤
最近访问板块 发新帖
查看: 6093 | 回复: 6
打印 上一主题 下一主题

SAP R/3 Disaster Recovery 测试步骤 [复制链接]

Chinese_Dragon

论坛徽章:
0
跳转到指定楼层
1楼 [收藏(0)] [报告]
发表于 2008-01-17 17:08 |只看该作者 |倒序浏览
SAP R/3 Disaster Recovery  测试步骤

Place : CNC Beijing branch Headquarters
OS : Solaris 5.9
SAP Version: SAP R/3   4.7  . DB: 9.2.0.1
Participator: Eric Zhang
Date: 2005/07/25


1. Install Solaris 5.9 Operating System

2. Install SAP R/3
#sapinst   
(copy all CDs to local directories .)
Install CI, and DB , do not load data (while prompt to let you load data, cancel and exit )
(I remember we choice the DB backup and recovery option)


3. Copy the following files from production machine to Testing machine:
1 - Backup profile (profile) ........ [/oracle/PD3/920_64/dbs/initPD3.sap]
2 ~ BACKINT/Mount profile (parfile) . [/oracle/PD3/920_64/dbs/initPD3.utl]

4. from the testing machine ,Install Legato Networker Storage Node and SAP Module.
  and Configure the SAP Module .


5. Option: you can create some required directories first , or by prompt later
  
such as : /oracle/PD3/sapbackup/
example:
=====
root@sapprd3a # cd /oracle/PD3
root@sapprd3a # mkdir sapbackup
root@sapprd3a # chmod 777 sapbackup
root@sapprd3a # mkdir saparch
root@sapprd3a # chmod 777 saparch
root@sapprd3a # mkdir sapcheck
root@sapprd3a # chmod 777 sapcheck

//CAUTION:   sometimes, the Restore report errors, maybe some directories you have not created .


6. Using 'orapd3' user . to execute $brtools utility
//GOAL : to recover the SAP init file and oracle init file and the timestampe file .

apprd3arapd3 11% brtools

BR651I BRTOOLS 6.20 (113)
BR280I Time stamp 2005-07-26 14.29.12
BR656I Choice menu 1 - please make a selection
-------------------------------------------------------------------------------
BR*Tools main menu
1 = Backup and database copy

2 - Restore and recovery

3 - Check and verification

4 - Database statistics

5 - Profiles and logs

6 - Additional functions

7 - Exit program



Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR662I Enter your choice:

2

BR280I Time stamp 2005-07-26 14.29.16

BR663I Your choice: '2'



BR280I Time stamp 2005-07-26 14.29.16

BR656I Choice menu 11 - please make a selection

-------------------------------------------------------------------------------

Restore and recovery



1 = Complete database recovery

2 - Database point-in-time recovery

3 - Tablespace point-in-time recovery

4 - Whole database reset

5 - Restore of individual backup files

6 - Restore and application of archivelog files

7 - Disaster recovery

8 - Reset input values



Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR662I Enter your choice:

7

BR280I Time stamp 2005-07-26 14.29.32

BR663I Your choice: '7'



BR280I Time stamp 2005-07-26 14.29.32

BR657I Input menu 35 - please check/enter input values

-------------------------------------------------------------------------------

BRRECOVER options for disaster recovery



1 ~ BRRECOVER profile (profile) ...... [initPD3.sap]

2 - Restore device type (device) ..... [util]

3 - BACKINT/Mount profile (parfile) .. [/oracle/PD3/920_64/dbs/initPD3.utl]

4 - Confirmation mode (confirm) ...... [yes]

5 - Recovery interval (interval) ..... [30]

6 - Scrolling line count (scroll) .... [20]

7 - Message language (language) ...... [E]

8 - BRRECOVER command line (command) . [-t disaster -p initPD3.sap -d util -r /oracle/PD3/920_64/dbs/initPD3.utl -i 30 -s 20 -l E]



Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR662I Enter your choice:

c

BR280I Time stamp 2005-07-26 14.29.43

BR663I Your choice: 'c'

BR259I Program execution will be continued...



BR291I BRRECOVER will be started with options '-t disaster -p initPD3.sap -d util -r /oracle/PD3/920_64/dbs/initPD3.utl -i 30 -s 20 -l E'



BR280I Time stamp 2005-07-26 14.29.43

BR670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR280I Time stamp 2005-07-26 14.29.50

BR257I Your reply: 'c'

BR259I Program execution will be continued...



+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

BR701I BRRECOVER 6.20 (113)

BR705I Start of database recovery: vdqmbmyw.drv 2005-07-26 14.29.50



BR280I Time stamp 2005-07-26 14.29.50

BR707I Recovery of database: PD3

BR708I BRRECOVER action ID: vdqmbmyw

BR709I BRRECOVER function ID: drv

BR710I Recovery type: disaster



BR280I Time stamp 2005-07-26 14.29.50

BR656I Choice menu 136 - please make a selection

-------------------------------------------------------------------------------

Disaster recovery main menu



1 = Restore profiles and log files from BRBACKUP backup

2 - Restore profiles and log files from BRARCHIVE backup

3 * Exit program

4 - Reset input values



Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR662I Enter your choice:

1

BR280I Time stamp 2005-07-26 14.29.57

BR663I Your choice: '1'



BR280I Time stamp 2005-07-26 14.29.57

BR656I Choice menu 137 - please make a selection

-------------------------------------------------------------------------------

Device type for restoring profiles and log files from BRBACKUP backup



1 - Local tape

2 - Remote tape

3 - Local disk

4 - Remote disk

5 = Backup utility



Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR662I Enter your choice:

5

BR280I Time stamp 2005-07-26 14.30.01

BR663I Your choice: '5'



BR280I Time stamp 2005-07-26 14.30.01

BR657I Input menu 144 - please check/enter input values

-------------------------------------------------------------------------------

Parameters for restoring profiles and log files from BRBACKUP backup utility



1 - Backup profile (profile) ........ [/oracle/PD3/920_64/dbs/initPD3.sap]

2 ~ BACKINT/Mount profile (parfile) . [/oracle/PD3/920_64/dbs/initPD3.utl]



Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR662I Enter your choice:

c

BR280I Time stamp 2005-07-26 14.30.04

BR663I Your choice: 'c'

BR259I Program execution will be continued...



BR428W File /oracle/PD3/920_64/dbs/initPD3.sap might be overwritten

BR428W File /oracle/PD3/920_64/dbs/initPD3.ora might be overwritten

BR428W File /oracle/PD3/920_64/dbs/initPD3.dba might be overwritten

BR428W File /oracle/PD3/920_64/dbs/initPD3.utl might be overwritten

BR428W File /oracle/PD3/sapbackup/backPD3.log might be overwritten

BR428W File /oracle/PD3/sapreorg/reorgPD3.log might be overwritten

BR428W File /oracle/PD3/sapreorg/structPD3.log might be overwritten



BR668I Warnings or errors occured - you can continue to ignore them or go back to repeat the last action

BR280I Time stamp 2005-07-26 14.30.04

BR670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR280I Time stamp 2005-07-26 14.30.10

BR257I Your reply: 'c'

BR259I Program execution will be continued...



BR280I Time stamp 2005-07-26 14.30.10

BR657I Input menu 145 - please check/enter input values

-------------------------------------------------------------------------------

Restore of profiles and log files from BRBACKUP backup



1 - Backup profile (init_sap) ......... [no]

2 - Oracle profile (init_ora) ......... [no]

3 - SAPDBA profile (init_dba) ......... [no]

4 - BACKINT/Mount profile (init_utl) .. [no]

5 - Detail log (det_log) .............. [yes]

6 - Summary log (sum_log) ............. [no]

7 - SAPDBA central log (reorg_log) .... [no]

8 - SAPDBA structure log (struct_log) . [no]

9 # Control file copy (control_file) .. [no]



Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR662I Enter your choice:

c

BR280I Time stamp 2005-07-26 14.30.16

BR663I Your choice: 'c'

BR259I Program execution will be continued...



BR746I File /oracle/PD3/sapbackup/det_log will be restored from BACKINT



BR280I Time stamp 2005-07-26 14.30.16

BR670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR280I Time stamp 2005-07-26 14.30.19

BR257I Your reply: 'c'

BR259I Program execution will be continued...



BR699I Reading log file /oracle/PD3/sapbackup/backPD3.log ...



BR280I Time stamp 2005-07-26 14.30.19

BR659I List menu 146 + please select one or more entries

-------------------------------------------------------------------------------

Restore of BRBACKUP detail logs



Pos.  Log           Start                Type        Mode        Device     Rc



  1 = bdqlxxxm.anf  2005-07-25 21.01.26  online      all         util_onl    9

  2 - bdqltacr.anf  2005-07-24 21.01.33  online      all         util_onl    1

  3 - bdqlochx.anf  2005-07-23 21.01.41  online      all         util_onl    1

  4 - bdqljend.anf  2005-07-22 21.01.49  online      all         util_onl    1

  5 - bdqlegsl.anf  2005-07-21 21.01.59  online      all         util_onl    1

  6 - bdqkzixw.anf  2005-07-20 21.02.12  online      all         util_onl    1

  7 - bdqkulcx.anf  2005-07-19 21.02.15  online      all         util_onl    1

  8 - bdqkpnie.anf  2005-07-18 21.02.24  online      all         util_onl    1

  9 - bdqkatxx.anf  2005-07-15 21.02.49  online      all         util_onl    1

10 - bdqjvwdf.anf  2005-07-14 21.02.59  online      all         util_onl    1

11 - bdqjqyim.anf  2005-07-13 21.03.08  online      all         util_onl    1

12 - bdqjmanr.anf  2005-07-12 21.03.15  online      all         util_onl    1

13 - bdqjhcsz.anf  2005-07-11 21.03.25  online      all         util_onl    1

14 - bdqjceyg.anf  2005-07-10 21.03.34  online      all         util_onl    1

15 - bdqixhdk.anf  2005-07-09 21.03.40  online      all         util_onl    1

16 - bdqisjir.anf  2005-07-08 21.03.49  online      all         util_onl    1

17 - bdqinloa.anf  2005-07-07 21.04.00  online      all         util_onl    1

18 - bdqiinth.anf  2005-07-06 21.04.09  online      all         util_onl    1

19 - bdqidpyn.anf  2005-07-05 21.04.17  online      all         util_onl    1

20 - bdqiczae.anf  2005-07-05 17.53.28  online      all         util_onl    1



Press <Rtn> to scroll, <n> to select, 'c' to continue, 's' to stop scrolling...

1

BR280I Time stamp 2005-07-26 14.30.38

BR663I Your selection: '1'



BR746I File /oracle/PD3/sapbackup/bdqlxxxm.anf will be restored from BACKINT



BR280I Time stamp 2005-07-26 14.30.38

BR229I Calling backup utility...



BR280I Time stamp 2005-07-26 14.33.53

#FILE..... /oracle/PD3/sapbackup/bdqlxxxm.anf

#RESTORED. 1122300817



BR280I Time stamp 2005-07-26 14.33.53

BR374I 1 of 1 file restored by backup utility

BR230I Backup utility called successfully



BR749I 1 file has been successfully restored



BR280I Time stamp 2005-07-26 14.33.53

BR670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

s

$

//CAUTION:  'bdqlxxxm.anf' is the timestamp file .
Chinese_Dragon

论坛徽章:
0
2楼 [报告]
发表于 2008-01-17 17:10 |只看该作者
7. $brrestore -verify
//the command Must be execute ok to go deep further .


8. $brrestore -b  bdqlxxxm.anf -m full
// TO Do a full restore
//CAUTION: the step , maybe you will wait a little long time to see the Legato pick up Tapes for Restore . very slowly.


NOTES:
If you found that the restore speed is very slowly . maybe you should modify the /etc/system to tuning the performance .



//CAUTION:
SAP R/3 Oracle udump directory :       /oracle/PD3/saptrace/usertrace
SAP R/3 Oracle bdump directory :       /oracle/PD3/saptrace/background

Restore SAP R/3 :
maybe you should create the directories, and give them 777 permission :
/oracle/PD3/saptrace/usertrace
/oracle/PD3/saptrace/background
/oracle/PD3/originalA
/oracle/PD3/originalB
/oracle/PD3/mirrlogA
/oracle/PD3/mirrlogB

while  restoring  the SAP R/3 , you should often check the following logs
/oracle/PD3/sapbackup/backPD3.log
/oracle/PD3/sapbackup/bdqlxxxm.anf(*.anf)


//Restore   sum_log:

sapprd3a:orapd3 24% brtools
BR651I BRTOOLS 6.20 (113)

BR280I Time stamp 2005-07-28 15.44.42
BR656I Choice menu 1 - please make a selection
-------------------------------------------------------------------------------
BR*Tools main menu

1 = Backup and database copy
2 - Restore and recovery
3 - Check and verification
4 - Database statistics
5 - Profiles and logs
6 - Additional functions
7 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR662I Enter your choice:
2
BR280I Time stamp 2005-07-28 15.44.44
BR663I Your choice: '2'

BR280I Time stamp 2005-07-28 15.44.44
BR656I Choice menu 11 - please make a selection
-------------------------------------------------------------------------------
Restore and recovery

1 = Complete database recovery
2 - Database point-in-time recovery
3 - Tablespace point-in-time recovery
4 - Whole database reset
5 - Restore of individual backup files
6 - Restore and application of archivelog files
7 - Disaster recovery
8 - Reset input values

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR662I Enter your choice:
7
BR280I Time stamp 2005-07-28 15.44.45
BR663I Your choice: '7'

BR280I Time stamp 2005-07-28 15.44.45
BR657I Input menu 35 - please check/enter input values
-------------------------------------------------------------------------------
BRRECOVER options for disaster recovery

1 ~ BRRECOVER profile (profile) ...... [initPD3.sap]
2 - Restore device type (device) ..... [util]
3 - BACKINT/Mount profile (parfile) .. [/oracle/PD3/920_64/dbs/initPD3.utl]
4 - Confirmation mode (confirm) ...... [yes]
5 - Recovery interval (interval) ..... [30]
6 - Scrolling line count (scroll) .... [20]
7 - Message language (language) ...... [E]
8 - BRRECOVER command line (command) . [-t disaster -p initPD3.sap -d util -r /oracle/PD3/920_64/dbs/initPD3.utl -i 30 -s 20 -l E]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR662I Enter your choice:
c
BR280I Time stamp 2005-07-28 15.44.48
BR663I Your choice: 'c'
BR259I Program execution will be continued...

BR291I BRRECOVER will be started with options '-t disaster -p initPD3.sap -d util -r /oracle/PD3/920_64/dbs/initPD3.utl -i 30 -s 20 -l E'

BR280I Time stamp 2005-07-28 15.44.48
BR670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR280I Time stamp 2005-07-28 15.44.50
BR257I Your reply: 'c'
BR259I Program execution will be continued...

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
BR701I BRRECOVER 6.20 (113)
BR705I Start of database recovery: vdqmlpgc.drv 2005-07-28 15.44.50

BR280I Time stamp 2005-07-28 15.44.50
BR707I Recovery of database: PD3
BR708I BRRECOVER action ID: vdqmlpgc
BR709I BRRECOVER function ID: drv
BR710I Recovery type: disaster

BR280I Time stamp 2005-07-28 15.44.50
BR656I Choice menu 136 - please make a selection
-------------------------------------------------------------------------------
Disaster recovery main menu

1 = Restore profiles and log files from BRBACKUP backup
2 - Restore profiles and log files from BRARCHIVE backup
3 * Exit program
4 - Reset input values

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR662I Enter your choice:
2
BR280I Time stamp 2005-07-28 15.44.54
BR663I Your choice: '2'

BR280I Time stamp 2005-07-28 15.44.54
BR656I Choice menu 137 - please make a selection
-------------------------------------------------------------------------------
Device type for restoring profiles and log files from BRARCHIVE backup

1 - Local tape
2 - Remote tape
3 - Local disk
4 - Remote disk
5 = Backup utility

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR662I Enter your choice:
5
BR280I Time stamp 2005-07-28 15.44.57
BR663I Your choice: '5'

BR280I Time stamp 2005-07-28 15.44.57
BR657I Input menu 144 - please check/enter input values
-------------------------------------------------------------------------------
Parameters for restoring profiles and log files from BRARCHIVE backup utility

1 - Backup profile (profile) ........ [/oracle/PD3/920_64/dbs/initPD3.sap]
2 ~ BACKINT/Mount profile (parfile) . [/oracle/PD3/920_64/dbs/initPD3.utl]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR662I Enter your choice:
c
BR280I Time stamp 2005-07-28 15.45.02
BR663I Your choice: 'c'
BR259I Program execution will be continued...

BR428W File /oracle/PD3/920_64/dbs/initPD3.sap might be overwritten
BR428W File /oracle/PD3/920_64/dbs/initPD3.ora might be overwritten
BR428W File /oracle/PD3/920_64/dbs/initPD3.dba might be overwritten
BR428W File /oracle/PD3/920_64/dbs/initPD3.utl might be overwritten
BR428W File /oracle/PD3/sapreorg/reorgPD3.log might be overwritten
BR428W File /oracle/PD3/sapreorg/structPD3.log might be overwritten

BR668I Warnings or errors occured - you can continue to ignore them or go back to repeat the last action
BR280I Time stamp 2005-07-28 15.45.02
BR670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR280I Time stamp 2005-07-28 15.45.05
BR257I Your reply: 'c'
BR259I Program execution will be continued...

BR280I Time stamp 2005-07-28 15.45.05
BR657I Input menu 145 - please check/enter input values
-------------------------------------------------------------------------------
Restore of profiles and log files from BRARCHIVE backup

1 - Backup profile (init_sap) ......... [no]
2 - Oracle profile (init_ora) ......... [no]
3 - SAPDBA profile (init_dba) ......... [no]
4 - BACKINT/Mount profile (init_utl) .. [no]
5 - Detail log (det_log) .............. [no]
6 - Summary log (sum_log) ............. [yes]
7 - SAPDBA central log (reorg_log) .... [no]
8 - SAPDBA structure log (struct_log) . [no]
9 - Control file copy (control_file) .. [no]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR662I Enter your choice:
6
BR280I Time stamp 2005-07-28 15.45.20
BR663I Your choice: '6'

BR280I Time stamp 2005-07-28 15.45.20
BR681I Enter string value for "sum_log" (yes|no) [yes]:

BR280I Time stamp 2005-07-28 15.45.24
BR686I The value of "sum_log" was not changed

BR280I Time stamp 2005-07-28 15.45.24
BR657I Input menu 145 - please check/enter input values
-------------------------------------------------------------------------------
Restore of profiles and log files from BRARCHIVE backup

1 - Backup profile (init_sap) ......... [no]
2 - Oracle profile (init_ora) ......... [no]
3 - SAPDBA profile (init_dba) ......... [no]
4 - BACKINT/Mount profile (init_utl) .. [no]
5 - Detail log (det_log) .............. [no]
6 - Summary log (sum_log) ............. [yes]
7 - SAPDBA central log (reorg_log) .... [no]
8 - SAPDBA structure log (struct_log) . [no]
9 - Control file copy (control_file) .. [no]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR662I Enter your choice:
c
BR280I Time stamp 2005-07-28 15.45.32
BR663I Your choice: 'c'
BR259I Program execution will be continued...

BR746I File /oracle/PD3/saparch/archPD3.log will be restored from BACKINT

BR280I Time stamp 2005-07-28 15.45.32
BR670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR280I Time stamp 2005-07-28 15.45.37
BR257I Your reply: 'c'
BR259I Program execution will be continued...

BR280I Time stamp 2005-07-28 15.45.37
BR229I Calling backup utility...

BR280I Time stamp 2005-07-28 15.48.44
#FILE..... /oracle/PD3/saparch/archPD3.log
#RESTORED. 1122366974

BR280I Time stamp 2005-07-28 15.48.44
BR374I 1 of 1 file restored by backup utility
BR230I Backup utility called successfully

BR749I 1 file has been successfully restored


// And After you restored the 'sum_log' file , you can vi it and get the log sequence .

vi /oracle/PD3/saparch/archPD3.log



Restore SAP R/3 oracle Archive log :

sapprd3a:orapd3 8% brrestore -a 3694 -3708
BR401I BRRESTORE 6.20 (113)
BR169I Value 'util_file_online' of parameter/option 'backup_dev_type/-d' ignored for 'brarchive' - 'util_file' assumed
BR405I Start of file restore: rdqmlpzu.rsa 2005-07-28 15.53.22
BR461W Redo log sequence number in line 88 of /oracle/PD3/saparch/archPD3.log not ascending
BR462W All lines in /oracle/PD3/saparch/archPD3.log till line 88 will be ignored
BR461W Redo log sequence number in line 267 of /oracle/PD3/saparch/archPD3.log not ascending
BR462W All lines in /oracle/PD3/saparch/archPD3.log till line 267 will be ignored
BR459W Backup adqmbxtc.svd terminated with errors

BR414I Offline redo log files for restore from database instance PD3:
3694,3695,3696,3697,3698,3699,3700,3701,3702,3703,
3704,3705,3706,3707,3708
BR280I Time stamp 2005-07-28 15.53.22
BR256I Enter 'c[ont]' to continue, 's[top]' to cancel the program:
c
BR280I Time stamp 2005-07-28 15.53.41
BR257I Your reply: 'c'
BR259I Program execution will be continued...

BR280I Time stamp 2005-07-28 15.53.41
BR407I Restore of database: PD3
BR408I BRRESTORE action ID: rdqmlpzu
BR409I BRRESTORE function ID: rsa
BR419I Files will be restored from backup: adqmbxtc.svd 2005-07-26 16.31.16
BR416I 15 files found to restore, total size 1152.372 MB
BR421I Restore device type: util_file
BR280I Time stamp 2005-07-28 15.53.41
BR256I Enter 'c[ont]' to continue, 's[top]' to cancel the program:
c
BR280I Time stamp 2005-07-28 15.53.54
BR257I Your reply: 'c'
BR259I Program execution will be continued...

BR280I Time stamp 2005-07-28 15.53.54
BR229I Calling backup utility...

BR280I Time stamp 2005-07-28 16.04.10
#ARCHIVE.. /oracle/PD3/oraarch/PD3arch1_3705.dbf
#RESTORED. 1122366678

BR280I Time stamp 2005-07-28 16.04.10
#ARCHIVE.. /oracle/PD3/oraarch/PD3arch1_3695.dbf
#RESTORED. 1122366861

BR280I Time stamp 2005-07-28 16.04.10
#ARCHIVE.. /oracle/PD3/oraarch/PD3arch1_3706.dbf
#RESTORED. 1122366870

BR280I Time stamp 2005-07-28 16.04.10
#ARCHIVE.. /oracle/PD3/oraarch/PD3arch1_3697.dbf
#RESTORED. 1122366878

BR280I Time stamp 2005-07-28 16.04.10
#ARCHIVE.. /oracle/PD3/oraarch/PD3arch1_3708.dbf
#RESTORED. 1122366886

BR280I Time stamp 2005-07-28 16.04.10
#ARCHIVE.. /oracle/PD3/oraarch/PD3arch1_3699.dbf
#RESTORED. 1122366894

BR280I Time stamp 2005-07-28 16.04.10
#ARCHIVE.. /oracle/PD3/oraarch/PD3arch1_3696.dbf
#RESTORED. 1122366902

BR280I Time stamp 2005-07-28 16.04.10
#ARCHIVE.. /oracle/PD3/oraarch/PD3arch1_3702.dbf
#RESTORED. 1122366911

BR280I Time stamp 2005-07-28 16.04.10
#ARCHIVE.. /oracle/PD3/oraarch/PD3arch1_3698.dbf
#RESTORED. 1122366920

BR280I Time stamp 2005-07-28 16.04.10
#ARCHIVE.. /oracle/PD3/oraarch/PD3arch1_3707.dbf
#RESTORED. 1122366929

BR280I Time stamp 2005-07-28 16.04.10
#ARCHIVE.. /oracle/PD3/oraarch/PD3arch1_3700.dbf
#RESTORED. 1122366936

BR280I Time stamp 2005-07-28 16.04.10
#ARCHIVE.. /oracle/PD3/oraarch/PD3arch1_3703.dbf
#RESTORED. 1122366944

BR280I Time stamp 2005-07-28 16.04.10
#ARCHIVE.. /oracle/PD3/oraarch/PD3arch1_3704.dbf
#RESTORED. 1122366952

BR280I Time stamp 2005-07-28 16.04.10
#ARCHIVE.. /oracle/PD3/oraarch/PD3arch1_3701.dbf
#RESTORED. 1122366961

BR280I Time stamp 2005-07-28 16.04.10
#ARCHIVE.. /oracle/PD3/oraarch/PD3arch1_3694.dbf
#RESTORED. 1122366969

BR280I Time stamp 2005-07-28 16.04.10
BR374I 15 of 15 files restored by backup utility
BR230I Backup utility called successfully

BR406I End of file restore: rdqmlpzu.rsa 2005-07-28 16.04.10
BR280I Time stamp 2005-07-28 16.04.10
BR403I BRRESTORE terminated successfully with warnings
sapprd3a:orapd3 9%
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
Chinese_Dragon

论坛徽章:
0
3楼 [报告]
发表于 2008-01-17 17:10 |只看该作者
//and when you restore the SAP full backup and the SAP R/3 oracle archive logs , you can apply the archive log and open the Database.


SQL>  startup mount
ORACLE instance started.


SQL> set autorecovery off
SQL> recover database using backup controlfile until cancel
ORA-00279: change 1255582852 generated at 07/25/2005 19:09:26 needed for thread1
ORA-00289: suggestion : /oracle/PD3/oraarch/PD3arch1_3694.dbf
ORA-00280: change 1255582852 for thread 1 is in sequence #3694


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
atuto
ORA-00279: change 1256658762 generated at 07/25/2005 22:13:32 needed for thread
1
ORA-00289: suggestion : /oracle/PD3/oraarch/PD3arch1_3695.dbf
ORA-00280: change 1256658762 for thread 1 is in sequence #3695
ORA-00278: log file '/oracle/PD3/oraarch/PD3arch1_3694.dbf' no longer needed
for this recovery

..............................


SQL> alter database open resetlogs;

Database altered.

SQL> select * from tab;
TNAME                               TABTYPE        CLUSTERID
------------------------------ ------- ----------
ACCESS$                        TABLE
ALL_ALL_TABLES                       VIEW
ALL_APPLY                       VIEW
ALL_APPLY_CONFLICT_COLUMNS     VIEW
ALL_APPLY_DML_HANDLERS               VIEW
ALL_APPLY_ERROR                VIEW
ALL_APPLY_KEY_COLUMNS               VIEW
ALL_APPLY_PARAMETERS               VIEW
ALL_APPLY_PROGRESS               VIEW
ALL_ARGUMENTS                       VIEW
ALL_ASSOCIATIONS               VIEW


//Check   /etc/hosts file before start up the SAP
//Confirm all the IP Address that needed are corrected .




sapprd3a:pd3adm 1% startsap

Checking PD3 Database
------------------------------
Database is running

Starting SAP-Collector Daemon
------------------------------
***********************************************************************
* This is Saposcol Version COLL 20.79 03/08/22 620 - V3.41 64Bit
* Usage:  saposcol -l: Start OS Collector
*         saposcol -k: Stop  OS Collector
*         saposcol -d: OS Collector Dialog Mode
*         saposcol -s: OS Collector Status
* The OS Collector is already running .....
************************************************************************
saposcol already running

Checking PD3 Database
------------------------------
Database is running

Starting SAP Instance DVEBMGS00
------------------------------
Startup-Log is written to /export/home/pd3adm/startsap_DVEBMGS00.log
Instance on host sapprd3a started
IGS on host sapprd3a started

sapprd3a:pd3adm 2% ps -ef|grep sap
    root   555     1  0   Jul 27 console  0:00 /usr/lib/saf/ttymon -g -h -p sapprd3a console login:  -T sun -d /dev/console -l
    root   542     1  0   Jul 27 ?        0:00 /usr/lib/dmi/snmpXdmid -s sapprd3a
  pd3adm  3374  3368  0 16:47:38 pts/9    0:00 /usr/sap/PD3/DVEBMGS00/igs/bin/igsmux_mt -rootdir=/usr/sap/PD3/DVEBMGS00/igs -r
  pd3adm  3305     1  0 16:47:08 ?        0:00 /usr/sap/PD3/SYS/exe/run/sapstart pf=/usr/sap/PD3/SYS/profile/START_DVEBMGS00_s
  pd3adm  3375  3368  0 16:47:39 pts/9    0:00 /usr/sap/PD3/DVEBMGS00/igs/bin/igspw_mt -rootdir=/usr/sap/PD3/DVEBMGS00/igs -no
  pd3adm  3368     1  0 16:47:38 pts/9    0:00 /usr/sap/PD3/DVEBMGS00/igs//bin/igswd_mt -dir=/usr/sap/PD3/DVEBMGS00/igs -mode=
  pd3adm  3376  3368  0 16:47:39 pts/9    0:00 /usr/sap/PD3/DVEBMGS00/igs/bin/igspw_mt -rootdir=/usr/sap/PD3/DVEBMGS00/igs -no
    root  2898     1  0 16:44:07 ?        0:00 /usr/sap/PD3/SYS/exe/run/saposcol
  pd3adm  3324  3305  0 16:47:08 ?        0:00 ms.sapPD3_DVEBMGS00 pf=/usr/sap/PD3/SYS/profile/PD3_DVEBMGS00_sapprd3a
  pd3adm  3325  3305  0 16:47:08 ?        0:01 dw.sapPD3_DVEBMGS00 pf=/usr/sap/PD3/SYS/profile/PD3_DVEBMGS00_sapprd3a
  pd3adm  3326  3305  0 16:47:08 ?        0:00 co.sapPD3_DVEBMGS00 -F pf=/usr/sap/PD3/SYS/profile/PD3_DVEBMGS00_sapprd3a
  pd3adm  3327  3305  0 16:47:08 ?        0:00 se.sapPD3_DVEBMGS00 -F pf=/usr/sap/PD3/SYS/profile/PD3_DVEBMGS00_sapprd3a
  pd3adm  3328  3325  0 16:47:12 ?        0:00 gwrd -dp pf=/usr/sap/PD3/SYS/profile/PD3_DVEBMGS00_sapprd3a
  pd3adm  3329  3325  0 16:47:12 ?        0:01 icman -attach pf=/usr/sap/PD3/SYS/profile/PD3_DVEBMGS00_sapprd3a
  pd3adm  3330  3325  0 16:47:12 ?        0:00 dw.sapPD3_DVEBMGS00 pf=/usr/sap/PD3/SYS/profile/PD3_DVEBMGS00_sapprd3a
  pd3adm  3331  3325  1 16:47:12 ?        0:01 dw.sapPD3_DVEBMGS00 pf=/usr/sap/PD3/SYS/profile/PD3_DVEBMGS00_sapprd3a
  pd3adm  3332  3325  0 16:47:12 ?        0:00 dw.sapPD3_DVEBMGS00 pf=/usr/sap/PD3/SYS/profile/PD3_DVEBMGS00_sapprd3a
  pd3adm  3333  3325  0 16:47:12 ?        0:00 dw.sapPD3_DVEBMGS00 pf=/usr/sap/PD3/SYS/profile/PD3_DVEBMGS00_sapprd3a
  pd3adm  3334  3325  0 16:47:12 ?        0:00 dw.sapPD3_DVEBMGS00 pf=/usr/sap/PD3/SYS/profile/PD3_DVEBMGS00_sapprd3a
  pd3adm  3335  3325  0 16:47:12 ?        0:00 dw.sapPD3_DVEBMGS00 pf=/usr/sap/PD3/SYS/profile/PD3_DVEBMGS00_sapprd3a
  pd3adm  3336  3325  0 16:47:13 ?        0:00 dw.sapPD3_DVEBMGS00 pf=/usr/sap/PD3/SYS/profile/PD3_DVEBMGS00_sapprd3a
  pd3adm  3337  3325  0 16:47:13 ?        0:00 dw.sapPD3_DVEBMGS00 pf=/usr/sap/PD3/SYS/profile/PD3_DVEBMGS00_sapprd3a
  pd3adm  3380  3072  0 16:47:44 pts/9    0:00 grep sap

sapprd3a:pd3adm 4% ps -ef|grep ora
  orapd3   698   689  0   Jul 27 pts/4    0:00 -csh
  orapd3  1145  1131  0 09:33:23 pts/6    0:00 -csh
  orapd3  1587  1406  0 15:36:16 pts/9    0:00 -csh
  orapd3  1697  1587  0 15:36:22 pts/9    0:00 sqlplus / as sysdba
  orapd3  1698  1697  0 15:36:22 ?        0:11 oraclePD3 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  orapd3  1715  1697  0 15:36:56 pts/9    0:00 /bin/csh
  orapd3  1787  1715  0 15:41:01 pts/9    0:00 sqlplus / as sysdba
  orapd3  1788  1787  0 15:41:01 ?        0:06 oraclePD3 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  orapd3  2025  1805  0 15:49:47 pts/9    0:00 sqlplus / as sysdba
  orapd3  1805  1787  0 15:41:27 pts/9    0:00 /bin/csh
  orapd3  2280  2025  0 16:06:02 ?        0:34 oraclePD3 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  orapd3  2274     1  0 16:05:56 ?        0:00 ora_reco_PD3
  orapd3  2264     1  0 16:05:55 ?        0:00 ora_pmon_PD3
  orapd3  2266     1  0 16:05:55 ?        0:33 ora_dbw0_PD3
  orapd3  2346  2025  0 16:35:04 pts/9    0:00 /bin/csh
  orapd3  2268     1  0 16:05:55 ?        0:12 ora_lgwr_PD3
  orapd3  2270     1  0 16:05:55 ?        0:01 ora_ckpt_PD3
  orapd3  2272     1  0 16:05:56 ?        0:00 ora_smon_PD3
  orapd3  2276     1  0 16:05:56 ?        0:02 ora_arc0_PD3
  orapd3  2278     1  0 16:05:56 ?        0:00 ora_arc1_PD3
  orapd3  2534  2255  0 16:38:25 pts/11   0:00 -csh
  orapd3  2649     1  0 16:40:00 ?        0:00 ora_p000_PD3
  orapd3  2651     1  0 16:40:00 ?        0:00 ora_p001_PD3
  orapd3  2653     1  0 16:40:00 ?        0:00 ora_p002_PD3
  orapd3  2655     1  0 16:40:00 ?        0:00 ora_p003_PD3
  orapd3  2657     1  1 16:40:00 ?        0:27 ora_p004_PD3
  orapd3  3065     1  0 16:44:58 ?        0:00 /oracle/PD3/920_64/bin/tnslsnr LISTENER -inherit
  pd3adm  3385  3072  0 16:48:11 pts/9    0:00 grep ora
  orapd3  3339     1  0 16:47:13 ?        0:00 oraclePD3 (DESCRIPTION=(LOCAL=NO)(SDU=32768))
  orapd3  3341     1  1 16:47:13 ?        0:03 oraclePD3 (DESCRIPTION=(LOCAL=NO)(SDU=32768))
  orapd3  3343     1  0 16:47:13 ?        0:00 oraclePD3 (DESCRIPTION=(LOCAL=NO)(SDU=32768))
  orapd3  3345     1  0 16:47:13 ?        0:00 oraclePD3 (DESCRIPTION=(LOCAL=NO)(SDU=32768))
  orapd3  3347     1  0 16:47:13 ?        0:00 oraclePD3 (DESCRIPTION=(LOCAL=NO)(SDU=32768))
  orapd3  3349     1  0 16:47:13 ?        0:00 oraclePD3 (DESCRIPTION=(LOCAL=NO)(SDU=32768))
  orapd3  3351     1  0 16:47:13 ?        0:00 oraclePD3 (DESCRIPTION=(LOCAL=NO)(SDU=32768))
  orapd3  3353     1  0 16:47:13 ?        0:00 oraclePD3 (DESCRIPTION=(LOCAL=NO)(SDU=32768))
sapprd3a:pd3adm 5%
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
maping

论坛徽章:
0
4楼 [报告]
发表于 2008-01-18 11:44 |只看该作者
不错不错！
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
sand_hz 该用户已被删除
5楼 [报告]
发表于 2008-01-19 13:37 |只看该作者
提示: 作者被禁止或删除 内容自动屏蔽
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
ibmanster

论坛徽章:
0
6楼 [报告]
发表于 2008-01-23 13:38 |只看该作者
厉害，自己还没有接触过呢
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
aha120

论坛徽章:
0
7楼 [报告]
发表于 2008-04-27 19:16 |只看该作者
sign!
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号：11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们：huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP