11.2.0.3 Dataguard setup standby activation fails

All posts relating to Oracle database administration.

Moderator: Tim...

11.2.0.3 Dataguard setup standby activation fails

Postby jrmtl » Thu Aug 01, 2013 12:06 pm

Hello all,

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 ?
jrmtl
Senior Member
 
Posts: 195
Joined: Tue Feb 22, 2005 7:08 pm
Location: Montreal

Re: 11.2.0.3 Dataguard setup standby activation fails

Postby jrmtl » Fri Aug 02, 2013 5:00 pm

Just wanted to report back that I redid the rman restore and transferred the controlfile once again properly as I may have not done it correctly the first time.

All works fine the phys. standby
Thx
jrmtl
Senior Member
 
Posts: 195
Joined: Tue Feb 22, 2005 7:08 pm
Location: Montreal

Re: 11.2.0.3 Dataguard setup standby activation fails

Postby Tim... » Sat Aug 03, 2013 12:27 am

OK. :)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17935
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 10 guests

cron