Showing posts with label ora-01547. Show all posts
Showing posts with label ora-01547. Show all posts

Monday, 2 February 2015

ora-01547 ora-01152 ora-01110 ---ORA-01152: file 1 was not restored from a sufficiently old backup

ORA-01152: file 1 was not restored from a sufficiently old backup


RMAN> recover database;

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;