ASM RAC Primary two nodes To none ASM RAC physical to logical stanndby
666047Feb 4 2012 — edited Feb 5 2012Dear All,
unable to convert my physical standby to logical stanndby
Primary ASM RAC Two Node
imal1,imal2
#######
spfile primary as below
imal2.__db_cache_size=1526726656
imal1.__db_cache_size=1392508928
imal2.__java_pool_size=16777216
imal1.__java_pool_size=16777216
imal2.__large_pool_size=33554432
imal1.__large_pool_size=33554432
imal1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
imal2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
imal2.__pga_aggregate_target=2399141888
imal1.__pga_aggregate_target=2399141888
imal2.__sga_target=4479516672
imal1.__sga_target=4479516672
imal2.__shared_io_pool_size=0
imal1.__shared_io_pool_size=0
imal2.__shared_pool_size=2835349504
imal1.__shared_pool_size=2952790016
imal2.__streams_pool_size=16777216
imal1.__streams_pool_size=33554432
*.archive_lag_target=0
*.audit_file_dest='/u01/app/oracle/admin/imal/adump'
*.audit_sys_operations=TRUE
*.audit_trail='DB'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+DATA/imal/controlfile/current.270.714599501','+FLASH/imal/controlfile/current.260.714599501'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='imal'
*.db_recovery_file_dest='+FLASH'
*.db_recovery_file_dest_size=112742891520
*.dg_broker_config_file1='/oracle/product/11.2.0/dbhome_1/dbs/DR1STBY.dat'
*.dg_broker_config_file2='/oracle/product/11.2.0/dbhome_1/dbs/DR2STBY.dat'
*.dg_broker_start=FALSE
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=imalXDB)'
*.fal_client='IMAL2','IMAL1'
*.fal_server='IMALMIR'
*.job_queue_processes=1000
*.log_archive_config='DG_CONFIG=(imal,imalmir)'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=IMAL'
*.log_archive_dest_2='SERVICE=imalmir LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=imalmir'
*.log_archive_dest_3='LOCATION=+FLASH/IMAL/standby_arch/ VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=IMAL'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_dest_state_3='ENABLE'
*.log_archive_format='%t_%s_%r.dbf'
*.log_archive_max_processes=4
*.log_archive_min_succeed_dest=1
*.memory_max_target=6872367104
*.memory_target=6872367104
*.open_cursors=500
*.processes=1800
*.remote_listener='SCAN-RAC:1521'
*.remote_login_passwordfile='exclusive'
*.resource_limit=FALSE
*.standby_file_management='AUTO'
*.undo_retention=3600
#######
Physical standby spfile
#######
imalmir.__db_cache_size=1526726656
imalmir.__java_pool_size=16777216
imalmir.__large_pool_size=16777216
imalmir.__oracle_base='/oracle'#ORACLE_BASE set from environmentimalmir.__pga_aggregate_target=1375731712
imalmir.__pga_aggregate_target=1375731712
imalmir.__sga_target=2046820352
imalmir.__shared_io_pool_size=0
imalmir.__shared_pool_size=452984832
imalmir.__streams_pool_size=0
*.audit_file_dest='/oracle/admin/imalmir/adump'
*.audit_sys_operations=FALSE
*.audit_trail='none'
*.cluster_database=FALSE
*.compatible='11.2.0.0.0'
*.control_file_record_keep_time=21
*.control_files='/oracle/product/11.2.0/dbhome_1/dbs/controlfile/current.260.714349539','/oracle/product/11.2.0/dbhome_1/dbs/controlfile/current.256.714349541'#Restore Controlfile
*.core_dump_dest='/oracle/admin/imalmir/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='+DATA/imal/','/data/imalmir/'
*.db_name='imalmir'
*.db_recovery_file_dest='/flash'
*.db_recovery_file_dest_size=111669149696
*.db_unique_name='imalmir'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=imalXDB)'
*.event='10262 trace name context forever, level 4000'
*.log_archive_config='DG_CONFIG=(imal,imalmir)'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) db_unique_name=imalmir'
*.log_archive_dest_2='SERVICE=IMAL LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=IMAL'
*.log_archive_dest_3='LOCATION=/flash/imalmir/standby_arch VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=imalmir'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_dest_state_3='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.log_file_name_convert='+FLASH/imal/','/flash/imalmir/'
*.memory_target=3422552064
*.open_cursors=700
*.processes=150
*.remote_login_passwordfile='exclusive'
*.standby_file_management='AUTO'
*.thread=1
*.undo_tablespace='UNDOTBS1'
##############################
GETTING ERROR WHEN EXECUTE THIS COMMAND (ALTER DATABASE RECOVER TO LOGICAL STANDBY imalmir)
ALTER DATABASE RECOVER TO LOGICAL STANDBY imalmir
Media Recovery Start: Managed Standby Recovery (imalmir)
started logmerger process
Fri Feb 03 23:37:20 2012
Managed Standby Recovery not using Real Time Apply
Parallel Media Recovery started with 4 slaves
Fri Feb 03 23:37:20 2012
Warning: recovery process PR01 cannot use async I/O
Fri Feb 03 23:37:20 2012
Warning: recovery process PR02 cannot use async I/O
Fri Feb 03 23:37:20 2012
Warning: recovery process PR03 cannot use async I/O
Fri Feb 03 23:37:20 2012
Warning: recovery process PR04 cannot use async I/O
Media Recovery Log /flash/IMALMIR/archivelog/2012_02_03/o1_mf_2_143443_7lrk8599_.arc
Media Recovery Log /flash/imalmir/standby_arch/1_156907_714599503.arc
Media Recovery Waiting for thread 2 sequence 143444
Fri Feb 03 23:40:17 2012
Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
RFS[1]: Assigned to RFS process 13864
RFS[1]: Identified database type as 'physical standby': Client is ARCH pid 25790
Fri Feb 03 23:40:18 2012
RFS[2]: Assigned to RFS process 13866
RFS[2]: Identified database type as 'physical standby': Client is ARCH pid 25792
Fri Feb 03 23:40:18 2012
RFS[3]: Assigned to RFS process 13868
RFS[3]: Identified database type as 'physical standby': Client is ARCH pid 25786
RFS[1]: Opened log for thread 2 sequence 143446 dbid 889373133 branch 714599503
RFS[2]: Opened log for thread 2 sequence 143444 dbid 889373133 branch 714599503
RFS[3]: Opened log for thread 2 sequence 143445 dbid 889373133 branch 714599503
Archived Log entry 5303 added for thread 2 sequence 143446 rlc 714599503 ID 0x3502d1ca dest 2:
Archived Log entry 5304 added for thread 2 sequence 143445 rlc 714599503 ID 0x3502d1ca dest 2:
Archived Log entry 5305 added for thread 2 sequence 143444 rlc 714599503 ID 0x3502d1ca dest 2:
RFS[3]: Opened log for thread 2 sequence 143447 dbid 889373133 branch 714599503
Archived Log entry 5306 added for thread 2 sequence 143447 rlc 714599503 ID 0x3502d1ca dest 2:
RFS[1]: Opened log for thread 2 sequence 143448 dbid 889373133 branch 714599503
Archived Log entry 5307 added for thread 2 sequence 143448 rlc 714599503 ID 0x3502d1ca dest 2:
Fri Feb 03 23:40:22 2012
Media Recovery Log /flash/IMALMIR/archivelog/2012_02_03/o1_mf_2_143444_7lrkklxk_.arc
Media Recovery Log /flash/imalmir/standby_arch/1_156908_714599503.arc
Fri Feb 03 23:40:24 2012
RFS[4]: Assigned to RFS process 13870
RFS[4]: Identified database type as 'physical standby': Client is LGWR SYNC pid 25728
Primary database is in MAXIMUM AVAILABILITY mode
Standby controlfile consistent with primary
Standby controlfile consistent with primary
Media Recovery Log /flash/imalmir/standby_arch/1_156909_714599503.arc
RFS[4]: No standby redo logfiles of size 51200 blocks available
RFS[4]: No standby redo logfiles selected (reason:7)
Errors in file /oracle/diag/rdbms/imalmir/imalmir/trace/imalmir_ora_13870.trc:
ORA-16086: Redo data cannot be written to the standby redo log
Media Recovery Log /flash/IMALMIR/archivelog/2012_02_03/o1_mf_2_143445_7lrkklyv_.arc
Media Recovery Log /flash/imalmir/standby_arch/1_156910_714599503.arc
Fri Feb 03 23:40:33 2012
Media Recovery Log /flash/IMALMIR/archivelog/2012_02_03/o1_mf_2_143446_7lrkklqd_.arc
Media Recovery Log /flash/imalmir/standby_arch/1_156911_714599503.arc
Media Recovery Log /flash/IMALMIR/archivelog/2012_02_03/o1_mf_2_143447_7lrkkmps_.arc
Media Recovery Log /flash/imalmir/standby_arch/1_156912_714599503.arc
Media Recovery Log /flash/IMALMIR/archivelog/2012_02_03/o1_mf_2_143448_7lrkkmz6_.arc
Fri Feb 03 23:40:43 2012
Incomplete Recovery applied until change 5182135661 time 02/03/2012 23:41:04
Fri Feb 03 23:40:43 2012
Media Recovery Complete (imalmir)
krsv_proc_kill: Killing 3 processes (all RFS)
Begin: Standby Redo Logfile archival
End: Standby Redo Logfile archival
RESETLOGS after incomplete recovery UNTIL CHANGE 5182135661
Resetting resetlogs activation ID 889377226 (0x3502d1ca)
ERROR: slave communication error with ASM; terminating process 13789
Errors in file /oracle/diag/rdbms/imalmir/imalmir/trace/imalmir_ora_13789.trc:
Fri Feb 03 23:41:38 2012
please help me out .......................................