| Disaster recovery on test also changed production [message #164611] |
Fri, 24 March 2006 05:43  |
patrick
Messages: 83
Registered: December 2000
|
Member |
|
|
We have Oracle 10.2 and we wanted to test the RMAN Disaster Recovery procedure we had but when the test server became live and we changed something in there the same change happened on our production database.
What we did
ServerA: Make a full RMAN backup with SPFILE and Controlfile
ServerB: (different ip address)
- Install Oracle 10.2
- copied the RMAN backups from serverA an put them in the flash recovery area of serverB
- Started RMAN and did the following
RMAN> SET DBID 676549873; (the same as the production server. Here is where it possibly goes wrong)
RMAN> STARTUP FORCE NOMOUNT;
RMAN> RESTORE SPFILE FROM AUTOBACKUP;
RMAN> STARTUP FORCE NOMOUNT:
RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP;
RMAN> ALTER DATABASE MOUNT:
RMAN> RESTORE DATABASE:
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN RESETLOGS;
After this ServerB was exactly the same as the production server.
When i dropped a table in serverB the same table was dropped on serverA
What is wrong and what did we make? How to solve this in the future from not happening again.
Patrick
Netherlands
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
