dari backup rman terakhirnya kemungkinan archivelognya/backup archivelognya ada yang kehapus pak. coba bapak select current_scn from v$database; bisa coba backup dari mulai scn itu di primarynya trus di pake untuk recovery di DR sitenya pak.. pls CMIIW.
--- Pada Sen, 26/10/09, praneko <[email protected]> menulis: Dari: praneko <[email protected]> Judul: [indo-oracle] RMAN recover database using backup controlfile failed Kepada: [email protected] Tanggal: Senin, 26 Oktober, 2009, 10:39 AM 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 __________________________________________________________ Coba Yahoo! Messenger 10 Beta yang baru. Kini dengan update real-time, panggilan video, dan banyak lagi! Kunjungi http://id.messenger.yahoo.com/ [Non-text portions of this message have been removed]
