I am trying to clone a 9i database (C) from a target 9i database (T). On running the rman script, i get the rman-20207 error : UNTIL TIME is before RESETLOGS time. When i do a list backup of database, no backup was display. Just yesterday, the target 9i database was refreshed from production (P), using rman. Does the refresh of T using rman, removed all previous backups of T?


No, it does not remove backups. They are just missing from the controlfile, and you can catalog them. When the T database was refreshed yesterday from P, a new incarnation of T started. But your UNTIL TIME clause refers to a point of time before that happened, when the previous incarnation was active. After restoring the controlfile on C, mount the database, then you can use the following command to view the incarnations:

RMAN> list incarnation;

You will also see the times when they started. Revert to the previous incarnation, e.g:

RMAN> reset database to incarnation 1;

Catalog the backups:

RMAN> catalog start with '/path/to/the/backups';

Then continue with restore and recover as you normally would.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.