Restore and recover of an oracle database in noarchivelog mode

Here are the steps to restore and recover a lost data file while the database is in noarchivelog mode.

 Assumptions: There is a full backup of the database

-----Shutdown the instance if it is not shutdown and startup in mount state
SQL> conn sys/orcl@to_primary as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount; ----- Starts the background processes, allocates memory and reads controlfiles.
ORACLE instance started.
 Total System Global Area 2499805184 bytes
Fixed Size                  8749920 bytes
Variable Size             687869088 bytes
Database Buffers         1795162112 bytes
Redo Buffers                8024064 bytes
Database mounted.

  -----Restore the entire database; including controlfiles and system/application data files from backup
SQL> $ rman target "'/ as sysbackup '"
 Recovery Manager: Release 12.2.0.1.0 - Production on Sat Feb 12 13:12:57 2022
 Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.
 connected to target database: ORCL (DBID=1623755738, not open)
 RMAN> restore database;
 Starting restore at 12-FEB-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=263 device type=DISK
 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 00001 to D:\APP\ADMIN\VIRTUAL\ORADATA\ORCL\SYSTEM01.DBF
channel ORA_DISK_1: restoring datafile 00003 to D:\APP\ADMIN\VIRTUAL\ORADATA\ORCL\SYSAUX01.DBF
channel ORA_DISK_1: restoring datafile 00005 to D:\APP\ADMIN\VIRTUAL\ORADATA\ORCL\UNDOTBS01.DBF
channel ORA_DISK_1: restoring datafile 00007 to D:\APP\ADMIN\VIRTUAL\ORADATA\ORCL\USERS01.DBF
channel ORA_DISK_1: reading from backup piece D:\APP\ADMIN\VIRTUAL\FAST_RECOVERY_AREA\ORCL\PRIMARY\BACKUPSET\2022_02_07\O1_MF_NNNDF_TAG20220207T223402_K02X1CT0_.BKP
channel ORA_DISK_1: piece handle=D:\APP\ADMIN\VIRTUAL\FAST_RECOVERY_AREA\ORCL\PRIMARY\BACKUPSET\2022_02_07\O1_MF_NNNDF_TAG20220207T223402_K02X1CT0_.BKP tag=TAG20220207T223402
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:26
Finished restore at 12-FEB-22
RMAN>recover database;
 Starting recover at 12-FEB-22
using channel ORA_DISK_1
 starting media recovery
 archived log for thread 1 with sequence 8 is already on disk as file D:\APP\ADMIN\VIRTUAL\FAST_RECOVERY_AREA\ORCL\PRIMARY\ARCHIVELOG\2022_02_09\O1_MF_1_8_K083SYDC_.ARC
archived log for thread 1 with sequence 9 is already on disk as file D:\APP\ADMIN\VIRTUAL\FAST_RECOVERY_AREA\ORCL\PRIMARY\ARCHIVELOG\2022_02_11\O1_MF_1_9_K0DBW8L6_.ARC
archived log for thread 1 with sequence 10 is already on disk as file D:\APP\ADMIN\VIRTUAL\FAST_RECOVERY_AREA\ORCL\PRIMARY\ARCHIVELOG\2022_02_11\O1_MF_1_10_K0F59GT1_.ARC
archived log for thread 1 with sequence 11 is already on disk as file D:\APP\ADMIN\VIRTUAL\FAST_RECOVERY_AREA\ORCL\PRIMARY\ARCHIVELOG\2022_02_11\O1_MF_1_11_K0F63TFT_.ARC
archived log file name=D:\APP\ADMIN\VIRTUAL\FAST_RECOVERY_AREA\ORCL\PRIMARY\ARCHIVELOG\2022_02_09\O1_MF_1_8_K083SYDC_.ARC thread=1 sequence=8
archived log file name=D:\APP\ADMIN\VIRTUAL\FAST_RECOVERY_AREA\ORCL\PRIMARY\ARCHIVELOG\2022_02_11\O1_MF_1_9_K0DBW8L6_.ARC thread=1 sequence=9
media recovery complete, elapsed time: 00:00:32
Finished recover at 12-FEB-22

 -----open the database
RMAN> alter database open; --Starts the background processes, allocates memory, reads controlfiles and opens online redo and data files. 
 Statement processed
 RMAN>
 Finally, users are advised to  re-enter all the changes that were made since the last backup

If your database has an incremental backup strategy , RMAN first restores the most recent level 0 backup and then RMAN recovery applies the incremental backup.

You must restore all data files before executing a recovery operation because  the database is in noarchivelog mode.

N.B: In noarchivelog mode lost data file  recovery is possible only up to the time of the last backup

PC Gaming Headset Headphone Hook Holder Hanger Mount, Headphones Stand with Adjustable & Rotating Arm Clamp, Under Desk Design, Universal Fit, Built in Cable Clip Organizer EURPMASK

(27325)

$12.99 (as of 30/06/2024 15:53 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

🎧【Clamp-on Headphone Stand】The E-Hold Series headphone holder fits desks from 0.31 inch to 1.57 inch thick, making it a versatile choice for most setups. The spring clamp is a breeze to remove and reattach. No glue, no mess. It blends seamlessly into... read more

LLEVTIC Computer Speakers, Desktop Speakers with 6 Colorful RGB Lights, Volume Control PC Speakers, USB Powered Gaming Speakers with 3.5mm Aux Cable for PC Monitor Laptop Tablet Phone

(1250)

44% Off $26.88 $14.99 (as of 30/06/2024 15:56 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

【Full-Range Stereo Sound Quality】Equipped with advanced sound drivers and a full-range 2.0 channel reinforced stereo core, this computer speakers provides the perfect atmosphere for your entertainment activities such as watching movies, gaming, and l... read more

Laptop Cleaning Kit Keyboard Cleaner, Keyboard Cleaning Kit Electronics Cleaning Tool for MacBook iPad Phone iPhone Pro, Brush Tool for Tablet, Computer, PC, TV Camera Lens Computer Vacuum Keyboard

(2045)

$16.98 (as of 30/06/2024 15:53 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

DEEP CLEAN YOUR DEVICE The electronics cleaner kit can effectively deep clean all your electronic devices such as mobile phones, tablets, TVs, etc. It comes with retractable large keyboard brush, polishing cleaning cloth X 2, keycap puller, metal pen... read more

UtechSmart Venus Pro RGB Wireless MMO Gaming Mouse, 16,000 DPI Optical Sensor, 2.4 GHz Transmission Technology, Ergonomic Design, 16M Chroma RGB Lighting, 16 programmable Buttons, Up to 70 Hours

20% Off $59.99 $47.99 (as of 30/06/2024 15:53 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

【Extensive Fully Programmable Buttons】16 customizable buttons can improve your gaming skills and performance by complex custom button macro coding of reconfiguration and assignment. The button custom function combines multiple keys into one button th... read more