使用dataguard将单实例数据库转换为rac数据库 - 数据库编程

and Real Application Testing options SQL> exit [oracle@suq1 ~]$ sqlplus sys/manager@primary as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 26 21:50:25 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> exit
5.使用duplicate 创建standby database：

[oracle@11g1 arch]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jul 26 22:28:11 2015

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

connected to target database: SUQ (DBID=1469685490)

RMAN> connect auxiliary sys/manager@standby

connected to auxiliary database: SUQ (not mounted)

RMAN> duplicate target database for standby from active database; 

Starting Duplicate Db at 26-JUL-15
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=141 instance=suq1 device type=DISK

contents of Memory Script:
{
   backup as copy reuse
   targetfile  '/opt/oracle/product/OraHome11204/dbs/orapwsuq' auxiliary format 
 '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwsuq1'   ;
}
executing Memory Script

Starting backup at 26-JUL-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=147 device type=DISK
Finished backup at 26-JUL-15

contents of Memory Script:
{
   backup as copy current controlfile for standby auxiliary format  '+DATADG/suq/control.ctl';
}
executing Memory Script

Starting backup at 26-JUL-15
using ch




annel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/opt/oracle/product/OraHome11204/dbs/snapcf_suq.f tag=TAG20150726T222820 RECID=3 STAMP=886112900
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 26-JUL-15

contents of Memory Script:
{
   sql clone 'alter database mount standby database';
}
executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script:
{
   set newname for tempfile  1 to 
 "+DATADG/suq/datafile/temp01.dbf";
   switch clone tempfile all;
   set newname for datafile  1 to 
 "+DATADG/suq/datafile/system01.dbf";
   set newname for datafile  2 to 
 "+DATADG/suq/datafile/sysaux01.dbf";
   set newname for datafile  3 to 
 "+DATADG/suq/datafile/undotbs01.dbf";
   set newname for datafile  4 to 
 "+DATADG/suq/datafile/users01.dbf";
   backup as copy reuse
   datafile  1 auxiliary format 
 "+DATADG/suq/datafile/system01.dbf"   datafile 
 2 auxiliary format 
 "+DATADG/suq/datafile/sysaux01.dbf"   datafile 
 3 auxiliary format 
 "+DATADG/suq/datafile/undotbs01.dbf"   datafile 
 4 auxiliary format 
 "+DATADG/suq/datafile/users01.dbf"   ;
   sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to +DATADG/suq/datafile/temp01.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 26-JUL-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/opt/oracle/oradata/suq/system01.

使用dataguard将单实例数据库转换为rac数据库(三)