Database Backup and Recovery (MOSC)

MOSC Banner

RMAN looking for archivelog before resetlog (almost, but not unlike Doc ID 265010.1)

edited Apr 4, 2022 2:39AM in Database Backup and Recovery (MOSC) 1 commentAnswered

Long story short, I restored a database with noresetlogs, set offline old undo, create new undo and set it as default, drop old undo. Backup has been running fine on this database.

This new database has been running archivelog to number 7xx. But when I try to restore to new server, it look for past archivelog ( 2xxx - yes, that four digits.)

The Doc ID 265010.1 gives a different scenario ( the offline datafile dropped after restoring halfway?)

While the solution given in the Doc ID works ( all files were transferred anyway) and I can just recover it manually and then open resetlogs on this new server, it still an extra step needed to be done that should have been done by backup software, should rman didn't generate error looking for archivelog files it should no longer need / required.

Tagged:

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