Can rfutil roll forward done while db is online?

[balebob]

Hi All,

We have a warm-spare db on a different server. I am wondering if I can ship the filled AI extents over and roll forward while the db on this warm-spare server is online. The reason is that warm-spare database is also being used for running report during the day (before the next refresh at mid-night).

Thanks,
BoB.

 

[TomBascom]

No.

As soon as you bring a database up, single user or multi-user, you can no longer roll forward against it. Even if you change nothing and immediately shut it down you have lost the ability to roll-forward against that db. You would need to restore from backup and start over.

You could, possibly, be reporting using a -RO session against your warm spare. In which case your roll-forward process could continue to keep things up to date but your -RO reports might not like the result very much (they may crash).

You could also backup the warm spare using -norecover in order to create a reporting db.

Or you could use Fathom replication to maintain both a warm spare and a reporting database.