■ 目的
Oracle DatabaseでOracle Real Application Clusters(RAC)オプションを使用すると、異なるサーバーで実行されている複数のインスタンスから、共有ストレージに保存された同じ物理データベースにアクセスできます。データベースは複数のハードウェア・システムにまたがりますが、アプリケーションからは、1つの統合データベースとして見えます。
このアーキテクチャでは、異なるノード上で実行されているOracle RACインスタンスによってサーバー障害からの保護が提供されるため、高可用性が実現します。なお、Oracle Applications、PeopleSoft、Siebel、SAPをはじめとする（ほぼ）すべてのアプリケーションは、一切変更なしでOracle RAC上で実行することができます。
ということで、Oracle Database 19c RACをインストールしてみてみます
■ 構成
環境は、前回インストールした自宅VMwareのOracle Grid Infrastructure環境へ、Oracle Real Application Clusters 19c をインストールしてみてみます。
● 参考
- Oracle Grid Infrastructure 19c をインストールしてみてみた
- VMware vSphere Hypervisor 7.0 (ESXi) をインストールしてみてみた
ORACLEソフトウェアはソフトウェア・ダウンロードからダウンロードしてみてみます
■ Oracleインストール・ユーザー作成
1) Oracle ユーザー作成
全Node
[root@rac19c-node1 ~]# /usr/sbin/useradd -u 54321 -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba oracle
2) ユーザー作成確認
全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) ユーザーパスワード設定
全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設定
全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ユーザーログイン
全Node
[root@rac19c-node1 ~]# su - oracle
● ORACLE_HOMEディレクトリ作成
以下全ノードで実施
全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ホーム・ディレクトリに展開
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実行
Node1
[oracle@rac19c-node1 ~]$ cd /u01/app/oracle/product/19.0.0/dbhome_1
[oracle@rac19c-node1 dbhome_1]$ ./runInstaller
2) Select Configuration Option画面
[Set up Software Only]を選択して、[Next]をクリック
3) Select Database Installtion Option画面
[Oracle Real Application Clusters Database Isntalation]を選択して、[Next]をクリック
4) Select List of Nodes画面
[SSH Connectiovity]をクリックし、以下項目を入力し、[Setup]をクリック
・Node Name: 全ノード選択
・OS Username: インストールユーザー名
・OS Password: インストールユーザーのパスワード
5) Successfillyプロンプト
Successfillyになった場合、[OK]をクリックし、前画面の[Next]をクリック
Successfillyにならない場合は、全ノードどうしがoracleインストールユーザーでsshできることを確認し、再度[Setup]をクリックし、Successfillyにします
6) Select Database Option
[Enterprise Edition]を選択し、[Next]をクリック
7) Specify Installtion Location画面
以下項目を入力し、[Next]をクリック
・Oracle Base: ORACLE_BASEパス
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)
9) Root script execution configuration
[Next]をクリック
10) Perform Prerequiste Checks画面
インストール要件確認中・・・
11) Perform Prerequiste Checks画面
Checksに問題がないことを確認し、[Next]をクリック
12) Summary画面
Install内容を確認し問題なければ、[Install]をクリック
13) Install Product画面
Install中・・・
14) Execute Configuration Scripts
表示された、root.shを、Node1から順番に直列で全ノード実行
・node1実行
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実行
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]をクリックして完了
■ Database作成
● DBCA実行
1) dbca実行
Node1
[oracle@rac11g1 ~]$ $ORACLE_HOME/bin/dbca
2) Select Database Operation画面
[Create a Database]を選択し、[Next]をクリック
3) Select Database Creattion Mode画面
[Adyanced configuration]を選択し、[Next]をクリック
4) Select Database Deployment Type画面
以下項目を設定し、[Next]をクリック
・Database Type: RAC
・Confuguration Type: ここではAdmin Managed
・Select a template: ここではCustom Database
5) Select List of Nodes画面
すべてのノードを選択し、[Next]をクリック
6) Specify Databse Identification details
以下項目を設定し、[Next]をクリック
・Global database name: Global database名を設定
・SID Prifix: SID固定名を設定、RACでは後ろにノード番号が振られます
・Create as container database: CDBとして設定するのでチェック
7) Select Database Storage Option画面
[Use Folowing for the database storage attributes]を選択し、[Multiplex redo logs and control files]をクリック
8) Multiplex redo logs and control files画面
REDOログファイルと制御ファイルを冗長配置するASMディスクグループを設定し、[OK]をクリックし、[Next]をクリック
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以上を設定
10) Archive mode parameters画面
以下を設定し、[OK]をクリックし、[Next]をクリック
・Automatic archiveing: チェック
・Archive log file format:Archive log フォーマットを設定
11) Select Database Options画面
必要なDagtabase Componetsを選択し、[Next]をクリック
12) Specify Configuration Option: Memoryタブ
Memoryパラメーターを設定
13) Specify Configuration Option: Sizingタブ
以下項目を設定
・Block Size:
・Processes:
14) Specify Configuration Option: Character Setsタブ
以下項目を設定
・Character Set
・National Character Set
・Default Language
・Default Teriitory
15) Specify Configuration Option: Connection modeタブ
[Dediated]or[Shared]を選択
16) Specify Configuration Option: Sample schemaタブ
Sample schema必要な場合はチェックし、[Next]をクリック
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へ登録する場合
18) Specify Database User Credentials画面
ユーザーのパスワードを設定し、[Next]をクリック
19) Select Database Creation Option画面
以下項目を入力し、[All Initialization Parameters]をクリック
・Create Database: Database作成する場合
・Save as a database template: テンプレート保存する場合
・Generate database creation scripts：Create Databaseスクリプト作成する場合
20) All Initialization Parameters画面
必要パラメータを設定し、[OK]をクリックし、前画面の[Customaize Storage Location]をクリック
21) Customaize Storage画面
Databaseファイルを設定し、[OK]をクリックして前画面の[Next]をクリック
・Control Files
・Tablespaces
・Datafiles
・Redo Log Groups
各ノード用にスレッド分けて３グループ以上でREDOログを設定
22) Perform Prerequiste Checks画面
チェック中・・・
23) Perform Prerequiste Checks画面
チェック内容に問題なければ、[Next]をクリック
ここでは、勉強用途でSCANホスト名はDNS利用していないため、[Ignoer All]へチェック
24) Summary画面
作成内容を確認し、[OK]をクリック
25) DB作成中
26) Dataabase Configuration Assistant画面
[Close]をクリックし、作成完了
■ DB作成確認
● CRS登録確認
全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接続確認
全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> 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停止
[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
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設定
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=20G;
System altered.
4) DB_RECOVERY_FILE_DEST設定
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '+RECO';
System altered.
5) Archive Logモード設定
SQL> ALTER DATABASE archivelog;
Database altered.
6) Archive Logモード確認
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停止
SQL> SHUTDOWN ;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
8) Database起動
[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作成
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;
System altered.
10) Archive Log作成確認
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接続
[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パラメータ確認
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バックアップ実行
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バックアップ確認
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
・Real Application Clustersインストレーション・ガイドfor Linux and UNIX
・Oracle Database 19c: クラスタリング
・Oracle Database 19c - インストールとアップグレード
● White Paper
・Oracle Database 19cでのOracle Real Application Clusters（Oracle RAC）