This forum is currently locked. You can't register or post questions at this time. (read more)

11.2.0.3 Dataguard setup standby activation fails

All posts relating to Oracle database administration.

Moderator: Tim...

jrmtl
Senior Member
Posts: 203
Joined: Tue Feb 22, 2005 7:08 pm
Location: Montreal

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: 203
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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 5 guests

cron