May 20, 2009 at 6:47 am
Hello,
is there a chance to restore a standby db which was activatet to recovery mode?
We have a disastertest were we want to switch between the productive db to the standby db.
After the switch to the standby db and test if all programs are working fine we go back to the productive db.
Oracle 10g has a function called "flashback" with them you can go back to a state before activating the standby db. (time stamp)
All what i want is to go around a new building of the standby db with a tape restore from the productive db (800 GB); activate the needed jobs...etc.
Please can anybody help me or knows a "workarround"?
thx in advance.
reinhard
May 20, 2009 at 7:02 am
To bring a database from STANDBY to ONLINE, run the following
RESTORE DATABASE <Database Name> WITH RECOVERY
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 20, 2009 at 7:46 am
Hello,
thats what i know, but how to bring it back to standby mode?
Point-in-Time? eq. 6 a.m.
Can i doe this with the Snapshot technology?
Thx
May 20, 2009 at 8:28 am
Restore a full backup and any tran logs you need. You're not going to get the DB back into standby in a state that will allow logs to be applied without starting again from a full backup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply