Dear All...
Mohon bantuannya untuk permasalah backup dan restore. Saat ini saya menggunakan
backup database A dengan tape library. Backup dilakukan empat kali; pertama,
malam hari dengan full backup, archivelog backup, controlfile backup; tiga
backup sisanya, yakni pagi, siang dan sore dilakukan backup archivelog dan
controlfile. backup menggunakan RMAN.Kemudian ketika saya mau restore (refresh)
database dari database A ke database B muncul pesan error sebagai berikut :
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
belowORA-01152: file 2 was not restored from a sufficiently old
backupORA-01110: data file 2:
'/oracle/oradata/data001/dbs/undo_data01.dbf'released channel: aux1RMAN-00571:
===========================================================RMAN-00569:
=============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571:
===========================================================RMAN-03002: failure
of Duplicate Db command at 01/26/2010 14:31:51RMAN-03015: error occurred in
stored script Memory ScriptRMAN-20506: no backup of archivelog foundRMAN-06053:
unable to perform media recovery because of missing logRMAN-06025: no backup of
log thread 1 seq 5215 lowscn 52273540 found to restoreRMAN-06025: no backup of
log thread 1 seq 5214 lowscn 52273534 found to restoreRMAN-06025: no backup of
log thread 1 seq 5213 lowscn 52268639 found to restore
Recovery Manager complete.
Kemudian saya shutdown dan startup, muncul pesan
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
Sepengetahuan saya, pada saat error ini kita harus alter database yang
memberikan archivelog yang sesuai. Tapi saya tidak bisa melakukan hal ini
karena backup berupa tape.
Kemudian saya coba restore kembali dengan RMAN muncul pesan dibawah, dan
database bisa startup dan open
RMAN-00571:
===========================================================RMAN-00569:
=============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571:
===========================================================RMAN-03002: failure
of Duplicate Db command at 01/26/2010 15:13:06RMAN-03015: error occurred in
stored script Memory ScriptRMAN-20506: no backup of archivelog foundRMAN-06053:
unable to perform media recovery because of missing logRMAN-06025: no backup of
log thread 1 seq 5255 lowscn 52299872 found to restoreRMAN-06025: no backup of
log thread 1 seq 5254 lowscn 52298951 found to restoreRMAN-06025: no backup of
log thread 1 seq 5253 lowscn 52298231 found to restoreRMAN-06025: no backup of
log thread 1 seq 5252 lowscn 52297707 found to restoreRMAN-06025: no backup of
log thread 1 seq 5251 lowscn 52296919 found to restoreRMAN-06025: no backup of
log thread 1 seq 5250 lowscn 52296220 found to restoreRMAN-06025: no backup of
log thread 1 seq 5249
lowscn 52295555 found to restoreRMAN-06025: no backup of log thread 1 seq 5248
lowscn 52294877 found to restoreRMAN-06025: no backup of log thread 1 seq 5247
lowscn 52294205 found to restoreRMAN-06025: no backup of log thread 1 seq 5246
lowscn 52293578 found to restoreRMAN-06025: no backup of log thread 1 seq 5245
lowscn 52292776 found to restoreRMAN-06025: no backup of log thread 1 seq 5244
lowscn 52292043 found to restoreRMAN-06025: no backup of log thread 1 seq 5243
lowscn 52291529 found to restoreRMAN-06025: no backup of log thread 1 seq 5242
lowscn 52290841 found to restoreRMAN-06025: no backup of log thread 1 seq 5241
lowscn 52290085 found to restoreRMAN-06025: no backup of log thread 1 seq 5240
lowscn 52289353 found to restoreRMAN-06025: no backup of log thread 1 seq 5239
lowscn 52288874 found to restoreRMAN-06025: no backup of log thread 1 seq 5238
lowscn 52288257 found to restoreRMAN-06025: no backup of log thread 1 seq 5237
lowscn 52287640
found to restoreRMAN-06025: no backup of log thread 1 seq 5236 lowscn 52287226
found to restore
Recovery Manager complete.
Mohon bantuannya untuk solving masalah ini....
Demikian dan TerimakasihSalam,Setiadi
[Non-text portions of this message have been removed]
