Hello all,
I am already using delphix express to successfully provision VDBS from a small dsource to developers. This successful test is based on a source env with ASM instance to another ASM target instance. I understand that the VBD datafiles are not stored in the target host ASM, but inside delphix engine itself.
Still studying the capabilities of Delphix, now I am trying to provision a VDB from a source that is hosted on ASM to a target environment that does not have an ASM instance installed. During the provision operation, the process freezes at delphix interface and hangs there at "Recovering Oracle database.". When I log into the target environment (all seens to be ok: the delphix mount point is correctly mounted ) and see the alert log for the VDB being provisioned I have a bunch of:
Starting background process ASMB
Fri Sep 23 14:15:09 2016
ASMB started with pid=23, OS id=19417
WARNING: failed to start ASMB (connection failed) state=0x1 sid=''
WARNING: ASMB exiting with error
(while the VBD creation process will be hanging until I halt it manually, there is no error catch on the delphix interface)
Ok, I understand that it is asking for a ASM instance because all datafiles from original DB are stored in my source's ASM instance. But what to do if my target does not have an ASM instance?
I already tried to:
Put this parameters in the VBD configuration
db_file_name_convert=('+DATA', '/var/oracle/oradata')
log_file_name_convert=('+DATA', '/var/oracle/online')
db_create_file_dest='/var/oracle/oradata'
log_file_name_convert='/var/oracle/online'
db_create_online_log_dest_n='/var/oracle/fra'
I also tried to put the FILE MAPPING rule:
\+DATA --> /var/oracle/
(it was validated)
And several combination of both.
I had a similar problem with this during the deployment of DBVISIT Standby from primary on ASM to standby NON-ASM, but I could get over it using db_file_name_convert.
What can I do to overcome this situation in Delphix?Thank you!
Guilherme Campos
Escola Superior do Ministério Público da União
Brasil