Oracle DataGuard 之--Physical DG转换Logical DG
alter database start logical standby apply immediateORA-16239 signalled during: alter database start logical standby apply immediate...
Mon Nov 04 16:50:55 2013
alter database add standby logfile
'/dsk1/oradata/gz/std_redo01a.log' size 50m
Completed: alter database add standby logfile
'/dsk1/oradata/gz/std_redo01a.log' size 50m
Mon Nov 04 16:51:11 2013
alter database add standby logfile
'/dsk1/oradata/gz/std_redo02a.log' size 50m
Completed: alter database add standby logfile
'/dsk1/oradata/gz/std_redo02a.log' size 50m
Mon Nov 04 16:51:26 2013
alter database add standby logfile
'/dsk1/oradata/gz/std_redo03a.log' size 50m
Completed: alter database add standby logfile
'/dsk1/oradata/gz/std_redo03a.log' size 50m
Mon Nov 04 16:51:44 2013
alter database add standby logfile
'/dsk1/oradata/gz/std_redo04a.log' size 50m
Completed: alter database add standby logfile
'/dsk1/oradata/gz/std_redo04a.log' size 50m
alter database start logical standby apply immediate
LOGSTDBY: Creating new session for dbid 242121299 starting at scn 0x0000.00000000
LOGSTDBY: Created session of id 1
LOGSTDBY: Attempting to pre-register dictionary build logfiles
LOGMINER: Error 308 encountered, failed to readlogfile arch_1_57_830282966.log
LOGMINER: Encountered error 1291 while adding logfile arch_1_57_830282966.log to session 1
LOGSTDBY: Unable to register recovery logfiles, will resend
ALTER DATABASE START LOGICAL STANDBY APPLY (gz)
with optional part
IMMEDIATE
Attempt to start background Logical Standby process
Mon Nov 04 16:51:51 2013
LSP0 started with pid=27, OS id=4433
Completed: alter database start logical standby apply immediate
LOGMINER: Parameters summary for session# = 1
LOGMINER: Number of processes = 3, Transaction Chunk Size = 201
LOGMINER: Memory Size = 30M, Checkpoint interval = 150M
LOGMINER: SpillScn 0, ResetLogScn 0
Mon Nov 04 16:52:03 2013
RFS: Opened log for thread 1 sequence 57 dbid 242121299 branch 830282966
Mon Nov 04 16:52:03 2013
RFS: Assigned to RFS process 4435
RFS: Identified database type as 'logical standby': Client is ARCH pid 4792
RFS: Opened log for thread 1 sequence 58 dbid 242121299 branch 830282966
Mon Nov 04 16:52:04 2013
LOGMINER: summary for session# = 1
LOGMINER: StartScn: 1022094 (0x0000.000f988e)
LOGMINER: EndScn: 0 (0x0000.00000000)
LOGMINER: HighConsumedScn: 1022854 (0x0000.000f9b86)
LOGMINER: session_flag 0x1
RFS LogMiner: Registered logfile to LogMiner session id
RFS: Opened log for thread 1 sequence 59 dbid 242121299 branch 830282966
RFS LogMiner: Registered logfile to LogMiner session id
RFS LogMiner: Registered logfile to LogMiner session id
RFS: Opened log for thread 1 sequence 60 dbid 242121299 branch 830282966
Mon Nov 04 16:52:04 2013
LOGMINER: session#=1, reader MS00 pid=30 OS id=4437 sid=39 started
RFS LogMiner: Registered logfile to LogMiner session id
RFS LogMiner: RFS id assigned as thread PING handler
Mon Nov 04 16:52:04 2013
LOGMINER: session#=1, builder MS01 pid=31 OS id=4439 sid=37 started
Mon Nov 04 16:52:04 2013
LOGMINER: session#=1, preparer MS02 pid=32 OS id=4441 sid=40 started
LOGMINER: Turning ON Log Auto Delete
LOGMINER: Begin mining logfile during dictionary load for session 1 thread 1 sequence 57, /dsk4/arch_gz/arch_1_57_830282966.log
Mon Nov 04 16:52:11 2013
Thread 1 advanced to log sequence 3 (LGWR switch)
Current log# 3 seq# 3 mem# 0: /dsk1/oradata/gz/redo03a.log
Current log# 3 seq# 3 mem# 1: /dsk2/oradata/gz/redo03b.log
Mon Nov 04 16:52:13 2013
Archived Log entry 2 added for thread 1 sequence 2 ID 0xb284e791 dest 1:
Thread 1 advanced to log sequence 4 (LGWR switch)
Current log# 1 seq# 4 mem# 0: /dsk1/oradata/gz/redo01a.log
Current log# 1 seq# 4 mem# 1: /dsk2/oradata/gz/redo01b.log
Mon Nov 04 16:52:20 2013
Archived Log entry 3 added for thread 1 sequence 3 ID 0xb284e791 dest 1:
Mon Nov 04 16:52:21 2013
Some indexes or index partitions of table SYSTEM.LOGMNR_TAB$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_TS$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_OBJ$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_IND$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_ICOL$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_COL$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_USER$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_CDEF$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_CCOL$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_LOB$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_PROPS$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_ENC$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_COLTYPE$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_SUBCOLTYPE$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_ATTRCOL$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_TYPE$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_ATTRIBUTE$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_NTAB$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_REFCON$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_OPQTYPE$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_KOPM$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_PARTOBJ$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_TABPART$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_INDPART$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_TABSUBPART$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_INDSUBPART$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_TABCOMPART$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_INDCOMPART$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_LOBFRAG$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_LOGMNR_BUILDLOG have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_SEED$ have been marked unusable
Some indexes or index partitions of table SYSTEM.LOGMNR_DICTIONARY$ have been marked unusable
Indexes of tableSYSTEM.LOGMNR_ATTRCOL$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_ATTRIBUTE$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_CCOL$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_CDEF$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_COL$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_COLTYPE$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_DICTIONARY$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_ENC$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_ICOL$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_IND$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_INDCOMPART$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_INDPART$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_INDSUBPART$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_KOPM$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_LOB$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_LOBFRAG$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_LOGMNR_BUILDLOG have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_NTAB$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_OBJ$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_OPQTYPE$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_PARTOBJ$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_PROPS$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_REFCON$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_SEED$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_SUBCOLTYPE$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_TAB$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_TABCOMPART$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_TABPART$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_TABSUBPART$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_TS$ have been rebuilt and are now usable
Mon Nov 04 16:52:24 2013
Thread 1 cannot allocate new log, sequence 5
Checkpoint not complete
Current log# 1 seq# 4 mem# 0: /dsk1/oradata/gz/redo01a.log
Current log# 1 seq# 4 mem# 1: /dsk2/oradata/gz/redo01b.log
Indexes of tableSYSTEM.LOGMNR_TYPE$ have been rebuilt and are now usable
Indexes of tableSYSTEM.LOGMNR_USER$ have been rebuilt and are now usable
Thread 1 advanced to log sequence 5 (LGWR switch)
Current log# 2 seq# 5 mem# 0: /dsk1/oradata/gz/redo02a.log
Current log# 2 seq# 5 mem# 1: /dsk2/oradata/gz/redo02b.log
Mon Nov 04 16:52:28 2013
Archived Log entry 4 added for thread 1 sequence 4 ID 0xb284e791 dest 1:
Mon Nov 04 16:52:37 2013
Starting background process SMCO
Mon Nov 04 16:52:37 2013
SMCO started with pid=33, OS id=4445
Mon Nov 04 16:52:52 2013
LOGMINER: End mining logfiles during dictionary load for session 1
Mon Nov 04 16:52:53 2013
LSP2 started with pid=35, OS id=4449
Mon Nov 04 16:52:54 2013
LOGMINER: Turning ON Log Auto Delete
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 57, /dsk4/arch_gz/arch_1_57_830282966.log
Mon Nov 04 16:52:54 2013
LOGSTDBY Analyzer process AS00 started with server id=0 pid=36 OS id=4451
LOGMINER: End mining logfile for session 1 thread 1 sequence 57, /dsk4/arch_gz/arch_1_57_830282966.log
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 58, /dsk4/arch_gz/arch_1_58_830
页:
[1]