- 论坛徽章:
- 0
|
两台物理服务器硬件配置一样,主服务器安装CENTOS5.7 ,从服务器安装CENTOS6.4,安装ORACLE 11G 11.2.0.1版本,按http://www.cnblogs.com/tippoint/archive/2013/04/18/3029019.html教程配置DG同步后,从库始终无法正常采集日志及应用日志,从库alter日志如下:
<msg time='2013-10-04T17:47:12.587+08:00' org_id='oracle' comp_id='rdbms'
msg_id='dbkrlCheckSuppressAlert:323:7003611' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt>Adjusting the default value of parameter parallel_max_servers
</txt>
</msg>
<msg time='2013-10-04T17:47:12.587+08:00' org_id='oracle' comp_id='rdbms'
msg_id='dbkrlCheckSuppressAlert:323:1029887391' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt>from 320 to 135 due to the value of parameter processes (150)
</txt>
</msg>
<msg time='2013-10-04T17:47:12.588+08:00' org_id='oracle' comp_id='rdbms'
msg_id='opistr_real:935:3971575317' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt>Starting ORACLE instance (normal)
</txt>
</msg>
<msg time='2013-10-04T17:47:17.174+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksunfy:14932:2937430291' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt>LICENSE_MAX_SESSION = 0
</txt>
</msg>
<msg time='2013-10-04T17:47:17.174+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksunfy:14933:4207019197' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt>LICENSE_SESSIONS_WARNING = 0
</txt>
</msg>
<msg time='2013-10-04T17:47:17.190+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kcsnfy:326:968333812' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt>Picked latch-free SCN scheme 3
</txt>
</msg>
<msg time='2013-10-04T17:47:17.762+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='datacenter'
host_addr='127.0.0.1' pid='18706'>
<txt>Archive destination LOG_ARCHIVE_DEST_2 invalidated
</txt>
</msg>
<msg time='2013-10-04T17:47:17.762+08:00' org_id='oracle' comp_id='rdbms'
type='UNKNOWN' level='16' host_id='datacenter'
host_addr='127.0.0.1' pid='18706'>
<txt>DB_UNIQUE_NAME orcl is not in the Data Guard configuration
</txt>
</msg>
<msg time='2013-10-04T17:47:17.780+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ktunfy:2209:3053135360' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt>Autotune of undo retention is turned on.
</txt>
</msg>
<msg time='2013-10-04T17:47:17.783+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ktinfy:1611:1526000287' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt>IMODE=BR
</txt>
</msg>
<msg time='2013-10-04T17:47:17.784+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ktinfy:1619:3929296192' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt>ILAT =28
</txt>
</msg>
<msg time='2013-10-04T17:47:17.793+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kzunfy:2274:2892522327' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt>LICENSE_MAX_USERS = 0
</txt>
</msg>
<msg time='2013-10-04T17:47:17.793+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kzanfy:1093:1161496215' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt>SYS auditing is disabled
</txt>
</msg>
<msg time='2013-10-04T17:47:17.815+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14782:789250895' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt>Starting up:
</txt>
</msg>
<msg time='2013-10-04T17:47:17.815+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14785:3284844642' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt>Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
</txt>
</msg>
<msg time='2013-10-04T17:47:17.815+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14854:1489803337' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt>Using parameter settings in server-side spfile /usr/local/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora
</txt>
</msg>
<msg time='2013-10-04T17:47:17.815+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14887:144004252' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt>System parameters with non-default values:
</txt>
</msg>
<msg time='2013-10-04T17:47:17.815+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14923:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> processes = 150
</txt>
</msg>
<msg time='2013-10-04T17:47:17.815+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14923:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> memory_target = 19G
</txt>
</msg>
<msg time='2013-10-04T17:47:17.815+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> control_files = "/usr/local/oracle/oradata/orcl/control01.ctl"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.815+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> control_files = "/usr/local/oracle/flash_recovery_area/orcl/control02.ctl"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.815+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14923:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> db_block_size = 8192
</txt>
</msg>
<msg time='2013-10-04T17:47:17.815+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> compatible = "11.2.0.0.0"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> log_archive_dest_1 = "LOCATION=/data/archive1 valid_for=(all_logfiles,primary_role) db_unique_name=orcldg"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> log_archive_dest_2 = "SERVICE=CAMEL lgwr sync valid_for=(online_logfile,primary_role) db_unique_name=orcl"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> log_archive_dest_state_1 = "enable"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> log_archive_dest_state_2 = "enable"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> fal_server = "CAMEL"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> log_archive_config = "dg_config=(orcldg,CAMEL)"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> db_recovery_file_dest = "/data"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14923:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> db_recovery_file_dest_size= 3882M
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> standby_file_management = "AUTO"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> undo_tablespace = "UNDOTBS1"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> remote_login_passwordfile= "EXCLUSIVE"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> db_domain = "camel.net"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> audit_file_dest = "/usr/local/oracle/admin/orcl/adump"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> audit_trail = "DB"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> audit_trail = "EXTENDED"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> db_name = "orcl"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> db_unique_name = "orcldg"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14923:527288951' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> open_cursors = 300
</txt>
</msg>
<msg time='2013-10-04T17:47:17.816+08:00' org_id='oracle' comp_id='rdbms'
msg_id='kspdmp:14914:3633090201' type='NOTIFICATION' group='startup'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18706'>
<txt> diagnostic_dest = "/usr/local/oracle"
</txt>
</msg>
<msg time='2013-10-04T17:47:17.833+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18752'>
<txt>PMON started with pid=2, OS id=18752
</txt>
</msg>
<msg time='2013-10-04T17:47:17.846+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18756'>
<txt>VKTM started with pid=3, OS id=18756
</txt>
</msg>
<msg time='2013-10-04T17:47:17.849+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='18756'>
<txt>VKTM running at (100ms) precision
</txt>
</msg>
<msg time='2013-10-04T17:47:17.857+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18762'>
<txt>GEN0 started with pid=4, OS id=18762
</txt>
</msg>
<msg time='2013-10-04T17:47:17.876+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18766'>
<txt>DIAG started with pid=5, OS id=18766
</txt>
</msg>
<msg time='2013-10-04T17:47:17.887+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18770'>
<txt>DBRM started with pid=6, OS id=18770
</txt>
</msg>
<msg time='2013-10-04T17:47:17.901+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18774'>
<txt>PSP0 started with pid=7, OS id=18774
</txt>
</msg>
<msg time='2013-10-04T17:47:17.911+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18778'>
<txt>DIA0 started with pid=8, OS id=18778
</txt>
</msg>
<msg time='2013-10-04T17:47:17.930+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18782'>
<txt>MMAN started with pid=9, OS id=18782
</txt>
</msg>
<msg time='2013-10-04T17:47:17.956+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18786'>
<txt>DBW0 started with pid=10, OS id=18786
</txt>
</msg>
<msg time='2013-10-04T17:47:17.969+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18790'>
<txt>DBW1 started with pid=11, OS id=18790
</txt>
</msg>
<msg time='2013-10-04T17:47:18.071+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18794'>
<txt>DBW2 started with pid=12, OS id=18794
</txt>
</msg>
<msg time='2013-10-04T17:47:18.084+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18798'>
<txt>DBW3 started with pid=13, OS id=18798
</txt>
</msg>
<msg time='2013-10-04T17:47:18.102+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18802'>
<txt>LGWR started with pid=14, OS id=18802
</txt>
</msg>
<msg time='2013-10-04T17:47:18.113+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18806'>
<txt>CKPT started with pid=15, OS id=18806
</txt>
</msg>
<msg time='2013-10-04T17:47:18.125+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18810'>
<txt>SMON started with pid=16, OS id=18810
</txt>
</msg>
<msg time='2013-10-04T17:47:18.135+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18814'>
<txt>RECO started with pid=17, OS id=18814
</txt>
</msg>
<msg time='2013-10-04T17:47:18.151+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18818'>
<txt>MMON started with pid=18, OS id=18818
</txt>
</msg>
<msg time='2013-10-04T17:47:18.161+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='18822'>
<txt>MMNL started with pid=19, OS id=18822
</txt>
</msg>
<msg time='2013-10-04T17:47:18.162+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='18706'>
<txt>starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
</txt>
</msg>
<msg time='2013-10-04T17:47:18.181+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='18706'>
<txt>starting up 1 shared server(s) ...
</txt>
</msg>
<msg time='2013-10-04T17:47:18.194+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksu_setup_oracle_base:23695:1585839296' client_id='' type='NOTIFICATION'
group='startup' level='16' host_id='datacenter'
host_addr='127.0.0.1' module='' pid='18706'>
<txt>ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
</txt>
</msg>
<msg time='2013-10-04T17:47:18.194+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksu_setup_oracle_base:23734:119623615' client_id='' type='NOTIFICATION'
group='startup' level='16' host_id='datacenter'
host_addr='127.0.0.1' module='' pid='18706'>
<txt>Reusing ORACLE_BASE from an earlier startup = /usr/local/oracle
</txt>
</msg>
<msg time='2013-10-04T18:02:00.294+08:00' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:2994:4222364190' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' host_id='datacenter'
host_addr='127.0.0.1' module='sqlplus@datacenter (TNS V1-V3)' pid='18833'>
<txt>alter database mount standby database
</txt>
</msg>
<msg time='2013-10-04T18:02:04.302+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module='sqlplus@datacenter (TNS V1-V3)'
pid='18833'>
<txt>ARCH: STARTING ARCH PROCESSES
</txt>
</msg>
<msg time='2013-10-04T18:02:04.312+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='19002'>
<txt>ARC0 started with pid=23, OS id=19002
</txt>
</msg>
<msg time='2013-10-04T18:02:05.312+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module='sqlplus@datacenter (TNS V1-V3)'
pid='18833'>
<txt>ARC0: Archival started
</txt>
</msg>
<msg time='2013-10-04T18:02:05.312+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module='sqlplus@datacenter (TNS V1-V3)'
pid='18833'>
<txt>ARCH: STARTING ARCH PROCESSES COMPLETE
</txt>
</msg>
<msg time='2013-10-04T18:02:05.313+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19002'>
<txt>ARC0: STARTING ARCH PROCESSES
</txt>
</msg>
<msg time='2013-10-04T18:02:05.322+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='18802'>
<txt>Successful mount of redo thread 1, with mount id 1355713560
</txt>
</msg>
<msg time='2013-10-04T18:02:05.322+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module='sqlplus@datacenter (TNS V1-V3)'
pid='18833'>
<txt>Physical Standby Database mounted.
</txt>
</msg>
<msg time='2013-10-04T18:02:05.322+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module='sqlplus@datacenter (TNS V1-V3)'
pid='18833'>
<txt>Lost write protection disabled
</txt>
</msg>
<msg time='2013-10-04T18:02:05.323+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='19006'>
<txt>ARC1 started with pid=24, OS id=19006
</txt>
</msg>
<msg time='2013-10-04T18:02:05.330+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='19010'>
<txt>ARC2 started with pid=25, OS id=19010
</txt>
</msg>
<msg time='2013-10-04T18:02:05.338+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19002'>
<txt>ARC1: Archival started
</txt>
</msg>
<msg time='2013-10-04T18:02:05.338+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='19014'>
<txt>ARC3 started with pid=26, OS id=19014
</txt>
</msg>
<msg time='2013-10-04T18:02:05.338+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19002'>
<txt>ARC2: Archival started
</txt>
</msg>
<msg time='2013-10-04T18:02:05.339+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19006'>
<txt>ARC1: Becoming the 'no FAL' ARCH
</txt>
</msg>
<msg time='2013-10-04T18:02:05.339+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19010'>
<txt>ARC2: Becoming the heartbeat ARCH
</txt>
</msg>
<msg time='2013-10-04T18:02:05.370+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module='sqlplus@datacenter (TNS V1-V3)'
pid='18833'>
<txt>WARNING: No local destinations have been defined for
</txt>
</msg>
<msg time='2013-10-04T18:02:05.370+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module='sqlplus@datacenter (TNS V1-V3)'
pid='18833'>
<txt> archival of the Standby Redo Log.
</txt>
</msg>
<msg time='2013-10-04T18:02:05.370+08:00' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:3065:2802784106' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' host_id='datacenter'
host_addr='127.0.0.1' module='sqlplus@datacenter (TNS V1-V3)' pid='18833'>
<txt>Completed: alter database mount standby database
</txt>
</msg>
<msg time='2013-10-04T18:02:06.339+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19002'>
<txt>ARC3: Archival started
</txt>
</msg>
<msg time='2013-10-04T18:02:06.339+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19002'>
<txt>ARC0: STARTING ARCH PROCESSES COMPLETE
</txt>
</msg>
<msg time='2013-10-04T18:02:15.440+08:00' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:2994:4222364190' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' host_id='datacenter'
host_addr='127.0.0.1' module='sqlplus@datacenter (TNS V1-V3)' pid='18833'>
<txt> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
</txt>
</msg>
<msg time='2013-10-04T18:02:15.441+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module='sqlplus@datacenter (TNS V1-V3)'
pid='18833'>
<txt>Attempt to start background Managed Standby Recovery process (orcl)
</txt>
</msg>
<msg time='2013-10-04T18:02:15.450+08:00' org_id='oracle' comp_id='rdbms'
msg_id='ksbrdp:3833:3697353022' type='NOTIFICATION' group='process start'
level='16' host_id='datacenter' host_addr='127.0.0.1'
pid='19018'>
<txt>MRP0 started with pid=27, OS id=19018
</txt>
</msg>
<msg time='2013-10-04T18:02:15.451+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19018'>
<txt>MRP0: Background Managed Standby Recovery process started (orcl)
</txt>
</msg>
<msg time='2013-10-04T18:02:20.461+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19018'>
<txt> started logmerger process
</txt>
</msg>
<msg time='2013-10-04T18:02:20.467+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>Managed Standby Recovery not using Real Time Apply
</txt>
</msg>
<msg time='2013-10-04T18:02:20.469+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>WARNING! Recovering data file 1 from a fuzzy file. If not the current file
</txt>
</msg>
<msg time='2013-10-04T18:02:20.469+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>it might be an online backup taken without entering the begin backup command.
</txt>
</msg>
<msg time='2013-10-04T18:02:20.469+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>WARNING! Recovering data file 2 from a fuzzy file. If not the current file
</txt>
</msg>
<msg time='2013-10-04T18:02:20.469+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>it might be an online backup taken without entering the begin backup command.
</txt>
</msg>
<msg time='2013-10-04T18:02:20.469+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>WARNING! Recovering data file 3 from a fuzzy file. If not the current file
</txt>
</msg>
<msg time='2013-10-04T18:02:20.470+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>it might be an online backup taken without entering the begin backup command.
</txt>
</msg>
<msg time='2013-10-04T18:02:20.470+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>WARNING! Recovering data file 4 from a fuzzy file. If not the current file
</txt>
</msg>
<msg time='2013-10-04T18:02:20.470+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>it might be an online backup taken without entering the begin backup command.
</txt>
</msg>
<msg time='2013-10-04T18:02:20.470+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>WARNING! Recovering data file 5 from a fuzzy file. If not the current file
</txt>
</msg>
<msg time='2013-10-04T18:02:20.470+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>it might be an online backup taken without entering the begin backup command.
</txt>
</msg>
<msg time='2013-10-04T18:02:20.470+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>WARNING! Recovering data file 6 from a fuzzy file. If not the current file
</txt>
</msg>
<msg time='2013-10-04T18:02:20.470+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>it might be an online backup taken without entering the begin backup command.
</txt>
</msg>
<msg time='2013-10-04T18:02:20.471+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>WARNING! Recovering data file 7 from a fuzzy file. If not the current file
</txt>
</msg>
<msg time='2013-10-04T18:02:20.471+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>it might be an online backup taken without entering the begin backup command.
</txt>
</msg>
<msg time='2013-10-04T18:02:20.471+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>WARNING! Recovering data file 8 from a fuzzy file. If not the current file
</txt>
</msg>
<msg time='2013-10-04T18:02:20.471+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>it might be an online backup taken without entering the begin backup command.
</txt>
</msg>
<msg time='2013-10-04T18:02:20.471+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>WARNING! Recovering data file 9 from a fuzzy file. If not the current file
</txt>
</msg>
<msg time='2013-10-04T18:02:20.471+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>it might be an online backup taken without entering the begin backup command.
</txt>
</msg>
<msg time='2013-10-04T18:02:20.734+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19018'>
<txt>Parallel Media Recovery started with 32 slaves
</txt>
</msg>
<msg time='2013-10-04T18:02:20.903+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19018'>
<txt>Waiting for all non-current ORLs to be archived...
</txt>
</msg>
<msg time='2013-10-04T18:02:20.903+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19018'>
<txt>All non-current ORLs have been archived.
</txt>
</msg>
<msg time='2013-10-04T18:02:20.903+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19018'>
<txt>Clearing online redo logfile 1 /usr/local/oracle/oradata/orcl/redo01.log
</txt>
</msg>
<msg time='2013-10-04T18:02:20.903+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19018'>
<txt>Clearing online log 1 of thread 1 sequence number 18229
</txt>
</msg>
<msg time='2013-10-04T18:02:20.912+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19018'>
<txt>Errors in file /usr/local/oracle/diag/rdbms/orcldg/orcl/trace/orcl_mrp0_19018.trc:
ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1: '/usr/local/oracle/oradata/orcl/redo01.log'
</txt>
</msg>
<msg time='2013-10-04T18:02:20.912+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19018'>
<txt>Clearing online redo logfile 1 complete
</txt>
</msg>
<msg time='2013-10-04T18:02:20.980+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module=''
pid='19022'>
<txt>Media Recovery Waiting for thread 1 sequence 18231
</txt>
</msg>
<msg time='2013-10-04T18:02:21.455+08:00' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:3065:2802784106' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' host_id='datacenter'
host_addr='127.0.0.1' module='sqlplus@datacenter (TNS V1-V3)' pid='18833'>
<txt>Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
</txt>
</msg>
<msg time='2013-10-04T18:02:21.524+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module='MMON_SLAVE'
pid='19162'>
<txt>db_recovery_file_dest_size of 3882 MB is 0.00% used. This is a
</txt>
</msg>
<msg time='2013-10-04T18:02:21.524+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module='MMON_SLAVE'
pid='19162'>
<txt>user-specified limit on the amount of space that will be used by this
</txt>
</msg>
<msg time='2013-10-04T18:02:21.524+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module='MMON_SLAVE'
pid='19162'>
<txt>database for recovery-related files, and does not reflect the amount of
</txt>
</msg>
<msg time='2013-10-04T18:02:21.524+08:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='datacenter' host_addr='127.0.0.1' module='MMON_SLAVE'
pid='19162'>
<txt>space available in the underlying filesystem or ASM diskgroup.
</txt>
</msg> |
|