12c RMAN Operations from ASM To Non-ASM Slow Performance
(Doc ID 2081537.1)
Last updated on FEBRUARY 15, 2019
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
RMAN Restore/Duplicate from ASM to Non ASM in 12.1 take a longer time waiting for the ASMB process.
Any RMAN command at the mount state which involves Non ASM location can take more time.
RMAN-03090: Starting restore at 2015-11-09 15:01:53
RMAN-08030: allocated channel: ORA_AUX_DISK_1
RMAN-08500: channel ORA_AUX_DISK_1: SID=1 device type=DISK
RMAN-08021: channel ORA_AUX_DISK_1: restoring control file
RMAN-08180: channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
RMAN-08505: output file name=/oradata/<db_name>/controlfile/control01.ctl
RMAN-03091: Finished restore at 2015-11-09 15:01:55 <<<<<<<<<<<<<<<<<<<<<<<======= Control file is Restored
RMAN-03090: Starting restore at 2015-11-09 15:21:59 <<<<<<<<<<<<<<=========== Actual Restore starts after 20 min
RMAN-12016: using channel ORA_AUX_DISK_1
RMAN-12016: using channel ORA_AUX_DISK_2
RMAN-12016: using channel ORA_AUX_DISK_3
RMAN-12016: using channel ORA_AUX_DISK_4
Alert log shows the below messages during the above time when there seems to be No Activity by RMAN after restoring the Controlfile
WARNING: failed to start ASMB (ASM instance not found)
Errors in file<adr_home>/diag/rdbms/<db_name>/<instance_name>/trace/<instance_name>_asmb_24847.trc:
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
WARNING: ASMB exiting with error
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document