Go to Qiita Advent Calendar 2024 Top
LoginSignup
3
2

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 1 year has passed since last update.

@asahide

RDS for Oracle の RMANバックアップをEFSに出力してみた

Posted at

はじめに

昨年RDS for OracleとEFSの統合が利用できるようになり、Amazon RDS for Oracle と Amazon Elastic File System (EFS) 統合を試してみたという記事を書きました。
2023/1/23にIntegrate Amazon RDS for Oracle with Amazon EFSという AWS Database blogが発表され、その中でRMANバックアップのEFS出力について触れられており、前回の私の検証ではその部分は実施していなかったため、追加で実施してみたものになります。

RMANバックアップのEFSへの出力

RDSからEFSへの出力は予め設定してあるものとします。（不明なかたは前回の記事を参照ください）

EFSへのディレクトリ作成

EFSへRMAN出力用のRMANディレクトリを作成します。
オーナとパーミッションは前回確認したとおり、3001:101 775で設定しておきます。

EFS上のディレクトリ作成
$ sudo mount -t nfs4 -o nfsvers=4.1,rsize=1048576,wsize=1048576,hard,timeo=600,retrans=2,noresvport fs-xxxxxxxxxxxxxxxxx.efs.ap-northeast-1.amazonaws.com:/ /efs
$ cd /efs
$ sudo mkdir RMAN
$ sudo chmod 775 RMAN
$ sudo chown 3001:101 RMAN
$ ll
total 8
drwxrwxr-x 2 3001 101 6144 Nov 28 02:03 datapump
drwxrwxr-x 2 3001 101 6144 Jan 29 03:50 RMAN
RDSのディレクトリオブジェクト作成

RDSへRMAN_DIR_EFSというディレクトリオブジェクトを作成します。

ディレクトリオブジェクト作成
SQL> BEGIN
rdsadmin.rdsadmin_util.create_directory_efs(
p_directory_name => 'RMAN_DIR_EFS',
p_path_on_efs => '/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN');
END;
/ 2  3  4  5  6

PL/SQL procedure successfully completed.

SQL> select directory_name, directory_path from dba_directories where directory_name='RMAN_DIR_EFS';

DIRECTORY_NAME               DIRECTORY_PATH
---------------------------- ----------------------------------
RMAN_DIR_EFS                 /rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN
RMANバックアップ実行

RMANバックアップの準備のため、まずは archivelog retention hoursを2時間に設定します。
アーカイブログの保持期間なので、システムによっては長く持った方が良い場合もあるかと思います。

RMANバックアップ準備
SQL> begin
rdsadmin.rdsadmin_util.set_configuration(
name => 'archivelog retention hours',
value => '2');
end;
/ 2  3  4  5  6  

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

準備ができたらRMANバックアップを実行します。

RMANバックアップの実行
SQL> BEGIN
rdsadmin.rdsadmin_rman_util.backup_database_full(
p_owner => 'SYS',
p_directory_name => 'RMAN_DIR_EFS',
p_section_size_mb => 100,
p_tag => 'FULL_DB_BACKUP',
p_rman_to_dbms_output => FALSE);
END;
/ 2  3  4  5  6  7  8  9
RUN_RMAN_CMD: /rdsdbbin/oracle/bin/rman TARGET / LOG /rdsdbdata/log/diag/rdbms/testdb01_a/TESTDB01/trace/rds-rman-backup-database-2023-01-29.13-08-22.579588000.txt @/rdsdbdata/tmp/rds-rman-backup-database-2023-01-29.13-08-22.579588000.input

PL/SQL procedure successfully completed.
RMANバックアップ確認

RMANのバックアップログを確認します。
ログはRUN_RMAN_CMDで出ているログ(rds-rman-backup-database-2023-01-29.13-08-22.579588000.txt)になります。

RMANバックアップログ
RMANバックアップログ
SQL> SELECT text FROM table(rdsadmin.rds_file_util.read_text_file('BDUMP', 'rds-rman-backup-database-2023-01-29.13-08-22.579588000.txt'));

TEXT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
<NULL>
Recovery Manager: Release 19.0.0.0.0 - Production on Sun Jan 29 13:08:24 2023
Version 19.17.0.0.0
<NULL>
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
<NULL>
connected to target database: TESTDB01 (DBID=2985517134)
<NULL>
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
2> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-%F';
3> CONFIGURE BACKUP OPTIMIZATION ON;
4> RUN {
5>   ALLOCATE CHANNEL d1 DEVICE TYPE DISK  FORMAT '/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-%T-%U';
6> CROSSCHECK ARCHIVELOG ALL;
7> BACKUP DATABASE TAG 'FULL_DB_BACKUP' SECTION SIZE 100M;
8>  RELEASE CHANNEL d1;
9> }
10>
using target database control file instead of recovery catalog
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
<NULL>
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-%F';
new RMAN configuration parameters are successfully stored
<NULL>
new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored
<NULL>
allocated channel: d1
channel d1: SID=191 device type=DISK
<NULL>
validation succeeded for archived log
archived log file name=/rdsdbdata/db/TESTDB01_A/arch/redolog-143-1-1120868262.arc RECID=1 STAMP=1127394136
validation succeeded for archived log
archived log file name=/rdsdbdata/db/TESTDB01_A/arch/redolog-144-1-1120868262.arc RECID=2 STAMP=1127394175
validation succeeded for archived log
archived log file name=/rdsdbdata/db/TESTDB01_A/arch/redolog-145-1-1120868262.arc RECID=3 STAMP=1127394478
Crosschecked 3 objects
<NULL>
<NULL>
Starting backup at 2023-01-29 13:08:28
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 1 through 12800
channel d1: starting piece 1 at 2023-01-29 13:08:28
channel d1: finished piece 1 at 2023-01-29 13:08:35
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_1_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 12801 through 25600
channel d1: starting piece 2 at 2023-01-29 13:08:35
channel d1: finished piece 2 at 2023-01-29 13:08:42
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_2_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 25601 through 38400
channel d1: starting piece 3 at 2023-01-29 13:08:42
channel d1: finished piece 3 at 2023-01-29 13:08:49
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_3_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 38401 through 51200
channel d1: starting piece 4 at 2023-01-29 13:08:50
channel d1: finished piece 4 at 2023-01-29 13:08:57
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_4_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 51201 through 64000
channel d1: starting piece 5 at 2023-01-29 13:08:57
channel d1: finished piece 5 at 2023-01-29 13:09:04
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_5_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 64001 through 76800
channel d1: starting piece 6 at 2023-01-29 13:09:04
channel d1: finished piece 6 at 2023-01-29 13:09:11
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_6_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 76801 through 89600
channel d1: starting piece 7 at 2023-01-29 13:09:11
channel d1: finished piece 7 at 2023-01-29 13:09:26
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_7_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:15
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 89601 through 102400
channel d1: starting piece 8 at 2023-01-29 13:09:26
channel d1: finished piece 8 at 2023-01-29 13:09:33
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_8_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 102401 through 115200
channel d1: starting piece 9 at 2023-01-29 13:09:33
channel d1: finished piece 9 at 2023-01-29 13:09:40
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_9_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 115201 through 128000
channel d1: starting piece 10 at 2023-01-29 13:09:41
channel d1: finished piece 10 at 2023-01-29 13:09:48
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_10_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 128001 through 140800
channel d1: starting piece 11 at 2023-01-29 13:09:48
channel d1: finished piece 11 at 2023-01-29 13:09:55
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_11_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 140801 through 153600
channel d1: starting piece 12 at 2023-01-29 13:09:55
channel d1: finished piece 12 at 2023-01-29 13:10:02
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_12_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 153601 through 166400
channel d1: starting piece 13 at 2023-01-29 13:10:02
channel d1: finished piece 13 at 2023-01-29 13:10:09
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_13_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 166401 through 179200
channel d1: starting piece 14 at 2023-01-29 13:10:10
channel d1: finished piece 14 at 2023-01-29 13:10:17
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_14_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 179201 through 192000
channel d1: starting piece 15 at 2023-01-29 13:10:17
channel d1: finished piece 15 at 2023-01-29 13:10:24
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_15_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 192001 through 204800
channel d1: starting piece 16 at 2023-01-29 13:10:24
channel d1: finished piece 16 at 2023-01-29 13:10:31
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_16_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 204801 through 217600
channel d1: starting piece 17 at 2023-01-29 13:10:31
channel d1: finished piece 17 at 2023-01-29 13:10:38
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_17_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 217601 through 230400
channel d1: starting piece 18 at 2023-01-29 13:10:38
channel d1: finished piece 18 at 2023-01-29 13:10:46
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_18_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:08
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 230401 through 243200
channel d1: starting piece 19 at 2023-01-29 13:10:46
channel d1: finished piece 19 at 2023-01-29 13:10:53
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_19_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 243201 through 256000
channel d1: starting piece 20 at 2023-01-29 13:10:53
channel d1: finished piece 20 at 2023-01-29 13:11:00
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_20_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 256001 through 268800
channel d1: starting piece 21 at 2023-01-29 13:11:00
channel d1: finished piece 21 at 2023-01-29 13:11:07
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_21_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 268801 through 281600
channel d1: starting piece 22 at 2023-01-29 13:11:07
channel d1: finished piece 22 at 2023-01-29 13:11:14
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_22_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 281601 through 294400
channel d1: starting piece 23 at 2023-01-29 13:11:14
channel d1: finished piece 23 at 2023-01-29 13:11:21
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_23_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 294401 through 307200
channel d1: starting piece 24 at 2023-01-29 13:11:22
channel d1: finished piece 24 at 2023-01-29 13:11:29
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_24_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 307201 through 320000
channel d1: starting piece 25 at 2023-01-29 13:11:29
channel d1: finished piece 25 at 2023-01-29 13:11:36
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_25_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 320001 through 332800
channel d1: starting piece 26 at 2023-01-29 13:11:36
channel d1: finished piece 26 at 2023-01-29 13:11:51
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_26_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:15
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 332801 through 345600
channel d1: starting piece 27 at 2023-01-29 13:11:51
channel d1: finished piece 27 at 2023-01-29 13:11:58
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_27_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 345601 through 358400
channel d1: starting piece 28 at 2023-01-29 13:11:58
channel d1: finished piece 28 at 2023-01-29 13:12:05
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_28_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 358401 through 371200
channel d1: starting piece 29 at 2023-01-29 13:12:05
channel d1: finished piece 29 at 2023-01-29 13:12:12
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_29_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 371201 through 384000
channel d1: starting piece 30 at 2023-01-29 13:12:13
channel d1: finished piece 30 at 2023-01-29 13:12:20
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_30_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 384001 through 396800
channel d1: starting piece 31 at 2023-01-29 13:12:20
channel d1: finished piece 31 at 2023-01-29 13:12:27
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_31_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 396801 through 409600
channel d1: starting piece 32 at 2023-01-29 13:12:27
channel d1: finished piece 32 at 2023-01-29 13:12:34
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_32_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 409601 through 422400
channel d1: starting piece 33 at 2023-01-29 13:12:34
channel d1: finished piece 33 at 2023-01-29 13:12:41
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_33_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 422401 through 435200
channel d1: starting piece 34 at 2023-01-29 13:12:41
channel d1: finished piece 34 at 2023-01-29 13:12:48
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_34_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 435201 through 448000
channel d1: starting piece 35 at 2023-01-29 13:12:48
channel d1: finished piece 35 at 2023-01-29 13:12:55
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_35_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 448001 through 460800
channel d1: starting piece 36 at 2023-01-29 13:12:55
channel d1: finished piece 36 at 2023-01-29 13:13:02
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_36_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 460801 through 473600
channel d1: starting piece 37 at 2023-01-29 13:13:03
channel d1: finished piece 37 at 2023-01-29 13:13:28
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_37_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:25
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 473601 through 486400
channel d1: starting piece 38 at 2023-01-29 13:13:28
channel d1: finished piece 38 at 2023-01-29 13:13:31
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_38_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:03
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_testtbs_kqsbmxh4_.dbf
backing up blocks 486401 through 499200
channel d1: starting piece 39 at 2023-01-29 13:13:31
channel d1: finished piece 39 at 2023-01-29 13:13:34
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_39_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:03
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00002 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_sysaux_kp6vvcjf_.dbf
backing up blocks 1 through 12800
channel d1: starting piece 1 at 2023-01-29 13:13:34
channel d1: finished piece 1 at 2023-01-29 13:13:41
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-181j5bfu_40_1_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00002 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_sysaux_kp6vvcjf_.dbf
backing up blocks 12801 through 25600
channel d1: starting piece 2 at 2023-01-29 13:13:41
channel d1: finished piece 2 at 2023-01-29 13:13:48
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-181j5bfu_40_2_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00002 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_sysaux_kp6vvcjf_.dbf
backing up blocks 25601 through 38400
channel d1: starting piece 3 at 2023-01-29 13:13:49
channel d1: finished piece 3 at 2023-01-29 13:13:56
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-181j5bfu_40_3_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00002 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_sysaux_kp6vvcjf_.dbf
backing up blocks 38401 through 51200
channel d1: starting piece 4 at 2023-01-29 13:13:56
channel d1: finished piece 4 at 2023-01-29 13:14:03
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-181j5bfu_40_4_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00002 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_sysaux_kp6vvcjf_.dbf
backing up blocks 51201 through 64000
channel d1: starting piece 5 at 2023-01-29 13:14:03
channel d1: finished piece 5 at 2023-01-29 13:14:06
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-181j5bfu_40_5_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:03
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00002 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_sysaux_kp6vvcjf_.dbf
backing up blocks 64001 through 76800
channel d1: starting piece 6 at 2023-01-29 13:14:06
channel d1: finished piece 6 at 2023-01-29 13:14:13
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-181j5bfu_40_6_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00002 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_sysaux_kp6vvcjf_.dbf
backing up blocks 76801 through 89600
channel d1: starting piece 7 at 2023-01-29 13:14:13
channel d1: finished piece 7 at 2023-01-29 13:14:16
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-181j5bfu_40_7_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:03
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00003 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_undo_t1_kp6vvd17_.dbf
backing up blocks 1 through 12800
channel d1: starting piece 1 at 2023-01-29 13:14:17
channel d1: finished piece 1 at 2023-01-29 13:14:20
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-1f1j5bh9_47_1_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:03
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00003 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_undo_t1_kp6vvd17_.dbf
backing up blocks 12801 through 25600
channel d1: starting piece 2 at 2023-01-29 13:14:20
channel d1: finished piece 2 at 2023-01-29 13:14:23
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-1f1j5bh9_47_2_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:03
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00003 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_undo_t1_kp6vvd17_.dbf
backing up blocks 25601 through 38400
channel d1: starting piece 3 at 2023-01-29 13:14:23
channel d1: finished piece 3 at 2023-01-29 13:14:26
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-1f1j5bh9_47_3_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:03
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00003 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_undo_t1_kp6vvd17_.dbf
backing up blocks 38401 through 51200
channel d1: starting piece 4 at 2023-01-29 13:14:26
channel d1: finished piece 4 at 2023-01-29 13:14:29
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-1f1j5bh9_47_4_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:03
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00003 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_undo_t1_kp6vvd17_.dbf
backing up blocks 51201 through 64000
channel d1: starting piece 5 at 2023-01-29 13:14:29
channel d1: finished piece 5 at 2023-01-29 13:14:32
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-1f1j5bh9_47_5_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:03
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00003 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_undo_t1_kp6vvd17_.dbf
backing up blocks 64001 through 76800
channel d1: starting piece 6 at 2023-01-29 13:14:32
channel d1: finished piece 6 at 2023-01-29 13:14:35
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-1f1j5bh9_47_6_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:03
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00003 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_undo_t1_kp6vvd17_.dbf
backing up blocks 76801 through 85760
channel d1: starting piece 7 at 2023-01-29 13:14:35
channel d1: finished piece 7 at 2023-01-29 13:14:38
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-1f1j5bh9_47_7_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:03
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00001 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_system_kp6vv9nv_.dbf
backing up blocks 1 through 12800
channel d1: starting piece 1 at 2023-01-29 13:14:39
channel d1: finished piece 1 at 2023-01-29 13:14:42
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-1m1j5bhv_54_1_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:03
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00001 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_system_kp6vv9nv_.dbf
backing up blocks 12801 through 25600
channel d1: starting piece 2 at 2023-01-29 13:14:42
channel d1: finished piece 2 at 2023-01-29 13:14:45
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-1m1j5bhv_54_2_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:03
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00001 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_system_kp6vv9nv_.dbf
backing up blocks 25601 through 38400
channel d1: starting piece 3 at 2023-01-29 13:14:45
channel d1: finished piece 3 at 2023-01-29 13:14:52
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-1m1j5bhv_54_3_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00001 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_system_kp6vv9nv_.dbf
backing up blocks 38401 through 51200
channel d1: starting piece 4 at 2023-01-29 13:14:52
channel d1: finished piece 4 at 2023-01-29 13:14:59
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-1m1j5bhv_54_4_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00001 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_system_kp6vv9nv_.dbf
backing up blocks 51201 through 64000
channel d1: starting piece 5 at 2023-01-29 13:14:59
channel d1: finished piece 5 at 2023-01-29 13:15:06
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-1m1j5bhv_54_5_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00001 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_system_kp6vv9nv_.dbf
backing up blocks 64001 through 76800
channel d1: starting piece 6 at 2023-01-29 13:15:07
channel d1: finished piece 6 at 2023-01-29 13:15:10
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-1m1j5bhv_54_6_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:03
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00004 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_users_kp6vvd85_.dbf
input datafile file number=00005 name=/rdsdbdata/db/TESTDB01_A/datafile/o1_mf_rdsadmin_kp6wyj8y_.dbf
channel d1: starting piece 1 at 2023-01-29 13:15:10
channel d1: finished piece 1 at 2023-01-29 13:15:17
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-backup-20230129-1s1j5biu_60_1_1 tag=FULL_DB_BACKUP comment=NONE
channel d1: backup set complete, elapsed time: 00:00:07
Finished backup at 2023-01-29 13:15:17
<NULL>
Starting Control File and SPFILE Autobackup at 2023-01-29 13:15:18
piece handle=/rdsefs-fs-xxxxxxxxxxxxxxxxx/RMAN/BACKUP-2023-01-29-13-08-22-c-2985517134-20230129-00 comment=NONE
Finished Control File and SPFILE Autobackup at 2023-01-29 13:15:21
<NULL>
released channel: d1
<NULL>
Recovery Manager complete.

533 rows selected.

EFS上に出力されたバックアップファイルは以下のようになります。
オーナは想定通り 3001:101 で出力されていますね。

EFS上に出力されたバックアップファイル
EFS上のバックアップファイル
$ ll /efs/RMAN
total 4574720
-rw-r----- 1 3001 101 104914944 Jan 29 04:09 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_10_1
-rw-r----- 1 3001 101 104660992 Jan 29 04:08 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_1_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:09 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_11_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:09 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_12_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:10 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_13_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:10 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_14_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:10 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_15_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:10 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_16_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:10 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_17_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:10 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_18_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:10 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_19_1
-rw-r----- 1 3001 101  93831168 Jan 29 04:10 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_20_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:08 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_2_1
-rw-r----- 1 3001 101  54599680 Jan 29 04:11 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_21_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:11 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_22_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:11 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_23_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:11 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_24_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:11 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_25_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:11 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_26_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:11 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_27_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:12 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_28_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:12 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_29_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:12 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_30_1
-rw-r----- 1 3001 101 104792064 Jan 29 04:08 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_3_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:12 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_31_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:12 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_32_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:12 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_33_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:12 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_34_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:12 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_35_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:12 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_36_1
-rw-r----- 1 3001 101  83828736 Jan 29 04:13 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_37_1
-rw-r----- 1 3001 101   9789440 Jan 29 04:13 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_38_1
-rw-r----- 1 3001 101     65536 Jan 29 04:13 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_39_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:08 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_4_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:09 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_5_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:09 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_6_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:09 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_7_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:09 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_8_1
-rw-r----- 1 3001 101 104914944 Jan 29 04:09 BACKUP-2023-01-29-13-08-22-backup-20230129-011j5b6c_1_9_1
-rw-r----- 1 3001 101  69132288 Jan 29 04:13 BACKUP-2023-01-29-13-08-22-backup-20230129-181j5bfu_40_1_1
-rw-r----- 1 3001 101  78471168 Jan 29 04:13 BACKUP-2023-01-29-13-08-22-backup-20230129-181j5bfu_40_2_1
-rw-r----- 1 3001 101  97533952 Jan 29 04:13 BACKUP-2023-01-29-13-08-22-backup-20230129-181j5bfu_40_3_1
-rw-r----- 1 3001 101  96133120 Jan 29 04:13 BACKUP-2023-01-29-13-08-22-backup-20230129-181j5bfu_40_4_1
-rw-r----- 1 3001 101   6701056 Jan 29 04:14 BACKUP-2023-01-29-13-08-22-backup-20230129-181j5bfu_40_5_1
-rw-r----- 1 3001 101  24264704 Jan 29 04:14 BACKUP-2023-01-29-13-08-22-backup-20230129-181j5bfu_40_6_1
-rw-r----- 1 3001 101     65536 Jan 29 04:14 BACKUP-2023-01-29-13-08-22-backup-20230129-181j5bfu_40_7_1
-rw-r----- 1 3001 101   2768896 Jan 29 04:14 BACKUP-2023-01-29-13-08-22-backup-20230129-1f1j5bh9_47_1_1
-rw-r----- 1 3001 101    212992 Jan 29 04:14 BACKUP-2023-01-29-13-08-22-backup-20230129-1f1j5bh9_47_2_1
-rw-r----- 1 3001 101    335872 Jan 29 04:14 BACKUP-2023-01-29-13-08-22-backup-20230129-1f1j5bh9_47_3_1
-rw-r----- 1 3001 101    491520 Jan 29 04:14 BACKUP-2023-01-29-13-08-22-backup-20230129-1f1j5bh9_47_4_1
-rw-r----- 1 3001 101    221184 Jan 29 04:14 BACKUP-2023-01-29-13-08-22-backup-20230129-1f1j5bh9_47_5_1
-rw-r----- 1 3001 101    131072 Jan 29 04:14 BACKUP-2023-01-29-13-08-22-backup-20230129-1f1j5bh9_47_6_1
-rw-r----- 1 3001 101    237568 Jan 29 04:14 BACKUP-2023-01-29-13-08-22-backup-20230129-1f1j5bh9_47_7_1
-rw-r----- 1 3001 101  52969472 Jan 29 04:14 BACKUP-2023-01-29-13-08-22-backup-20230129-1m1j5bhv_54_1_1
-rw-r----- 1 3001 101  75161600 Jan 29 04:14 BACKUP-2023-01-29-13-08-22-backup-20230129-1m1j5bhv_54_2_1
-rw-r----- 1 3001 101 103202816 Jan 29 04:14 BACKUP-2023-01-29-13-08-22-backup-20230129-1m1j5bhv_54_3_1
-rw-r----- 1 3001 101  89251840 Jan 29 04:14 BACKUP-2023-01-29-13-08-22-backup-20230129-1m1j5bhv_54_4_1
-rw-r----- 1 3001 101  98287616 Jan 29 04:15 BACKUP-2023-01-29-13-08-22-backup-20230129-1m1j5bhv_54_5_1
-rw-r----- 1 3001 101  53993472 Jan 29 04:15 BACKUP-2023-01-29-13-08-22-backup-20230129-1m1j5bhv_54_6_1
-rw-r----- 1 3001 101  17121280 Jan 29 04:15 BACKUP-2023-01-29-13-08-22-backup-20230129-1s1j5biu_60_1_1
-rw-r----- 1 3001 101   8978432 Jan 29 04:15 BACKUP-2023-01-29-13-08-22-c-2985517134-20230129-00

まとめ

RDS for OracleのRMANバックアップをEFSに出力してみました。
特にexpdpの出力やファイルの出力と変わったところはありません。
RDS上でのRMANの利用は、実際には Oracle DB インスタンスの一般的な RMAN タスクの実行に 「現時点では、RMAN の復元は Amazon RDS for Oracle の DB インスタンスでサポートされていません。」 とあり、利用用途はかなり限られると思います。（他環境への移行等も通常はexpdp/impdpを利用すると思います）

おまけ

最初にRMANバックアップを取得しようとしたところ、 ORA-20001: Internal error: Database must be in ARCHIVELOG mode for backup related operations. というエラーが出て取得できませんでした。

RMANバックアップ時のエラー
SQL> BEGIN
rdsadmin.rdsadmin_rman_util.backup_database_full(
p_owner => 'SYS',
p_directory_name => 'RMAN_DIR_EFS',
p_section_size_mb => 100,
p_tag => 'FULL_DB_BACKUP',
p_rman_to_dbms_output => FALSE);
END;
/ 2  3  4  5  6  7  8  9
BEGIN
*
ERROR at line 1:
ORA-20001: Internal error: Database must be in ARCHIVELOG mode for backup related operations.
ORA-06512: at "SYS.RDS_SYS_RMAN_UTIL", line 154
ORA-06512: at "SYS.RDS_SYS_RMAN_UTIL", line 1129
ORA-06512: at "SYS.RDS_SYS_RMAN_UTIL", line 1205
ORA-06512: at "RDSADMIN.RDSADMIN_RMAN_UTIL", line 133
ORA-06512: at line 2

RDSの自動バックアップが無効になっていると、noarchivelogモードになっているようです。
自動バックアップを有効にしたところ、無事RMANバックアップが取得できました。

変更前
SQL> select name,log_mode from v$database;

NAME      LOG_MODE
--------- ------------
TESTDB01  NOARCHIVELOG

image.png

変更後
SQL> select name,log_mode from v$database;

NAME      LOG_MODE
--------- ------------
TESTDB01  ARCHIVELOG
3
2
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
3
2

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?