Database Backup and Recovery (MOSC)

MOSC Banner

Any option to open database before resetlog time?

edited Apr 13, 2022 2:20PM in Database Backup and Recovery (MOSC) 2 commentsAnswered

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';

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