In a support project you may face a situation where you have created a control file for online backup and you do not have sufficient archive logs to recover database.
At this point you will face issue while openeing the database using open reset logs.
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:\ORACLE\PM1\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'
In such cases you may try the below solution,
Set the parameter as below in oracle and open the database, now open resetlogs will not show any error messages.
_allow_resetlogs_corruption=true
Sql>alter system set _allow_resetlogs_corruption=true scope=memory;
Warning:- By setting this parameter to TRUE may cause the database to corrupt in many occassions, please use this solution wisely.
At this point you will face issue while openeing the database using open reset logs.
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'E:\ORACLE\PM1\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'
In such cases you may try the below solution,
Set the parameter as below in oracle and open the database, now open resetlogs will not show any error messages.
_allow_resetlogs_corruption=true
Sql>alter system set _allow_resetlogs_corruption=true scope=memory;
Warning:- By setting this parameter to TRUE may cause the database to corrupt in many occassions, please use this solution wisely.
iam applying the addons its not loading
ReplyDelete