Re: How to rebulid the primary after failover.

From: John Hurley <johnthehurley_at_gmail.com>
Date: Thu, 13 Sep 2012 08:32:06 -0700 (PDT)
Message-ID: <ccebbc99-97be-40f8-a828-9e423736aa9e_at_n9g2000yqn.googlegroups.com>

On Sep 13, 8:25 am, finn..._at_gmail.com wrote:
> 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.

Lets start with an overview of your environment please. Servers/ storage/databases with relevant details like platforms and version numbers.

Then give us a detailed overview of what you are trying to accomplish and what your initial configuration was before getting into trouble please. Received on Thu Sep 13 2012 - 10:32:06 CDT