次の2つの例は、rconfig
ユーティリティ用のConvertToRAC
XML入力ファイルです。例14-1のXML入力ファイルは、Oracle ASMを使用したシングル・インスタンス・データベースを、Oracle ASM記憶域でポリシー管理Oracle RACデータベース(サーバー・プールを使用)に変換するものです。例14-2のXML入力ファイルは、Oracle ASMを使用したシングル・インスタンス・データベースを、管理者管理Oracle RACデータベースに変換するものです。
例14-1 ポリシー管理データベースのrconfig ConvertToRAC XMLファイルの例
<?xml version="1.0" encoding="UTF-8"?> <n:RConfig xmlns:n="http://www.example.com/rconfig" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.example.com/rconfig"> <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>/oracle/product/12.1.0/db_1</n:SourceDBHome> <!--Specify OracleHome where the rac database should be configured. It can be same as SourceDBHome --> <n:TargetDBHome>/oracle/product/12.1.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="sales"> <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 existing or new server pools which are used by the Policy Managed Cluster Database. --> <n:ServerPoolList> <n:ExistingServerPool name="custom"/> <n:NewServerPool name="newpool" cardinality="2"/> </n:ServerPoolList> <!--Specify RacOneNode along with servicename to convert database to RACOne Node --> <!--n:RacOneNode servicename="salesrac1service"/--> <!--InstancePrefix is not required for Policy Managed database. If specified, it will be ignored. Instance names are generated automatically based on db_unique_ name for Policy Managed dababase.--> <!-- 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>+ASMDG</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>+ASMDG</n:TargetFlashRecoveryArea> </n:SharedStorage> </n:Convert> </n:ConvertToRAC> </n:RConfig>
例14-2 管理者管理データベースのrconfig ConvertToRAC XMLファイルの例
<?xml version="1.0" encoding="UTF-8"?> <n:RConfig xmlns:n="http://www.example.com/rconfig" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.example.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>/oracle/product/12.1.0/db_1</n:SourceDBHome> <!--Specify OracleHome where the rac database should be configured. It can be same as SourceDBHome --> <n:TargetDBHome>/oracle/product/12.1.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="sales"> <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="node1"/> <n:Node name="node2"/> </n:NodeList> <!--Specify RacOneNode along with servicename to convert database to RACOne Node --> <!--n:RacOneNode servicename="salesrac1service"/--> <!--Instance Prefix tag is optional starting with 11.2. If left empty, it is derived from db_unique_name.--> <n:InstancePrefix>sales</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 not 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>+ASMDG</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>+ASMDG</n:TargetFlashRecoveryArea> </n:SharedStorage> </n:Convert> </n:ConvertToRAC> </n:RConfig>