Home » Server Options » Data Guard » Converting ASM to NonASM Standby (Oracle 12c, windows 2012)
Converting ASM to NonASM Standby [message #650755] Tue, 03 May 2016 02:46 Go to previous message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
HI All,

I am trying to make a Standby DB (Non ASM format) from an Production DB server which is ASM format.

Went through some documents, but have some doubt on convert.

When we say "db_create_file_dest", it consider only one Drives, am I right?
How can I tackle if I have 1TB of DB size under 5 Different Disk Drives, where all the Datafiles to be placed?

ALTER SYSTEM SET control_files='/u02/oradata/TESTDB/control01.ctl' SCOPE=spfile;
ALTER SYSTEM SET db_create_file_dest='/u02/oradata' SCOPE=spfile;
ALTER SYSTEM SET db_recovery_file_dest='/u02/flash_recovery_area' SCOPE=spfile;


And also, if I use the parameter "db_file_name_convert='+DATA/MUMBAI/' format.

Then How I can specify particular Datafile to be placed in the particular Drive?

Kindly help.

Thanks and Regards.
Muktha
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: no output from v$archived_log in standby
Next Topic: Duplicate DB for Standby
Goto Forum:
  


Current Time: Thu Jan 23 07:54:34 CST 2020