to asm

I did to change to asm

but see the error..


[oracle@server1 bin]$ . oraenv src
ORACLE_SID = [oracle] ? src
The Oracle base for ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db is /oracle/app/oracle
[oracle@server1 bin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 9 13:02:37 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> select name from v$database;

NAME
---------
SRC

SQL> show parameter inst

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
active_instance_count                integer
cluster_database_instances           integer     1
instance_groups                      string
instance_name                        string      src
instance_number                      integer     0
instance_type                        string      RDBMS
open_links_per_instance              integer     4
parallel_instance_group              string
parallel_server_instances            integer     1
SQL> alter system set control_files='+disk_group_1' scope=spfile;

System altered.

SQL> alter system set db_create_file_dest='+disk_group_1' scope=spfile;

System altered.

SQL> alter system set db_recovery_file_dest='+disk_group_1' scope=spfile;

System altered.

SQL> alter user sys identified by sys;

User altered.

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

Total System Global Area  464519168 bytes
Fixed Size                  1337240 bytes
Variable Size             146802792 bytes
Database Buffers          310378496 bytes
Redo Buffers                6000640 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@server1 bin]$ rman

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Sep 9 13:14:36 2013

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

RMAN> connect target /

connected to target database: SRC (not mounted)

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

Starting restore at 09-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/09/2013 13:16:14
ORA-19504: failed to create file "+DISK_GROUP_1"
ORA-17502: ksfdcre:4 Failed to create file +DISK_GROUP_1
ORA-15001: diskgroup "DISK_GROUP_1" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Synchronization Service
ORA-19600: input file is control file  (/oracle/app/oracle/oradata/src/control01.ctl)
ORA-19601: output file is control file  (+DISK_GROUP_1)

RMAN>
user interrupt received


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:
Check the error messages:
ORA-19504: failed to create file "+DISK_GROUP_1"
ORA-15077: could not locate ASM instance serving a required diskgroup

Did you create the ASM instance?
Did you create the disk group?  

Based on your previous questions I assume you are looking to migrate a non-ASM database to ASM.

Please provide the steps you have already performed.

If you are following some 'step-by-step' method, please provide the link to it.
0
jcob_lAuthor Commented:
I aleady gave whatever I did...
I did not follow anything..
I you have any steps kindly provide..
0
jcob_lAuthor Commented:
Slightvv could you figure out..

Any chance of reply.
0
slightwv (䄆 Netminder) Commented:
>>I aleady gave whatever I did...

You just posted some commands you executed.  You didn't provide any background on how you got to here.

You also haven't provided what you are trying to do.

We have no way of knowing what you are doing unless you tell us.

I'm still guessing you are looking to migrate a non-ASM database to ASM.

If this is correct, I suggest you spend some time in the online docs:
Performing Oracle ASM Data Migration with RMAN

http://docs.oracle.com/cd/E11882_01/server.112/e18951/asm_rman.htm
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
jcob_lAuthor Commented:
yes
0
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.