Home » Server Options » Data Guard » Why new physical standby database cannot received redo log after fail o ver (10.2.0.2, windows 32 bit)
Why new physical standby database cannot received redo log after fail o ver [message #519606] Mon, 15 August 2011 09:10
kytemanaic
Messages: 55
Registered: February 2009
Member
Hi

here's my rdbms spec:


SYS@cta>select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for 32-bit Windows: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production


I have originally configured a physical standby database configuration correctly.

orginally

primary db physical standby db
cta cta_std

later

primary db physical standby db
cta_std cta



After I performed a failed over using data guard broker.

it failover successfully.

when I tried to reinstate the former primary db as a physical standby database using the data guard broker, it fails.

so I disable the data guard broker configuration.

so I used the instructions from http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/scenarios.htm#i1050055
Quote:


Flashing Back a Failed Primary Database into a Physical Standby Database


to flashback the new physical standby database manually.

to my surprise it din error out any thing!

I tried all the troubleshooting guide with respect to the above,

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/troubleshooting.htm#i634242

Quote:

A.1.3 Standby Database Does Not Receive Redo Data from the Primary Database


here's my archive log information


from the new primary db, this is order by sequence

Quote:


SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME, applied FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# FIRST_TIME NEXT_TIME APP
---------- -------------------- -------------------- ---
1 15-AUG-2011 10:31:10 15-AUG-2011 10:31:12 NO
1 15-AUG-2011 10:31:10 15-AUG-2011 10:31:12 YES
2 15-AUG-2011 10:31:12 15-AUG-2011 10:40:20 NO
2 15-AUG-2011 10:31:12 15-AUG-2011 10:40:20 YES
3 15-AUG-2011 10:40:20 15-AUG-2011 10:48:27 NO
3 15-AUG-2011 10:40:20 15-AUG-2011 10:48:27 YES
3 15-AUG-2011 10:40:20 15-AUG-2011 10:48:27 YES
4 15-AUG-2011 10:48:27 15-AUG-2011 13:11:36 NO
4 15-AUG-2011 10:48:27 15-AUG-2011 13:11:36 YES
5 15-AUG-2011 13:11:36 15-AUG-2011 13:13:25 YES
5 15-AUG-2011 13:11:36 15-AUG-2011 13:13:25 NO

SEQUENCE# FIRST_TIME NEXT_TIME APP
---------- -------------------- -------------------- ---
6 15-AUG-2011 13:13:25 15-AUG-2011 14:13:37 NO
6 15-AUG-2011 13:13:25 15-AUG-2011 14:13:37 YES
7 15-AUG-2011 14:13:37 15-AUG-2011 14:17:11 YES
7 15-AUG-2011 14:13:37 15-AUG-2011 14:17:11 NO
8 15-AUG-2011 14:17:11 15-AUG-2011 15:59:29 YES
8 15-AUG-2011 14:17:11 15-AUG-2011 15:59:29 NO
9 15-AUG-2011 15:59:29 15-AUG-2011 17:32:29 NO
10 15-AUG-2011 17:32:29 15-AUG-2011 17:33:03 NO
10 15-AUG-2011 17:32:29 15-AUG-2011 17:33:03 YES
11 15-AUG-2011 17:33:03 15-AUG-2011 20:22:40 NO
11 15-AUG-2011 17:33:03 15-AUG-2011 20:22:40 YES

SEQUENCE# FIRST_TIME NEXT_TIME APP
---------- -------------------- -------------------- ---
12 15-AUG-2011 20:22:40 15-AUG-2011 20:22:55 NO
12 15-AUG-2011 20:22:40 15-AUG-2011 20:22:55 YES
13 15-AUG-2011 20:22:55 15-AUG-2011 20:35:51 YES
13 15-AUG-2011 20:22:55 15-AUG-2011 20:35:51 NO
14 15-AUG-2011 20:35:51 15-AUG-2011 20:38:50 NO
14 15-AUG-2011 20:35:51 15-AUG-2011 20:38:50 YES
15 15-AUG-2011 20:38:50 15-AUG-2011 20:46:45 NO
15 15-AUG-2011 20:38:50 15-AUG-2011 20:46:45 NO
178 10-AUG-2011 13:43:13 10-AUG-2011 13:43:38 NO
187 10-AUG-2011 14:52:34 10-AUG-2011 14:52:57 NO
198 11-AUG-2011 16:13:48 11-AUG-2011 16:14:11 NO

SEQUENCE# FIRST_TIME NEXT_TIME APP
---------- -------------------- -------------------- ---
203 11-AUG-2011 16:41:31 11-AUG-2011 16:41:54 NO
213 11-AUG-2011 21:49:35 11-AUG-2011 21:49:58 NO
218 11-AUG-2011 22:01:01 11-AUG-2011 22:01:26 NO
245 12-AUG-2011 13:02:01 12-AUG-2011 13:13:30 NO
246 12-AUG-2011 13:13:30 12-AUG-2011 16:46:56 NO
247 12-AUG-2011 16:46:56 12-AUG-2011 16:53:40 NO
248 12-AUG-2011 16:53:40 12-AUG-2011 16:53:48 NO
249 12-AUG-2011 16:53:48 12-AUG-2011 17:03:40 NO
250 12-AUG-2011 17:03:40 12-AUG-2011 20:06:16 YES
250 12-AUG-2011 17:03:40 12-AUG-2011 20:06:16 NO
251 12-AUG-2011 20:06:16 12-AUG-2011 20:06:31 YES

SEQUENCE# FIRST_TIME NEXT_TIME APP
---------- -------------------- -------------------- ---
251 12-AUG-2011 20:06:16 12-AUG-2011 20:06:31 NO
252 12-AUG-2011 20:06:31 12-AUG-2011 20:08:18 NO
252 12-AUG-2011 20:06:31 12-AUG-2011 20:08:18 YES
253 12-AUG-2011 20:08:18 15-AUG-2011 08:27:20 NO
253 12-AUG-2011 20:08:18 15-AUG-2011 08:27:20 YES
254 15-AUG-2011 08:27:20 15-AUG-2011 08:37:40 NO
254 15-AUG-2011 08:27:20 15-AUG-2011 08:37:40 YES
255 15-AUG-2011 08:37:40 15-AUG-2011 09:54:46 YES
255 15-AUG-2011 08:37:40 15-AUG-2011 09:54:46 NO
256 15-AUG-2011 09:54:46 15-AUG-2011 09:54:52 YES
256 15-AUG-2011 09:54:46 15-AUG-2011 09:54:52 NO

SEQUENCE# FIRST_TIME NEXT_TIME APP
---------- -------------------- -------------------- ---
257 15-AUG-2011 09:54:52 15-AUG-2011 09:55:19 NO
257 15-AUG-2011 09:54:52 15-AUG-2011 09:55:19 YES
258 15-AUG-2011 09:55:19 15-AUG-2011 10:17:21 NO
258 15-AUG-2011 09:55:19 15-AUG-2011 10:17:21 YES
259 15-AUG-2011 10:17:21 15-AUG-2011 10:17:27 YES
259 15-AUG-2011 10:17:21 15-AUG-2011 10:17:27 NO
260 15-AUG-2011 10:17:27 15-AUG-2011 10:20:12 YES
260 15-AUG-2011 10:17:27 15-AUG-2011 10:20:12 NO
261 15-AUG-2011 10:20:12 15-AUG-2011 10:20:18 YES
261 15-AUG-2011 10:20:12 15-AUG-2011 10:20:18 NO
262 15-AUG-2011 10:20:18 15-AUG-2011 10:28:16 YES

SEQUENCE# FIRST_TIME NEXT_TIME APP
---------- -------------------- -------------------- ---
262 15-AUG-2011 10:20:18 15-AUG-2011 10:28:16 NO
263 15-AUG-2011 10:28:16 15-AUG-2011 10:28:22 YES
263 15-AUG-2011 10:28:16 15-AUG-2011 10:28:22 NO
264 15-AUG-2011 10:28:22 15-AUG-2011 10:31:05 YES
264 15-AUG-2011 10:28:22 15-AUG-2011 10:31:05 YES

71 rows selected.



but when order by next_time, the order becomes very different.

SYS@ctastd>SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME, applied FROM V$ARCHIVED_LOG
ORDER BY NEXT_TIME;

 SEQUENCE# FIRST_TIME           NEXT_TIME            APP
---------- -------------------- -------------------- ---
       178 10-AUG-2011 13:43:13 10-AUG-2011 13:43:38 NO
       187 10-AUG-2011 14:52:34 10-AUG-2011 14:52:57 NO
       198 11-AUG-2011 16:13:48 11-AUG-2011 16:14:11 NO
       203 11-AUG-2011 16:41:31 11-AUG-2011 16:41:54 NO
       213 11-AUG-2011 21:49:35 11-AUG-2011 21:49:58 NO
       218 11-AUG-2011 22:01:01 11-AUG-2011 22:01:26 NO
       245 12-AUG-2011 13:02:01 12-AUG-2011 13:13:30 NO
       246 12-AUG-2011 13:13:30 12-AUG-2011 16:46:56 NO
       247 12-AUG-2011 16:46:56 12-AUG-2011 16:53:40 NO
       248 12-AUG-2011 16:53:40 12-AUG-2011 16:53:48 NO
       249 12-AUG-2011 16:53:48 12-AUG-2011 17:03:40 NO

 SEQUENCE# FIRST_TIME           NEXT_TIME            APP
---------- -------------------- -------------------- ---
       250 12-AUG-2011 17:03:40 12-AUG-2011 20:06:16 YES
       250 12-AUG-2011 17:03:40 12-AUG-2011 20:06:16 NO
       251 12-AUG-2011 20:06:16 12-AUG-2011 20:06:31 YES
       251 12-AUG-2011 20:06:16 12-AUG-2011 20:06:31 NO
       252 12-AUG-2011 20:06:31 12-AUG-2011 20:08:18 YES
       252 12-AUG-2011 20:06:31 12-AUG-2011 20:08:18 NO
       253 12-AUG-2011 20:08:18 15-AUG-2011 08:27:20 YES
       253 12-AUG-2011 20:08:18 15-AUG-2011 08:27:20 NO
       254 15-AUG-2011 08:27:20 15-AUG-2011 08:37:40 NO
       254 15-AUG-2011 08:27:20 15-AUG-2011 08:37:40 YES
       255 15-AUG-2011 08:37:40 15-AUG-2011 09:54:46 NO

 SEQUENCE# FIRST_TIME           NEXT_TIME            APP
---------- -------------------- -------------------- ---
       255 15-AUG-2011 08:37:40 15-AUG-2011 09:54:46 YES
       256 15-AUG-2011 09:54:46 15-AUG-2011 09:54:52 YES
       256 15-AUG-2011 09:54:46 15-AUG-2011 09:54:52 NO
       257 15-AUG-2011 09:54:52 15-AUG-2011 09:55:19 NO
       257 15-AUG-2011 09:54:52 15-AUG-2011 09:55:19 YES
       258 15-AUG-2011 09:55:19 15-AUG-2011 10:17:21 YES
       258 15-AUG-2011 09:55:19 15-AUG-2011 10:17:21 NO
       259 15-AUG-2011 10:17:21 15-AUG-2011 10:17:27 YES
       259 15-AUG-2011 10:17:21 15-AUG-2011 10:17:27 NO
       260 15-AUG-2011 10:17:27 15-AUG-2011 10:20:12 YES
       260 15-AUG-2011 10:17:27 15-AUG-2011 10:20:12 NO

 SEQUENCE# FIRST_TIME           NEXT_TIME            APP
---------- -------------------- -------------------- ---
       261 15-AUG-2011 10:20:12 15-AUG-2011 10:20:18 NO
       261 15-AUG-2011 10:20:12 15-AUG-2011 10:20:18 YES
       262 15-AUG-2011 10:20:18 15-AUG-2011 10:28:16 YES
       262 15-AUG-2011 10:20:18 15-AUG-2011 10:28:16 NO
       263 15-AUG-2011 10:28:16 15-AUG-2011 10:28:22 YES
       263 15-AUG-2011 10:28:16 15-AUG-2011 10:28:22 NO
       264 15-AUG-2011 10:28:22 15-AUG-2011 10:31:05 YES
       264 15-AUG-2011 10:28:22 15-AUG-2011 10:31:05 YES
         1 15-AUG-2011 10:31:10 15-AUG-2011 10:31:12 YES
         1 15-AUG-2011 10:31:10 15-AUG-2011 10:31:12 NO
         2 15-AUG-2011 10:31:12 15-AUG-2011 10:40:20 YES

 SEQUENCE# FIRST_TIME           NEXT_TIME            APP
---------- -------------------- -------------------- ---
         2 15-AUG-2011 10:31:12 15-AUG-2011 10:40:20 NO
         3 15-AUG-2011 10:40:20 15-AUG-2011 10:48:27 YES
         3 15-AUG-2011 10:40:20 15-AUG-2011 10:48:27 YES
         3 15-AUG-2011 10:40:20 15-AUG-2011 10:48:27 NO
         4 15-AUG-2011 10:48:27 15-AUG-2011 13:11:36 NO
         4 15-AUG-2011 10:48:27 15-AUG-2011 13:11:36 YES
         5 15-AUG-2011 13:11:36 15-AUG-2011 13:13:25 YES
         5 15-AUG-2011 13:11:36 15-AUG-2011 13:13:25 NO
         6 15-AUG-2011 13:13:25 15-AUG-2011 14:13:37 NO
         6 15-AUG-2011 13:13:25 15-AUG-2011 14:13:37 YES
         7 15-AUG-2011 14:13:37 15-AUG-2011 14:17:11 NO

 SEQUENCE# FIRST_TIME           NEXT_TIME            APP
---------- -------------------- -------------------- ---
         7 15-AUG-2011 14:13:37 15-AUG-2011 14:17:11 YES
         8 15-AUG-2011 14:17:11 15-AUG-2011 15:59:29 NO
         8 15-AUG-2011 14:17:11 15-AUG-2011 15:59:29 YES
         9 15-AUG-2011 15:59:29 15-AUG-2011 17:32:29 NO
        10 15-AUG-2011 17:32:29 15-AUG-2011 17:33:03 NO
        10 15-AUG-2011 17:32:29 15-AUG-2011 17:33:03 YES
        11 15-AUG-2011 17:33:03 15-AUG-2011 20:22:40 NO
        11 15-AUG-2011 17:33:03 15-AUG-2011 20:22:40 YES
        12 15-AUG-2011 20:22:40 15-AUG-2011 20:22:55 YES
        12 15-AUG-2011 20:22:40 15-AUG-2011 20:22:55 NO
        13 15-AUG-2011 20:22:55 15-AUG-2011 20:35:51 NO

 SEQUENCE# FIRST_TIME           NEXT_TIME            APP
---------- -------------------- -------------------- ---
        13 15-AUG-2011 20:22:55 15-AUG-2011 20:35:51 YES
        14 15-AUG-2011 20:35:51 15-AUG-2011 20:38:50 NO
        14 15-AUG-2011 20:35:51 15-AUG-2011 20:38:50 YES
        15 15-AUG-2011 20:38:50 15-AUG-2011 20:46:45 NO
        15 15-AUG-2011 20:38:50 15-AUG-2011 20:46:45 NO

71 rows selected.



there's no archive gap as well

SYS@cta>select * from v$archive_gap
  2  ;

no rows selected


here's the information on the new standby that fails to received any log whenever

a log switch is performed at the new primary, i.e. ALTER SYSTEM SWITCH LOGFILE;


SYS@cta>SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME,applied FROM V$ARCHIVED_LOG ORDE
R BY next_time ;

 SEQUENCE# FIRST_TIME           NEXT_TIME            APP
---------- -------------------- -------------------- ---
        11 15-AUG-2011 17:33:03 15-AUG-2011 20:22:40 YES
        12 15-AUG-2011 20:22:40 15-AUG-2011 20:22:55 YES
        13 15-AUG-2011 20:22:55 15-AUG-2011 20:35:51 YES
        14 15-AUG-2011 20:35:51 15-AUG-2011 20:38:50 YES


as you can see something is really wrong here.


according to http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/troubleshooting.htm#i634242

Quote:

You used an invalid backup as the basis for the standby database (for example, you used a backup from the wrong database, or did not create the standby control file using the correct method).


In fact i re-create the physical standby base according to http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ps.htm#i67520
Quote:


Step-by-Step Instructions for Creating a Physical Standby Database

but the problem still persists.

what could be wrong, what should be the next best solution?

but judging from the log there's a couple of switchovers performed the two servers.

also I used only a recovery catalog to catalog both primary and standby, you can't register both db in one recovery catalog since they both share the same dbid,

when I do the crosscheck command

on the new standby db



RMAN> crosscheck copy of database;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=139 devtype=DISK
validation failed for datafile copy
datafile copy filename=D:\ORA102\CTA\RECOVERY_FILE_DEST\CTASTD\DATAFILE\SYSTEM01
.DBF recid=58 stamp=759267132
validation succeeded for datafile copy
datafile copy filename=D:\ORA102\CTA\RECOVERY_FILE_DEST\CTA\DATAFILE\O1_MF_SYSTE
M_74B2TF1G_.DBF recid=65 stamp=759275129
validation failed for datafile copy
datafile copy filename=D:\ORA102\CTA\RECOVERY_FILE_DEST\CTASTD\DATAFILE\UNDOTBS0
1.DBF recid=59 stamp=759267158
validation succeeded for datafile copy
datafile copy filename=D:\ORA102\CTA\RECOVERY_FILE_DEST\CTA\DATAFILE\O1_MF_UNDOT
BS1_74B2V689_.DBF recid=69 stamp=759275129
validation succeeded for datafile copy
datafile copy filename=D:\ORA102\CTA\RECOVERY_FILE_DEST\CTA\DATAFILE\O1_MF_UNDOT
BS1_74B2O7MK_.DBF recid=68 stamp=759275129
validation failed for datafile copy
datafile copy filename=D:\ORA102\CTA\RECOVERY_FILE_DEST\CTASTD\DATAFILE\SYSAUX01
.DBF recid=60 stamp=759267181
validation succeeded for datafile copy
datafile copy filename=D:\ORA102\CTA\RECOVERY_FILE_DEST\CTA\DATAFILE\O1_MF_SYSAU
X_74B2VOGN_.DBF recid=64 stamp=759275129
validation succeeded for datafile copy
datafile copy filename=D:\ORA102\CTA\RECOVERY_FILE_DEST\CTA\DATAFILE\O1_MF_SYSAU
X_74B2OPTC_.DBF recid=63 stamp=759275129
validation failed for datafile copy
datafile copy filename=D:\ORA102\CTA\RECOVERY_FILE_DEST\CTASTD\DATAFILE\USERS01.
DBF recid=61 stamp=759267399
validation succeeded for datafile copy
datafile copy filename=D:\ORA102\CTA\RECOVERY_FILE_DEST\CTA\DATAFILE\O1_MF_USERS
_74B39OF5_.DBF recid=70 stamp=759275129
validation failed for datafile copy
datafile copy filename=D:\ORA102\CTA\RECOVERY_FILE_DEST\CTASTD\DATAFILE\TOMKYTE_
TS.DBF recid=62 stamp=759267411
validation succeeded for datafile copy
datafile copy filename=D:\ORA102\CTA\RECOVERY_FILE_DEST\CTA\DATAFILE\O1_MF_TOMKY
TE__74B2P62G_.DBF recid=66 stamp=759275129
validation succeeded for datafile copy
datafile copy filename=D:\ORA102\CTA\RECOVERY_FILE_DEST\CTA\DATAFILE\O1_MF_TOMKY
TE__74B2W4PG_.DBF recid=67 stamp=759275129
Crosschecked 13 objects


RMAN>




any files that is in the subdiredirectory fails D:\ORA102\CTA\RECOVERY_FILE_DEST\CTASTD\

i,e.

Quote:


validation failed for datafile copy
datafile copy filename=D:\ORA102\CTA\RECOVERY_FILE_DEST\CTASTD\DATAFILE\SYSTEM01
.DBF recid=58 stamp=759267132



but when I do a crosschek in the new primary, i,e, ctastd

Quote:


RMAN> crosscheck backup of database;

using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\ORA102\CTA\RECOVERY_FILE_DEST\CTA\BACKUPSET\2011_08_15\
_MF_NNNDF_CTA_20110815_1058_74K2VY1G_.BKP recid=95 stamp=759275128
Crosschecked 1 objects



the reverse happens!

any backup in D:\ORA102\CTA\RECOVERY_FILE_DEST\CTA\BACKUPSET\ becomes invalid!

here's my listener.ora and tns.name on the new standby db, cta


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = c:\ora102)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = CTA_DGMGRL)
      (ORACLE_HOME = C:\ora102)
      (SID_NAME = CTA)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = cta)
      (ORACLE_HOME = C:\ora102)
      (SID_NAME = cta)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle_test)(PORT = 1521))
    )
  )




tnsname.ora same on both servers.

CTA_PRIMARY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle_test)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = cta)
    )
  )

CTA_STANDBY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = CTASTD)
    )
  )


here's my archive details at the new archive_log_dest_1 and archive_log_dest_2 details on the new standby db, cta



SYS@cta>show parameter log_archive_dest_1

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string      location="D:\Ora102\cta\arc1",
                                                  valid_for=(ONLINE_LOGFILE,ALL
                                                 _ROLES)
log_archive_dest_10                  string
SYS@cta>show parameter log_archive_dest_2

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2                   string      service="(DESCRIPTION=(ADDRESS
                                                 _LIST=(ADDRESS=(PROTOCOL=tcp)(
                                                 HOST=STANDBY)(PORT=1521)))(CON
                                                 NECT_DATA=(SERVICE_NAME=CTASTD
                                                 _XPT)(INSTANCE_NAME=ctastd)(SE
                                                 RVER=dedicated)))",    ARCH SY
                                                 NC NOAFFIRM delay=0 OPTIONAL m
                                                 ax_failure=0 max_connections=1
                                                    reopen=300 db_unique_name="
                                                 CTASTD" register net_timeout=1
                                                 80  valid_for=(online_logfile,

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
                                                 primary_role)



here's my listner.ora on the new primary, ctastd

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = c:\ora102)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ctastd_dgmgrl)
      (ORACLE_HOME = C:\ora102)
      (SID_NAME = ctastd)
    )
  )

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1521))
  )



here's the archive_log_dest on the new primary, ctastd


SYS@ctastd>show parameter log_archive_dest_1

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1                   string      location="D:\Ora102\cta\arc1",
                                                  valid_for=(ONLINE_LOGFILE,ALL
                                                 _ROLES)
log_archive_dest_10                  string
SYS@ctastd>show parameter log_archive_dest_2

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2                   string      SERVICE=cta_primary LGWR ASYNC
                                                  VALID_FOR=(ONLINE_LOGFILES,PR
                                                 IMARY_ROLE) DB_UNIQUE_NAME=cta


thanks a lot for the advise and solution!

[Updated on: Mon, 15 August 2011 09:18]

Report message to a moderator

Previous Topic: switchover fails becoz of ORA-12514: TNS:listener does not currently
Next Topic: will data guard fail over causes a new incarnation
Goto Forum:
  


Current Time: Thu Mar 28 04:05:12 CDT 2024