Re: Duplicate database question

--0__=zPk7fc24TUoIxVkqw6kdY66BBNkpeEe9fspaHUbYxjcSoZwcYL0eg0W6
Content-type: text/plain; charset=us-ascii Content-Disposition: inline

Michael,

     I use local naming, not names server, but have always in the past setup a test box using the same sid as prod. So far, I have not experienced any problems. As long as the machine name/host ip address is different, you should be fine.....

     Also, keeping the same sid is very convenient in order to be able to restore prod to test without the hassle of re-creating the controfiles (which I had to do only this am:>)

Hannah

"Michael Ray" <Michael.Ray_at_trw.com> on 11/15/2000 10:45:25 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: Duplicate database question

List,
I have finally got a test box of some sort set up and have restored an old backup of our production database on it. It is my understanding that the 2 databases can have the same instance names since they are on different machines. All I should have to do is add an entry in the names server with a different service name pointing to the test box. Is there anything I am missing before I do this? I have not started the listener on the test box yet to make sure nobody could get in outside the server.

I seem to recall a subthread in the past couple weeks regarding database unique IDs. Do I need to worry about this? I would expect these would be the same value for both since I restored from a backup to make my test db.

Thanks.

Michael Ray
Oracle DBA
TRW, Marshall, IL
217-826-3011 x2438

--0__=zPk7fc24TUoIxVkqw6kdY66BBNkpeEe9fspaHUbYxjcSoZwcYL0eg0W6
Content-type: text/html;

        name="TEXT.htm"

Content-Disposition: attachment; filename="TEXT.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PWlz by04ODU5LTEiIGh0dHAtZXF1aXY9Q29udGVudC1UeXBlPg0KPE1FVEEgY29udGVudD0iTVNIVE1M IDUuMDAuMjkxOS42MzA3IiBuYW1lPUdFTkVSQVRPUj48L0hFQUQ+DQo8Qk9EWSBzdHlsZT0iRk9O VDogOHB0IE1TIFNhbnMgU2VyaWY7IE1BUkdJTi1MRUZUOiAycHg7IE1BUkdJTi1UT1A6IDJweCI+ DQo8RElWPkxpc3QsPC9ESVY+DQo8RElWPkkgaGF2ZSBmaW5hbGx5IGdvdCBhIHRlc3QgYm94IG9m IHNvbWUgc29ydCBzZXQgdXAgYW5kIA0KaGF2ZSZuYnNwO3Jlc3RvcmVkJm5ic3A7YW4gb2xkIGJh Y2t1cCBvZiBvdXIgcHJvZHVjdGlvbiBkYXRhYmFzZSBvbiBpdC4gSXQgaXMgbXkgDQp1bmRlcnN0 YW5kaW5nIHRoYXQgdGhlIDIgZGF0YWJhc2VzIGNhbiBoYXZlIHRoZSBzYW1lIGluc3RhbmNlIG5h bWVzIHNpbmNlIHRoZXkgDQphcmUgb24gZGlmZmVyZW50IG1hY2hpbmVzLiBBbGwgSSBzaG91bGQg aGF2ZSB0byBkbyBpcyBhZGQgYW4gZW50cnkgaW4gdGhlIG5hbWVzIA0Kc2VydmVyIHdpdGggYSBk aWZmZXJlbnQgc2VydmljZSBuYW1lIHBvaW50aW5nIHRvIHRoZSB0ZXN0IGJveC4gSXMgdGhlcmUg YW55dGhpbmcgDQpJIGFtIG1pc3NpbmcgYmVmb3JlIEkgZG8gdGhpcz8gSSBoYXZlIG5vdCBzdGFy dGVkIHRoZSBsaXN0ZW5lciBvbiB0aGUgdGVzdCBib3ggDQp5ZXQgdG8gbWFrZSBzdXJlIG5vYm9k eSBjb3VsZCBnZXQgaW4gb3V0c2lkZSB0aGUgc2VydmVyLjwvRElWPg0KPERJVj4mbmJzcDs8L0RJ Vj4NCjxESVY+SSBzZWVtIHRvIHJlY2FsbCBhIHN1YnRocmVhZCBpbiB0aGUgcGFzdCBjb3VwbGUg d2Vla3MgcmVnYXJkaW5nIGRhdGFiYXNlIA0KdW5pcXVlIElEcy4gRG8gSSBuZWVkIHRvIHdvcnJ5 IGFib3V0IHRoaXM/Jm5ic3A7SSB3b3VsZCBleHBlY3QgdGhlc2Ugd291bGQgYmUgDQp0aGUgc2Ft ZSB2YWx1ZSBmb3IgYm90aCBzaW5jZSBJIHJlc3RvcmVkIGZyb20gYSBiYWNrdXAgdG8gbWFrZSBt eSB0ZXN0IGRiLjwvRElWPg0KPERJVj4mbmJzcDs8L0RJVj4NCjxESVY+VGhhbmtzLjwvRElWPg0K PERJVj4mbmJzcDs8L0RJVj4NCjxESVY+TWljaGFlbCBSYXk8QlI+T3JhY2xlIERCQTxCUj5UUlcs IE1hcnNoYWxsLCBJTDxCUj4yMTctODI2LTMwMTEgDQp4MjQzODwvRElWPjwvQk9EWT48L0hUTUw+ Received on Wed Nov 15 2000 - 11:42:44 CST