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>