Database Backup and Recovery (MOSC)

MOSC Banner

Recover DB from hot backup & roll forward.

Hi all,

I'm trying to recover a DB from a storage snapshot and roll forward to a certain time. We're trying this on a test server before applying to production systems.

Our procedure is the following :

1/ put the DB into "begin backup".

2/ taking a storage copy all the data (datafiles, controlfiles etc.) with PureStorage mechanism.

3/ Continuing normal activity...

4/ Recovery stage:

   a) shutdown the DB and the copy back the PuregStorage backup

   b) startup mount, alter database end backup & recover database until time '2021-06-01:01:00:00' (my begin backup was 31/5 at 15:00)

Recover applies all the archivelogs and at the end we get the following message.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center