[indo-oracle] ORA-01111: name for data file 77 is unknown - rename to correct file

[Andes Febrian]

Dear gurus,

Env database, DataGuard database. minggu lalu saya menambahkan datafile pada
primary db, kemudian hari ini ketika saya query
on primary :
SQL> SELECT THREAD#,MAX(SEQUENCE#) FROM v$log_history GROUP BY THREAD#;

   THREAD# MAX(SEQUENCE#)
---------- --------------
         1           6475

on standby :
SQL> SELECT THREAD#,MAX(SEQUENCE#) FROM v$log_history GROUP BY THREAD#;

   THREAD# MAX(SEQUENCE#)
---------- --------------
         1           6396

terjadi lagging, kemudian saya coba untuk recover automatic standby
database, tapi muncul error sebagai berikut :
SQL> recover automatic standby database;
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 77 is unknown - rename to correct file
ORA-01110: data file 77: '/oracle/db10g/dbs/UNNAMED00077'
ORA-01157: cannot identify/lock data file 77 - see DBWR trace file
ORA-01111: name for data file 77 is unknown - rename to correct file
ORA-01110: data file 77: '/oracle/db10g/dbs/UNNAMED00077'

mohon bantuan, apa yg harus saya lakukan, cari di inet di suruh rename the
missing file to the real life, tp yg saya tidak mengerti adalah yg harus di
rubah yg mana ? karena datafile saya tidak berada disini "ORA-01110: data
file 77: '/oracle/db10g/dbs/UNNAMED00077'"

many thanks

-- 
Cheers,
^_^ Andes ^_^


[Non-text portions of this message have been removed]