ORA-01152: file 1 was not restored from a sufficiently old backup
starting media recovery
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/oracledb/oradata/stlbas/system01.dbf'
RMAN> list backup of archivelog all;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6867 2.88G DISK 00:00:34 01-FEB-15
BP Key: 6962 Status: AVAILABLE Compressed: NO Tag: TAG20150201T012203
Piece Name: /back/rman/STLBAS_mmpu52v9_6870_1_20150201.arch
List of Archived Logs in backup set 6867
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 36221 2600574277 31-JAN-15 2600605406 31-JAN-15
1 36222 2600605406 31-JAN-15 2600627762 31-JAN-15
1 36223 2600627762 31-JAN-15 2600647950 31-JAN-15
1 36224 2600647950 31-JAN-15 2600662535 31-JAN-15
1 36225 2600662535 31-JAN-15 2600717481 31-JAN-15
1 36226 2600717481 31-JAN-15 2600741241 31-JAN-15
1 36227 2600741241 31-JAN-15 2600790390 31-JAN-15
1 36228 2600790390 31-JAN-15 2600816991 31-JAN-15
1 36229 2600816991 31-JAN-15 2600825320 31-JAN-15
1 36230 2600825320 31-JAN-15 2600835621 01-FEB-15
1 36231 2600835621 01-FEB-15 2600840871 01-FEB-15
1 36232 2600840871 01-FEB-15 2600844061 01-FEB-15
1 36233 2600844061 01-FEB-15 2600846909 01-FEB-15
1 36234 2600846909 01-FEB-15 2600849775 01-FEB-15
1 36235 2600849775 01-FEB-15 2600852908 01-FEB-15
1 36236 2600852908 01-FEB-15 2600855742 01-FEB-15
1 36237 2600855742 01-FEB-15 2600858910 01-FEB-15
1 36238 2600858910 01-FEB-15 2600861908 01-FEB-15
1 36239 2600861908 01-FEB-15 2600864790 01-FEB-15
1 36240 2600864790 01-FEB-15 2600867574 01-FEB-15
1 36241 2600867574 01-FEB-15 2600870383 01-FEB-15
1 36242 2600870383 01-FEB-15 2600873220 01-FEB-15
1 36243 2600873220 01-FEB-15 2600876061 01-FEB-15
1 36244 2600876061 01-FEB-15 2600879665 01-FEB-15
1 36245 2600879665 01-FEB-15 2600882739 01-FEB-15
1 36246 2600882739 01-FEB-15 2600885804 01-FEB-15
1 36247 2600885804 01-FEB-15 2600888651 01-FEB-15
1 36248 2600888651 01-FEB-15 2600891543 01-FEB-15
1 36249 2600891543 01-FEB-15 2600894895 01-FEB-15
1 36250 2600894895 01-FEB-15 2600897684 01-FEB-15
1 36251 2600897684 01-FEB-15 2600900574 01-FEB-15
1 36252 2600900574 01-FEB-15 2600903408 01-FEB-15
1 36253 2600903408 01-FEB-15 2600906920 01-FEB-15
1 36254 2600906920 01-FEB-15 2600910373 01-FEB-15
1 36255 2600910373 01-FEB-15 2600913188 01-FEB-15
1 36256 2600913188 01-FEB-15 2600915992 01-FEB-15
1 36257 2600915992 01-FEB-15 2600918821 01-FEB-15
1 36258 2600918821 01-FEB-15 2600921662 01-FEB-15
1 36259 2600921662 01-FEB-15 2600924499 01-FEB-15
1 36260 2600924499 01-FEB-15 2600927306 01-FEB-15
1 36261 2600927306 01-FEB-15 2600930132 01-FEB-15
1 36262 2600930132 01-FEB-15 2600932938 01-FEB-15
1 36263 2600932938 01-FEB-15 2600936116 01-FEB-15
1 36264 2600936116 01-FEB-15 2600939496 01-FEB-15
1 36265 2600939496 01-FEB-15 2600942433 01-FEB-15
1 36266 2600942433 01-FEB-15 2600945251 01-FEB-15
1 36267 2600945251 01-FEB-15 2600948054 01-FEB-15
1 36268 2600948054 01-FEB-15 2600950863 01-FEB-15
1 36269 2600950863 01-FEB-15 2600953653 01-FEB-15
1 36270 2600953653 01-FEB-15 2600956598 01-FEB-15
1 36271 2600956598 01-FEB-15 2600959671 01-FEB-15
1 36272 2600959671 01-FEB-15 2600962481 01-FEB-15
1 36273 2600962481 01-FEB-15 2600968235 01-FEB-15
1 36274 2600968235 01-FEB-15 2600971093 01-FEB-15
RMAN> recover database UNTIL SEQUENCE 36274;
RMAN> recover database UNTIL SEQUENCE 36274;
Starting recover at 03-FEB-15
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/03/2015 12:23:14
RMAN-06556: datafile 1 must be restored from backup older than SCN 2600968235
RMAN> recover database UNTIL SEQUENCE 36275;
Starting recover at 03-FEB-15
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=36274
channel ORA_DISK_1: reading from backup piece /back/rman/STLBAS_mmpu52v9_6870_1_20150201.arch
channel ORA_DISK_1: piece handle=/back/rman/STLBAS_mmpu52v9_6870_1_20150201.arch tag=TAG20150201T012203
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
archived log file name=/oracledb/oracle/dbs/arch1_36274_842022897.dbf thread=1 sequence=36274
media recovery complete, elapsed time: 00:00:01
Finished recover at 03-FEB-15
RMAN> alter database open resetlogs;
