DBA'ers saya coba restore backup rman di Disaster recovery site. Database berhasil di restore (controlfile dan database serta archived log filenya). Database backup pakai Hot backup (archived log enabled)
Saat mau open database resetlogs, ada failed ORA-01194 RMAN> alter database open resetlogs; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of alter db command at 10/21/2009 22:50:32 ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/oradata/mnprd/system_mnprd_01.dbf' Dari data v$datafile , datafile nomor 68 status Recover. (datafile 68 /oradata/mnprd/minetrak_tbl_10 RECOVER ) Saat restore archivelog file from sequence = 68556 , sedang datafile /oradata/mnprd/minetrak_tbl_10 membutuhkan sequence 67409 dimana ini archived log tgl 6 July 2009 dan saya tidak punya backup tgl segitu lagi. Step selanjutnya bagaimana ya kira kira ? Apakah ada yang mengalami hal yang sama ? Makasih sebelumnya. Amang
