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/or acle/produ ct/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='+di sk_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/oradat a/src/cont rol01.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/oradat a/src/cont rol01.ctl)
ORA-19601: output file is control file (+DISK_GROUP_1)
RMAN>
user interrupt received
RMAN>
but see the error..
[oracle@server1 bin]$ . oraenv src
ORACLE_SID = [oracle] ? src
The Oracle base for ORACLE_HOME=/oracle/app/or
[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
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
System altered.
SQL> alter system set db_create_file_dest='+disk
System altered.
SQL> alter system set db_recovery_file_dest='+di
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/oradat
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/oradat
ORA-19601: output file is control file (+DISK_GROUP_1)
RMAN>
user interrupt received
RMAN>
ASKER
I aleady gave whatever I did...
I did not follow anything..
I you have any steps kindly provide..
I did not follow anything..
I you have any steps kindly provide..
ASKER
Slightvv could you figure out..
Any chance of reply.
Any chance of reply.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yes
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.