Monday, February 12, 2018

ORA-01152: file 1 was not restored from a sufficiently old backup

on DR site after creating the DR database I am not able to start it and getting the error below:

[oracle@serv01n01 (db1apd1) dbs]$ srvctl start database -d db1apd
PRCR-1079 : Failed to start resource ora.db1apd.db
CRS-5017: The resource action "ora.db1apd.db start" encountered the following error:
ORA-10458: standby database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '+DATA/DB1APD/DATAFILE/system.915.967902569'
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/serv01n01/crs/trace/crsd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.db1apd.db' on 'serv01n01' failed
CRS-2632: There are no more servers to try to place resource 'ora.db1apd.db' on that would satisfy its placement policy
[oracle@serv01n01 (db1apd1) dbs]$


After looking at the primary site. I have noticed that the log_archive_dest_state_2 is reset so I need to enable it to get the recovery working. Because it is reset so no new logs are going to DR and DR site is not able to recover the database up to latest point in time. Hence getting the error.

SQL> show parameter log_archive_dest_state_2

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_2             string      RESET
SQL>
SQL>
SQL> alter system set log_archive_dest_state_2='enable' scope=both sid='*';

System altered.

SQL>


Once the parameter is enabled on primary site, I have tried starting the database on DR and it worked.

[oracle@serv01n01 (db1apd1) dbs]$ srvctl start database -d db1apd
[oracle@serv01n01 (db1apd1) dbs]$

--Issue fixed. 

No comments: