[orcl:~]$ rman target / nocatalog
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Oct 4 16:59:48 2023
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1324638472, not open)
using target database control file instead of recovery catalog
RMAN> list failure;
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
562 HIGH OPEN 04-OCT-23 One or more non-system datafiles are missing
RMAN> advise failure;
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
562 HIGH OPEN 04-OCT-23 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=14 device type=DISK
analyzing automatic repair options complete
Mandatory Manual Actions
========================
no manual actions available
Optional Manual Actions
=======================
1. If file +DATA/orcl/datafile/undotbs1.258.796857625 was unintentionally renamed or moved, restore it
2. If file +DATA/orcl/datafile/users.259.796857625 was unintentionally renamed or moved, restore it
3. If file +DATA/orcl/datafile/example.265.796857803 was unintentionally renamed or moved, restore it
Automated Repair Options
========================
Option Repair Description
------ ------------------
1 Restore and recover datafile 3; Restore and recover datafile 4; Restore and recover datafile 5
Strategy: The repair includes complete media recovery with no data loss
Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_1942910270.hm
RMAN> repair failure;
Strategy: The repair includes complete media recovery with no data loss
Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_1942910270.hm
contents of repair script:
# restore and recover datafile
restore datafile 3, 4, 5;
recover datafile 3, 4, 5;
Do you really want to execute the above repair (enter YES or NO)? yes
executing repair script
Starting restore at 04-OCT-23
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to +DATA/orcl/datafile/undotbs1.258.796857625
channel ORA_DISK_1: restoring datafile 00004 to +DATA/orcl/datafile/users.259.796857625
channel ORA_DISK_1: restoring datafile 00005 to +DATA/orcl/datafile/example.265.796857803
channel ORA_DISK_1: reading from backup piece /home/oracle/arch/ORCL/backupset/2023_10_04/o1_mf_nnndf_TAG20231004T161949_lkt4m668_.bkp
channel ORA_DISK_1: piece handle=/home/oracle/arch/ORCL/backupset/2023_10_04/o1_mf_nnndf_TAG20231004T161949_lkt4m668_.bkp tag=TAG20231004T161949
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 04-OCT-23
Starting recover at 04-OCT-23
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 04-OCT-23
repair failure complete
Do you want to open the database (enter YES or NO)? yes
database opened