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 next message
muktha_22
Messages: 527
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
Re: Converting ASM to NonASM Standby [message #650757 is a reply to message #650755] Tue, 03 May 2016 03:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

db_file_name_convert is a list of pairs of values: 'origin1,dest1,origin2,dest2...'

Re: Converting ASM to NonASM Standby [message #650764 is a reply to message #650757] Tue, 03 May 2016 04:12 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

Yes, But How I can specify the Destination location of every datafiles?

Kindly guide me.

Regards
Binoj
Re: Converting ASM to NonASM Standby [message #650765 is a reply to message #650764] Tue, 03 May 2016 04:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Name each one in db_file_name_convert but I never saw someone wanting to specify each and every file new name.

Re: Converting ASM to NonASM Standby [message #650769 is a reply to message #650765] Tue, 03 May 2016 05:16 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

Fine,

Not every datafiles, but what if I want to place 50 Datafiles in D: Drive 50 in E:Drive and 50 in F:Drive.
Should we add 150 Datafiles along with the new paths?

Regards
Muktha
Re: Converting ASM to NonASM Standby [message #650771 is a reply to message #650769] Tue, 03 May 2016 05:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Do you understand what db_file_name_convert is for and how it works?

Re: Converting ASM to NonASM Standby [message #650772 is a reply to message #650771] Tue, 03 May 2016 06:03 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

Yes, below is the syntax, which convert ASM files into the NONASM DB location of "/u01/app/oracle/oradata/dupdb".
Which means all the Datafiles, Online Redo logfiles will be in the same location am I right?

db_file_name_convert='+DATA/DEMODB/DATAFILE/','/u01/app/oracle/oradata/dupdb/'
log_file_name_convert='+DATA/DEMODB/ONLINELOG/','/u01/app/oracle/oradata/dupdb/'


Regards
Muktha
Re: Converting ASM to NonASM Standby [message #650774 is a reply to message #650772] Tue, 03 May 2016 06:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes but do you understand how it works?
How the conversion works?

Re: Converting ASM to NonASM Standby [message #650788 is a reply to message #650774] Wed, 04 May 2016 00:16 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

Yes, It is logically moving the Datafiles from primary to the new cloned DB and register the new location of the files in the CONTROL FILE of the new CLONED DB.

Regards
Muktha
Re: Converting ASM to NonASM Standby [message #650793 is a reply to message #650788] Wed, 04 May 2016 00:51 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This is not my question.
How does it do this "logically moving"?
If you can't explain with words do it with an example.

Previous Topic: no output from v$archived_log in standby
Next Topic: Duplicate DB for Standby
Goto Forum:
  


Current Time: Thu Mar 28 15:33:39 CDT 2024