My database is in noarchivelog mode and I took last full backup on Friday and no incremental backup exist.
I am trying to restore my database using below concept
1.
run
{
restore database;
recover database:
}
2.
restore database from tag 'AFTRBANNER8_4';
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 6773333 generated at 08/24/2018 12:26:31 needed for thread 1
ORA-00289: suggestion :
/u01/app/oracle/fast_recovery_area/SEED/archivelog/2018_08_27/o1_mf_1_439_%u_.a
3.
run
{
set until time="to_date('24082018 14:30:00','ddmmyyyy hh24:mi:ss')";
restore database;
recover database;
}
4.
run
{
restore database from tag 'AFTRBANNER8_4';
recover database;
RMAN-08187: WARNING: media recovery until SCN 6773333 complete
}
While open database with resetlogs I got error with all concept alter database open resetlogs
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u02/oradata/SEED/datafile/o1_mf_system_fr7t80lv_.dbf'