Home » RDBMS Server » Server Administration » Extension of datafile in ASM (11g, 11.2.0.3, solaris10)
Extension of datafile in ASM [message #612341] |
Wed, 16 April 2014 04:51  |
ashishkumarmahanta80
Messages: 231 Registered: October 2006 Location: kolkatta
|
Senior Member |
|
|
Dear All,
Datafiles are stored in ASM. So datafiles are having its own nomenclatures. Bi-mistake, one of the datafile is created on the same path as mentioned below -
create bigfile tablespace bi datafile 'E:\APP\ADMINISTRATOR\ORADATA\TREGTST1\bi01.dbf' size 100m autoextend on next 12M extent management local segment space management auto;
Now, my concerned is, whether there will be any impact on this datafiles? Will it use the benefit of ASM (like - mirroring,etc)
Waiting for your kind response...
Regards,
Ashish
|
|
|
|
|
Re: Extension of datafile in ASM [message #612375 is a reply to message #612374] |
Thu, 17 April 2014 03:33   |
ashishkumarmahanta80
Messages: 231 Registered: October 2006 Location: kolkatta
|
Senior Member |
|
|
Dear @all,
Apologize !!!
Tablespace is created on the below path but name is "bi01.dbf".
create bigfile tablespace bi datafile '+DATADG1/lvgiprod/datafile/hlthchk01.dbf/bi01.dbf' size 100m autoextend on next 12M extent management local segment space management auto;
On ASM, script should be like this
create bigfile tablespace bi;
Now, whether created tablespace will be benefited by ASM? Though, File name is by OMF
Regards,
Ashish Kumar Mahanta
[Updated on: Thu, 17 April 2014 03:44] Report message to a moderator
|
|
|
|
|
|
Goto Forum:
Current Time: Mon May 05 11:17:18 CDT 2025
|