Create standby from standby became primary after failover
Recently I had to perform a failover on my standby DB, because my Primary Db had a hardware problem. Now I have to recreate our previously well worked environment. But I stuck just on the first step when I try to restore controlfile.
Here are my steps. I think they will tell you more than my long sentences.
On now primary DB:
bash-3.2$ tnsping stbill
TNS Ping Utility for HPUX: Version 10.2.0.4.0 - Production on 11-NOV-2012 13:14:01
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
/oracle2/10.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))) (CONNECT_DATA = (UR = A) (SERVER = DEDICATED) (SERVICE_NAME = bill)))