Recovering database [message #70513] |
Tue, 25 June 2002 04:15 |
Dev
Messages: 28 Registered: May 2001
|
Junior Member |
|
|
Hi all,
We are running online production server. Did a migration on high end server for which we cloned the database using coldbackup of server A database. Did a resetlogs for database on new server B. The server B crashed after 10 hrs due to filesystem corruption and we had to revert back to old server A.
My question is as we were about to loose the data of 10 hrs.
1. Was it possible to apply the logs of new database on server B to database of old server A so that we can get the transactions for the logs?
2. If yes how can this be accomplished?
3. Is there any other method where in I can get the two databases in sync with all the data?
Regards,
3.
|
|
|
Re: Recovering database [message #70519 is a reply to message #70513] |
Tue, 25 June 2002 05:54 |
Bruno
Messages: 12 Registered: May 2002
|
Junior Member |
|
|
Hi !
No, you can't . When you use the open resetlogs you create a new incarnation of the database. SCN ,logseq are reseted !
When you use the "open resetlogs" option YOU MUST BACKUP your database immediately or your database can't be restored later.
If you backup the database, simply restore the files and recover the database.
If you want that the 2 database, use a standby database if one database can be read-only. Else see the replication option.
|
|
|