How can i change the database name on MaxDB?

[Former Member]

Hello. I need to do a homogeneous copy where the source system is the productive system and the target system is the quality system. Therefore after to restore the data backup i need to change the database name of quality system (from CLP to CLQ) but i'm not sure that it could be possible because in the MaxDB documentation i didn't found nothing about that. please can you tell me if it is possible and how i change it?

I work with MaxDB 7.6.04.11. Thanks for your help.

[markus_doehr2 · Accepted solution]

Yes - this is possible. you "just" import the backup of the other system.

Read

1014782 - FAQ: MaxDB system copy

129352 - Homogeneous system copy with MaxDB (SAP DB)

Markus

[Former Member · Accepted solution]

Yes, i have read these notes, but when i do the restore with initialization the target instance is rename as CLP, the same name that the source instance. Then, after the restore, i want to change the database name to CLQ again

[former_member204746 · Accepted solution]

I used to use DBMGUI for that, menu:

Instance -> Installation Wizard

Create your new instance with SID CLQ

when asked to adapt parameters:

Change Value for RUNDIRECTORY for CLQ

Click on Extended

Change value for OFFICIAL_NODE to the new servername

Change DIAG_HISTORY_PATH to CLQ

now, restore your DB and run recovery if needed.

[markus_doehr2 · Accepted solution]

> Yes, i have read these notes, but when i do the restore with initialization the target instance is rename as CLP

How do you restore? DBMGUI?

Markus

[lbreddemann · Accepted solution]

Hi Eric,

the adaption of the mentioned parameters is only necessary when the parameters for the new instance are taken from the backup.

When the default parameters are chosen or a copy of an existing database parameter setup is used, DBMGUI automatically replaces the paramter values according to the new SID.

best regards,

Lars

[Former Member · Accepted solution]

Hello Markus. In response for your question "How do you restore? DBMGUI?": yes, i restore the data backup with DBMGUI. The question is if i restore a data backup in a different instance (differents SIDs the source instance and target instance) after the restore with initialization the name of the target instance will be the same that the source instance, then how i rename the database name (SID) as it was originally?

Edited by: Ivonne Garcia on Oct 2, 2008 3:30 PM

[former_member204746 · Accepted solution]

Ivonne, Have you read my answer? it should work as I have refreshed my LiveCache instance about a dozen time with that procedure.

[Former Member · Accepted solution]

Yes Eric, i read your answer. I understand you tell me about to create a new instance with the corresponding parameters, but i want to restore the data backup of productive system (PRD) in the test system (QAS), these systems (PRD and QAS) has differents databases and SIDs and they are in differents servers. I think that after the recovery, the SID of the target database (QAS) will be the same of PRD, i need to change it as QAS over the same instance. In this procedure of recovery with initialization the SID of the target database (QAS) don't change ? if it changes how rename the SID as QAS again over the same instance?

Edited by: Ivonne Garcia on Oct 2, 2008 5:39 PM

[former_member204746 · Accepted solution]

my procedure worked in the past. once you restore the DB, it will use the new SID.

the only thing that remains is to change some content tables if this is a SAP system (not for LiveCache)

check the homogeneous system copy guide to know which steps and transaction you must accomplish to change these.

[Former Member · Accepted solution]

"once you restore the DB, it will use the new SID" that's the problem, i need that it use the SID original, no the new SID. I want to keep the SID that the database had before the recovery with initialization.

[former_member204746 · Accepted solution]

I'm not sure that I follow you, you want to change SID from CLP to CLQ... but do not want to change SID????

[Former Member · Accepted solution]

I will try to explain better: the SID of the source database is CLP and the SID of the target database is CLQ, when you say "once you restore the DB, it will use the new SID", i understand that the new SID in the target database would CLP or am i wrong? and i need that the SID in the target database remains CLQ after the restore.

Edited by: Ivonne Garcia on Oct 2, 2008 10:24 PM

[lbreddemann · Accepted solution]

> I will try to explain better: the SID of the source database is CLP and the SID of the target database is CLQ, when you say "once you restore the DB, it will use the new SID", i understand that the new SID in the target database would CLP or am i wrong? and i need that the SID in the target database remains CLQ after the restore.

Hi Ivonne,

what you've described as your requirement is exactly what will happen, when you just perform the procedure that Eric described to you.

A recovery won't change the SID of the instance you perform the recovery to.

All it does is: take the instance as is and load the data pages to the data area. Afterwards the log files may be recovered.

Think of the instance as a kind of container for your database.

The instance itself is not the database - so the SID does not change with the content of the database.

Hmm... why not simply try it?

Create a little test instance and back it up.

Create another instance with a different name and recover the backup of the first instance.

You will still have both instances, each with its original name.

regards,

Lars

[Former Member · Accepted solution]

Thank you very much. I understand. Thank Eric too. All of you helped me a lot.

[Former Member · Accepted solution]

Thank you very much. I understand. All of you helped me a lot.