Hi All
I am new to Oracle DB administration. Recently I faced an issue with RMAN restore operation. Using RAMN, I took a full back up ,(lets say backup Set1) of my Oracle database which is in NOARCHIVE mode. After a couple of days, I restored the database using the backup I took, so far so good.
Now I again did a full back ( lets say set 2) of the same database without any issue. Again after few days, I had to restore the database using the first full backup (set1) I took. however this time the restore operation failed with the following error msg. Any suggestion, if I am doing anything wrong here ? Thanks in Advance.
RMAN> restore database from tag='TAG20160801T141038';
Starting restore at 16-AUG-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=28 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/16/2016 10:25:10
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 23 found to restore