STANDBY DATABSE UNDO ERROR(ORA-10564、ORA-10567、ORA-01110)
standby database trace log
Tue Dec 15 10:19:43 2015
alter database recover managed standby database using current logfile disconnect
Attempt to start background Managed Standby Recovery process (oracle11)
Tue Dec 15 10:19:43 2015
MRP0 started with pid=28, OS id=25313
MRP0: Background Managed Standby Recovery process started (oracle11)
started logmerger process
Tue Dec 15 10:19:48 2015
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 12 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Log /orafile/oraarch/1_1031_882528643.rac
Completed: alter database recover managed standby database using current logfile disconnect
Tue Dec 15 10:19:49 2015
Errors in file /app/oracle/diag/rdbms/oracle11dg/oracle11/trace/oracle11_pr06_25328.trc (incident=576287):
ORA-00600: 內部錯誤程式碼, 引數: [3020], [3], [24862], [12607774], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 3, block# 24862, file offset is 407339008 bytes)
ORA-10564: tablespace UNDOTBS1
ORA-01110: 資料檔案 3: '/orafile/oradata/undotbs01.dbf'
ORA-10560: block type 'KTU UNDO BLOCK'
Incident details in: /app/oracle/diag/rdbms/oracle11dg/oracle11/incident/incdir_576287/oracle11_pr06_25328_i576287.trc
Tue Dec 15 10:19:49 2015
Errors in file /app/oracle/diag/rdbms/oracle11dg/oracle11/trace/oracle11_pr09_25334.trc (incident=576311):
ORA-00600: 內部錯誤程式碼, 引數: [3020], [3], [11606], [12594518], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 3, block# 11606, file offset is 190152704 bytes)
ORA-10564: tablespace UNDOTBS1
ORA-01110: 資料檔案 3: '/orafile/oradata/undotbs01.dbf'
ORA-10560: block type 'KTU UNDO BLOCK'
Incident details in: /app/oracle/diag/rdbms/oracle11dg/oracle11/incident/incdir_576311/oracle11_pr09_25334_i576311.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Slave exiting with ORA-600 exception
Errors in file /app/oracle/diag/rdbms/oracle11dg/oracle11/trace/oracle11_pr09_25334.trc:
ORA-00600: 內部錯誤程式碼, 引數: [3020], [3], [11606], [12594518], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 3, block# 11606, file offset is 190152704 bytes)
ORA-10564: tablespace UNDOTBS1
ORA-01110: 資料檔案 3: '/orafile/oradata/undotbs01.dbf'
ORA-10560: block type 'KTU UNDO BLOCK'
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Slave exiting with ORA-600 exception
Errors in file /app/oracle/diag/rdbms/oracle11dg/oracle11/trace/oracle11_pr06_25328.trc:
ORA-00600: 內部錯誤程式碼, 引數: [3020], [3], [24862], [12607774], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 3, block# 24862, file offset is 407339008 bytes)
ORA-10564: tablespace UNDOTBS1
ORA-01110: 資料檔案 3: '/orafile/oradata/undotbs01.dbf'
ORA-10560: block type 'KTU UNDO BLOCK'
Errors in file /app/oracle/diag/rdbms/oracle11dg/oracle11/trace/oracle11_mrp0_25313.trc (incident=576231):
ORA-00600: 內部錯誤程式碼, 引數: [3020], [3], [11606], [12594518], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 3, block# 11606, file offset is 190152704 bytes)
ORA-10564: tablespace UNDOTBS1
ORA-01110: 資料檔案 3: '/orafile/oradata/undotbs01.dbf'
ORA-10560: block type 'KTU UNDO BLOCK'
Incident details in: /app/oracle/diag/rdbms/oracle11dg/oracle11/incident/incdir_576231/oracle11_mrp0_25313_i576231.trc
Tue Dec 15 10:19:50 2015
Dumping diagnostic data in directory=[cdmp_20151215101950], requested by (instance=1, osid=25334 (PR09)), summary=[incident=576311].
Tue Dec 15 10:19:50 2015
Sweep [inc][576311]: completed
Sweep [inc][576287]: completed
Sweep [inc][576231]: completed
Sweep [inc2][576311]: completed
Sweep [inc2][576287]: completed
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Recovery Slave PR09 previously exited with exception 600
MRP0: Background Media Recovery terminated with error 448
Errors in file /app/oracle/diag/rdbms/oracle11dg/oracle11/trace/oracle11_pr00_25316.trc:
ORA-00448: 後臺程式正常結束
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Recovered data files to a consistent state at change 3539009743
MRP0: Background Media Recovery process shutdown (oracle11)
Dumping diagnostic data in directory=[cdmp_20151215101951], requested by (instance=1, osid=25313 (MRP0)), summary=[incident=576231].
ORA-01110: 資料檔案 3: '/orafile/oradata/undotbs01.dbf'Tue Dec 15 10:20:50 2015
Sweep [inc2][576231]: completed
ORA-10567: Redo is inconsistent with data block (file# 3, block# 24862, file offset is 407339008 bytes)Tue Dec 15 10:32:41 2015
db_recovery_file_dest_size of 819200 MB is 0.44% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Tue Dec 15 10:48:39 2015
alter tablespace UNDOTBS1 begin backup
ORA-1109 signalled during: alter tablespace UNDOTBS1 begin backup...
Tue Dec 15 10:49:52 2015
alter tablespace UNDOTBS1 end backup
Completed: alter tablespace UNDOTBS1 end backup
Tue Dec 15 10:55:14 2015
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 17
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Tue Dec 15 10:55:19 2015
ARCH shutting down
Tue Dec 15 10:55:19 2015
ARCH shutting down
Tue Dec 15 10:55:19 2015
ARC3: Archival stoppedARCH shutting down
Tue Dec 15 10:55:19 2015
ARCH shutting down
ARC1: Archival stopped
ARC2: Relinquishing active heartbeat ARCH role
ARC0: Archival stopped
ARC2: Archival stopped
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Tue Dec 15 10:55:21 2015
Stopping background process VKTM
Shutting down archive processes
Archiving is disabled
Tue Dec 15 10:55:24 2015
Instance shutdown complete
Tue Dec 15 10:55:30 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =250
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /app/oracle/product/11.2.0/db_1
System name: Linux
Node name: smsplatform02
Release: 3.8.13-44.1.1.el6uek.x86_64
Version: #2 SMP Wed Sep 10 06:10:25 PDT 2014
Machine: x86_64
Using parameter settings in server-side spfile /app/oracle/product/11.2.0/db_1/dbs/spfileoracle11.ora
System parameters with non-default values:
processes = 1500
sessions = 2280
nls_language = "SIMPLIFIED CHINESE"
nls_territory = "CHINA"
memory_target = 12864M
control_files = "/orafile/oradata/control01.ctl"
control_files = "/orafile/oradata/control02.ctl"
control_files = "/backup/orafile/control03.ctl"
db_block_size = 16384
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=/orafile/oraarch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=oracle11dg"
log_archive_dest_2 = "SERVICE=primary LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=oracle11"
log_archive_dest_state_1 = "ENABLE"
log_archive_dest_state_2 = "ENABLE"
fal_client = "standby"
fal_server = "primary"
log_archive_config = "dg_config=(oracle11,oracle11dg)"
log_archive_format = "%t_%s_%r.rac"
db_recovery_file_dest = "/backup/orafile"
db_recovery_file_dest_size= 800G
standby_file_management = "AUTO"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=oracle11XDB)"
utl_file_dir = "/home/oracle/"
audit_file_dest = "/app/oracle/admin/oracle11/adump"
commit_wait = "NOWAIT"
commit_logging = "BATCH"
audit_trail = "DB"
db_name = "oracle11"
db_unique_name = "oracle11dg"
open_cursors = 3000
deferred_segment_creation= TRUE
diagnostic_dest = "/app/oracle"
Tue Dec 15 10:55:32 2015
PMON started with pid=2, OS id=26934
Tue Dec 15 10:55:32 2015
PSP0 started with pid=3, OS id=26936
Tue Dec 15 10:55:33 2015
VKTM started with pid=4, OS id=26938 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Tue Dec 15 10:55:33 2015
GEN0 started with pid=5, OS id=26942
Tue Dec 15 10:55:33 2015
DIAG started with pid=6, OS id=26944
Tue Dec 15 10:55:33 2015
DBRM started with pid=7, OS id=26946
Tue Dec 15 10:55:33 2015
DIA0 started with pid=8, OS id=26948
Tue Dec 15 10:55:33 2015
MMAN started with pid=9, OS id=26950
Tue Dec 15 10:55:33 2015
DBW0 started with pid=10, OS id=26952
Tue Dec 15 10:55:33 2015
DBW1 started with pid=11, OS id=26954
Tue Dec 15 10:55:33 2015
LGWR started with pid=12, OS id=26956
Tue Dec 15 10:55:33 2015
CKPT started with pid=13, OS id=26958
Tue Dec 15 10:55:33 2015
SMON started with pid=14, OS id=26960
Tue Dec 15 10:55:33 2015
RECO started with pid=15, OS id=26962
Tue Dec 15 10:55:33 2015
MMON started with pid=16, OS id=26964
Tue Dec 15 10:55:33 2015
MMNL started with pid=17, OS id=26966
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /app/oracle
Tue Dec 15 10:55:33 2015
ALTER DATABASE MOUNT
ARCH: STARTING ARCH PROCESSES
Tue Dec 15 10:55:37 2015
ARC0 started with pid=21, OS id=27155
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Successful mount of redo thread 1, with mount id 2591747685
Physical Standby Database mounted.
Lost write protection disabled
Tue Dec 15 10:55:38 2015
ARC1 started with pid=22, OS id=27171
Tue Dec 15 10:55:39 2015
ARC2 started with pid=23, OS id=27173
Tue Dec 15 10:55:39 2015
ARC3 started with pid=24, OS id=27175
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC2: Becoming the active heartbeat ARCH
Completed: ALTER DATABASE MOUNT
Tue Dec 15 10:55:39 2015
ALTER DATABASE OPEN
AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only access
Beginning standby crash recovery.
Serial Media Recovery started
Managed Standby Recovery starting Real Time Apply
Media Recovery Log /orafile/oraarch/1_1031_882528643.rac
Tue Dec 15 10:55:39 2015
Using STANDBY_ARCHIVE_DEST parameter default value as /orafile/oraarch
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Tue Dec 15 10:55:44 2015
Primary database is in MAXIMUM PERFORMANCE mode
RFS[1]: Assigned to RFS process 27185
RFS[1]: Selected log 12 for thread 1 sequence 1192 dbid -1722023950 branch 882528643
Tue Dec 15 10:55:44 2015
RFS[2]: Assigned to RFS process 27187
RFS[2]: Selected log 11 for thread 1 sequence 1191 dbid -1722023950 branch 882528643
Tue Dec 15 10:55:54 2015
Archived Log entry 1259 added for thread 1 sequence 1191 ID 0x998786f6 dest 1:
Tue Dec 15 10:55:59 2015
Media Recovery Log /orafile/oraarch/1_1032_882528643.rac
Tue Dec 15 10:56:18 2015
Media Recovery Log /orafile/oraarch/1_1033_882528643.rac
Tue Dec 15 10:56:51 2015
Media Recovery Log /orafile/oraarch/1_1034_882528643.rac
Tue Dec 15 10:57:18 2015
Media Recovery Log /orafile/oraarch/1_1035_882528643.rac
Tue Dec 15 10:58:06 2015
Media Recovery Log /orafile/oraarch/1_1036_882528643.rac
Tue Dec 15 10:58:38 2015
Media Recovery Log /orafile/oraarch/1_1037_882528643.rac
Media Recovery Log /orafile/oraarch/1_1038_882528643.rac
Tue Dec 15 10:58:58 2015
Media Recovery Log /orafile/oraarch/1_1039_882528643.rac
Tue Dec 15 10:59:17 2015
Media Recovery Log /orafile/oraarch/1_1040_882528643.rac
Tue Dec 15 10:59:30 2015
Media Recovery Log /orafile/oraarch/1_1041_882528643.rac
Tue Dec 15 10:59:48 2015
Media Recovery Log /orafile/oraarch/1_1042_882528643.rac
Tue Dec 15 11:00:04 2015
Media Recovery Log /orafile/oraarch/1_1043_882528643.rac
Tue Dec 15 11:00:47 2015
Media Recovery Log /orafile/oraarch/1_1044_882528643.rac
Media Recovery Log /orafile/oraarch/1_1045_882528643.rac
Media Recovery Log /orafile/oraarch/1_1046_882528643.rac
Tue Dec 15 11:01:04 2015
Media Recovery Log /orafile/oraarch/1_1047_882528643.rac
Tue Dec 15 11:01:17 2015
Media Recovery Log /orafile/oraarch/1_1048_882528643.rac
Tue Dec 15 11:01:36 2015
Media Recovery Log /orafile/oraarch/1_1049_882528643.rac
Tue Dec 15 11:01:53 2015
Media Recovery Log /orafile/oraarch/1_1050_882528643.rac
priamry database
alter tablespace UNDOTBS1 begin backup;
host cp /orafile/oradata/undotbs01.dbf /home/oracle/undotbs01.dbf
alter tablespace UNDOTBS1 end backup;
standby database
SQL> alter database datafile 3 offline drop;
Database altered.
SQL> host cp /orafile/oradata/undotbs01.dbf /orafile/oradata/bakundotbs01.dbf
SQL> host scp /home/oracle/undotbs01.dbf oracle@172.20.1.100:/orafile/oradata/undotbs01.dbf
SQL> alter database datafile 3 online;
Database altered.
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> alter database open read only;
Database altered.
SQL> alter database recover managed standby database using current logfile disconnect;
Database altered.
see standby tarce日誌已經恢復正常
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =250
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /app/oracle/product/11.2.0/db_1
System name: Linux
Node name: smsplatform02
Release: 3.8.13-44.1.1.el6uek.x86_64
Version: #2 SMP Wed Sep 10 06:10:25 PDT 2014
Machine: x86_64
Using parameter settings in server-side spfile /app/oracle/product/11.2.0/db_1/dbs/spfileoracle11.ora
System parameters with non-default values:
processes = 1500
sessions = 2280
nls_language = "SIMPLIFIED CHINESE"
nls_territory = "CHINA"
memory_target = 12864M
control_files = "/orafile/oradata/control01.ctl"
control_files = "/orafile/oradata/control02.ctl"
control_files = "/backup/orafile/control03.ctl"
db_block_size = 16384
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=/orafile/oraarch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=oracle11dg"
log_archive_dest_2 = "SERVICE=primary LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=oracle11"
log_archive_dest_state_1 = "ENABLE"
log_archive_dest_state_2 = "ENABLE"
fal_client = "standby"
fal_server = "primary"
log_archive_config = "dg_config=(oracle11,oracle11dg)"
log_archive_format = "%t_%s_%r.rac"
db_recovery_file_dest = "/backup/orafile"
db_recovery_file_dest_size= 800G
standby_file_management = "AUTO"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=oracle11XDB)"
utl_file_dir = "/home/oracle/"
audit_file_dest = "/app/oracle/admin/oracle11/adump"
commit_wait = "NOWAIT"
commit_logging = "BATCH"
audit_trail = "DB"
db_name = "oracle11"
db_unique_name = "oracle11dg"
open_cursors = 3000
deferred_segment_creation= TRUE
diagnostic_dest = "/app/oracle"
Tue Dec 15 10:55:32 2015
PMON started with pid=2, OS id=26934
Tue Dec 15 10:55:32 2015
PSP0 started with pid=3, OS id=26936
Tue Dec 15 10:55:33 2015
VKTM started with pid=4, OS id=26938 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Tue Dec 15 10:55:33 2015
GEN0 started with pid=5, OS id=26942
Tue Dec 15 10:55:33 2015
DIAG started with pid=6, OS id=26944
Tue Dec 15 10:55:33 2015
DBRM started with pid=7, OS id=26946
Tue Dec 15 10:55:33 2015
DIA0 started with pid=8, OS id=26948
Tue Dec 15 10:55:33 2015
MMAN started with pid=9, OS id=26950
Tue Dec 15 10:55:33 2015
DBW0 started with pid=10, OS id=26952
Tue Dec 15 10:55:33 2015
DBW1 started with pid=11, OS id=26954
Tue Dec 15 10:55:33 2015
LGWR started with pid=12, OS id=26956
Tue Dec 15 10:55:33 2015
CKPT started with pid=13, OS id=26958
Tue Dec 15 10:55:33 2015
SMON started with pid=14, OS id=26960
Tue Dec 15 10:55:33 2015
RECO started with pid=15, OS id=26962
Tue Dec 15 10:55:33 2015
MMON started with pid=16, OS id=26964
Tue Dec 15 10:55:33 2015
MMNL started with pid=17, OS id=26966
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /app/oracle
Tue Dec 15 10:55:33 2015
ALTER DATABASE MOUNT
ARCH: STARTING ARCH PROCESSES
Tue Dec 15 10:55:37 2015
ARC0 started with pid=21, OS id=27155
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Successful mount of redo thread 1, with mount id 2591747685
Physical Standby Database mounted.
Lost write protection disabled
Tue Dec 15 10:55:38 2015
ARC1 started with pid=22, OS id=27171
Tue Dec 15 10:55:39 2015
ARC2 started with pid=23, OS id=27173
Tue Dec 15 10:55:39 2015
ARC3 started with pid=24, OS id=27175
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC2: Becoming the active heartbeat ARCH
Completed: ALTER DATABASE MOUNT
Tue Dec 15 10:55:39 2015
ALTER DATABASE OPEN
AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only access
Beginning standby crash recovery.
Serial Media Recovery started
Managed Standby Recovery starting Real Time Apply
Media Recovery Log /orafile/oraarch/1_1031_882528643.rac
Tue Dec 15 10:55:39 2015
Using STANDBY_ARCHIVE_DEST parameter default value as /orafile/oraarch
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Tue Dec 15 10:55:44 2015
Primary database is in MAXIMUM PERFORMANCE mode
RFS[1]: Assigned to RFS process 27185
RFS[1]: Selected log 12 for thread 1 sequence 1192 dbid -1722023950 branch 882528643
Tue Dec 15 10:55:44 2015
RFS[2]: Assigned to RFS process 27187
RFS[2]: Selected log 11 for thread 1 sequence 1191 dbid -1722023950 branch 882528643
Tue Dec 15 10:55:54 2015
Archived Log entry 1259 added for thread 1 sequence 1191 ID 0x998786f6 dest 1:
Tue Dec 15 10:55:59 2015
Media Recovery Log /orafile/oraarch/1_1032_882528643.rac
Tue Dec 15 10:56:18 2015
Media Recovery Log /orafile/oraarch/1_1033_882528643.rac
Tue Dec 15 10:56:51 2015
Media Recovery Log /orafile/oraarch/1_1034_882528643.rac
Tue Dec 15 10:57:18 2015
Media Recovery Log /orafile/oraarch/1_1035_882528643.rac
Tue Dec 15 10:58:06 2015
Media Recovery Log /orafile/oraarch/1_1036_882528643.rac
Tue Dec 15 10:58:38 2015
Media Recovery Log /orafile/oraarch/1_1037_882528643.rac
Media Recovery Log /orafile/oraarch/1_1038_882528643.rac
Tue Dec 15 10:58:58 2015
Media Recovery Log /orafile/oraarch/1_1039_882528643.rac
Tue Dec 15 10:59:17 2015
Media Recovery Log /orafile/oraarch/1_1040_882528643.rac
Tue Dec 15 10:59:30 2015
Media Recovery Log /orafile/oraarch/1_1041_882528643.rac
Tue Dec 15 10:59:48 2015
Media Recovery Log /orafile/oraarch/1_1042_882528643.rac
Tue Dec 15 11:00:04 2015
Media Recovery Log /orafile/oraarch/1_1043_882528643.rac
Tue Dec 15 11:00:47 2015
Media Recovery Log /orafile/oraarch/1_1044_882528643.rac
Media Recovery Log /orafile/oraarch/1_1045_882528643.rac
Media Recovery Log /orafile/oraarch/1_1046_882528643.rac
Tue Dec 15 11:01:04 2015
Media Recovery Log /orafile/oraarch/1_1047_882528643.rac
Tue Dec 15 11:01:17 2015
Media Recovery Log /orafile/oraarch/1_1048_882528643.rac
Tue Dec 15 11:01:36 2015
Media Recovery Log /orafile/oraarch/1_1049_882528643.rac
Tue Dec 15 11:01:53 2015
Media Recovery Log /orafile/oraarch/1_1050_882528643.rac
Tue Dec 15 10:19:43 2015
alter database recover managed standby database using current logfile disconnect
Attempt to start background Managed Standby Recovery process (oracle11)
Tue Dec 15 10:19:43 2015
MRP0 started with pid=28, OS id=25313
MRP0: Background Managed Standby Recovery process started (oracle11)
started logmerger process
Tue Dec 15 10:19:48 2015
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 12 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Log /orafile/oraarch/1_1031_882528643.rac
Completed: alter database recover managed standby database using current logfile disconnect
Tue Dec 15 10:19:49 2015
Errors in file /app/oracle/diag/rdbms/oracle11dg/oracle11/trace/oracle11_pr06_25328.trc (incident=576287):
ORA-00600: 內部錯誤程式碼, 引數: [3020], [3], [24862], [12607774], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 3, block# 24862, file offset is 407339008 bytes)
ORA-10564: tablespace UNDOTBS1
ORA-01110: 資料檔案 3: '/orafile/oradata/undotbs01.dbf'
ORA-10560: block type 'KTU UNDO BLOCK'
Incident details in: /app/oracle/diag/rdbms/oracle11dg/oracle11/incident/incdir_576287/oracle11_pr06_25328_i576287.trc
Tue Dec 15 10:19:49 2015
Errors in file /app/oracle/diag/rdbms/oracle11dg/oracle11/trace/oracle11_pr09_25334.trc (incident=576311):
ORA-00600: 內部錯誤程式碼, 引數: [3020], [3], [11606], [12594518], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 3, block# 11606, file offset is 190152704 bytes)
ORA-10564: tablespace UNDOTBS1
ORA-01110: 資料檔案 3: '/orafile/oradata/undotbs01.dbf'
ORA-10560: block type 'KTU UNDO BLOCK'
Incident details in: /app/oracle/diag/rdbms/oracle11dg/oracle11/incident/incdir_576311/oracle11_pr09_25334_i576311.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Slave exiting with ORA-600 exception
Errors in file /app/oracle/diag/rdbms/oracle11dg/oracle11/trace/oracle11_pr09_25334.trc:
ORA-00600: 內部錯誤程式碼, 引數: [3020], [3], [11606], [12594518], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 3, block# 11606, file offset is 190152704 bytes)
ORA-10564: tablespace UNDOTBS1
ORA-01110: 資料檔案 3: '/orafile/oradata/undotbs01.dbf'
ORA-10560: block type 'KTU UNDO BLOCK'
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Slave exiting with ORA-600 exception
Errors in file /app/oracle/diag/rdbms/oracle11dg/oracle11/trace/oracle11_pr06_25328.trc:
ORA-00600: 內部錯誤程式碼, 引數: [3020], [3], [24862], [12607774], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 3, block# 24862, file offset is 407339008 bytes)
ORA-10564: tablespace UNDOTBS1
ORA-01110: 資料檔案 3: '/orafile/oradata/undotbs01.dbf'
ORA-10560: block type 'KTU UNDO BLOCK'
Errors in file /app/oracle/diag/rdbms/oracle11dg/oracle11/trace/oracle11_mrp0_25313.trc (incident=576231):
ORA-00600: 內部錯誤程式碼, 引數: [3020], [3], [11606], [12594518], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 3, block# 11606, file offset is 190152704 bytes)
ORA-10564: tablespace UNDOTBS1
ORA-01110: 資料檔案 3: '/orafile/oradata/undotbs01.dbf'
ORA-10560: block type 'KTU UNDO BLOCK'
Incident details in: /app/oracle/diag/rdbms/oracle11dg/oracle11/incident/incdir_576231/oracle11_mrp0_25313_i576231.trc
Tue Dec 15 10:19:50 2015
Dumping diagnostic data in directory=[cdmp_20151215101950], requested by (instance=1, osid=25334 (PR09)), summary=[incident=576311].
Tue Dec 15 10:19:50 2015
Sweep [inc][576311]: completed
Sweep [inc][576287]: completed
Sweep [inc][576231]: completed
Sweep [inc2][576311]: completed
Sweep [inc2][576287]: completed
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Recovery Slave PR09 previously exited with exception 600
MRP0: Background Media Recovery terminated with error 448
Errors in file /app/oracle/diag/rdbms/oracle11dg/oracle11/trace/oracle11_pr00_25316.trc:
ORA-00448: 後臺程式正常結束
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Recovered data files to a consistent state at change 3539009743
MRP0: Background Media Recovery process shutdown (oracle11)
Dumping diagnostic data in directory=[cdmp_20151215101951], requested by (instance=1, osid=25313 (MRP0)), summary=[incident=576231].
ORA-01110: 資料檔案 3: '/orafile/oradata/undotbs01.dbf'Tue Dec 15 10:20:50 2015
Sweep [inc2][576231]: completed
ORA-10567: Redo is inconsistent with data block (file# 3, block# 24862, file offset is 407339008 bytes)Tue Dec 15 10:32:41 2015
db_recovery_file_dest_size of 819200 MB is 0.44% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Tue Dec 15 10:48:39 2015
alter tablespace UNDOTBS1 begin backup
ORA-1109 signalled during: alter tablespace UNDOTBS1 begin backup...
Tue Dec 15 10:49:52 2015
alter tablespace UNDOTBS1 end backup
Completed: alter tablespace UNDOTBS1 end backup
Tue Dec 15 10:55:14 2015
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 17
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Tue Dec 15 10:55:19 2015
ARCH shutting down
Tue Dec 15 10:55:19 2015
ARCH shutting down
Tue Dec 15 10:55:19 2015
ARC3: Archival stoppedARCH shutting down
Tue Dec 15 10:55:19 2015
ARCH shutting down
ARC1: Archival stopped
ARC2: Relinquishing active heartbeat ARCH role
ARC0: Archival stopped
ARC2: Archival stopped
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Tue Dec 15 10:55:21 2015
Stopping background process VKTM
Shutting down archive processes
Archiving is disabled
Tue Dec 15 10:55:24 2015
Instance shutdown complete
Tue Dec 15 10:55:30 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =250
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /app/oracle/product/11.2.0/db_1
System name: Linux
Node name: smsplatform02
Release: 3.8.13-44.1.1.el6uek.x86_64
Version: #2 SMP Wed Sep 10 06:10:25 PDT 2014
Machine: x86_64
Using parameter settings in server-side spfile /app/oracle/product/11.2.0/db_1/dbs/spfileoracle11.ora
System parameters with non-default values:
processes = 1500
sessions = 2280
nls_language = "SIMPLIFIED CHINESE"
nls_territory = "CHINA"
memory_target = 12864M
control_files = "/orafile/oradata/control01.ctl"
control_files = "/orafile/oradata/control02.ctl"
control_files = "/backup/orafile/control03.ctl"
db_block_size = 16384
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=/orafile/oraarch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=oracle11dg"
log_archive_dest_2 = "SERVICE=primary LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=oracle11"
log_archive_dest_state_1 = "ENABLE"
log_archive_dest_state_2 = "ENABLE"
fal_client = "standby"
fal_server = "primary"
log_archive_config = "dg_config=(oracle11,oracle11dg)"
log_archive_format = "%t_%s_%r.rac"
db_recovery_file_dest = "/backup/orafile"
db_recovery_file_dest_size= 800G
standby_file_management = "AUTO"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=oracle11XDB)"
utl_file_dir = "/home/oracle/"
audit_file_dest = "/app/oracle/admin/oracle11/adump"
commit_wait = "NOWAIT"
commit_logging = "BATCH"
audit_trail = "DB"
db_name = "oracle11"
db_unique_name = "oracle11dg"
open_cursors = 3000
deferred_segment_creation= TRUE
diagnostic_dest = "/app/oracle"
Tue Dec 15 10:55:32 2015
PMON started with pid=2, OS id=26934
Tue Dec 15 10:55:32 2015
PSP0 started with pid=3, OS id=26936
Tue Dec 15 10:55:33 2015
VKTM started with pid=4, OS id=26938 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Tue Dec 15 10:55:33 2015
GEN0 started with pid=5, OS id=26942
Tue Dec 15 10:55:33 2015
DIAG started with pid=6, OS id=26944
Tue Dec 15 10:55:33 2015
DBRM started with pid=7, OS id=26946
Tue Dec 15 10:55:33 2015
DIA0 started with pid=8, OS id=26948
Tue Dec 15 10:55:33 2015
MMAN started with pid=9, OS id=26950
Tue Dec 15 10:55:33 2015
DBW0 started with pid=10, OS id=26952
Tue Dec 15 10:55:33 2015
DBW1 started with pid=11, OS id=26954
Tue Dec 15 10:55:33 2015
LGWR started with pid=12, OS id=26956
Tue Dec 15 10:55:33 2015
CKPT started with pid=13, OS id=26958
Tue Dec 15 10:55:33 2015
SMON started with pid=14, OS id=26960
Tue Dec 15 10:55:33 2015
RECO started with pid=15, OS id=26962
Tue Dec 15 10:55:33 2015
MMON started with pid=16, OS id=26964
Tue Dec 15 10:55:33 2015
MMNL started with pid=17, OS id=26966
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /app/oracle
Tue Dec 15 10:55:33 2015
ALTER DATABASE MOUNT
ARCH: STARTING ARCH PROCESSES
Tue Dec 15 10:55:37 2015
ARC0 started with pid=21, OS id=27155
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Successful mount of redo thread 1, with mount id 2591747685
Physical Standby Database mounted.
Lost write protection disabled
Tue Dec 15 10:55:38 2015
ARC1 started with pid=22, OS id=27171
Tue Dec 15 10:55:39 2015
ARC2 started with pid=23, OS id=27173
Tue Dec 15 10:55:39 2015
ARC3 started with pid=24, OS id=27175
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC2: Becoming the active heartbeat ARCH
Completed: ALTER DATABASE MOUNT
Tue Dec 15 10:55:39 2015
ALTER DATABASE OPEN
AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only access
Beginning standby crash recovery.
Serial Media Recovery started
Managed Standby Recovery starting Real Time Apply
Media Recovery Log /orafile/oraarch/1_1031_882528643.rac
Tue Dec 15 10:55:39 2015
Using STANDBY_ARCHIVE_DEST parameter default value as /orafile/oraarch
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Tue Dec 15 10:55:44 2015
Primary database is in MAXIMUM PERFORMANCE mode
RFS[1]: Assigned to RFS process 27185
RFS[1]: Selected log 12 for thread 1 sequence 1192 dbid -1722023950 branch 882528643
Tue Dec 15 10:55:44 2015
RFS[2]: Assigned to RFS process 27187
RFS[2]: Selected log 11 for thread 1 sequence 1191 dbid -1722023950 branch 882528643
Tue Dec 15 10:55:54 2015
Archived Log entry 1259 added for thread 1 sequence 1191 ID 0x998786f6 dest 1:
Tue Dec 15 10:55:59 2015
Media Recovery Log /orafile/oraarch/1_1032_882528643.rac
Tue Dec 15 10:56:18 2015
Media Recovery Log /orafile/oraarch/1_1033_882528643.rac
Tue Dec 15 10:56:51 2015
Media Recovery Log /orafile/oraarch/1_1034_882528643.rac
Tue Dec 15 10:57:18 2015
Media Recovery Log /orafile/oraarch/1_1035_882528643.rac
Tue Dec 15 10:58:06 2015
Media Recovery Log /orafile/oraarch/1_1036_882528643.rac
Tue Dec 15 10:58:38 2015
Media Recovery Log /orafile/oraarch/1_1037_882528643.rac
Media Recovery Log /orafile/oraarch/1_1038_882528643.rac
Tue Dec 15 10:58:58 2015
Media Recovery Log /orafile/oraarch/1_1039_882528643.rac
Tue Dec 15 10:59:17 2015
Media Recovery Log /orafile/oraarch/1_1040_882528643.rac
Tue Dec 15 10:59:30 2015
Media Recovery Log /orafile/oraarch/1_1041_882528643.rac
Tue Dec 15 10:59:48 2015
Media Recovery Log /orafile/oraarch/1_1042_882528643.rac
Tue Dec 15 11:00:04 2015
Media Recovery Log /orafile/oraarch/1_1043_882528643.rac
Tue Dec 15 11:00:47 2015
Media Recovery Log /orafile/oraarch/1_1044_882528643.rac
Media Recovery Log /orafile/oraarch/1_1045_882528643.rac
Media Recovery Log /orafile/oraarch/1_1046_882528643.rac
Tue Dec 15 11:01:04 2015
Media Recovery Log /orafile/oraarch/1_1047_882528643.rac
Tue Dec 15 11:01:17 2015
Media Recovery Log /orafile/oraarch/1_1048_882528643.rac
Tue Dec 15 11:01:36 2015
Media Recovery Log /orafile/oraarch/1_1049_882528643.rac
Tue Dec 15 11:01:53 2015
Media Recovery Log /orafile/oraarch/1_1050_882528643.rac
priamry database
alter tablespace UNDOTBS1 begin backup;
host cp /orafile/oradata/undotbs01.dbf /home/oracle/undotbs01.dbf
alter tablespace UNDOTBS1 end backup;
standby database
SQL> alter database datafile 3 offline drop;
Database altered.
SQL> host cp /orafile/oradata/undotbs01.dbf /orafile/oradata/bakundotbs01.dbf
SQL> host scp /home/oracle/undotbs01.dbf oracle@172.20.1.100:/orafile/oradata/undotbs01.dbf
SQL> alter database datafile 3 online;
Database altered.
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> alter database open read only;
Database altered.
SQL> alter database recover managed standby database using current logfile disconnect;
Database altered.
see standby tarce日誌已經恢復正常
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =250
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /app/oracle/product/11.2.0/db_1
System name: Linux
Node name: smsplatform02
Release: 3.8.13-44.1.1.el6uek.x86_64
Version: #2 SMP Wed Sep 10 06:10:25 PDT 2014
Machine: x86_64
Using parameter settings in server-side spfile /app/oracle/product/11.2.0/db_1/dbs/spfileoracle11.ora
System parameters with non-default values:
processes = 1500
sessions = 2280
nls_language = "SIMPLIFIED CHINESE"
nls_territory = "CHINA"
memory_target = 12864M
control_files = "/orafile/oradata/control01.ctl"
control_files = "/orafile/oradata/control02.ctl"
control_files = "/backup/orafile/control03.ctl"
db_block_size = 16384
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=/orafile/oraarch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=oracle11dg"
log_archive_dest_2 = "SERVICE=primary LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=oracle11"
log_archive_dest_state_1 = "ENABLE"
log_archive_dest_state_2 = "ENABLE"
fal_client = "standby"
fal_server = "primary"
log_archive_config = "dg_config=(oracle11,oracle11dg)"
log_archive_format = "%t_%s_%r.rac"
db_recovery_file_dest = "/backup/orafile"
db_recovery_file_dest_size= 800G
standby_file_management = "AUTO"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=oracle11XDB)"
utl_file_dir = "/home/oracle/"
audit_file_dest = "/app/oracle/admin/oracle11/adump"
commit_wait = "NOWAIT"
commit_logging = "BATCH"
audit_trail = "DB"
db_name = "oracle11"
db_unique_name = "oracle11dg"
open_cursors = 3000
deferred_segment_creation= TRUE
diagnostic_dest = "/app/oracle"
Tue Dec 15 10:55:32 2015
PMON started with pid=2, OS id=26934
Tue Dec 15 10:55:32 2015
PSP0 started with pid=3, OS id=26936
Tue Dec 15 10:55:33 2015
VKTM started with pid=4, OS id=26938 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Tue Dec 15 10:55:33 2015
GEN0 started with pid=5, OS id=26942
Tue Dec 15 10:55:33 2015
DIAG started with pid=6, OS id=26944
Tue Dec 15 10:55:33 2015
DBRM started with pid=7, OS id=26946
Tue Dec 15 10:55:33 2015
DIA0 started with pid=8, OS id=26948
Tue Dec 15 10:55:33 2015
MMAN started with pid=9, OS id=26950
Tue Dec 15 10:55:33 2015
DBW0 started with pid=10, OS id=26952
Tue Dec 15 10:55:33 2015
DBW1 started with pid=11, OS id=26954
Tue Dec 15 10:55:33 2015
LGWR started with pid=12, OS id=26956
Tue Dec 15 10:55:33 2015
CKPT started with pid=13, OS id=26958
Tue Dec 15 10:55:33 2015
SMON started with pid=14, OS id=26960
Tue Dec 15 10:55:33 2015
RECO started with pid=15, OS id=26962
Tue Dec 15 10:55:33 2015
MMON started with pid=16, OS id=26964
Tue Dec 15 10:55:33 2015
MMNL started with pid=17, OS id=26966
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /app/oracle
Tue Dec 15 10:55:33 2015
ALTER DATABASE MOUNT
ARCH: STARTING ARCH PROCESSES
Tue Dec 15 10:55:37 2015
ARC0 started with pid=21, OS id=27155
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Successful mount of redo thread 1, with mount id 2591747685
Physical Standby Database mounted.
Lost write protection disabled
Tue Dec 15 10:55:38 2015
ARC1 started with pid=22, OS id=27171
Tue Dec 15 10:55:39 2015
ARC2 started with pid=23, OS id=27173
Tue Dec 15 10:55:39 2015
ARC3 started with pid=24, OS id=27175
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC2: Becoming the active heartbeat ARCH
Completed: ALTER DATABASE MOUNT
Tue Dec 15 10:55:39 2015
ALTER DATABASE OPEN
AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only access
Beginning standby crash recovery.
Serial Media Recovery started
Managed Standby Recovery starting Real Time Apply
Media Recovery Log /orafile/oraarch/1_1031_882528643.rac
Tue Dec 15 10:55:39 2015
Using STANDBY_ARCHIVE_DEST parameter default value as /orafile/oraarch
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Tue Dec 15 10:55:44 2015
Primary database is in MAXIMUM PERFORMANCE mode
RFS[1]: Assigned to RFS process 27185
RFS[1]: Selected log 12 for thread 1 sequence 1192 dbid -1722023950 branch 882528643
Tue Dec 15 10:55:44 2015
RFS[2]: Assigned to RFS process 27187
RFS[2]: Selected log 11 for thread 1 sequence 1191 dbid -1722023950 branch 882528643
Tue Dec 15 10:55:54 2015
Archived Log entry 1259 added for thread 1 sequence 1191 ID 0x998786f6 dest 1:
Tue Dec 15 10:55:59 2015
Media Recovery Log /orafile/oraarch/1_1032_882528643.rac
Tue Dec 15 10:56:18 2015
Media Recovery Log /orafile/oraarch/1_1033_882528643.rac
Tue Dec 15 10:56:51 2015
Media Recovery Log /orafile/oraarch/1_1034_882528643.rac
Tue Dec 15 10:57:18 2015
Media Recovery Log /orafile/oraarch/1_1035_882528643.rac
Tue Dec 15 10:58:06 2015
Media Recovery Log /orafile/oraarch/1_1036_882528643.rac
Tue Dec 15 10:58:38 2015
Media Recovery Log /orafile/oraarch/1_1037_882528643.rac
Media Recovery Log /orafile/oraarch/1_1038_882528643.rac
Tue Dec 15 10:58:58 2015
Media Recovery Log /orafile/oraarch/1_1039_882528643.rac
Tue Dec 15 10:59:17 2015
Media Recovery Log /orafile/oraarch/1_1040_882528643.rac
Tue Dec 15 10:59:30 2015
Media Recovery Log /orafile/oraarch/1_1041_882528643.rac
Tue Dec 15 10:59:48 2015
Media Recovery Log /orafile/oraarch/1_1042_882528643.rac
Tue Dec 15 11:00:04 2015
Media Recovery Log /orafile/oraarch/1_1043_882528643.rac
Tue Dec 15 11:00:47 2015
Media Recovery Log /orafile/oraarch/1_1044_882528643.rac
Media Recovery Log /orafile/oraarch/1_1045_882528643.rac
Media Recovery Log /orafile/oraarch/1_1046_882528643.rac
Tue Dec 15 11:01:04 2015
Media Recovery Log /orafile/oraarch/1_1047_882528643.rac
Tue Dec 15 11:01:17 2015
Media Recovery Log /orafile/oraarch/1_1048_882528643.rac
Tue Dec 15 11:01:36 2015
Media Recovery Log /orafile/oraarch/1_1049_882528643.rac
Tue Dec 15 11:01:53 2015
Media Recovery Log /orafile/oraarch/1_1050_882528643.rac
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29065182/viewspace-1872555/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle standby ORA-00600:[3020] ORA-10567Oracle
- [江楓]In Memory Undo與logical standby databaseDatabase
- Oracle下的Databse,Instance,SchemasOracle
- oracle 跨庫查詢物件 CREATE DATABSE LINKOracle物件
- Oracle dataguard報錯:Error 1017 received logging on to the standbyOracleError
- PING[ARC2]: Heartbeat failed to connect to standby 'xyxdbs'. Error is 1605AIError
- ORA-01115 ORA-01110 ORA-27091 ORA-27072 Error: 5: I/O error (Doc ID 559697.1)Error
- PING[ARC2]: Heartbeat failed to connect to standby 'DG'. Error is 12541AIError
- PING[ARC2]: Heartbeat failed to connect to standby 'jzhddg'. Error is 16032.AIError
- 28、undo_1_2(undo引數、undo段、事務)
- Oracle standby的ORA-01578 ORA-01110 ORA-26040 坑爹的NOLOGGINGOracle
- 主庫到standby報錯解決:Error 12154 received logging on to the standby ORA-12154Error
- 邏輯STANDBY上的ORA-00600: internal error code, arguments: [krvtadc], [], [], [], [], []Error
- Innodb undo之 undo結構簡析
- MySQL undoMySql
- Oracle 12C RAC的單機Standby returning error ORA-16191OracleError
- PING[ARC5]: Heartbeat failed to connect to standby 'dghq'. Error is 12154.AIError
- 物理Standby資料庫及邏輯Standby資料庫(Physical Standby & Logical Standby)資料庫
- ORA-00600 3020 和ORA-10567 問題定位
- ora-01110處理
- Oracle Redo and UndoOracle Redo
- Oracle undo 管理Oracle
- Git undo 操作Git
- mysql undo管理MySql
- Oracle Undo SegmentOracle
- oracle undo管理Oracle
- oracle undo一Oracle
- Undo Mode (30)
- 【UNDO】使用重建UNDO表空間方法解決UNDO表空間過大問題
- 主庫報 Error 12154 received logging on to the standby PING[ARC2]Error
- standby databaseDatabase
- Innodb undo之 undo物理結構的初始化
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- 物理standby和邏輯standby的區別
- 【undo】undo 意外刪除處理辦法(非歸檔)
- Oracle 12c 新特性 - 臨時表undo(TEMP UNDO)Oracle
- MySQL purge 清理undoMySql
- InnoDB undo log原理