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;
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.
ReplyDeleteSitus 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