Home » RDBMS Server » Server Administration » Adding logfile groups in ASM
Adding logfile groups in ASM [message #225096] Sat, 17 March 2007 06:49 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
10G:
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER
---------- ------- ------- ------------------------------------------------
3 ONLINE C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
2 ONLINE C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG

I have already created ASM instance and mount diskgroups
and now i want to create a logfile group using ASM storage by using the followings

SQL>alter database add logfile group 1
members "+DGROUP1\REDO01.LOG" size 100m

ERROR at line 2:
ORA-00933: SQL command not properly ended

alter database add logfile group 1
members "+DGROUP1/logfiles/REDO1.ORA" size 10m

ERROR at line 2:
ORA-00933: SQL command not properly ended

Can anybody help me in this regard?
thanx in advance
Re: Adding logfile groups in ASM [message #225102 is a reply to message #225096] Sat, 17 March 2007 09:09 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
AFAIK, one should NOT use double quote characters (") but use single quote characters (').
Previous Topic: can we encrypt the RMAN backup with netbackup
Next Topic: Deleted REDO02.LOG (ORA-00313)
Goto Forum:
  


Current Time: Fri Dec 09 04:00:08 CST 2016

Total time taken to generate the page: 0.09722 seconds