Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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