11.2单机数据库转换为RAC-1-使用rconfig完成转换

联系:QQ(5163721)

标题:11.2单机数据库转换为RAC-1-使用rconfig完成转换

作者:Lunar©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]

将单机数据库转换为RAC数据库,有好几种方法:
1,使用DBCA
2,手工添加thread(这个方法最经典,从9i到10g,到11.1,到11.2都可以,不过11.2以后,Oracle不推荐使用这个方法)
3,使用rconfig
4,ODA上有专门的工具进行转换,号称无敌脚本,O(∩_∩)O哈哈~(本次我没有测试,因为上面的方法已经足够多选择了)
.
rconfig功能还是比较强大的,除了单机转换为RAC,还可以单机转换为Standalone,Standalone转换为RAC,RAC转换为Standalone等等。
.
这里我们使用Oracle 11.2推荐的方法,体验一下rconfig的强大之处。
首先,我们要从一个单机数据库备份,然后恢复到到RAC环境中:

backup database filesperset = 2  format '/home/oracle/backup/db_full_%U';
sql 'alter system archive log current';
backup archivelog from time 'sysdate-1' filesperset = 2  format '/home/oracle/backup/arch_bak_%U';
backup current controlfile format '/home/oracle/backup/ctl_%U';

然后将这个数据库恢复到已经安装了GI的环境中,就是普通的将数据文件恢复到ASM的操作,没什么难度,主要命令如下:

startup nomount pfile=xxxxx
restore controlfile from 'xxxxxxx';
set newname for database to '+DATADG1';
restore database;
switch datafile all;
catalog backuppiece '/home/oracle/test/arch_bak_22q2t3co_1_1';
catalog backuppiece '/home/oracle/test/arch_bak_21q2t3co_1_1';
recover database using backup controlfile until cancel;
ALTER DATABASE OPEN RESETLOGS;

.
在ORACLE_HOME下有一个xml脚本,通常我们只需要修改这个脚本,就可以完成转换:
即: $ORACLE_HOME/assistants/rconfig/sampleXMLs/ConvertToRAC_AdminManaged.xml
1,我们先复制一个过来,进行修改:

$su – oracle
cp $ORACLE_HOME/assistants/rconfig/sampleXMLs/ConvertToRAC_AdminManaged.xml lunar.xml

其中,Convert verify=”ONLY”表示只测试转换过程,不实际转换。
Convert verify=”YES”,表示真实的执行转换。
测试过程这里略过了,我们看一年他是如何转换的。
我这里xml的内容如下:

[oracle@lunar1 test]$ cat lunar.xml
<?xml version="1.0" encoding="UTF-8"?>
<n:RConfig xmlns:n="http://www.oracle.com/rconfig"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xsi:schemaLocation="http://www.oracle.com/rconfig rconfig.xsd">
    <n:ConvertToRAC>   
<!-- Verify does a precheck to ensure all pre-requisites are met, before the conversion is attempted. Allowable values are: YES|NO|ONLY -->
        <n:Convert verify="YES">
<!--Specify current OracleHome of non-rac database for SourceDBHome -->
              <n:SourceDBHome>/u01/app/oracle/product/11.2.0/db_1</n:SourceDBHome>
<!--Specify OracleHome where the rac database should be configured. It can be same as SourceDBHome -->
              <n:TargetDBHome>/u01/app/oracle/product/11.2.0/db_1</n:TargetDBHome>
<!--Specify SID of non-rac database and credential. User with sysdba role is required to perform conversion -->
              <n:SourceDBInfo SID="lunar1">
                <n:Credentials>
                  <n:User>sys</n:User>
                  <n:Password>oracle</n:Password>
                  <n:Role>sysdba</n:Role>
                </n:Credentials>
              </n:SourceDBInfo>
<!--Specify the list of nodes that should have rac instances running for the Admin Managed Cluster Database. LocalNode should be the first node in this nodelist. -->
              <n:NodeList>        
                <n:Node name="lunar1"/>
                <n:Node name="lunar2"/>
              </n:NodeList>
<!--Specify RacOneNode along with servicename to convert database to RACOne Node -->
              <!--n:RacOneNode  servicename="saleslunar1service"/-->
<!--Instance Prefix tag is optional starting with 11.2. If left empty, it is derived from db_unique_name.-->
              <n:InstancePrefix>lunar</n:InstancePrefix>
<!-- Listener details are no longer needed starting 11.2. Database is registered with default listener and SCAN listener running from Oracle Grid Infrastructure home. -->
<!--Specify the type of storage to be used by rac database. Allowable values are CFS|ASM. The non-rac database should have same storage type. ASM credentials are no needed for conversion. -->
              <n:SharedStorage type="ASM">
<!--Specify Database Area Location to be configured for rac database.If this field is left empty, current storage will be used for rac database. For CFS, this field will have directory path. -->
                <n:TargetDatabaseArea>+DATADG1</n:TargetDatabaseArea>
<!--Specify Fast Recovery Area to be configured for rac database. If this field is left empty, current recovery area of non-rac database will be configured for rac database. If current database is not using recovery Area, the resulting rac database will not have a recovery area. -->
                <n:TargetFlashRecoveryArea>+DATADG1</n:TargetFlashRecoveryArea>
              </n:SharedStorage>
        </n:Convert>
    </n:ConvertToRAC>
</n:RConfig>
[oracle@lunar1 test]$ 

具体的转换过程如下:

[oracle@lunar1 test]$ rconfig lunar.xml
Converting Database "lunar" to Cluster Database. Target Oracle Home: /u01/app/oracle/product/11.2.0/db_1. Database Role: PRIMARY.
Setting Data Files and Control Files
Adding Database Instances
Adding Redo Logs
Enabling threads for all Database Instances
Setting TEMP tablespace
Adding UNDO tablespaces
Adding Trace files
Setting Fast Recovery Area
Updating Oratab
Creating Password file(s)
Configuring Listeners
Configuring related CRS resources
Starting Cluster Database
<?xml version="1.0" ?>
<RConfig version="1.1" >
<ConvertToRAC>
    <Convert>
      <Response>
        <Result code="0" >
          Operation Succeeded
        </Result>
      </Response>
      <ReturnValue type="object">
<Oracle_Home>
         /u01/app/oracle/product/11.2.0/db_1
       </Oracle_Home>
       <Database type="ADMIN_MANAGED"  >
         <InstanceList>
           <Instance SID="lunar1" Node="lunar1"  >
           </Instance>
           <Instance SID="lunar2" Node="lunar2"  >
           </Instance>
         </InstanceList>
       </Database>     </ReturnValue>
    </Convert>
  </ConvertToRAC></RConfig>
[oracle@lunar1 test]$ 

从这里我们清晰的看到,rconfig进行转换的时候,主要执行了如下步骤:

Setting Data Files and Control Files
Adding Database Instances
Adding Redo Logs
Enabling threads for all Database Instances
Setting TEMP tablespace
Adding UNDO tablespaces
Adding Trace files
Setting Fast Recovery Area
Updating Oratab
Creating Password file(s)
Configuring Listeners
Configuring related CRS resources
Starting Cluster Database

转换结果如下,lunar数据库已经是RAC数据库了,且已经在两个节点都启动了:

[root@lunar2 ~]# crsctl status res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADG1.dg
               ONLINE  ONLINE       lunar1                                         
               ONLINE  ONLINE       lunar2                                         
ora.DATADG2.dg
               ONLINE  ONLINE       lunar1                                         
               ONLINE  ONLINE       lunar2                                         
ora.LISTENER.lsnr
               ONLINE  ONLINE       lunar1                                         
               ONLINE  ONLINE       lunar2                                         
ora.asm
               ONLINE  ONLINE       lunar1                     Started             
               ONLINE  ONLINE       lunar2                     Started             
ora.gsd
               OFFLINE OFFLINE      lunar1                                         
               OFFLINE OFFLINE      lunar2                                         
ora.net1.network
               ONLINE  ONLINE       lunar1                                         
               ONLINE  ONLINE       lunar2                                         
ora.ons
               ONLINE  INTERMEDIATE lunar1                     CHECK TIMED OUT     
               ONLINE  INTERMEDIATE lunar2                     CHECK TIMED OUT     
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       lunar2                                         
ora.cvu
      1        ONLINE  ONLINE       lunar2                                         
ora.lunar.db
      1        ONLINE  ONLINE       lunar1                     Open                
      2        ONLINE  ONLINE       lunar2                     Open                
ora.oc4j
      1        ONLINE  ONLINE       lunar1                                         
ora.lunar1.vip
      1        ONLINE  ONLINE       lunar1                                         
ora.lunar2.vip
      1        ONLINE  ONLINE       lunar2                                         
ora.scan1.vip
      1        ONLINE  ONLINE       lunar2                                         
[root@lunar2 ~]# 

但是我个人并不喜欢rconfig的操作,原因是,他要进行backup as copy database的操作。
那么,就意味着,如果数据库巨大的话,需要的空间也会是双倍的
但是用传统的方法,手工添加第二个实例就不会有这个需求,比如我的数据库30T,怎么弄?

。。。。。。。。。。。。。。。。。。。
[Thread-81] [ 2013-06-24 08:12:56.090 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=RMAN> backup as copy database to destination  '+ASMDATA';
[Thread-81] [ 2013-06-24 08:12:56.173 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=Starting backup at 24-JUN-13
[Thread-81] [ 2013-06-24 08:12:56.793 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=allocated channel: ORA_DISK_1
[Thread-81] [ 2013-06-24 08:12:56.802 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=channel ORA_DISK_1: SID=19 instance=lunar1 device type=DISK
[Thread-81] [ 2013-06-24 08:12:59.169 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=channel ORA_DISK_1: starting datafile copy
[Thread-81] [ 2013-06-24 08:12:59.430 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=input datafile file number=00004 name=+ASMDATA/lunar/datafile/users.316.818912513
[Thread-81] [ 2013-06-24 08:15:24.683 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=output file name=+ASMDATA/lunar/datafile/users.322.818928779 tag=TAG20130624T081258 RECID=1 STAMP=818928915
[Thread-81] [ 2013-06-24 08:15:24.689 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:25
[Thread-81] [ 2013-06-24 08:15:24.974 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=channel ORA_DISK_1: starting datafile copy
[Thread-81] [ 2013-06-24 08:15:25.070 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=input datafile file number=00001 name=+ASMDATA/lunar/datafile/system.317.818912513
[Thread-81] [ 2013-06-24 08:16:10.130 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=output file name=+ASMDATA/lunar/datafile/system.323.818928925 tag=TAG20130624T081258 RECID=2 STAMP=818928965
[Thread-81] [ 2013-06-24 08:16:10.137 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
[Thread-81] [ 2013-06-24 08:16:10.694 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=channel ORA_DISK_1: starting datafile copy
[Thread-81] [ 2013-06-24 08:16:11.100 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=input datafile file number=00002 name=+ASMDATA/lunar/datafile/sysaux.318.818912517
[Thread-81] [ 2013-06-24 08:16:36.203 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=output file name=+ASMDATA/lunar/datafile/sysaux.324.818928971 tag=TAG20130624T081258 RECID=3 STAMP=818928995
[Thread-81] [ 2013-06-24 08:16:36.210 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
[Thread-81] [ 2013-06-24 08:16:36.935 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=channel ORA_DISK_1: starting datafile copy
[Thread-81] [ 2013-06-24 08:16:37.311 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=input datafile file number=00003 name=+ASMDATA/lunar/datafile/undotbs1.319.818912523
[Thread-81] [ 2013-06-24 08:16:52.443 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=output file name=+ASMDATA/lunar/datafile/undotbs1.325.818928997 tag=TAG20130624T081258 RECID=4 STAMP=818929011
[Thread-81] [ 2013-06-24 08:16:52.445 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
[Thread-81] [ 2013-06-24 08:16:52.458 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=Finished backup at 24-JUN-13
[Thread-81] [ 2013-06-24 08:16:56.649 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-81] [ 2013-06-24 08:16:56.691 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-81] [ 2013-06-24 08:16:56.712 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=RMAN> set echo on
[Thread-81] [ 2013-06-24 08:16:56.715 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-81] [ 2013-06-24 08:16:56.718 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=echo set on
[Thread-81] [ 2013-06-24 08:16:56.718 CST ] [RMANEngine.readSqlOutput:945]  Notifying writer to proceed because m_bInterrupted=falsebNotify=truem_bReaderDone=falsem_bFatalErrorOccured=false
[Thread-81] [ 2013-06-24 08:16:56.719 CST ] [RMANEngine.run:729]  Return Value from readSqlOutput=echo set on
[main] [ 2013-06-24 08:16:56.722 CST ] [RMANEngine.executeImpl:1146]  Completed wait from reader
[main] [ 2013-06-24 08:16:56.723 CST ] [RMANEngine.executeImpl:1193]  DONE EXECUTING GIVEN COMMAND=backup as copy database to destination  '+ASMDATA';
[main] [ 2013-06-24 08:16:56.727 CST ] [RMANEngine.executeImpl:1098]  m_bExecQuery=false
[main] [ 2013-06-24 08:16:56.730 CST ] [RMANEngine.executeImpl:1106]  Command being written to rman process=backup as backupset reuse spfile format  '+ASMDATA/sp_lunar1_backup';
[main] [ 2013-06-24 08:16:56.733 CST ] [RMANEngine.executeImpl:1134]  Notify reader to start reading
[Thread-81] [ 2013-06-24 08:16:56.735 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-81] [ 2013-06-24 08:16:56.932 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=RMAN> backup as backupset reuse spfile format  '+ASMDATA/sp_lunar1_backup';
[Thread-81] [ 2013-06-24 08:16:56.994 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=Starting backup at 24-JUN-13
[Thread-81] [ 2013-06-24 08:16:57.278 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=using channel ORA_DISK_1
[Thread-81] [ 2013-06-24 08:16:57.782 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=channel ORA_DISK_1: starting full datafile backup set
[Thread-81] [ 2013-06-24 08:16:57.785 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=channel ORA_DISK_1: specifying datafile(s) in backup set
[Thread-81] [ 2013-06-24 08:16:57.849 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=including current SPFILE in backup set
[Thread-81] [ 2013-06-24 08:16:57.853 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=channel ORA_DISK_1: starting piece 1 at 24-JUN-13
[Thread-81] [ 2013-06-24 08:16:58.869 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=channel ORA_DISK_1: finished piece 1 at 24-JUN-13
[Thread-81] [ 2013-06-24 08:16:58.870 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=piece handle=+ASMDATA/sp_lunar1_backup tag=TAG20130624T081657 comment=NONE
[Thread-81] [ 2013-06-24 08:16:58.873 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
[Thread-81] [ 2013-06-24 08:16:58.879 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=Finished backup at 24-JUN-13
[Thread-81] [ 2013-06-24 08:17:01.476 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-81] [ 2013-06-24 08:17:01.523 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-81] [ 2013-06-24 08:17:01.555 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=RMAN> set echo on

。。。。。。。。。。。。。。。。。。。

[Thread-83] [ 2013-06-24 08:17:10.683 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-83] [ 2013-06-24 08:17:10.685 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=RMAN> startup force nomount pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initlunar1.ora';
[Thread-83] [ 2013-06-24 08:17:21.503 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=Oracle instance started
[Thread-83] [ 2013-06-24 08:17:22.702 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-83] [ 2013-06-24 08:17:22.703 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=Total System Global Area     626327552 bytes
[Thread-83] [ 2013-06-24 08:17:22.708 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-83] [ 2013-06-24 08:17:22.709 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=Fixed Size                     2230952 bytes
[Thread-83] [ 2013-06-24 08:17:22.709 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=Variable Size                247465304 bytes
[Thread-83] [ 2013-06-24 08:17:22.710 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=Database Buffers             369098752 bytes
[Thread-83] [ 2013-06-24 08:17:22.710 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=Redo Buffers                   7532544 bytes
[Thread-83] [ 2013-06-24 08:17:22.806 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-83] [ 2013-06-24 08:17:22.806 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-83] [ 2013-06-24 08:17:22.807 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=RMAN> set echo on
[Thread-83] [ 2013-06-24 08:17:22.807 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-83] [ 2013-06-24 08:17:22.808 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=echo set on
[Thread-83] [ 2013-06-24 08:17:22.808 CST ] [RMANEngine.readSqlOutput:945]  Notifying writer to proceed because m_bInterrupted=falsebNotify=truem_bReaderDone=falsem_bFatalErrorOccured=false
[Thread-83] [ 2013-06-24 08:17:22.808 CST ] [RMANEngine.run:729]  Return Value from readSqlOutput=echo set on
[main] [ 2013-06-24 08:17:22.809 CST ] [RMANEngine.executeImpl:1146]  Completed wait from reader
[main] [ 2013-06-24 08:17:22.810 CST ] [RMANEngine.executeImpl:1193]  DONE EXECUTING GIVEN COMMAND=startup force nomount pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initlunar1.ora';
[main] [ 2013-06-24 08:17:22.810 CST ] [Instance.setControlAutoBackupOff:519]  CONFIGURE CONTROLFILE AUTOBACKUP OFF 
[main] [ 2013-06-24 08:17:22.811 CST ] [RMANEngine.executeImpl:1098]  m_bExecQuery=false
[main] [ 2013-06-24 08:17:22.814 CST ] [RMANEngine.executeImpl:1106]  Command being written to rman process=set nocfau;
[main] [ 2013-06-24 08:17:22.815 CST ] [RMANEngine.executeImpl:1134]  Notify reader to start reading
[Thread-83] [ 2013-06-24 08:17:22.815 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-83] [ 2013-06-24 08:17:22.816 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=RMAN> set nocfau;
[Thread-83] [ 2013-06-24 08:17:22.816 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=executing command: SET NOCFAU
[Thread-83] [ 2013-06-24 08:17:22.829 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=using target database control file instead of recovery catalog
[Thread-83] [ 2013-06-24 08:17:23.395 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-83] [ 2013-06-24 08:17:23.397 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-83] [ 2013-06-24 08:17:23.397 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=RMAN> set echo on
[Thread-83] [ 2013-06-24 08:17:23.397 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-83] [ 2013-06-24 08:17:23.398 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=echo set on
[Thread-83] [ 2013-06-24 08:17:23.398 CST ] [RMANEngine.readSqlOutput:945]  Notifying writer to proceed because m_bInterrupted=falsebNotify=truem_bReaderDone=falsem_bFatalErrorOccured=false
[Thread-83] [ 2013-06-24 08:17:23.398 CST ] [RMANEngine.run:729]  Return Value from readSqlOutput=echo set on
[main] [ 2013-06-24 08:17:23.399 CST ] [RMANEngine.executeImpl:1146]  Completed wait from reader
[main] [ 2013-06-24 08:17:23.400 CST ] [RMANEngine.executeImpl:1193]  DONE EXECUTING GIVEN COMMAND=set nocfau;
[main] [ 2013-06-24 08:17:23.401 CST ] [RMANEngine.executeImpl:1098]  m_bExecQuery=false
[main] [ 2013-06-24 08:17:23.402 CST ] [RMANEngine.executeImpl:1106]  Command being written to rman process=restore spfile to  '+ASMDATA/spfilelunar1.ora'  from  '+ASMDATA/sp_lunar1_backup';
[main] [ 2013-06-24 08:17:23.402 CST ] [RMANEngine.executeImpl:1134]  Notify reader to start reading
[Thread-83] [ 2013-06-24 08:17:23.403 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-83] [ 2013-06-24 08:17:23.404 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=RMAN> restore spfile to  '+ASMDATA/spfilelunar1.ora'  from  '+ASMDATA/sp_lunar1_backup';
[Thread-83] [ 2013-06-24 08:17:23.405 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=Starting restore at 24-JUN-13
[Thread-83] [ 2013-06-24 08:17:23.546 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=allocated channel: ORA_DISK_1
[Thread-83] [ 2013-06-24 08:17:23.552 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=channel ORA_DISK_1: SID=18 instance=lunar1 device type=DISK
[Thread-83] [ 2013-06-24 08:17:23.906 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-83] [ 2013-06-24 08:17:24.331 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=channel ORA_DISK_1: restoring spfile from AUTOBACKUP +ASMDATA/sp_lunar1_backup
[Thread-83] [ 2013-06-24 08:17:25.358 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
[Thread-83] [ 2013-06-24 08:17:25.359 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=Finished restore at 24-JUN-13
[Thread-83] [ 2013-06-24 08:17:25.440 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-83] [ 2013-06-24 08:17:25.441 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-83] [ 2013-06-24 08:17:25.441 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=RMAN> set echo on
[Thread-83] [ 2013-06-24 08:17:25.441 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-83] [ 2013-06-24 08:17:25.441 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=echo set on
[Thread-83] [ 2013-06-24 08:17:25.442 CST ] [RMANEngine.readSqlOutput:945]  Notifying writer to proceed because m_bInterrupted=falsebNotify=truem_bReaderDone=falsem_bFatalErrorOccured=false
[Thread-83] [ 2013-06-24 08:17:25.442 CST ] [RMANEngine.run:729]  Return Value from readSqlOutput=echo set on
[main] [ 2013-06-24 08:17:25.443 CST ] [RMANEngine.executeImpl:1146]  Completed wait from reader
[main] [ 2013-06-24 08:17:25.443 CST ] [RMANEngine.executeImpl:1193]  DONE EXECUTING GIVEN COMMAND=restore spfile to  '+ASMDATA/spfilelunar1.ora'  from  '+ASMDATA/sp_lunar1_backup';
[main] [ 2013-06-24 08:17:25.444 CST ] [RMANEngine.executeImpl:1098]  m_bExecQuery=false
[main] [ 2013-06-24 08:17:25.444 CST ] [RMANEngine.executeImpl:1106]  Command being written to rman process=shutdown immediate;
[main] [ 2013-06-24 08:17:25.444 CST ] [RMANEngine.executeImpl:1134]  Notify reader to start reading
[Thread-83] [ 2013-06-24 08:17:25.445 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-83] [ 2013-06-24 08:17:25.445 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=RMAN> shutdown immediate;
[Thread-83] [ 2013-06-24 08:17:34.039 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=Oracle instance shut down
[Thread-83] [ 2013-06-24 08:17:34.040 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=
[Thread-83] [ 2013-06-24 08:17:34.041 CST ] [RMANEngine.readSqlOutput:801]  Log RMAN Output=

。。。。。。。。。。。。。。。。。。。。

此条目发表在 RAC 分类目录,贴了 , 标签。将固定链接加入收藏夹。

发表评论

电子邮件地址不会被公开。 必填项已用 * 标注

您可以使用这些 HTML 标签和属性: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>