When creating a 10g Database on the ASM instance of Oracle11.2 RAC, an error is reported: The Cluster Manager cannot be connected, and the ASM instance cannot be located. The error message is as follows:
ORA-15077: cocould not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
However, it is normal to create an 11 GB database on the cluster.
My goal is to migrate the 10 Gb database to the 11.2RAC environment. First, restore the 10 Gb database on 11.2RAC, and then upgrade it to the 11 gb rdbms environment.
An error is reported when the control file is restored. It indicates that you cannot connect to Cluster Manager.
/U02/rman_211 @ serv2 => servdb2 $ rman target/
Recovery Manager: Release 10.2.0.4.0-Production on Fri May 4 10:52:22 2012
Copyright (c) 1982,200 7, Oracle. All rights reserved.
Connected to target database: servdb (not mounted)
RMAN> restore controlfile from '/u02/rman_211/ctl_1un9u0a4_00001.20120501 ';
Starting restore at 04-MAY-12
Using target database control file instead of recovery catalog
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: sid = 320 devtype = DISK
Channel ORA_DISK_1: restoring control file
RMAN-00571: ========================================================== ==============================
RMAN-00569: ==================== error message stack follows ==========================
RMAN-00571: ========================================================== ==============================
RMAN-03002: failure of restore command at 10:52:49
ORA-19870: error reading backup piece/u02/rman_211/ctl_1un9u0a4_00001.20120501
ORA-19504: failed to create file "+ WEBDG/servdb/control01.ctl"
ORA-17502: ksfdre: 3 Failed to create file + WEBDG/servdb/control01.ctl
ORA-15001: diskgroup "WEBDG" does not exist or is not mounted.
ORA-15077: cocould not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
When this error is explained in the official Oracle documentation, 11gR2 is not compatible with earlier versions of databases. The cluster configuration of 11gR2 is dynamic, and the cluster configuration must be fixed for libraries of earlier versions, such as those of Version 10.2.
The official Oracle documentation also provides a solution to pin the css resource.
Log on to the operating system as the root user and run the following command.
[Root @ serv2 bin] #./crsctl pin css-n serv1 serv2
CRS-4664: Node serv1 successfully pinned.
CRS-4664: Node serv2 successfully pinned.
[Root @ serv2 bin] #
[Root @ serv2 bin] #./olsnodes-t
Serv1 Pinned
Serv2 Pinned
Return to the RMAN interface to restore the control file.
RMAN> restore controlfile from '/u02/rman_211/ctl_1un9u0a4_00001.20120501 ';
Starting restore at 04-MAY-12
Using channel ORA_DISK_1
Channel ORA_DISK_1: restoring control file
Channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
Output filename = + WEBDG/servdb/control01.ctl
Output filename = + WEBDG/servdb/control02.ctl
Finished restore at 04-MAY-12
For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12