| Converting ASM to NonASM Standby [message #650755] |
Tue, 03 May 2016 02:46  |
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 #650772 is a reply to message #650771] |
Tue, 03 May 2016 06:03  |
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
