diskname

I made an error while chaning the parameter in order to change from non asm to asm



Is there any way to eradicate..


[oracle@server2 dbs]$ pwd
/oracle/app/oracle/product/11.2.0/db2/dbs
[oracle@server2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 20 07:03:52 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> startup spfile='/oracle/app/oracle/product/11.2.0/db2/dbs/spfilevin.ora';
SP2-0714: invalid combination of STARTUP options
SQL> startup spfile='/oracle/app/oracle/product/11.2.0/db2/dbs/spfilevin';    
SP2-0714: invalid combination of STARTUP options
SQL> show parameter pfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> create spfile from pfile;

File created.

SQL> show paramter spfile;
SP2-0158: unknown SHOW option "paramter"
SP2-0158: unknown SHOW option "spfile"
SQL> show paramter spfile;
SP2-0158: unknown SHOW option "paramter"
SP2-0158: unknown SHOW option "spfile"
SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> create pfile file from spfile;
create pfile file from spfile
             *
ERROR at line 1:
ORA-00923: FROM keyword not found where expected


SQL> shu
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  744910848 bytes
Fixed Size                  1339120 bytes
Variable Size             440402192 bytes
Database Buffers          297795584 bytes
Redo Buffers                5373952 bytes
Database mounted.
Database opened.
SQL> show parameter pfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /oracle/app/oracle/product/11.
                                                 2.0/db2/dbs/spfilevin.ora
SQL>
SQL>                                          
SQL> ALTER SYSTEM SET control_files='+DATA1' scope=spfile;

System altered.

SQL> ALTER SYSTEM SET db_create_file_dest='+DATA' scope=spfile;


System altered.

SQL> SQL> ALTER SYSTEM SET db_create_file_dest='+DATA' scope=spfile;


System altered.

SQL> SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.

Total System Global Area  744910848 bytes
Fixed Size                  1339120 bytes
Variable Size             440402192 bytes
Database Buffers          297795584 bytes
Redo Buffers                5373952 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@server2 dbs]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Sep 20 10:26:29 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: VIN (not mounted)

RMAN> restore controlfile from '/oracle/app/oracle/oradata/vin
2>
3>

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-02002: unexpected end of input file reached

RMAN> restore controlfile from '/oracle/app/oracle/oradata/vin/control01.ctl';

Starting restore at 20-SEP-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/20/2013 10:32:56
ORA-19504: failed to create file "+DATA1"
ORA-17502: ksfdcre:4 Failed to create file +DATA1
ORA-15001: diskgroup "DATA1" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-19600: input file is control file  (/oracle/app/oracle/oradata/vin/control01.ctl)
ORA-19601: output file is control file  (+DATA1)

RMAN> exit


Recovery Manager complete.
[oracle@server2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 20 10:35:22 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> ALTER SYSTEM SET db_create_file_dest='+DATA1' scope=spfile;

SQL> ALTER SYSTEM SET db_create_file_dest='+DATA1' scope=spfile;

System altered.

SQL>
 ALTER SYSTEM SET db_create_file_dest='+DATA1' scope=spfile;
SQL>
 ALTER SYSTEM SET db_create_file_dest='+DATA1' scope=spfile;
System altered.

         
  2  
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@server2 dbs]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Sep 20 10:37:18 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: VIN (not mounted)

RMAN> restore controlfile from '/oracle/app/oracle/oradata/vin/control01.ctl';

Starting restore at 20-SEP-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=16 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/20/2013 10:37:41
ORA-19504: failed to create file "+DATA1"
ORA-17502: ksfdcre:4 Failed to create file +DATA1
ORA-15001: diskgroup "DATA1" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-19600: input file is control file  (/oracle/app/oracle/oradata/vin/control01.ctl)
ORA-19601: output file is control file  (+DATA1)

RMAN>
jcob_lAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
Pay attention to the following error:
ORA-15001: diskgroup "DATA1" does not exist or is not mounted

Did you create the DATA1 diskgroup?
Is is mounted?
0
jcob_lAuthor Commented:
yes I created Data1

How will I make sure that it is mounted...
0
slightwv (䄆 Netminder) Commented:
Like I have commented  in many of your previous questions, please refer to the documentation.

http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmcon.htm#CJHEFJJG

About Mounting and Dismounting Disk Groups

After reading what that has to say, it provides a link to:
http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#i1019481

Mounting and Dismounting Disk Groups

This section should help you.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.