How to rebulid the primary after failover.

From: <finnysj_at_gmail.com>
Date: Thu, 13 Sep 2012 05:25:56 -0700 (PDT)
Message-ID: <9df377a6-3b2d-4717-b060-4bdc996021e5_at_googlegroups.com>

We have performed a failover in our environment by the below method . It was worst we are not able to bring up the production the only choice left over is failover.

We have enabled the flash back and created a checkpoint then failover.

SQL> select max(sequence#) from v$log_history;

MAX(SEQUENCE#)

---

          9221

SQL> alter system set db_recovery_file_dest_size=14G;

System altered.

SQL> alter system set db_recovery_file_dest='/u01/oradata/flashback';

System altered.

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database flashback on;

Database altered.

SQL> create restore point before_open_standby guarantee flashback database;

Restore point created.

SQL> alter database activate standby database;

Database altered.

SQL> select database_role from v$database;

DATABASE_ROLE

---

PRIMARY SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

SQL> select max(sequence#) from v$log_history;

MAX(SEQUENCE#)

---

          9221 (This is the log sequence same after the failover also)

after the we have nearly some 30 log sequence are generated but it started from the no 1.

Now we need to rebuild the Production DB and to sync with the standby.. please help us with the steps and suggest some documents. Received on Thu Sep 13 2012 - 07:25:56 CDT