maxdb incremental issue

Hi,

While doing disaster recovery test on one of the machine ..

I have done following things..

I have maintained the mediums for full data backup and incremental.

I have started recovery in ADMIN mode.

1. Recovering full backup using -- recover_start DATA

2. Recovering the incremental backup using - recover_start INC

After successful restore of incremental backup i made the db into ONLINE.

But the data seems to be the old week backup, even though it restored successfully.

Need to use any other commands to overwrite the data ?

SAP Managed Tags:
SAP MaxDB

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)

Hi,

What is the version of MaxDB ? Do you have DBMGUI or DBStudio installed ?

Please post the output of the command

dbmcli> backup_history_list

Regards,

Yashwanth

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

Comment

Hi Yashwanth,

I have taken the full and incremental backups on the source system then i am restoring on the other system.

Maxdb version is 7.6

I don't have dbmgui installed.

What i would like to do is , restoring the full and incremental backups from source system to target system.

Help me on this

Hi,

From your reply I understood that you are trying to restore a databackup and a subsequent incremental backup from a source system to a target system. correct ?

Please clarify the following things so that I can give you correct steps on how to restore:

What are the source and target versions of the MaxDB ?

Are you trying to restore the database to a point in time when the incremental backup was taken or to a different point-in-time before/after the incremental backup was taken ?

dbmcli -d <**db_name**> -u DBM,<**password**> backup_history_list

Let me know the output of this command.

Regards,

Yashwanth

Yes What you said is correct..

1.Source and target maxdb version are same. Maxdb version 7.6.03.09

2. I just want to restore the backup to latest incremental backup , at that i would like to restore.

3. backup_history_list output

| 256016| 1| 0 | |

503E409A0011|DAT_000000023|SAVE WARM|2012-08-29 11:17:37|2012-08-29 11:17:37|201 2-08-29 11:18:04|2012-08-29 12:59:18| 3004030| |NO |DATA | 25493608| 1| 0 | |

503EF9B30012|PAG_000000024|SAVE WARM|2012-08-30 00:27:16|2012-08-30 00:27:16|201 2-08-30 00:27:19|2012-08-30 00:27:21| 3011386| |NO |INC | 4216| 1| 0 | |

5040495A0013|PAG_000000025|SAVE WARM|2012-08-31 00:19:29|2012-08-31 00:19:29|201 2-08-31 00:19:34|2012-08-31 00:19:46| 3043029| |NO |INC | 27768| 1| 0 | |

5041CE630014|DAT_000000026|SAVE WARM|2012-09-01 03:59:17|2012-09-01 03:59:17|201 2-09-01 03:59:35|2012-09-01 03:59:37| 3081396| |NO |DATA | 0| 0| -903 |Could not open volume |

5041D5040015|DAT_000000027|SAVE WARM|2012-09-01 04:27:33|2012-09-01 04:27:33|201 2-09-01 04:27:39|2012-09-01 04:27:39| 3081482| |NO |DATA | 0| 0| -903 |Could not open volume |

5041D5C80016|DAT_000000028|SAVE WARM|2012-09-01 04:30:49|2012-09-01 04:30:49|201 2-09-01 04:30:55|2012-09-01 04:30:55| 3081495| |NO |DATA | 0| 0| -903 |Could not open volume |

5041D7AB0017|DAT_000000029|SAVE WARM|2012-09-01 04:38:51|2012-09-01 04:38:51|201 2-09-01 04:38:57|2012-09-01 04:38:58| 3081526| |NO |DATA | 0| 0| -903 |Could not open volume |

5041DE680018|DAT_000000030|SAVE WARM|2012-09-01 05:07:36|2012-09-01 05:07:36|201 2-09-01 05:07:43|2012-09-01 06:47:03| 3081609| |NO |DATA | 25502944| 1| 0 | |

50443FBB0019|PAG_000000031|SAVE WARM|2012-09-03 00:27:24|2012-09-03 00:27:24|201 2-09-03 00:27:30|2012-09-03 00:27:36| 3101817| |NO |INC | 16944| 1| 0 | |

504593A7001A|PAG_000000032|SAVE WARM|2012-09-04 00:37:51|2012-09-04 00:37:51|201 2-09-04 00:37:56|2012-09-04 00:38:06| 3126726| |NO |INC | 25808| 1| 0 | |

5046E2C0001B|PAG_000000033|SAVE WARM|2012-09-05 00:27:33|2012-09-05 00:27:33|201 2-09-05 00:27:37|2012-09-05 00:28:29| 3185143| |NO |INC | 49632| 1| 0 | |

50483754001C|PAG_000000034|SAVE WARM|2012-09-06 00:40:41|2012-09-06 00:40:41|201 2-09-06 00:40:44|2012-09-06 00:42:03| 3213151| |NO |INC | 63456| 1| 0 | |

5049832C001D|PAG_000000035|SAVE WARM|2012-09-07 00:16:31|2012-09-07 00:16:31|201 2-09-07 00:16:34|2012-09-07 00:18:01| 3236449| |NO |INC | 68648| 1| 0 | |

504A9992001E|DAT_000000036|SAVE WARM|2012-09-07 20:04:24|2012-09-07 20:04:24|201 2-09-07 20:04:42|2012-09-07 20:04:44| 3260816| |NO |DATA | 0| 0| -903 |Could not open volume |

504A9AB0001F|DAT_000000037|SAVE WARM|2012-09-07 20:09:04|2012-09-07 20:09:04|201 2-09-07 20:09:10|2012-09-07 21:43:49| 3260832| |NO |DATA | 25520712| 1| 0 | |

504D7A900020|PAG_000000038|SAVE WARM|2012-09-10 00:28:54|2012-09-10 00:28:54|201 2-09-10 00:28:57|2012-09-10 00:29:10| 3297348| |NO |INC | 22088| 1| 0 | |

504DDEC30021|LOG_000000012|SAVE WARM|2012-08-29 06:26:27|2012-09-10 07:36:19|201 2-09-10 07:36:19|2012-09-10 07:43:03| 2936746| 3318433| |AUTO | 256016| 1| 0 | |

504ECCDD0022|PAG_000000039|SAVE WARM|2012-09-11 00:32:18|2012-09-11 00:32:18|201 2-09-11 00:32:21|2012-09-11 00:32:52| 3329774| |NO |INC | 35040| 1| 0 | |

504F26C60023|PAG_000000040|SAVE WARM|2012-09-11 06:55:52|2012-09-11 06:55:52|201 2-09-11 06:55:54|2012-09-11 06:56:32| 3347289| |NO |INC | 39800| 1| 0 | |

504F2D680024|PAG_000000041|SAVE WARM|2012-09-11 07:24:09|2012-09-11 07:24:09|201 2-09-11 07:24:12|2012-09-11 07:25:03| 3347704| |NO |INC | 40104| 1| 0 | |

504F33F20025|PAG_000000042|SAVE WARM|2012-09-11 07:52:15|2012-09-11 07:52:15|201 2-09-11 07:52:29|2012-09-11 07:53:58| 3349007| |NO |INC | 41640| 1| 0 | |

504F35CD0026|PAG_000000043|SAVE WARM|2012-09-11 07:59:58|2012-09-11 07:59:58|201 2-09-11 07:59:59|2012-09-11 07:59:59| 3349314| |NO |INC | 0| 0| -903 |Could not open volume |

504F3CD90027|PAG_000000044|SAVE WARM|2012-09-11 08:30:03|2012-09-11 08:30:03|201 2-09-11 08:30:05|2012-09-11 08:30:05| 3350111| |NO |INC | 0| 0| -903 |Could not open volume |

50508E5C0028|PAG_000000045|SAVE WARM|2012-09-12 08:30:34|2012-09-12 08:30:34|201 2-09-12 08:30:55|2012-09-12 08:30:56| 3386686| |NO |INC | 0| 0| -903 |Could not open volume |

50509A730029|PAG_000000046|SAVE WARM|2012-09-12 09:21:41|2012-09-12 09:21:41|201 2-09-12 09:21:43|2012-09-12 09:22:57| 3387654| |NO |INC | 58072| 1| 0 | |

5051DFDB002A|PAG_000000047|SAVE WARM|2012-09-13 08:30:08|2012-09-13 08:30:08|201 2-09-13 08:30:14|2012-09-13 08:32:18| 3418095| |NO |INC | 70128| 1| 0 | |

Hi,

From the output attached, I can see that the last complete DATA backup was DAT_000000037. If I understood correct from your previous reply, you would like to restore the last INCREMENTAL backup that would be PAG_000000047 here.

Proceed as follows in the target system.

Copy the "DAT_000000037" and "PAG_000000047" to the target system.

First recover the data backup "DAT_000000037" with initialization using the following command in your target system.

To start a restore of a data backup a database session has to be created:

dbmcli on DB> db_connect [<user>],[<password>]

As you created the dbmcli session using the database manager operator user, no user has to be specified here. The same user will be used.

At first it is good to check if the backup can be accessed as expected and reading the data will work fine. A service session is required for this:

dbmcli on DB> db_admin
dbmcli on DB> service_connect
dbmcli on DB> recover_check <medium_name> <backup_type>

For the example in your case it would be:

dbmcli on DB> recover_check DAT_000000037 data

If the output of this command shows a returncode 0 and information about the
backup the check was successful. To start the restore of this data backup
afterwards you can carry on with:

dbmcli on DB> service_release

dbmcli on DB1>db_activate recover DAT_000000037 DATA

Note: This command performs an initialization of the database and afterwards a restore of the specified data backup. Please be aware that initialization means that all data are deleted and

therefore lost forever.

Then proceed with the restore of incremental backup as follows:

dbmcli on DB1> recover_start PAG_000000047 PAGES

After the restore of the backup it is required to load the system tables.

To load system tables, bring the database online. Connect to the database as SYSDBA user with same user as SOURCE system.

dbmcli on DB1>load_systab

For more information refer to the SAP Note: 1377148 - FAQ: SAP MaxDB backup/recovery

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

Let me know if you have any more questions on this.

Regards,

Yashwanth

Thanks Yashwanth,

I will update you once i done the activity.

Hi,

A small correction to step 5 in my previous reply

After the restore of the backup it is required to load the system tables manually as of version 7.6 or less

To load system tables, Connect to the database as DBM user in target & run the command

dbmcli on DB1>load_systab -u SYSDBA,<Password>

(SYSDBA User/Pwd from the source database system)

Regards,

Yashwanth

Hi,

Were you able to succesfully restore the database ??

Let me know

Thanks,

Yashwanth

Hi yeshwanth,

Sorry for late reply, I am able to successfully restore the database with data and incremental backups also. Able to login into sap also.

One more issue .....

1. Actually on the test server which is running, i made to db_admin .

2. Then i would like to restore the full backup with the db_activate recover DATA.

3. But due to permission problem in the medium of file, db_activate is not started.

4. Then i try to make online of the db by db_online.

But its not coming to online.

Even though the db_activate is not started, why its not coming to online.

Please advice ..

Hi,

It is not clear for me what kind of error you are experiencing. Please tell me the exact error message you see when you try to bring db online.

Post the output of the command db_restartinfo

Please attach all the KnlMsg* files and dbm.prt file from the RUN directory of your database.

Regards,

Yashwanth

Ask a Question

Top Q&A Solution Author

User

Count