If Getting this error so try to open resetlogs and noretlogs check all datafile header Chkpt no. is same verify all datafiles..In My case getting this error then kick start the database but after open the db quick take a backup first.
RMAN> recover database.
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01245: offline file 2 will be lost if RESETLOGS is done
ORA-01110: data file 2: '/oradb/app/oracle/oradata/orcl/users02.dbf'
NOTE:--- DBA use this own risk after that i dnt knw some data missing or not so before using this match all scn and sequence and verify to all
when database not open resetlog and noresetlog then kick start db
_allow_resetlogs_corruption=true
set on pfile the up but then up after that take a full backup because after that instance will be chrashed.
And co-ordinate with development and your seniors then take the action.
No comments:
Post a Comment