Home » Other » General » Automatic Storage Management (ASM) auto create datafile (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production)
Automatic Storage Management (ASM) auto create datafile [message #672664] Mon, 22 October 2018 10:06 Go to next message
wtolentino
Messages: 249
Registered: March 2005
Senior Member
just want to get a quick understanding of the ASM. i am aware that the Automatic Storage Management (ASM) is somewhat the volume manager and a file system for oracle database files.

there was an error about
ORA-01653: unable to extend table ODI.C$_CMS_EXPEND by 4096 in tablespace ODIDEV

then somehow this was fixed by adding a new datafile for the tablespace ODIDEV. i checked that the datafile has this naming convention in number format.

+DATA0010/app/datafile/odi_dev.221.56009514

i was wondering if the ASM automatically created the datafile. just want to know if the ASM can and has the functionality to automatically create the datafile.

thank you,
warren

[Updated on: Mon, 22 October 2018 10:14]

Report message to a moderator

Re: Automatic Storage Management (ASM) auto create datafile [message #672667 is a reply to message #672664] Mon, 22 October 2018 10:23 Go to previous message
John Watson
Messages: 7659
Registered: January 2010
Location: Global Village
Senior Member
No, ASM will never create a file automatically. Either someone added the file, or perhaps you have some maintenance jpb configured to detect and fix tablespace full issues.
Previous Topic: Problem with timezone date (merged)
Next Topic: Redo Log Buffer Quick Question
Goto Forum:
  


Current Time: Wed Nov 14 03:35:30 CST 2018