MAX DB data restore on newly installed system

[Former Member]

Hi

We have one PRD system with MAX DB ,we want to restore the complete data backup from PRD to DEV system which one installed newly for testing purpose.

I tried to restore but it is failing.

Can you please share how to do restore with another system data.

Thanks

Mahipal

[former_member188883]

Hi Mahipal,

For MaxDB restoration refer following links

http://scn.sap.com/docs/DOC-7810

http://wiki.sdn.sap.com/wiki/display/MaxDB/HowTo+-+SAP+MaxDB+recovery+with+Database+Manager+CLI

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Deepak

I already read those two,but my scenarion is to restore the remote system data where backup and log backup history is not available.

Thanks

Mahipal

[former_member188883]

Hi Mahipal,

Could you share the steps used by you to perform the restore. Also share the error message and database version.

Regards,

Deepak Kori

[former_member188883]

Hi Mahipal,

You may also look into the thread for homogenous system copy

SAP Note 1014782 (FAQ: MaxDB System Copy)

  http://scn.sap.com/thread/1188258

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Deepak

In DBGUi i clicked on restore option and choosen the option restore from media,when i browse the media location is not dispalying complete data & log backup files copied from remote system(from which i have taken the backup)

Thanks

Mahipal

[former_member188883]

Hi Mahipal,

You can define a new media for restoration and define the path where backup files located.

Also note you need to initialize your database while recovering. So select appropriate action.

Also refer the threads share above for guidance.

Regards,

Deepak Kori

[Former Member]

HI Deepak

How to initialize the database.

Thank
mahipal

[former_member188883]

Hi Mahipal,

In DBMgui when you select option for recovery in the pop-window just look for a checkbox written with Initialize Database.

You need to select that check box.

Regards,

Deepak Kori

[Former Member]

i will try and let you know the status

thanks

[Former Member]

Hi Deepak

When i check my Complete data backup file from check option it giving below error

24994 runtime environment error:1060 Kernel start failed

Thanks

Mahipal

[former_member188883]

Hi Mahipal,

Have you restored your database successfully. If yes, Make the database online and then perform any checks.

Regards,

Deepak Kori

[Former Member]

one of my friend tried to restore it is given error and database went to admin state,when click on online but giving below error

24988 SQL Error:9046 message not avialable

Thanks

Mahipal

[former_member188883]

Hi Mahipal,

Could you share dbm.prt log file details.

Regards,

Deepak Kori

[Former Member]

Hi Mahipal,

The database should be in the ADMIN operational state to restore.

Follow below steps:

1. 1. Select the database in the explorer tree.
2. 2. In the context menu of the database, choose Administration Tasks Recovery...
3. 3. If necessary, transfer the database to the ADMIN operational state.
4. Select the recovery type
5. Select Initialize Database before recovery check box
6. Select backup template
7. Start recovery

Thanks,

Venkat