Any option to open database before resetlog time?
I have a week's worth of full RMAN backups. In trying to fix a corruption issue, in error I did an open database resetlogs. When I did that I get
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u10/testdb/PROJ_TEST/datafiles/system01.dbf'
All my attempts to restore an earlier controlfile and restore do no work.
Example:
RMAN> run
2> {
3> set until time '06-APR-2022';
4> restore controlfile from '/u05/backup/PROJ_TEST/CF_TESTDB_1035134141_20220406_350_au0q7n8a_1_1';