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'
Any ideas why ?
All works fine the phys. standby
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 2 guests