Here we will simulate recovery scenario of database.First we will create crash situation and then we will try to recover from that.
Check backup is available for your database
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2 Full 17.94M DISK 00:00:02 2019-02-10:10:29:16
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20190210T102914
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/autobackup/2019_02_10/o1_mf_s_999858554_g5zcx47j_.bkp
SPFILE Included: Modification time: 2019-02-10:10:27:33
SPFILE db_unique_name: ORCL1
Control File Included: Ckp SCN: 1547969 Ckp time: 2019-02-10:10:29:14
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
3 Full 17.94M DISK 00:00:17 2019-02-10:22:10:11
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20190210T220953
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/autobackup/2019_02_10/o1_mf_s_999900594_g60nzcsd_.bkp
SPFILE Included: Modification time: 2019-02-10:22:04:19
SPFILE db_unique_name: ORCL1
Control File Included: Ckp SCN: 1698850 Ckp time: 2019-02-10:22:09:54
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
4 Full 17.94M DISK 00:00:01 2019-02-10:23:35:21
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20190210T233519
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/autobackup/2019_02_10/o1_mf_s_999905720_g60sz1lg_.bkp
SPFILE Included: Modification time: 2019-02-10:23:31:54
SPFILE db_unique_name: ORCL1
Control File Included: Ckp SCN: 1717829 Ckp time: 2019-02-10:23:35:20
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
15 Full 17.94M DISK 00:00:00 2019-05-09:21:28:54
BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20190509T212854
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/autobackup/2019_05_09/o1_mf_s_1007846934_gf8mkyho_.bkp
SPFILE Included: Modification time: 2019-05-09:21:23:08
SPFILE db_unique_name: ORCL1
Control File Included: Ckp SCN: 1968008 Ckp time: 2019-05-09:21:28:54
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
16 Full 1.04G DISK 00:00:41 2019-05-09:21:40:25
BP Key: 16 Status: AVAILABLE Compressed: NO Tag: TAG20190509T213944
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/backupset/2019_05_09/o1_mf_nnndf_TAG20190509T213944_gf8n68hq_.bkp
List of Datafiles in backup set 16
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
1 Full 1968434 2019-05-09:21:39:44 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_system_g56bzr71_.dbf
3 Full 1968434 2019-05-09:21:39:44 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_sysaux_g56c4gwz_.dbf
4 Full 1968434 2019-05-09:21:39:44 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_undotbs1_g56c8082_.dbf
7 Full 1968434 2019-05-09:21:39:44 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_users_g56c8cf3_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
17 Full 557.34M DISK 00:00:32 2019-05-09:21:41:01
BP Key: 17 Status: AVAILABLE Compressed: NO Tag: TAG20190509T213944
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/80C5B383246F06B2E0531201A8C09E95/backupset/2019_05_09/o1_mf_nnndf_TAG20190509T213944_gf8n7p03_.bkp
List of Datafiles in backup set 17
Container ID: 3, PDB Name: JIGI
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
9 Full 1968502 2019-05-09:21:40:29 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_system_g56fjomp_.dbf
10 Full 1968502 2019-05-09:21:40:29 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_sysaux_g56fjoqy_.dbf
11 Full 1968502 2019-05-09:21:40:29 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_undotbs1_g56fjoqz_.dbf
12 Full 1968502 2019-05-09:21:40:29 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_users_g56fmk1x_.dbf
19 Full 1968502 2019-05-09:21:40:29 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsa_g60sbrnw_.dbf
20 Full 1968502 2019-05-09:21:40:29 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsb_g60scc47_.dbf
21 Full 1968502 2019-05-09:21:40:29 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsc_g60scts8_.dbf
22 Full 1968502 2019-05-09:21:40:29 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsd_g60sdjw8_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
18 Full 543.82M DISK 00:00:26 2019-05-09:21:41:31
BP Key: 18 Status: AVAILABLE Compressed: NO Tag: TAG20190509T213944
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/8183F1693BDD1468E0531201A8C02271/backupset/2019_05_09/o1_mf_nnndf_TAG20190509T213944_gf8n8skb_.bkp
List of Datafiles in backup set 18
Container ID: 4, PDB Name: TEST
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
13 Full 1968525 2019-05-09:21:41:05 NO /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_system_g5zcg9hv_.dbf
14 Full 1968525 2019-05-09:21:41:05 NO /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_sysaux_g5zcg9k5_.dbf
15 Full 1968525 2019-05-09:21:41:05 NO /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_undotbs1_g5zcg9k7_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
19 Full 498.41M DISK 00:00:21 2019-05-09:21:42:01
BP Key: 19 Status: AVAILABLE Compressed: NO Tag: TAG20190509T213944
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/80C541CF0FA65E3FE0531201A8C06FB0/backupset/2019_05_09/o1_mf_nnndf_TAG20190509T213944_gf8n9wrg_.bkp
List of Datafiles in backup set 19
Container ID: 2, PDB Name: PDB$SEED
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
5 Full 1441388 2019-01-31:23:20:14 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_system_g56ch5lh_.dbf
6 Full 1441388 2019-01-31:23:20:14 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_sysaux_g56ch5h5_.dbf
8 Full 1441388 2019-01-31:23:20:14 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_undotbs1_g56ch5o2_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
20 Full 498.41M DISK 00:00:24 2019-05-09:21:42:30
BP Key: 20 Status: AVAILABLE Compressed: NO Tag: TAG20190509T213944
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/818DC149F5282394E0531201A8C0C446/backupset/2019_05_09/o1_mf_nnndf_TAG20190509T213944_gf8nbp70_.bkp
List of Datafiles in backup set 20
Container ID: 5, PDB Name: APP_PDB
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
16 Full 1698582 2019-02-10:22:04:20 NO /u01/app/oracle/oradata/ORCL1/818DC149F5282394E0531201A8C0C446/datafile/o1_mf_system_g60nm8qh_.dbf
17 Full 1698582 2019-02-10:22:04:20 NO /u01/app/oracle/oradata/ORCL1/818DC149F5282394E0531201A8C0C446/datafile/o1_mf_sysaux_g60nm8r7_.dbf
18 Full 1698582 2019-02-10:22:04:20 NO /u01/app/oracle/oradata/ORCL1/818DC149F5282394E0531201A8C0C446/datafile/o1_mf_undotbs1_g60nm8r8_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
21 Full 17.94M DISK 00:00:00 2019-05-09:21:42:31
BP Key: 21 Status: AVAILABLE Compressed: NO Tag: TAG20190509T214231
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/autobackup/2019_05_09/o1_mf_s_1007847751_gf8nchvk_.bkp
SPFILE Included: Modification time: 2019-05-09:21:23:08
SPFILE db_unique_name: ORCL1
Control File Included: Ckp SCN: 1968730 Ckp time: 2019-05-09:21:42:31
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
22 Full 17.94M DISK 00:00:00 2019-05-09:22:00:49
BP Key: 22 Status: AVAILABLE Compressed: NO Tag: TAG20190509T220049
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/autobackup/2019_05_09/o1_mf_s_1007848849_gf8ofshd_.bkp
SPFILE Included: Modification time: 2019-05-09:22:00:44
SPFILE db_unique_name: ORCL1
Control File Included: Ckp SCN: 1970924 Ckp time: 2019-05-09:22:00:49
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
23 Incr 1 30.84M DISK 00:00:38 2019-05-09:22:04:06
BP Key: 23 Status: AVAILABLE Compressed: NO Tag: OH_BKP
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/backupset/2019_05_09/o1_mf_nnnd1_OH_BKP_gf8olvj9_.bkp
List of Datafiles in backup set 23
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
1 1 Incr 1980987 2019-05-09:22:03:28 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_system_g56bzr71_.dbf
3 1 Incr 1980987 2019-05-09:22:03:28 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_sysaux_g56c4gwz_.dbf
4 1 Incr 1980987 2019-05-09:22:03:28 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_undotbs1_g56c8082_.dbf
7 1 Incr 1980987 2019-05-09:22:03:28 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_users_g56c8cf3_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
24 Incr 1 2.31M DISK 00:00:31 2019-05-09:22:04:46
BP Key: 24 Status: AVAILABLE Compressed: NO Tag: OH_BKP
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/80C5B383246F06B2E0531201A8C09E95/backupset/2019_05_09/o1_mf_nnnd1_OH_BKP_gf8on7rs_.bkp
List of Datafiles in backup set 24
Container ID: 3, PDB Name: JIGI
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
9 1 Incr 1983045 2019-05-09:22:04:15 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_system_g56fjomp_.dbf
10 1 Incr 1983045 2019-05-09:22:04:15 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_sysaux_g56fjoqy_.dbf
11 1 Incr 1983045 2019-05-09:22:04:15 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_undotbs1_g56fjoqz_.dbf
12 1 Incr 1983045 2019-05-09:22:04:15 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_users_g56fmk1x_.dbf
19 1 Incr 1983045 2019-05-09:22:04:15 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsa_g60sbrnw_.dbf
20 1 Incr 1983045 2019-05-09:22:04:15 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsb_g60scc47_.dbf
21 1 Incr 1983045 2019-05-09:22:04:15 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsc_g60scts8_.dbf
22 1 Incr 1983045 2019-05-09:22:04:15 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsd_g60sdjw8_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
25 Incr 1 232.00K DISK 00:00:26 2019-05-09:22:05:16
BP Key: 25 Status: AVAILABLE Compressed: NO Tag: OH_BKP
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/8183F1693BDD1468E0531201A8C02271/backupset/2019_05_09/o1_mf_nnnd1_OH_BKP_gf8oocqp_.bkp
List of Datafiles in backup set 25
Container ID: 4, PDB Name: TEST
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
13 1 Incr 1984938 2019-05-09:22:04:51 NO /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_system_g5zcg9hv_.dbf
14 1 Incr 1984938 2019-05-09:22:04:51 NO /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_sysaux_g5zcg9k5_.dbf
15 1 Incr 1984938 2019-05-09:22:04:51 NO /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_undotbs1_g5zcg9k7_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
26 Full 17.94M DISK 00:00:01 2019-05-09:22:05:34
BP Key: 26 Status: AVAILABLE Compressed: NO Tag: TAG20190509T220533
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/autobackup/2019_05_09/o1_mf_s_1007849133_gf8opp2j_.bkp
SPFILE Included: Modification time: 2019-05-09:22:00:44
SPFILE db_unique_name: ORCL1
Control File Included: Ckp SCN: 1987276 Ckp time: 2019-05-09:22:05:33
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
27 Incr 1 29.03M DISK 00:00:36 2019-05-09:22:08:12
BP Key: 27 Status: AVAILABLE Compressed: NO Tag: OH_BKP
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/backupset/2019_05_09/o1_mf_nnnd1_OH_BKP_gf8otlym_.bkp
List of Datafiles in backup set 27
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
1 1 Incr 1993233 2019-05-09:22:07:37 1993378 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_system_g56bzr71_.dbf
3 1 Incr 1993233 2019-05-09:22:07:37 1993610 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_sysaux_g56c4gwz_.dbf
4 1 Incr 1993233 2019-05-09:22:07:37 1993280 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_undotbs1_g56c8082_.dbf
7 1 Incr 1993233 2019-05-09:22:07:37 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_users_g56c8cf3_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
28 Incr 1 96.00K DISK 00:00:23 2019-05-09:22:08:45
BP Key: 28 Status: AVAILABLE Compressed: NO Tag: OH_BKP
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/80C5B383246F06B2E0531201A8C09E95/backupset/2019_05_09/o1_mf_nnnd1_OH_BKP_gf8ovyqm_.bkp
List of Datafiles in backup set 28
Container ID: 3, PDB Name: JIGI
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
9 1 Incr 1993640 2019-05-09:22:08:22 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_system_g56fjomp_.dbf
10 1 Incr 1993640 2019-05-09:22:08:22 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_sysaux_g56fjoqy_.dbf
11 1 Incr 1993640 2019-05-09:22:08:22 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_undotbs1_g56fjoqz_.dbf
12 1 Incr 1993640 2019-05-09:22:08:22 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_users_g56fmk1x_.dbf
19 1 Incr 1993640 2019-05-09:22:08:22 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsa_g60sbrnw_.dbf
20 1 Incr 1993640 2019-05-09:22:08:22 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsb_g60scc47_.dbf
21 1 Incr 1993640 2019-05-09:22:08:22 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsc_g60scts8_.dbf
22 1 Incr 1993640 2019-05-09:22:08:22 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsd_g60sdjw8_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
29 Incr 1 56.00K DISK 00:00:16 2019-05-09:22:09:04
BP Key: 29 Status: AVAILABLE Compressed: NO Tag: OH_BKP
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/8183F1693BDD1468E0531201A8C02271/backupset/2019_05_09/o1_mf_nnnd1_OH_BKP_gf8owrjq_.bkp
List of Datafiles in backup set 29
Container ID: 4, PDB Name: TEST
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
13 1 Incr 1993653 2019-05-09:22:08:48 NO /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_system_g5zcg9hv_.dbf
14 1 Incr 1993653 2019-05-09:22:08:48 NO /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_sysaux_g5zcg9k5_.dbf
15 1 Incr 1993653 2019-05-09:22:08:48 NO /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_undotbs1_g5zcg9k7_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
30 Full 17.94M DISK 00:00:02 2019-05-09:22:09:16
BP Key: 30 Status: AVAILABLE Compressed: NO Tag: TAG20190509T220914
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/autobackup/2019_05_09/o1_mf_s_1007849354_gf8oxmv0_.bkp
SPFILE Included: Modification time: 2019-05-09:22:07:23
SPFILE db_unique_name: ORCL1
Control File Included: Ckp SCN: 1993675 Ckp time: 2019-05-09:22:09:14
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
31 Incr 1 4.74M DISK 00:00:32 2019-05-09:22:10:38
BP Key: 31 Status: AVAILABLE Compressed: NO Tag: OH_BKP
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/backupset/2019_05_09/o1_mf_nnnd1_OH_BKP_gf8oz761_.bkp
List of Datafiles in backup set 31
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
1 1 Incr 1993773 2019-05-09:22:10:06 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_system_g56bzr71_.dbf
3 1 Incr 1993773 2019-05-09:22:10:06 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_sysaux_g56c4gwz_.dbf
4 1 Incr 1993773 2019-05-09:22:10:06 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_undotbs1_g56c8082_.dbf
7 1 Incr 1993773 2019-05-09:22:10:06 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_users_g56c8cf3_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
32 Incr 1 96.00K DISK 00:00:24 2019-05-09:22:11:06
BP Key: 32 Status: AVAILABLE Compressed: NO Tag: OH_BKP
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/80C5B383246F06B2E0531201A8C09E95/backupset/2019_05_09/o1_mf_nnnd1_OH_BKP_gf8p0bld_.bkp
List of Datafiles in backup set 32
Container ID: 3, PDB Name: JIGI
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
9 1 Incr 1993796 2019-05-09:22:10:42 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_system_g56fjomp_.dbf
10 1 Incr 1993796 2019-05-09:22:10:42 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_sysaux_g56fjoqy_.dbf
11 1 Incr 1993796 2019-05-09:22:10:42 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_undotbs1_g56fjoqz_.dbf
12 1 Incr 1993796 2019-05-09:22:10:42 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_users_g56fmk1x_.dbf
19 1 Incr 1993796 2019-05-09:22:10:42 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsa_g60sbrnw_.dbf
20 1 Incr 1993796 2019-05-09:22:10:42 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsb_g60scc47_.dbf
21 1 Incr 1993796 2019-05-09:22:10:42 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsc_g60scts8_.dbf
22 1 Incr 1993796 2019-05-09:22:10:42 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsd_g60sdjw8_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
33 Incr 1 56.00K DISK 00:00:17 2019-05-09:22:11:24
BP Key: 33 Status: AVAILABLE Compressed: NO Tag: OH_BKP
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/8183F1693BDD1468E0531201A8C02271/backupset/2019_05_09/o1_mf_nnnd1_OH_BKP_gf8p147g_.bkp
List of Datafiles in backup set 33
Container ID: 4, PDB Name: TEST
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
13 1 Incr 1993816 2019-05-09:22:11:07 NO /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_system_g5zcg9hv_.dbf
14 1 Incr 1993816 2019-05-09:22:11:07 NO /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_sysaux_g5zcg9k5_.dbf
15 1 Incr 1993816 2019-05-09:22:11:07 NO /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_undotbs1_g5zcg9k7_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
34 Full 17.94M DISK 00:00:01 2019-05-09:22:11:34
BP Key: 34 Status: AVAILABLE Compressed: NO Tag: TAG20190509T221133
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/autobackup/2019_05_09/o1_mf_s_1007849493_gf8p1y8x_.bkp
SPFILE Included: Modification time: 2019-05-09:22:11:29
SPFILE db_unique_name: ORCL1
Control File Included: Ckp SCN: 1993833 Ckp time: 2019-05-09:22:11:33
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
35 Incr 1 52.66M DISK 00:00:43 2019-05-22:23:57:15
BP Key: 35 Status: AVAILABLE Compressed: NO Tag: %TAG
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/backupset/2019_05_22/o1_mf_nnnd1__TAG_ggc52s3s_.bkp
List of Datafiles in backup set 35
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
1 1 Incr 2319406 2019-05-22:23:56:32 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_system_g56bzr71_.dbf
3 1 Incr 2319406 2019-05-22:23:56:32 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_sysaux_g56c4gwz_.dbf
4 1 Incr 2319406 2019-05-22:23:56:32 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_undotbs1_g56c8082_.dbf
7 1 Incr 2319406 2019-05-22:23:56:32 NO /u01/app/oracle/oradata/ORCL1/datafile/o1_mf_users_g56c8cf3_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
36 Incr 1 1.98M DISK 00:00:23 2019-05-22:23:57:41
BP Key: 36 Status: AVAILABLE Compressed: NO Tag: %TAG
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/80C5B383246F06B2E0531201A8C09E95/backupset/2019_05_22/o1_mf_nnnd1__TAG_ggc547cn_.bkp
List of Datafiles in backup set 36
Container ID: 3, PDB Name: JIGI
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
9 1 Incr 2319431 2019-05-22:23:57:19 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_system_g56fjomp_.dbf
10 1 Incr 2319431 2019-05-22:23:57:19 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_sysaux_g56fjoqy_.dbf
11 1 Incr 2319431 2019-05-22:23:57:19 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_undotbs1_g56fjoqz_.dbf
12 1 Incr 2319431 2019-05-22:23:57:19 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_users_g56fmk1x_.dbf
19 1 Incr 2319431 2019-05-22:23:57:19 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsa_g60sbrnw_.dbf
20 1 Incr 2319431 2019-05-22:23:57:19 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsb_g60scc47_.dbf
21 1 Incr 2319431 2019-05-22:23:57:19 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsc_g60scts8_.dbf
22 1 Incr 2319431 2019-05-22:23:57:19 NO /u01/app/oracle/oradata/ORCL1/80C5B383246F06B2E0531201A8C09E95/datafile/o1_mf_tsd_g60sdjw8_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
37 Incr 1 1.46M DISK 00:00:20 2019-05-22:23:58:04
BP Key: 37 Status: AVAILABLE Compressed: NO Tag: %TAG
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/8183F1693BDD1468E0531201A8C02271/backupset/2019_05_22/o1_mf_nnnd1__TAG_ggc550yj_.bkp
List of Datafiles in backup set 37
Container ID: 4, PDB Name: TEST
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
13 1 Incr 2319492 2019-05-22:23:57:44 NO /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_system_g5zcg9hv_.dbf
14 1 Incr 2319492 2019-05-22:23:57:44 NO /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_sysaux_g5zcg9k5_.dbf
15 1 Incr 2319492 2019-05-22:23:57:44 NO /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_undotbs1_g5zcg9k7_.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
38 Full 17.94M DISK 00:00:03 2019-05-22:23:58:17
BP Key: 38 Status: AVAILABLE Compressed: NO Tag: TAG20190522T235814
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/autobackup/2019_05_22/o1_mf_s_1008979094_ggc560xf_.bkp
SPFILE Included: Modification time: 2019-05-22:23:24:54
SPFILE db_unique_name: ORCL1
Control File Included: Ckp SCN: 2319518 Ckp time: 2019-05-22:23:58:14
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
39 172.09M DISK 00:00:09 2019-05-22:23:58:39
BP Key: 39 Status: AVAILABLE Compressed: NO Tag: %TAG
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/backupset/2019_05_22/o1_mf_annnn__TAG_ggc56grn_.bkp
List of Archived Logs in backup set 39
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 8 1962846 2019-05-09:21:00:08 2096592 2019-05-20:23:20:23
1 9 2096592 2019-05-20:23:20:23 2202176 2019-05-22:19:37:57
1 10 2202176 2019-05-22:19:37:57 2308913 2019-05-22:23:17:14
1 11 2308913 2019-05-22:23:17:14 2319540 2019-05-22:23:58:26
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
40 Full 17.94M DISK 00:00:01 2019-05-22:23:58:48
BP Key: 40 Status: AVAILABLE Compressed: NO Tag: TAG20190522T235847
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/autobackup/2019_05_22/o1_mf_s_1008979127_ggc57048_.bkp
SPFILE Included: Modification time: 2019-05-22:23:24:54
SPFILE db_unique_name: ORCL1
Control File Included: Ckp SCN: 2319559 Ckp time: 2019-05-22:23:58:47
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
41 Full 17.91M DISK 00:00:02 2019-05-22:23:58:58
BP Key: 41 Status: AVAILABLE Compressed: NO Tag: %TAG
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/backupset/2019_05_22/o1_mf_ncnnf__TAG_ggc579rx_.bkp
Control File Included: Ckp SCN: 2319595 Ckp time: 2019-05-22:23:58:56
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
42 Full 17.94M DISK 00:00:01 2019-05-22:23:59:00
BP Key: 42 Status: AVAILABLE Compressed: NO Tag: TAG20190522T235859
Piece Name: /u01/app/oracle/fast_recovery_area/orcl1/ORCL1/autobackup/2019_05_22/o1_mf_s_1008979139_ggc57dov_.bkp
SPFILE Included: Modification time: 2019-05-22:23:58:48
SPFILE db_unique_name: ORCL1
Control File Included: Ckp SCN: 2319601 Ckp time: 2019-05-22:23:58:59
Now connect your pluggable database
SQL> alter session set container=TEST;
Session altered.Create one tablespace in pluggable database .
SQL> CREATE TABLESPACE TEST;
Tablespace created.Create one user and grant quota on this tablespace to that user.
SQL> create user test identified by oracle default tablespace test quota unlimited on test;
User created.
SQL> grant create session to test;
Grant succeeded.Now lets create a table which will be stored to TEST tablespace.
SQL> create table test.tst(no number,name varchar2(100), city varchar2(50)) tablespace test;
Table created.
SQL> insert into test.tst values(1,'jagruti','palanpur');
1 row created.
SQL> COMMIT;
Commit complete.
SQL> insert into test.tst select * from test.tst;
1 row created.
SQL> COMMIT;
Commit complete.
SQL> insert into test.tst select * from test.tst;
2 rows created.
SQL> /
4 rows created.
SQL> /
8 rows created.
SQL> COMMIT;
Commit complete.
SQL> Now lets check data of this table by connecting to TEST user
SQL> conn test/oracle@test
Connected.
SQL> select count(*) from tst;
COUNT(*)
----------
16
SQL> Connect database in root container and shutdown it using abort option
[oracle@prod-18c ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun May 26 22:36:04 2019
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> shut abort
ORACLE instance shut down.
SQL> Move to the datafile physically
[oracle@prod-18c datafile]$ cd
[oracle@prod-18c ~]$ cd /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile
[oracle@prod-18c datafile]$ ll
total 841684
-rw-r----- 1 oracle oinstall 377495552 May 26 22:34 o1_mf_sysaux_g5zcg9k5_.dbf
-rw-r----- 1 oracle oinstall 272637952 May 26 22:34 o1_mf_system_g5zcg9hv_.dbf
-rw-r----- 1 oracle oinstall 67117056 May 26 22:18 o1_mf_temp_g5zcg9k7_.dbf
-rw-r----- 1 oracle oinstall 104865792 May 26 22:34 o1_mf_test_ggokd0rh_.dbf
-rw-r----- 1 oracle oinstall 104865792 May 26 22:34 o1_mf_undotbs1_g5zcg9k7_.dbf
[oracle@prod-18c datafile]$ mv o1_mf_test_ggokd0rh_.dbf /u01/app/oracle/
[oracle@prod-18c datafile]$Lets start database now.
[oracle@prod-18c ~]$ export ORACLE_SID=orcl1
[oracle@prod-18c ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun May 26 22:42:41 2019
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 851443712 bytes
Fixed Size 8798456 bytes
Variable Size 327159560 bytes
Database Buffers 511705088 bytes
Redo Buffers 3780608 bytes
Database mounted.
Database opened.
SQL>We can see CDB$ROOT database is opened successfully. Lets check alert log of database.
[oracle@prod-18c datafile]$ tail -20f /u01/app/oracle/diag/rdbms/orcl1/orcl1/trace/alert_orcl1.log
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2019-05-26T22:43:27.644080+05:30
Errors in file /u01/app/oracle/diag/rdbms/orcl1/orcl1/trace/orcl1_dbw0_1593.trc:
ORA-01186: file 23 failed verification tests
ORA-01157: cannot identify/lock data file 23 - see DBWR trace file
ORA-01110: data file 23: '/u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_test_ggokd0rh_.dbf'
2019-05-26T22:43:27.644165+05:30
File 23 not verified due to error ORA-01157
2019-05-26T22:43:30.173831+05:30
db_recovery_file_dest_size of 12780 MB is 47.01% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
2019-05-26T22:43:35.516438+05:30
Setting Resource Manager plan SCHEDULER[0x4AC9]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager CDB plan DEFAULT_MAINTENANCE_PLAN via parameterWe can see alert log shows error occurred while opening pluggable database. Now lets start TEST pdb.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 JIGI READ WRITE NO
4 TEST MOUNTED
5 APP_PDB MOUNTED
SQL> ALTER PLUGGABLE DATABASE TEST OPEN;
ALTER PLUGGABLE DATABASE TEST OPEN
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 23 - see DBWR trace file
ORA-01110: data file 23:
'/u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_t
est_ggokd0rh_.dbf'
SQL> Lets take help of RMAN. Check failure using list failure command .
RMAN> LIST FAILURE;
using target database control file instead of recovery catalog
Database Role: PRIMARY
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------------- -------
1762 CRITICAL OPEN 2019-05-26:22:47:31 System datafile 13: '/u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_system_g5zcg9hv_.dbf' needs media recovery
1765 HIGH OPEN 2019-05-26:22:47:31 One or more non-system datafiles need media recovery
1742 HIGH OPEN 2019-05-26:22:42:55 One or more non-system datafiles are missing
RMAN>It is showing us that TEST pdb’s system datafile needs recovery and it is in critical stage.
Lets check what solution is available in RMAN using advise failure command .
RMAN> ADVISE FAILURE;
Database Role: PRIMARY
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------------- -------
1762 CRITICAL OPEN 2019-05-26:22:47:31 System datafile 13: '/u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_system_g5zcg9hv_.dbf' needs media recovery
1765 HIGH OPEN 2019-05-26:22:47:31 One or more non-system datafiles need media recovery
1742 HIGH OPEN 2019-05-26:22:42:55 One or more non-system datafiles are missing
analyzing automatic repair options; this may take some time
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=69 device type=DISK
analyzing automatic repair options complete
Mandatory Manual Actions
========================
no manual actions available
Optional Manual Actions
=======================
1. If you restored the wrong version of data file /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_system_g5zcg9hv_.dbf, then replace it with the correct one
2. Automatic repairs may be available if you shutdown the database and restart it in mount mode
3. If you restored the wrong version of data file /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_sysaux_g5zcg9k5_.dbf, then replace it with the correct one
4. If you restored the wrong version of data file /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_undotbs1_g5zcg9k7_.dbf, then replace it with the correct one
5. If file /u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_test_ggokd0rh_.dbf was unintentionally renamed or moved, restore it
Automated Repair Options
========================
Option Repair Description
------ ------------------
1 Restore and recover datafile 23; Recover datafile 13; Recover datafile 14; ...
Strategy: The repair includes complete media recovery with no data loss
Repair script: /u01/app/oracle/diag/rdbms/orcl1/orcl1/hm/reco_3451212.hm
RMAN> Lets check preview of repair failure , which will just give us commands and not perform actual recovery.
RMAN> repair failure preview;
Strategy: The repair includes complete media recovery with no data loss
Repair script: /u01/app/oracle/diag/rdbms/orcl1/orcl1/hm/reco_3451212.hm
contents of repair script:
# restore and recover datafile
sql 'TEST' 'alter database datafile 23 offline';
restore ( datafile 23 );
recover datafile 23;
sql 'TEST' 'alter database datafile 23 online';
# recover datafile
sql 'TEST' 'alter database datafile 13, 14, 15 offline';
recover datafile 13, 14, 15;
sql 'TEST' 'alter database datafile 13, 14, 15 online';
RMAN> Lets perform recovery.
RMAN> repair failure;
Strategy: The repair includes complete media recovery with no data loss
Repair script: /u01/app/oracle/diag/rdbms/orcl1/orcl1/hm/reco_3451212.hm
contents of repair script:
# restore and recover datafile
sql 'TEST' 'alter database datafile 23 offline';
restore ( datafile 23 );
recover datafile 23;
sql 'TEST' 'alter database datafile 23 online';
# recover datafile
sql 'TEST' 'alter database datafile 13, 14, 15 offline';
recover datafile 13, 14, 15;
sql 'TEST' 'alter database datafile 13, 14, 15 online';
Do you really want to execute the above repair (enter YES or NO)? YES
executing repair script
sql statement: alter database datafile 23 offline
Starting restore at 2019-05-26:22:54:28
using channel ORA_DISK_1
creating datafile file number=23 name=/u01/app/oracle/oradata/ORCL1/8183F1693BDD1468E0531201A8C02271/datafile/o1_mf_test_ggokd0rh_.dbf
restore not done; all files read only, offline, excluded, or already restored
Finished restore at 2019-05-26:22:54:30
Starting recover at 2019-05-26:22:54:30
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:01
Finished recover at 2019-05-26:22:54:31
sql statement: alter database datafile 23 online
sql statement: alter database datafile 13, 14, 15 offline
Starting recover at 2019-05-26:22:54:31
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:01
Finished recover at 2019-05-26:22:54:33
sql statement: alter database datafile 13, 14, 15 online
repair failure complete
RMAN> Lets again check list failure to crosscheck if any failure still exist
RMAN> list failure;
Database Role: PRIMARY
no failures found that match specification
RMAN>Let us open TEST pdb now.
SQL> ALTER PLUGGABLE DATABASE TEST OPEN;
Pluggable database altered.
SQL> We can see here after RMAN’s repair failure the pdb is open now.
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Telegram Channel: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
