Link to home
Start Free TrialLog in
Avatar of jcob_l
jcob_l

asked on

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>
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

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.
Avatar of jcob_l

ASKER

I aleady gave whatever I did...
I did not follow anything..
I you have any steps kindly provide..
Avatar of jcob_l

ASKER

Slightvv could you figure out..

Any chance of reply.
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jcob_l

ASKER

yes