on 11-18-2008 12:27 PM
Dear all,
we are using ecc5 and windows and oracle 9i I am going to apply support package .Please tell me the step by step process of backup and full restore . I am using DB13 for backup. Please suggest.
Regards,
Shiva
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Login as <SID>adm user & run the following command
brrestore -b <backup logfilelogfile> -m full
this command restore the backup.
you can find backup logfile in /oracle/<SID>/sapbackup/.ant or .aft .
For backup using brtools follow the following procedure:-
Run Brtools Than you get the following option
1 = Database backup
2 - Archivelog backup
3 - Database copy
4 - Non-database backup
5 - Verification of database backup
6 - Verification of archivelog backup
7 + Additional functions
8 - Reset input values
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-
BR662I Enter your choice:
1
BR280I Time stamp 2008-04-04 18.41.57
BR663I Your choice: '1'
BR280I Time stamp 2008-04-04 18.41.57
BR657I Input menu 15 - please check/enter input values
-
BRBACKUP main options for backup and database copy
1 - BRBACKUP profile (profile) ....... [initPRD.sap]
2 - Backup device type (device) ...... [tape]
3 ~ Tape volumes for backup (volume) . []
4 # BACKINT/Mount profile (parfile) .. []
5 - Database user/password (user) .... [system/*******]
6 - Backup type (type) ............... [online]
7 - Back up disk backup (backup) ..... [no]
8 # Delete disk backup (delete) ...... [no]
9 ~ Files for backup (mode) .......... [all]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-
BR662I Enter your choice:
3
BR280I Time stamp 2008-04-04 18.42.25
BR663I Your choice: '3'
BR280I Time stamp 2008-04-04 18.42.25
BR681I Enter string value for "volume" (scratch|<tape_vol>|<tape_vol
PRDB04
BR280I Time stamp 2008-04-04 18.43.06
BR683I New value for "volume": 'PRDB04'
BR280I Time stamp 2008-04-04 18.43.06
BR657I Input menu 15 - please check/enter input values
-
BRBACKUP main options for backup and database copy
1 - BRBACKUP profile (profile) ....... [initPRD.sap]
2 - Backup device type (device) ...... [tape]
3 ~ Tape volumes for backup (volume) . [PRDB04]
4 # BACKINT/Mount profile (parfile) .. []
5 - Database user/password (user) .... [system/*******]
6 - Backup type (type) ............... [online]
7 - Back up disk backup (backup) ..... [no]
8 # Delete disk backup (delete) ...... [no]
9 ~ Files for backup (mode) .......... [all]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-
BR662I Enter your choice:
c
BR280I Time stamp 2008-04-04 18.43.46
BR663I Your choice: 'c'
BR259I Program execution will be continued...
BR280I Time stamp 2008-04-04 18.43.46
BR657I Input menu 16 - please check/enter input values
-
Additional BRBACKUP options for backup and database copy
1 - Confirmation mode (confirm) ....... [yes]
2 - Query mode (query) ................ [no]
3 - Compression mode (compress) ....... [hardware]
4 - Verification mode (verify) ........ [no]
5 - Fill-up previous backups (fillup) . [no]
6 - Parallel execution (execute) ...... [0]
7 - Additional output (output) ........ [no]
8 - Message language (language) ....... [E]
9 - BRBACKUP command line (command) ... [-p initPRD.sap -d tape -v
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-
BR662I Enter your choice:
c
BR280I Time stamp 2008-04-04 18.44.29
BR663I Your choice: 'c'
BR259I Program execution will be continued...
BR291I BRBACKUP will be started with options '-p initPRD.sap -d tape
E'
BR280I Time stamp 2008-04-04 18.44.29
BR670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to
c
BR280I Time stamp 2008-04-04 18.45.13
BR257I Your reply: 'c'
BR259I Program execution will be continued...
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
BR051I BRBACKUP 6.20 (113)
BR189W Expiration period equal 0 - backup volumes could be immediate
BR055I Start of database backup: bdxpzadt.ant 2008-04-04 18.45.13
BR319I Control file copy was created: /oracle/PRD/sapbackup/cntrlPRD
BR280I Time stamp 2008-04-04 18.45.13
BR057I Backup of database: PRD
BR058I BRBACKUP action ID: bdxpzadt
BR059I BRBACKUP function ID: ant
BR110I Backup mode: ALL
BR077I Database file for backup: /oracle/PRD/sapbackup/cntrlPRD.dbf
BR061I 25 files found for backup, total size 45884.883 MB
BR143I Backup type: online
BR113I Files will be compressed by hardware
BR130I Backup device type: tape
BR102I Following backup device will be used: /dev/rmt0.1
BR103I Following backup volume will be used: PRDB04
BR280I Time stamp 2008-04-04 18.45.13
BR256I Enter 'c[ont]' to continue, 's[top]' to cancel the program:
c
BR280I Time stamp 2008-04-04 18.45.50
BR257I Your reply: 'c'
BR259I Program execution will be continued...
BR208I Volume with name PRDB04 required in device /dev/rmt0.1
BR210I Please mount BRBACKUP volume, if you have not already done so
BR280I Time stamp 2008-04-04 18.45.50
BR256I Enter 'c[ont]' to continue, 's[top]' to cancel the program:
c
BR280I Time stamp 2008-04-04 18.46.26
BR257I Your reply: 'c'
BR259I Program execution will be continued...
BR280I Time stamp 2008-04-04 18.46.26
BR226I Rewinding tape volume in device /dev/rmt0 ...
BR351I Restoring /oracle/PRD/sapbackup/.tape.hdr0
BR355I from /dev/rmt0.1 ...
BR241I Checking label on volume in device /dev/rmt0.1
BR280I Time stamp 2008-04-04 18.46.26
BR226I Rewinding tape volume in device /dev/rmt0 ...
BR202I Saving /oracle/PRD/sapbackup/.tape.hdr0
BR203I to /dev/rmt0.1 ...
BR209I Volume in device /dev/rmt0.1 has name PRDB04
BR202I Saving init_ora
BR203I to /dev/rmt0.1 ...
BR202I Saving /oracle/PRD/920_64/dbs/initPRD.sap
BR203I to /dev/rmt0.1 ...
Let me know If you have any problem regarding backup & restore
karan
User | Count |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.