Home » RDBMS Server » Server Administration » ASM interview question (Oracle 11g,12c, Unix)
ASM interview question [message #677075] Fri, 16 August 2019 00:06 Go to next message
BalajiDBA
Messages: 58
Registered: October 2018
Member
Hi,

What happen if you miss "+" sign while adding datafile in ASM disk group ?

Can someone answer this question been asked in interview?

Regards,
Balaji
Re: ASM interview question [message #677076 is a reply to message #677075] Fri, 16 August 2019 01:33 Go to previous messageGo to next message
John Watson
Messages: 8084
Registered: January 2010
Location: Global Village
Senior Member
For example,
orclz>
orclz> alter tablespace jw add datafile 'DATADG' size 1m;

Tablespace altered.

orclz> select name from v$datafile where name like '%DATADG%';

NAME
---------------------------------------------------------------------------------------------------------------------------------------
C:\APP\ORACLE\PRODUCT\19.3.0\DATABASE\DATADG

orclz>
Never mind your question, what does this tell you about problem solving skills?
Re: ASM interview question [message #677077 is a reply to message #677076] Fri, 16 August 2019 03:08 Go to previous messageGo to next message
BalajiDBA
Messages: 58
Registered: October 2018
Member
orclz> select name from v$datafile where name like '%DATADG%';

NAME
---------------------------------------------------------------------------------------------------------------------------------------
C:\APP\ORACLE\PRODUCT\19.3.0\DATABASE\DATADG
The datafile 'DATADG' gets added as it was mentioned in alter tablespace command.
Re: ASM interview question [message #677083 is a reply to message #677077] Fri, 16 August 2019 09:41 Go to previous message
EdStevens
Messages: 1148
Registered: September 2013
Senior Member
BalajiDBA wrote on Fri, 16 August 2019 03:08
orclz> select name from v$datafile where name like '%DATADG%';

NAME
---------------------------------------------------------------------------------------------------------------------------------------
C:\APP\ORACLE\PRODUCT\19.3.0\DATABASE\DATADG
The datafile 'DATADG' gets added as it was mentioned in alter tablespace command.
You missed the point when John said "Never mind your question, what does this tell you about problem solving skills?"

Did you notice that your question was about ASM and John's demo was not on ASM?

What did John do to answer your question?
What could you have done to answer your own question?
Previous Topic: IMPDP gives failed messages in oracle 19c
Next Topic: ORA-00205: Standby database
Goto Forum:
  


Current Time: Fri Dec 13 06:53:19 CST 2019