I have done all steps ( logs properly shipped and applied ) prior to activating a standby DB.
When I perform the following steps i get this error which is very strange.
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH; OK
shutdown immediate; OK
startup mount; OK
alter database activate physical standby database;
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/usr/oradata/orastdby/oradata2/system01.dbf'
Thx in advance for the help
Depends upon how you built it. If you used RMAN this might work :
RMAN Incremental Backups to Roll Forward a Physical Standby Database
How large is your Primary Database?