VMwareへOracle Real Application Clusters 19c (RAC)をインストールしてみてみた

# ■ 目的
Oracle DatabaseでOracle Real Application Clusters(RAC)オプションを使用すると、異なるサーバーで実行されている複数のインスタンスから、共有ストレージに保存された同じ物理データベースにアクセスできます。データベースは複数のハードウェア・システムにまたがりますが、アプリケーションからは、1つの統合データベースとして見えます。
このアーキテクチャでは、異なるノード上で実行されているOracle  RACインスタンスによってサーバー障害からの保護が提供されるため、高可用性が実現します。なお、Oracle  Applications、PeopleSoft、Siebel、SAPをはじめとする（ほぼ）すべてのアプリケーションは、一切変更なしでOracle RAC上で実行することができます。
ということで、Oracle Database 19c RACをインストールしてみてみます



# ■ 構成
![構成.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/7ae9e859-6a9e-bb3e-4e13-b1a2ca8e03c4.png)
環境は、前回インストールした自宅VMwareのOracle Grid Infrastructure環境へ、Oracle Real Application Clusters 19c をインストールしてみてみます。
**● 参考**
　- [Oracle Grid Infrastructure 19c をインストールしてみてみた](https://qiita.com/shirok/items/38f835498e5333901b5e)
　- [VMware vSphere Hypervisor 7.0 (ESXi) をインストールしてみてみた](https://qiita.com/shirok/items/ffc4a04e6891ddc8dee2)
 ORACLEソフトウェアは[ソフトウェア・ダウンロード](https://www.oracle.com/jp/downloads/applications/software-download.html)からダウンロードしてみてみます


# ■ Oracleインストール・ユーザー作成
#### 1) Oracle ユーザー作成

```shell:全Node
[root@rac19c-node1 ~]# /usr/sbin/useradd -u 54321 -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba oracle
```

#### 2) ユーザー作成確認

```shell:全Node
[root@rac19c-node1 ~]# id -a oracle
	id=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba),54327(asmdba)
```

#### 3) ユーザーパスワード設定

```shell:全Node
[root@rac19c-node1 ~]# passwd oracle
	Changing password for user oracle.
	New password:
	Retype new password:
	passwd: all authentication tokens updated successfully.
```

#### 4) 環境変数.bash_profile設定


```shell:全Node
[oracle@rac11g1 ~]$ vi ~/.bash_profile
	# Oracle DB
	umask 022
	export LANG=C
	export NLS_LANG=American_America.UTF8
	export ORACLE_BASE=/u01/app/oracle
	export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
	export PATH=$ORACLE_HOME/bin:$PATH
	export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
	export ORACLE_SID=orcl1
	export ORACLE_UNQNAME=orcl
```




# ■ Oracle Database インストール
## ● oracleユーザーログイン

```shell:全Node
[root@rac19c-node1 ~]# su - oracle
```


## ● ORACLE_HOMEディレクトリ作成
以下全ノードで実施

```shell:全Node
[oracle@rac19c-node1 ~]$ mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
[oracle@rac19c-node1 ~]$ chgrp oinstall /u01/app/oracle/product/19.0.0/dbhome_1
```


## ● インストール・イメージ・ファイル配置
ノード１でのみ以下実行、インストール時に他ノードへ配布インストールされます
Oracle Databaseインストール・イメージ・ファイル(db_home.zip)をダウンロードし、
ファイルをOracleホーム・ディレクトリに展開

```shell:Node1
[oracle@rac19c-node1 ~]$ cd /u01/app/oracle/product/19.0.0/dbhome_1
[oracle@rac19c-node1 dbhome_1]$ unzip -q /<インストール・イメージzipディレクトリ>/db_home.zip
```


## ● runInstaller実行

#### 1) runInstaller実行
Oracleホーム・ディレクトへ移動して、runInstaller実行

```shell:Node1
[oracle@rac19c-node1 ~]$ cd /u01/app/oracle/product/19.0.0/dbhome_1
[oracle@rac19c-node1 dbhome_1]$ ./runInstaller
```

![01.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/5cc3947a-ec30-3843-e093-1e6305050d79.png)



#### 2) Select Configuration Option画面
[Set up Software Only]を選択して、[Next]をクリック
![02.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/0fe1f96d-72a9-bed8-d6cc-b9f9ab39bd1f.png)


#### 3) Select Database Installtion　Option画面
[Oracle Real Application Clusters Database Isntalation]を選択して、[Next]をクリック
![03.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/ef585447-9824-f8c0-a5ce-f6d0ab7868bc.png)



#### 4) Select List of Nodes画面
[SSH Connectiovity]をクリックし、以下項目を入力し、[Setup]をクリック

	・Node Name: 全ノード選択
	・OS Username: インストールユーザー名
	・OS Password: インストールユーザーのパスワード

![04.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/628414d4-3af1-9b41-a662-dc4e5e82be45.png)


#### 5) Successfillyプロンプト
Successfillyになった場合、[OK]をクリックし、前画面の[Next]をクリック
Successfillyにならない場合は、全ノードどうしがoracleインストールユーザーでsshできることを確認し、再度[Setup]をクリックし、Successfillyにします
![05.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/1c597933-4c01-612b-249e-98c63fbf5f6f.png)


#### 6) Select Database Option
[Enterprise Edition]を選択し、[Next]をクリック
![07.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/10692dc0-e368-0fe1-e0b4-26a92aad31e7.png)


#### 7) Specify Installtion Location画面
以下項目を入力し、[Next]をクリック

	・Oracle Base: ORACLE_BASEパス

![08.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/80aa6ef9-15f4-5422-5939-273afee3594a.png)


#### 8) Privileged Operationg System Groups
以下項目を入力し、[Next]をクリック

	・Database Administratior Group: dba
	・Database Operator Group: oper
	・Database Backup and Recovery group (OSBACKUPDBA)
	・Data Guard administrative (OSDGDBA)
	・Encryption Key Management administratore (OSKMDBA)
	・Real Application Cluster Administrative administratore (OSRACDBA)

![09.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/a8caa810-1fd5-56f8-20df-cbbb7369bf81.png)



#### 9) Root script execution configuration
[Next]をクリック
![10.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/a159886c-809d-2c2a-a184-67c66f0cf9bd.png)


#### 10) Perform Prerequiste Checks画面
インストール要件確認中・・・
![11.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/a174d83a-0d4b-57ee-2212-69b0fbd07d9c.png)



#### 11) Perform Prerequiste Checks画面
Checksに問題がないことを確認し、[Next]をクリック
![12.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/bc18355c-b045-a57c-6d3c-11a6f6d60b57.png)


#### 12) Summary画面
Install内容を確認し問題なければ、[Install]をクリック
![13.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/5d051d66-0de1-4e57-2a45-96298b32bd33.png)


#### 13) Install Product画面
Install中・・・

![14.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/c36f3899-1632-ef67-b7bc-2685390f2105.png)



#### 14) Execute Configuration Scripts
表示された、root.shを、Node1から順番に直列で全ノード実行
![15.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/ae87b519-babd-3653-0dec-ffe2789db0ac.png)

**・node1実行**

```shell:Node1
[root@rac19c-node1 ~]# /u01/app/oracle/product/19.0.0/dbhome_1/root.sh
	Performing root user operation.

	The following environment variables are set as:
		ORACLE_OWNER= oracle
		ORACLE_HOME=  /u01/app/oracle/product/19.0.0/dbhome_1

	Enter the full pathname of the local bin directory: [/usr/local/bin]:
	The contents of "dbhome" have not changed. No need to overwrite.
	The contents of "oraenv" have not changed. No need to overwrite.
	The contents of "coraenv" have not changed. No need to overwrite.

	Entries will be added to the /etc/oratab file as needed by
	Database Configuration Assistant when a database is created
	Finished running generic part of root script.
	Now product-specific root actions will be performed.
```

**・Node2実行**

```shell:Node2
[root@rac19c-node2 ~]# /u01/app/oracle/product/19.0.0/dbhome_1/root.sh
	Performing root user operation.

	The following environment variables are set as:
		ORACLE_OWNER= oracle
		ORACLE_HOME=  /u01/app/oracle/product/19.0.0/dbhome_1

	Enter the full pathname of the local bin directory: [/usr/local/bin]:
	The contents of "dbhome" have not changed. No need to overwrite.
	The contents of "oraenv" have not changed. No need to overwrite.
	The contents of "coraenv" have not changed. No need to overwrite.

	Entries will be added to the /etc/oratab file as needed by
	Database Configuration Assistant when a database is created
	Finished running generic part of root script.
	Now product-specific root actions will be performed.
```

#### 15) Finish
Succeccfulしたら、[Close]をクリックして完了
![16.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/bd771d6f-7e2c-bff5-a893-a244f7156db7.png)







# ■ Database作成

## ● DBCA実行

#### 1) dbca実行

```shell:Node1
[oracle@rac11g1 ~]$ $ORACLE_HOME/bin/dbca
```

![01.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/d6a5363f-789b-4e77-a62e-4a3747f0489d.png)



#### 2) Select Database Operation画面
[Create a Database]を選択し、[Next]をクリック
![02.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/914cb73f-5dbb-aacd-f3ed-2e7d98191020.png)



#### 3) Select Database Creattion Mode画面
[Adyanced configuration]を選択し、[Next]をクリック
![03.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/06a18fcd-66f2-5898-8077-6a044d914e8c.png)



#### 4) Select Database Deployment Type画面
以下項目を設定し、[Next]をクリック

	・Database Type: RAC
	・Confuguration Type: ここではAdmin Managed
	・Select a template: ここではCustom Database

![04.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/2119b390-915c-a370-2806-ccc0b43a5a0d.png)

#### 5) Select List of Nodes画面
すべてのノードを選択し、[Next]をクリック
![05.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/7dd7c476-5862-ae77-3326-4562e70ee471.png)


#### 6) Specify Databse Identification details
以下項目を設定し、[Next]をクリック

	・Global database name: Global database名を設定
	・SID Prifix: SID固定名を設定、RACでは後ろにノード番号が振られます
	・Create as container database: CDBとして設定するのでチェック

![05.5.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/d0d30adb-d586-b9bb-f9dd-57174a6d675b.png)

#### 7) Select Database Storage Option画面
[Use Folowing for the database storage attributes]を選択し、[Multiplex redo logs and control files]をクリック
![06.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/a2c13b50-57dc-708d-5f20-01f807b3fbdc.png)

#### 8) Multiplex redo logs and control files画面
REDOログファイルと制御ファイルを冗長配置するASMディスクグループを設定し、[OK]をクリックし、[Next]をクリック
![06.5.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/0bb64081-d3db-226f-a63d-d069d846c49c.png)

#### 9) Select Fast Recivery Option画面
以下設定をし、[Enable archiving]をチェックし、[Edit archive mode parameters]をクリック

	・Specify FastRecovery Areaへチェック
		- Recivery files storage type: ASMを選択
		- Fast Recon¥very Area: FRA用ASMディスクを選択
		- Fast Recovery Area size: 18GB以上を設定

![06.6.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/c2955a54-08d4-907d-b32b-fd9be6969bd2.png)


#### 10) Archive mode parameters画面
以下を設定し、[OK]をクリックし、[Next]をクリック

	・Automatic archiveing: チェック
	・Archive log file format:Archive log フォーマットを設定


#### 11) Select Database Options画面
必要なDagtabase Componetsを選択し、[Next]をクリック
![07.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/1f163764-1660-950c-d05c-d5c8a3afed21.png)


#### 12) Specify Configuration Option: Memoryタブ
Memoryパラメーターを設定
![08.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/a16a114d-847a-7421-52e2-ee358853fd5e.png)

#### 13) Specify Configuration Option: Sizingタブ
以下項目を設定

	・Block Size: 
	・Processes: 

![09.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/b053bbfd-48fa-7592-9fc1-a068bf9523dc.png)


#### 14) Specify Configuration Option: Character Setsタブ
以下項目を設定

	・Character Set
	・National Character Set
	・Default Language
	・Default Teriitory

![10.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/50111e0c-8534-1151-7439-8236cc018b6a.png)

#### 15) Specify Configuration Option: Connection modeタブ
[Dediated]or[Shared]を選択
![11.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/09500cc6-5d63-94f2-4371-1ce8645c4288.png)


#### 16) Specify Configuration Option: Sample schemaタブ
Sample schema必要な場合はチェックし、[Next]をクリック
![12.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/fe21c38a-4a1a-51cf-e291-56fa6adfad42.png)



#### 17) Specity Management Options画面
以下項目を入力し、[Next]をクリック

	・Run CLuster Verification Utility(CVU): CVU確認する場合
	・Configure Enterprise Manager(EM)express: EM Express作る場合
	・Register with Enterprise Manager(EM): EM Cloud COntorolへ登録する場合

![13.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/af8122c4-ada3-c868-ad05-93c2c3e1ab6c.png)

#### 18) Specify Database User Credentials画面
ユーザーのパスワードを設定し、[Next]をクリック
![14.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/d0d2d5c8-1dfe-1b56-1d37-54ccf286b61a.png)


#### 19) Select Database Creation Option画面
以下項目を入力し、[All Initialization Parameters]をクリック

	・Create Database: Database作成する場合
	・Save as a database template: テンプレート保存する場合
	・Generate database creation scripts：Create Databaseスクリプト作成する場合

![15.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/cf7ad897-7f47-0920-759a-ed465fb86de0.png)

#### 20) All Initialization Parameters画面
必要パラメータを設定し、[OK]をクリックし、前画面の[Customaize Storage Location]をクリック
![15.5.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/cfa7c64d-6541-5087-4b48-48d65c357289.png)


#### 21) Customaize Storage画面
Databaseファイルを設定し、[OK]をクリックして前画面の[Next]をクリック

・Control Files
![15.6.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/8862cf6b-743f-a258-da49-f902d653e9e2.png)

・Tablespaces
![15.7.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/73264155-09df-b51f-b319-984fb96a4f84.png)

・Datafiles
![15.8.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/6bf9fbeb-2515-1240-9852-583a1e9a23e1.png)

・Redo Log Groups
各ノード用にスレッド分けて３グループ以上でREDOログを設定
![15.9.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/266dc914-aa56-4efa-1575-34aaa90ede80.png)


#### 22) Perform Prerequiste Checks画面
チェック中・・・
![16.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/ab407798-268a-d1e1-f914-b5967c5052e9.png)

#### 23) Perform Prerequiste Checks画面
チェック内容に問題なければ、[Next]をクリック
ここでは、勉強用途でSCANホスト名はDNS利用していないため、[Ignoer All]へチェック
![17.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/d0176ac2-1e10-1306-b574-f919fd9ae9c3.png)



#### 24) Summary画面
作成内容を確認し、[OK]をクリック
![19.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/ea84e409-cd28-a2bf-0e6e-b7fe36e822af.png)




#### 25) DB作成中
![20.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/3e8b09a7-acad-243d-db21-f11a4ef1216e.png)

#### 26)  Dataabase Configuration Assistant画面
[Close]をクリックし、作成完了
![21.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/109087/6bef2931-aacf-92f5-620c-cc12050dafa3.png)




# ■ DB作成確認
## ● CRS登録確認

```shell:全Node
[root@rac19c-node1 ~]# su - grid
	Last login: Wed Dec  2 09:55:13 JST 2020

[grid@rac19c-node1 ~]$ crsctl stat res -t
	--------------------------------------------------------------------------------
	Name           Target  State        Server                   State details
	--------------------------------------------------------------------------------
	Local Resources
	--------------------------------------------------------------------------------
	ora.LISTENER.lsnr
				ONLINE  ONLINE       rac19c-node1             STABLE
				ONLINE  ONLINE       rac19c-node2             STABLE
	ora.chad
				ONLINE  ONLINE       rac19c-node1             STABLE
				ONLINE  ONLINE       rac19c-node2             STABLE
	ora.net1.network
				ONLINE  ONLINE       rac19c-node1             STABLE
				ONLINE  ONLINE       rac19c-node2             STABLE
	ora.ons
				ONLINE  ONLINE       rac19c-node1             STABLE
				ONLINE  ONLINE       rac19c-node2             STABLE
	--------------------------------------------------------------------------------
	Cluster Resources
	--------------------------------------------------------------------------------
	ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
		1        ONLINE  ONLINE       rac19c-node1             STABLE
		2        ONLINE  ONLINE       rac19c-node2             STABLE
		3        ONLINE  OFFLINE                               STABLE
	ora.CRS.dg(ora.asmgroup)
		1        ONLINE  ONLINE       rac19c-node1             STABLE
		2        ONLINE  ONLINE       rac19c-node2             STABLE
		3        OFFLINE OFFLINE                               STABLE
	ora.DATA.dg(ora.asmgroup)
		1        ONLINE  ONLINE       rac19c-node1             STABLE
		2        ONLINE  ONLINE       rac19c-node2             STABLE
		3        OFFLINE OFFLINE                               STABLE
	ora.LISTENER_SCAN1.lsnr
		1        ONLINE  ONLINE       rac19c-node2             STABLE
	ora.LISTENER_SCAN2.lsnr
		1        ONLINE  ONLINE       rac19c-node1             STABLE
	ora.LISTENER_SCAN3.lsnr
		1        ONLINE  ONLINE       rac19c-node1             STABLE
	ora.RECO.dg(ora.asmgroup)
		1        ONLINE  ONLINE       rac19c-node1             STABLE
		2        ONLINE  ONLINE       rac19c-node2             STABLE
		3        ONLINE  OFFLINE                               STABLE
	ora.asm(ora.asmgroup)
		1        ONLINE  ONLINE       rac19c-node1             Started,STABLE
		2        ONLINE  ONLINE       rac19c-node2             Started,STABLE
		3        OFFLINE OFFLINE                               STABLE
	ora.asmnet1.asmnetwork(ora.asmgroup)
		1        ONLINE  ONLINE       rac19c-node1             STABLE
		2        ONLINE  ONLINE       rac19c-node2             STABLE
		3        OFFLINE OFFLINE                               STABLE
	ora.cvu
		1        ONLINE  ONLINE       rac19c-node1             STABLE
	ora.orcl.db
		1        ONLINE  ONLINE       rac19c-node1             Open,HOME=/u01/app/o
																racle/product/19.0.0
																/dbhome_1,STABLE
		2        ONLINE  ONLINE       rac19c-node2             Open,HOME=/u01/app/o
																racle/product/19.0.0
																/dbhome_1,STABLE
	ora.qosmserver
		1        ONLINE  ONLINE       rac19c-node1             STABLE
	ora.rac19c-node1.vip
		1        ONLINE  ONLINE       rac19c-node1             STABLE
	ora.rac19c-node2.vip
		1        ONLINE  ONLINE       rac19c-node2             STABLE
	ora.scan1.vip
		1        ONLINE  ONLINE       rac19c-node2             STABLE
	ora.scan2.vip
		1        ONLINE  ONLINE       rac19c-node1             STABLE
	ora.scan3.vip
		1        ONLINE  ONLINE       rac19c-node1             STABLE
	--------------------------------------------------------------------------------


```


## ● SQL＊Plus接続確認

```shell:全Node
[oracle@rac19c-node1 ~]$ sqlplus / as sysdba

	SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 3 01:55:10 2020
	Version 19.0.0.0.0

	Copyright (c) 1982, 2019, Oracle.  All rights reserved.


	Connected to:
	Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
	Version 19.0.0.0.0


	SQL> select instance_name from gv$instance;

		INSTANCE_NAME
		------------------------------------------------
		orcl1
		orcl2
```

## ● 初期化パラメータ確認

```sql
SQL> create pfile='/tmp/init.ora' from spfile;

	File created.

SQL> host cat /tmp/init.ora
	orcl2.__data_transfer_cache_size=0
	orcl1.__data_transfer_cache_size=0
	orcl1.__db_cache_size=1744830464
	orcl2.__db_cache_size=1744830464
	orcl2.__inmemory_ext_roarea=0
	orcl1.__inmemory_ext_roarea=0
	orcl2.__inmemory_ext_rwarea=0
	orcl1.__inmemory_ext_rwarea=0
	orcl2.__java_pool_size=0
	orcl1.__java_pool_size=0
	orcl2.__large_pool_size=16777216
	orcl1.__large_pool_size=16777216
	orcl2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
	orcl1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
	orcl2.__pga_aggregate_target=838860800
	orcl1.__pga_aggregate_target=838860800
	orcl2.__sga_target=2516582400
	orcl1.__sga_target=2516582400
	orcl2.__shared_io_pool_size=134217728
	orcl1.__shared_io_pool_size=134217728
	orcl1.__shared_pool_size=603979776
	orcl2.__shared_pool_size=603979776
	orcl2.__streams_pool_size=0
	orcl1.__streams_pool_size=0
	orcl2.__unified_pga_pool_size=0
	orcl1.__unified_pga_pool_size=0
	*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
	*.audit_trail='db'
	*.cluster_database=true
	*.compatible='19.0.0'
	*.control_files='+DATA/ORCL/CONTROLFILE/current.290.1058210743','+RECO/ORCL/CONTROLFILE/current.271.1058210743'
	*.db_block_size=8192
	*.db_create_file_dest='+DATA'
	*.db_create_online_log_dest_1='+DATA'
	*.db_create_online_log_dest_2='+RECO'
	*.db_domain='oracle.com'
	*.db_name='orcl'
	*.db_recovery_file_dest='+RECO'
	*.db_recovery_file_dest_size=18471m
	*.diagnostic_dest='/u01/app/oracle'
	*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
	*.enable_pluggable_database=true
	family:dw_helper.instance_mode='read-only'
	orcl2.instance_number=2
	orcl1.instance_number=1
	*.local_listener='-oraagent-dummy-'
	*.log_archive_format='archive-redo%t_%s_%r.log'
	*.nls_language='JAPANESE'
	*.nls_territory='JAPAN'
	*.open_cursors=300
	*.pga_aggregate_target=797m
	*.processes=300
	*.remote_login_passwordfile='exclusive'
	*.sga_target=2388m
	orcl2.thread=2
	orcl1.thread=1
	*.undo_tablespace='UNDOTBS1'
	orcl2.undo_tablespace='UNDOTBS2'
	orcl1.undo_tablespace='UNDOTBS1'
```


# ■ Archive Logモード設定
Archive Log設定していなかったので設定

#### 1) Database停止

```shell
[grid@rac19c-node1 ~]$ srvctl stop db -d orcl
[grid@rac19c-node1 ~]$ srvctl status db -d orcl
	Instance orcl1 is not running on node rac19c-node1
	Instance orcl2 is not running on node rac19c-node2
```

#### 2) STARTUP MOUNT

```shell
SQL> startup mount
	ORACLE instance started.

	Total System Global Area 2516582152 bytes
	Fixed Size		    9137928 bytes
	Variable Size		  620756992 bytes
	Database Buffers	 1879048192 bytes
	Redo Buffers		    7639040 bytes
	Database mounted.
```

#### 3) DB_RECOVERY_FILE_DEST_SIZE設定

```shell
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=20G;

	System altered.
```

#### 4) DB_RECOVERY_FILE_DEST設定

```shell
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '+RECO';

	System altered.
```

#### 5) Archive Logモード設定

```shell
SQL> ALTER DATABASE archivelog;

	Database altered.
```

#### 6) Archive Logモード確認

```shell
SQL> ARCHIVE LOG LIST
	Database log mode	       Archive Mode
	Automatic archival	       Enabled
	Archive destination	       USE_DB_RECOVERY_FILE_DEST
	Oldest online log sequence     12
	Next log sequence to archive   13
	Current log sequence	       13
```

#### 7) Database停止

```shell
SQL> SHUTDOWN ;
	ORA-01109: database not open


	Database dismounted.
	ORACLE instance shut down.
```


#### 8) Database起動

```shell
[grid@rac19c-node1 ~]$ srvctl start db -d orcl
[grid@rac19c-node1 ~]$ srvctl status db -d orcl
	Instance orcl1 is running on node rac19c-node1
	Instance orcl2 is running on node rac19c-node2
```

#### 9) Archive Log作成

```shell
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;

	System altered.
```

#### 10) Archive Log作成確認

```shell
SQL> SELECT name FROM V$ARCHIVED_LOG;

	NAME
	----------------------------------------------------------------
	+RECO/ORCL/ARCHIVELOG/2020_12_03/thread_2_seq_10.257.1058171869
	+RECO/ORCL/ARCHIVELOG/2020_12_03/thread_1_seq_18.256.1058171869
```


## ■ RMANバックアップ
Databaseをバックアップしておきます

#### 1) RMAN接続

```sql
[oracle@rac19c-node1 ~]$ rman target /

	Recovery Manager: Release 19.0.0.0.0 - Production on Thu Dec 3 08:46:32 2020
	Version 19.0.0.0.0

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

	connected to target database: ORCL (DBID=1585868896)
```



#### 2) RMANパラメータ確認

```sql
RMAN> show all;

	using target database control file instead of recovery catalog
	RMAN configuration parameters for database with db_unique_name ORCL are:
	CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
	CONFIGURE BACKUP OPTIMIZATION OFF; # default
	CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
	CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
	CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
	CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
	CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
	CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
	CONFIGURE MAXSETSIZE TO UNLIMITED; # default
	CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
	CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
	CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
	CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
	CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
	CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/19.0.0/dbhome_1/dbs/snapcf_orcl1.f'; # default
```


#### 3) RMANバックアップ実行

```shell
RMAN> BACKUP INCREMENTAL LEVEL 0  DATABASE　DATABASE PLUS ARCHIVELOG TO DESTINATION '+RECO';

	Starting backup at 03-DEC-20
	current log archived
	using target database control file instead of recovery catalog
	allocated channel: ORA_DISK_1
	channel ORA_DISK_1: SID=75 instance=orcl1 device type=DISK
	channel ORA_DISK_1: starting archived log backup set
	channel ORA_DISK_1: specifying archived log(s) in backup set
	input archived log thread=1 sequence=13 RECID=1 STAMP=1058168407
	input archived log thread=2 sequence=2 RECID=2 STAMP=1058168408
	input archived log thread=2 sequence=3 RECID=5 STAMP=1058169941
	input archived log thread=1 sequence=14 RECID=3 STAMP=1058169939
	input archived log thread=1 sequence=15 RECID=4 STAMP=1058169940
	input archived log thread=2 sequence=4 RECID=6 STAMP=1058170646
	input archived log thread=2 sequence=5 RECID=7 STAMP=1058170646
	input archived log thread=1 sequence=16 RECID=10 STAMP=1058170651
	input archived log thread=2 sequence=6 RECID=8 STAMP=1058170648
	input archived log thread=2 sequence=7 RECID=9 STAMP=1058170648
	input archived log thread=1 sequence=17 RECID=11 STAMP=1058171376
	input archived log thread=2 sequence=8 RECID=12 STAMP=1058171380
	input archived log thread=2 sequence=9 RECID=13 STAMP=1058171380
	input archived log thread=1 sequence=18 RECID=15 STAMP=1058171869
	input archived log thread=2 sequence=10 RECID=14 STAMP=1058171869
	input archived log thread=1 sequence=19 RECID=17 STAMP=1058172512
	input archived log thread=2 sequence=11 RECID=16 STAMP=1058172512
	channel ORA_DISK_1: starting piece 1 at 03-DEC-20
	channel ORA_DISK_1: finished piece 1 at 03-DEC-20
	piece handle=+RECO/ORCL/BACKUPSET/2020_12_03/annnf0_tag20201203t084833_0.260.1058172513 tag=TAG20201203T084833 comment=NONE
	channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
	Finished backup at 03-DEC-20

	Starting backup at 03-DEC-20
	using channel ORA_DISK_1
	channel ORA_DISK_1: starting incremental level 0 datafile backup set
	channel ORA_DISK_1: specifying datafile(s) in backup set
	input datafile file number=00001 name=+DATA/ORCL/DATAFILE/system.260.1058088167
	input datafile file number=00003 name=+DATA/ORCL/DATAFILE/sysaux.262.1058088179
	input datafile file number=00005 name=+DATA/ORCL/DATAFILE/undotbs1.264.1058088187
	input datafile file number=00007 name=+DATA/ORCL/DATAFILE/undotbs2.268.1058088223
	input datafile file number=00008 name=+DATA/ORCL/DATAFILE/users.269.1058088225
	channel ORA_DISK_1: starting piece 1 at 03-DEC-20
	channel ORA_DISK_1: finished piece 1 at 03-DEC-20
	piece handle=+RECO/ORCL/BACKUPSET/2020_12_03/nnndn0_tag20201203t084841_0.261.1058172521 tag=TAG20201203T084841 comment=NONE
	channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
	channel ORA_DISK_1: starting incremental level 0 datafile backup set
	channel ORA_DISK_1: specifying datafile(s) in backup set
	input datafile file number=00001 name=+DATA/ORCL/DATAFILE/system.260.1058088167
	input datafile file number=00003 name=+DATA/ORCL/DATAFILE/sysaux.262.1058088179
	input datafile file number=00005 name=+DATA/ORCL/DATAFILE/undotbs1.264.1058088187
	input datafile file number=00007 name=+DATA/ORCL/DATAFILE/undotbs2.268.1058088223
	input datafile file number=00008 name=+DATA/ORCL/DATAFILE/users.269.1058088225
	channel ORA_DISK_1: starting piece 1 at 03-DEC-20
	channel ORA_DISK_1: finished piece 1 at 03-DEC-20
	piece handle=+RECO/ORCL/BACKUPSET/2020_12_03/nnndn0_tag20201203t084841_0.262.1058172547 tag=TAG20201203T084841 comment=NONE
	channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
	channel ORA_DISK_1: starting incremental level 0 datafile backup set
	channel ORA_DISK_1: specifying datafile(s) in backup set
	input datafile file number=00011 name=+DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/undotbs1.275.1058090035
	input datafile file number=00012 name=+DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/undo_2.277.1058090083
	input datafile file number=00009 name=+DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/system.274.1058090035
	input datafile file number=00010 name=+DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/sysaux.273.1058090035
	input datafile file number=00013 name=+DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/users.278.1058090085
	channel ORA_DISK_1: starting piece 1 at 03-DEC-20
	channel ORA_DISK_1: finished piece 1 at 03-DEC-20
	piece handle=+RECO/ORCL/B571AD3185132A80E053C064A8C05201/BACKUPSET/2020_12_03/nnndn0_tag20201203t084841_0.263.1058172573 tag=TAG20201203T084841 comment=NONE
	channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
	channel ORA_DISK_1: starting incremental level 0 datafile backup set
	channel ORA_DISK_1: specifying datafile(s) in backup set
	input datafile file number=00011 name=+DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/undotbs1.275.1058090035
	input datafile file number=00012 name=+DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/undo_2.277.1058090083
	input datafile file number=00009 name=+DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/system.274.1058090035
	input datafile file number=00010 name=+DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/sysaux.273.1058090035
	input datafile file number=00013 name=+DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/users.278.1058090085
	channel ORA_DISK_1: starting piece 1 at 03-DEC-20
	channel ORA_DISK_1: finished piece 1 at 03-DEC-20
	piece handle=+RECO/ORCL/B571AD3185132A80E053C064A8C05201/BACKUPSET/2020_12_03/nnndn0_tag20201203t084841_0.264.1058172587 tag=TAG20201203T084841 comment=NONE
	channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
	channel ORA_DISK_1: starting incremental level 0 datafile backup set
	channel ORA_DISK_1: specifying datafile(s) in backup set
	input datafile file number=00006 name=+DATA/ORCL/B5713DA1AA6F73E6E053BF64A8C04AEC/DATAFILE/undotbs1.265.1058088189
	input datafile file number=00002 name=+DATA/ORCL/B5713DA1AA6F73E6E053BF64A8C04AEC/DATAFILE/system.261.1058088175
	input datafile file number=00004 name=+DATA/ORCL/B5713DA1AA6F73E6E053BF64A8C04AEC/DATAFILE/sysaux.263.1058088185
	channel ORA_DISK_1: starting piece 1 at 03-DEC-20
	channel ORA_DISK_1: finished piece 1 at 03-DEC-20
	piece handle=+RECO/ORCL/B5713DA1AA6F73E6E053BF64A8C04AEC/BACKUPSET/2020_12_03/nnndn0_tag20201203t084841_0.265.1058172603 tag=TAG20201203T084841 comment=NONE
	channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
	channel ORA_DISK_1: starting incremental level 0 datafile backup set
	channel ORA_DISK_1: specifying datafile(s) in backup set
	input datafile file number=00006 name=+DATA/ORCL/B5713DA1AA6F73E6E053BF64A8C04AEC/DATAFILE/undotbs1.265.1058088189
	input datafile file number=00002 name=+DATA/ORCL/B5713DA1AA6F73E6E053BF64A8C04AEC/DATAFILE/system.261.1058088175
	input datafile file number=00004 name=+DATA/ORCL/B5713DA1AA6F73E6E053BF64A8C04AEC/DATAFILE/sysaux.263.1058088185
	channel ORA_DISK_1: starting piece 1 at 03-DEC-20
	channel ORA_DISK_1: finished piece 1 at 03-DEC-20
	piece handle=+RECO/ORCL/B5713DA1AA6F73E6E053BF64A8C04AEC/BACKUPSET/2020_12_03/nnndn0_tag20201203t084841_0.266.1058172617 tag=TAG20201203T084841 comment=NONE
	channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
	Finished backup at 03-DEC-20

	Starting backup at 03-DEC-20
	current log archived
	using channel ORA_DISK_1
	channel ORA_DISK_1: starting archived log backup set
	channel ORA_DISK_1: specifying archived log(s) in backup set
	input archived log thread=2 sequence=12 RECID=19 STAMP=1058172633
	input archived log thread=1 sequence=20 RECID=18 STAMP=1058172632
	channel ORA_DISK_1: starting piece 1 at 03-DEC-20
	channel ORA_DISK_1: finished piece 1 at 03-DEC-20
	piece handle=+RECO/ORCL/BACKUPSET/2020_12_03/annnf0_tag20201203t085033_0.269.1058172633 tag=TAG20201203T085033 comment=NONE
	channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
	Finished backup at 03-DEC-20

	Starting Control File and SPFILE Autobackup at 03-DEC-20
	piece handle=+RECO/ORCL/AUTOBACKUP/2020_12_03/s_1058172634.270.1058172635 comment=NONE
	Finished Control File and SPFILE Autobackup at 03-DEC-20
```

#### 4) RMANバックアップ確認

```sql
RMAN> list backup;


	List of Backup Sets
	===================


	BS Key  Size       Device Type Elapsed Time Completion Time
	------- ---------- ----------- ------------ ---------------
	1       181.28M    DISK        00:00:04     03-DEC-20
			BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20201203T084833
			Piece Name: +RECO/ORCL/BACKUPSET/2020_12_03/annnf0_tag20201203t084833_0.260.1058172513

	List of Archived Logs in backup set 1
	Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
	---- ------- ---------- --------- ---------- ---------
	1    13      1229297    02-DEC-20 1434090    03-DEC-20
	1    14      1434090    03-DEC-20 1538199    03-DEC-20
	1    15      1538199    03-DEC-20 1538204    03-DEC-20
	1    16      1638241    03-DEC-20 1638376    03-DEC-20
	1    17      1638376    03-DEC-20 1745605    03-DEC-20
	1    18      1745605    03-DEC-20 1752172    03-DEC-20
	1    19      1752172    03-DEC-20 1753658    03-DEC-20
	2    2       1329479    03-DEC-20 1434086    03-DEC-20
	2    3       1434086    03-DEC-20 1538237    03-DEC-20
	2    4       1538237    03-DEC-20 1638240    03-DEC-20
	2    5       1638240    03-DEC-20 1638244    03-DEC-20
	2    6       1638244    03-DEC-20 1638246    03-DEC-20
	2    7       1638246    03-DEC-20 1638365    03-DEC-20
	2    8       1639312    03-DEC-20 1745604    03-DEC-20
	2    9       1745604    03-DEC-20 1745740    03-DEC-20
	2    10      1746695    03-DEC-20 1752175    03-DEC-20
	2    11      1752175    03-DEC-20 1753655    03-DEC-20

	BS Key  Type LV Size       Device Type Elapsed Time Completion Time
	------- ---- -- ---------- ----------- ------------ ---------------
	2       Incr 0  557.58M    DISK        00:00:16     03-DEC-20
			BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20201203T084841
			Piece Name: +RECO/ORCL/BACKUPSET/2020_12_03/nnndn0_tag20201203t084841_0.261.1058172521
	List of Datafiles in backup set 2
	File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
	---- -- ---- ---------- --------- ----------- ------ ----
	1    0  Incr 1753684    03-DEC-20              NO    +DATA/ORCL/DATAFILE/system.260.1058088167
	3    0  Incr 1753684    03-DEC-20              NO    +DATA/ORCL/DATAFILE/sysaux.262.1058088179
	5    0  Incr 1753684    03-DEC-20              NO    +DATA/ORCL/DATAFILE/undotbs1.264.1058088187
	7    0  Incr 1753684    03-DEC-20              NO    +DATA/ORCL/DATAFILE/undotbs2.268.1058088223
	8    0  Incr 1753684    03-DEC-20              NO    +DATA/ORCL/DATAFILE/users.269.1058088225

	BS Key  Type LV Size       Device Type Elapsed Time Completion Time
	------- ---- -- ---------- ----------- ------------ ---------------
	3       Incr 0  557.58M    DISK        00:00:16     03-DEC-20
			BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20201203T084841
			Piece Name: +RECO/ORCL/BACKUPSET/2020_12_03/nnndn0_tag20201203t084841_0.262.1058172547
	List of Datafiles in backup set 3
	File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
	---- -- ---- ---------- --------- ----------- ------ ----
	1    0  Incr 1753700    03-DEC-20              NO    +DATA/ORCL/DATAFILE/system.260.1058088167
	3    0  Incr 1753700    03-DEC-20              NO    +DATA/ORCL/DATAFILE/sysaux.262.1058088179
	5    0  Incr 1753700    03-DEC-20              NO    +DATA/ORCL/DATAFILE/undotbs1.264.1058088187
	7    0  Incr 1753700    03-DEC-20              NO    +DATA/ORCL/DATAFILE/undotbs2.268.1058088223
	8    0  Incr 1753700    03-DEC-20              NO    +DATA/ORCL/DATAFILE/users.269.1058088225

	BS Key  Type LV Size       Device Type Elapsed Time Completion Time
	------- ---- -- ---------- ----------- ------------ ---------------
	4       Incr 0  467.22M    DISK        00:00:11     03-DEC-20
			BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20201203T084841
			Piece Name: +RECO/ORCL/B571AD3185132A80E053C064A8C05201/BACKUPSET/2020_12_03/nnndn0_tag20201203t084841_0.263.1058172573
	List of Datafiles in backup set 4
	Container ID: 3, PDB Name: PDB
	File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
	---- -- ---- ---------- --------- ----------- ------ ----
	9    0  Incr 1329663    03-DEC-20              NO    +DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/system.274.1058090035
	10   0  Incr 1329663    03-DEC-20              NO    +DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/sysaux.273.1058090035
	11   0  Incr 1329663    03-DEC-20              NO    +DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/undotbs1.275.1058090035
	12   0  Incr 1329663    03-DEC-20              NO    +DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/undo_2.277.1058090083
	13   0  Incr 1329663    03-DEC-20              NO    +DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/users.278.1058090085

	BS Key  Type LV Size       Device Type Elapsed Time Completion Time
	------- ---- -- ---------- ----------- ------------ ---------------
	5       Incr 0  467.22M    DISK        00:00:10     03-DEC-20
			BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20201203T084841
			Piece Name: +RECO/ORCL/B571AD3185132A80E053C064A8C05201/BACKUPSET/2020_12_03/nnndn0_tag20201203t084841_0.264.1058172587
	List of Datafiles in backup set 5
	Container ID: 3, PDB Name: PDB
	File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
	---- -- ---- ---------- --------- ----------- ------ ----
	9    0  Incr 1329663    03-DEC-20              NO    +DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/system.274.1058090035
	10   0  Incr 1329663    03-DEC-20              NO    +DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/sysaux.273.1058090035
	11   0  Incr 1329663    03-DEC-20              NO    +DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/undotbs1.275.1058090035
	12   0  Incr 1329663    03-DEC-20              NO    +DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/undo_2.277.1058090083
	13   0  Incr 1329663    03-DEC-20              NO    +DATA/ORCL/B571AD3185132A80E053C064A8C05201/DATAFILE/users.278.1058090085

	BS Key  Type LV Size       Device Type Elapsed Time Completion Time
	------- ---- -- ---------- ----------- ------------ ---------------
	6       Incr 0  464.00M    DISK        00:00:10     03-DEC-20
			BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20201203T084841
			Piece Name: +RECO/ORCL/B5713DA1AA6F73E6E053BF64A8C04AEC/BACKUPSET/2020_12_03/nnndn0_tag20201203t084841_0.265.1058172603
	List of Datafiles in backup set 6
	Container ID: 2, PDB Name: PDB$SEED
	File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
	---- -- ---- ---------- --------- ----------- ------ ----
	2    0  Incr 1110645    02-DEC-20              NO    +DATA/ORCL/B5713DA1AA6F73E6E053BF64A8C04AEC/DATAFILE/system.261.1058088175
	4    0  Incr 1110645    02-DEC-20              NO    +DATA/ORCL/B5713DA1AA6F73E6E053BF64A8C04AEC/DATAFILE/sysaux.263.1058088185
	6    0  Incr 1110645    02-DEC-20              NO    +DATA/ORCL/B5713DA1AA6F73E6E053BF64A8C04AEC/DATAFILE/undotbs1.265.1058088189

	BS Key  Type LV Size       Device Type Elapsed Time Completion Time
	------- ---- -- ---------- ----------- ------------ ---------------
	7       Incr 0  464.00M    DISK        00:00:10     03-DEC-20
			BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20201203T084841
			Piece Name: +RECO/ORCL/B5713DA1AA6F73E6E053BF64A8C04AEC/BACKUPSET/2020_12_03/nnndn0_tag20201203t084841_0.266.1058172617
	List of Datafiles in backup set 7
	Container ID: 2, PDB Name: PDB$SEED
	File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
	---- -- ---- ---------- --------- ----------- ------ ----
	2    0  Incr 1110645    02-DEC-20              NO    +DATA/ORCL/B5713DA1AA6F73E6E053BF64A8C04AEC/DATAFILE/system.261.1058088175
	4    0  Incr 1110645    02-DEC-20              NO    +DATA/ORCL/B5713DA1AA6F73E6E053BF64A8C04AEC/DATAFILE/sysaux.263.1058088185
	6    0  Incr 1110645    02-DEC-20              NO    +DATA/ORCL/B5713DA1AA6F73E6E053BF64A8C04AEC/DATAFILE/undotbs1.265.1058088189

	BS Key  Size       Device Type Elapsed Time Completion Time
	------- ---------- ----------- ------------ ---------------
	8       33.50K     DISK        00:00:00     03-DEC-20
			BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20201203T085033
			Piece Name: +RECO/ORCL/BACKUPSET/2020_12_03/annnf0_tag20201203t085033_0.269.1058172633

	List of Archived Logs in backup set 8
	Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
	---- ------- ---------- --------- ---------- ---------
	1    20      1753658    03-DEC-20 1753807    03-DEC-20
	2    12      1753655    03-DEC-20 1753810    03-DEC-20

	BS Key  Type LV Size       Device Type Elapsed Time Completion Time
	------- ---- -- ---------- ----------- ------------ ---------------
	9       Full    18.89M     DISK        00:00:01     03-DEC-20
			BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20201203T085034
			Piece Name: +RECO/ORCL/AUTOBACKUP/2020_12_03/s_1058172634.270.1058172635
	SPFILE Included: Modification time: 03-DEC-20
	SPFILE db_unique_name: ORCL
	Control File Included: Ckp SCN: 1753823      Ckp time: 03-DEC-20
```

# ■ 参考情報
## ● マニュアル
　・[Grid Infrastructureインストレーションおよびアップグレード・ガイドfor Linux](https://docs.oracle.com/cd/F19136_01/cwlin/index.html)
　・[Real Application Clustersインストレーション・ガイドfor Linux and UNIX](https://docs.oracle.com/cd/F19136_01/rilin/index.html)
　・[Oracle Database 19c: クラスタリング](https://docs.oracle.com/cd/F19136_01/clustering.html)
　・[Oracle Database 19c - インストールとアップグレード](https://docs.oracle.com/cd/F19136_01/install-and-upgrade.html)
## ● White Paper
・[Oracle Database 19cでのOracle Real Application Clusters（Oracle RAC）](https://www.oracle.com/technetwork/jp/database/options/clustering/rac-twp-overview-5303704-ja.pdf)