I have a backup of the database. I need to restore it at a particular time. I know the sequence, which was at that time (I've seen it so: 'archive log list;'). when I am specifying:
run {
set until sequence MY_SEQUENCE;
...
}
I got an error:
error ORA-01180. can not create datafile 1.
If 'set until sequence' clause isn't specified, the process of restore is successful.
The database has only one incarnation. All backup sets status available. Backup set of archivelog with MY_SEQUENCE available. Backup was taken after I looked at the current sequence.
v$datafile_header shows zero CHECKPOINT_CHANGE#.
1265151.1 not helpful.