SAP Backup Restore and recovery using BR Tools

Hi,

I took the backup of our server using BR Tools to disk . Now i have ianstall the new server for same the took the backup server(Example- Server name and database name for same).Now i transfer the backup data to new installing the server location . So now i want to restore and recover the database using BR Tools . So any command or syntax is there, Our SAP Version ECC5.0, database Oracle 9.2 and OS windows 2003 server.So kindly help me the for this issue.

Best Regards,

Thiru

+91 9840544311

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Use the system copy guides, they tell you what you need to do:

http://service.sap.com/systemcopy

Markus

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Dear Markus,

Thanks for your reply.

I had already took a backup of the Development server and i would

like to know is it possible to restore the backup to another pc

which is not of the same configuration of the Development

server .Development server domain name numericdev i have given the same name. Please guide the external backup restoration purcedure.

Best Regards,

Thiru

+91 9840544311

Edited by: Thiru Moorthi on Feb 10, 2009 3:20 PM

Dear Markus,

Thanks for your reply.

I have already taken the backup from Development server and i could

like to know is it possible to restore the backup to another server.

The new server is not the same configuration of the Development

server .Development server domain and database name numericdev and i have given the same name in the new server also. Please guide the backup restoration purcedure.

Best Regards,

Thiru

+91 9840544311

> I have already taken the backup from Development server and i could

> like to know is it possible to restore the backup to another server.

Yes - it is.

> The new server is not the same configuration of the Development

That is no problem - you will "just" need to adapt the script you create during the system copy to reflect your filesystem layout.

Just read the guide and follow the procedure for doing a copy using backup/restore.

Markus

Hi Markus,

Thanks for your reply, Kindly request you to any Link and OSS Note is there for backup restore /recover, please mention.

Best Regards,

Thiru

Not sure what you mean, did you use the link I gave you?

http://service.sap.com/systemcopy

--> System Copy and Migration

Markus

Dear Markus,

Thanks for your reply. My requirement is backup restoration fot the external SAP backup via BR Tools only. As per your advice I will go through the link http://service.sap.com/systemcopy, this only system copy. my requirement only Database restore and recover option not in system copy.

Best Regards,

Thiru

Well - isn´t that what you try a system copy? You take backup of one system and want to import that into another?

You can check

--> Backup and Recovery

Markus

Dear Markus,

We have gothroughed the () link.But I try to backup restore option via brtoos. I have changed the initSID.ora file path for E:sapbackup . I am try to backup restoration option but fatal error displayed.

Oracle installation Path: D drive.

External backup store the Path: E drive.

I have mentione below for the Error message.

BR0651I BRTOOLS 6.40 (50)

BR0280I BRTOOLS time stamp: 2009-02-11 17.03.20

BR0656I Choice menu 1 - please make a selection

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

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

BR0662I Enter your choice:

BR0280I BRTOOLS time stamp: 2009-02-11 17.03.24

BR0663I Your choice: '5'

BR0280I BRTOOLS time stamp: 2009-02-11 17.03.24

BR0656I 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 program status

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

BR0662I Enter your choice:

BR0280I BRTOOLS time stamp: 2009-02-11 17.03.27

BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2009-02-11 17.03.27

BR0657I Input menu 34 - please enter/check input values

BRRECOVER options for restore and recovery

1 - BRRECOVER profile (profile) ...... [initTRG.sap]

2 ~ BACKINT/Mount profile (parfile) .. []

3 - Database user/password (user) .... [/]

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

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

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

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

8 - BRRECOVER command line (command) . [-p initTRG.sap -t complete -i 30 -s 20

-l E]

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

BR0662I Enter your choice:

BR0280I BRTOOLS time stamp: 2009-02-11 17.03.30

BR0663I Your choice: '8'

BR0280I BRTOOLS time stamp: 2009-02-11 17.03.30

BR0681I Enter string value for "command" [-p initTRG.sap -t complete -i 30 -s 20

-l E]:

E:sapbackupdzvbzlncntrlTRG.DBF

BR0280I BRTOOLS time stamp: 2009-02-11 17.04.24

BR0683I New value for "command": 'E:sapbackupdzvbzlncntrlTRG.DBF'

BR0280I BRTOOLS time stamp: 2009-02-11 17.04.24

BR0657I Input menu 34 - please enter/check input values

BRRECOVER options for restore and recovery

1 - BRRECOVER profile (profile) ...... [initTRG.sap]

2 ~ BACKINT/Mount profile (parfile) .. []

3 - Database user/password (user) .... [/]

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

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

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

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

8 - BRRECOVER command line (command) . [E:sapbackupdzvbzlncntrlTRG.DBF]

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

BR0662I Enter your choice:

BR0280I BRTOOLS time stamp: 2009-02-11 17.04.45

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRRECOVER will be started with options 'E:sapbackupdzvbzlncntrlTRG.D

BF'

BR0280I BRTOOLS time stamp: 2009-02-11 17.04.45

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

BR0280I BRTOOLS time stamp: 2009-02-11 17.04.54

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

###############################################################################

BR0701I BRRECOVER 6.40 (50)

BR0154E Unexpected option value 'E:sapbackupdzvbzlncntrlTRG.DBF' found at po

sition 1

BR0280I BRRECOVER time stamp: 2009-02-11 17.04.54

BR0700E Fatal errors occurred - terminating processing...

BR0797I Number of restored/recovered database files: 0/0

BR0798I Number of restored/applied incremental files: 0/0

BR0799I Number of restored/applied archivelog files: 0/0

BR0706I End of database recovery: vdzxdkqo.log 2009-02-11 17.04.54

BR0280I BRRECOVER time stamp: 2009-02-11 17.04.54

BR0704I BRRECOVER terminated with errors

###############################################################################

BR0292I Execution of BRRECOVER finished with return code 3

BR0668I Warnings or errors occurred - you can continue to ignore them or go back

to repeat the last action

BR0280I BRTOOLS time stamp: 2009-02-11 17.04.54

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

So how can i restore the backup. Please guide us for the above issue.

Best Regards,

Thiru

> We have gothroughed the () link.But I try to backup restore option via brtoos. I have changed the initSID.ora file path for E:sapbackup . I am try to backup restoration option but fatal error displayed.

You did not change the init<SID> filepath but you deleted everything else:

> BR0681I Enter string value for "command" [-p initTRG.sap -t complete -i 30 -s 20 -l E]:

> E:sapbackupdzvbzlncntrlTRG.DBF

you need to add everything if you need to change this path (so "-p initTRG.sap -t complete.... etc.)

Markus

Dear Markus,

Thanks for your reply. We have gothrough the below link but canot display the webpage.

I have to be change only so "-p initTRG.sap -t complete.... etc" this command or any other is needed.

http://-p initTRG.sap -t complete -i 30 -s 20 -l E:

Internet Explorer cannot display the webpage

Most likely causes:

You are not connected to the Internet.

The website is encountering problems.

There might be a typing error in the address.

What you can try:

Diagnose Connection Problems

More information

This problem can be caused by a variety of issues, including:

Internet connectivity has been lost.

The website is temporarily unavailable.

The Domain Name Server (DNS) is not reachable.

The Domain Name Server (DNS) does not have a listing for the website's domain.

If this is an HTTPS (secure) address, click Tools, click Internet Options, click Advanced, and check to be sure the SSL and TLS protocols are enabled under the security section.

For offline users

You can still view subscribed feeds and some recently viewed webpages.

To view subscribed feeds

Click the Favorites Center button , click Feeds, and then click the feed you want to view.

To view recently visited webpages (might not work on all pages)

Click Tools , and then click Work Offline.

Click the Favorites Center button , click History, and then click the page you want to view.

> Thanks for your reply. We have gothrough the below link but canot display the webpage.

> I have to be change only so "-p initTRG.sap -t complete.... etc" this command

yes

> Internet Explorer cannot display the webpage

> Most likely causes:

> You are not connected to the Internet.

> The website is encountering problems.

> There might be a typing error in the address.

I can open that page nicely by clicking on it so it must be something on your side.

Markus

Dear Markus,

We have to be changed this "-p initTRG.sap -t complete.... etc" command which file change for initSID.sap or initTRG.ora. Please guide us. My requirement only taken the backup restore.

Brst Regards,

Thiru

The web page is:

Markus

Ask a Question

Top Q&A Solution Author

User

Count