hi guys!
This is what I've done:
I copied an existing oracle 7.3.4, 2 instances, to a new server that replaced the old server. The OS is NT4 SP6 and both machines run 7.3.4.0.
For each instance i did the following
• Stop the instances
• copy all the datafiles over to the new server
o sys1xxx.ora (SYSTEM)
o usr1xxx.ora (USER_DATA)
o rbs1xxx.ora (ROLLBACK_DATA)
o tmp1xxx.ora (TEMPORARY_DATA)
o dat1xxx.ora (DB_DATA)
• copy the controlfiles
o ctl1xxx.ora
o ctl2xxx.ora
• copy the redo-log files, 2 sets
• copy the archive-logs
• copy the initxxx.ora file
• make the new instance with oradim73
All the files were copied with scopy and placed in the same filestructur, located exactly the same as on the original server .
The old server was then deleted from the domain and the new server was renamed to the name the old server had. Then I mounted both instances and everything seemed ok.
Now, nearly a month after the installation I'm getting reports that strange things is happening in one of the instances, the other one seems fine. There seems to be something wrong with the pointers to this instance. The client-programs seems to have trouble to register data in some fields and fields get crossed causing a mess of reports
from this database.
Also, there are some economy-systems(i.e winsak) installed on top of these instances that are very special. only the programmers can explain how these programs work, but they include a lot a batch-jobs and mappings to the database-server..
Is there anybody that can tell me if i did something wrong under the moving job of the database? I'm kinda suspecting these special-systems on top of oracle that is causing troubles, but I cannot be sure.. appreciate any suggestions!
This is what I've done:
I copied an existing oracle 7.3.4, 2 instances, to a new server that replaced the old server. The OS is NT4 SP6 and both machines run 7.3.4.0.
For each instance i did the following
• Stop the instances
• copy all the datafiles over to the new server
o sys1xxx.ora (SYSTEM)
o usr1xxx.ora (USER_DATA)
o rbs1xxx.ora (ROLLBACK_DATA)
o tmp1xxx.ora (TEMPORARY_DATA)
o dat1xxx.ora (DB_DATA)
• copy the controlfiles
o ctl1xxx.ora
o ctl2xxx.ora
• copy the redo-log files, 2 sets
• copy the archive-logs
• copy the initxxx.ora file
• make the new instance with oradim73
All the files were copied with scopy and placed in the same filestructur, located exactly the same as on the original server .
The old server was then deleted from the domain and the new server was renamed to the name the old server had. Then I mounted both instances and everything seemed ok.
Now, nearly a month after the installation I'm getting reports that strange things is happening in one of the instances, the other one seems fine. There seems to be something wrong with the pointers to this instance. The client-programs seems to have trouble to register data in some fields and fields get crossed causing a mess of reports
from this database.
Also, there are some economy-systems(i.e winsak) installed on top of these instances that are very special. only the programmers can explain how these programs work, but they include a lot a batch-jobs and mappings to the database-server..
Is there anybody that can tell me if i did something wrong under the moving job of the database? I'm kinda suspecting these special-systems on top of oracle that is causing troubles, but I cannot be sure.. appreciate any suggestions!