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;

1 comment:

  1. Jadwal Resmi Laga Ayam SV388 14 Maret 2019 - Kamis, 14 Maret 2019 – Pada Hari Tersebut Akan Di Laksanakan Berbagai Pertandingan Sabung Ayam Secara Live di Arena Sabung Ayam Thailand.

    Situs Judi Sabung Ayam Online SV388 Merupakan Situs Judi Asal Thailand Yang Sangat Terkenal Dengan Permainan Sabung Ayam Yang Fair dan Menghibur Para Penonton Judi Sabung Ayam.

    Untuk Info Lebih Lanjut Bisa Hub kami Di :
    wechat : bolavita
    line : cs_bolavita
    whatsapp : +628122222995
    BBM: BOLAVITA

    ReplyDelete