1. Check terlebih dulu nama file di primary site: SQL> SELECT name FROM v$datafile WHERE file#=77; misal: /oradata/df77.dbf
2. Offlinekan tablespace dari datafile no 77 di standby site, apabila belum offline SQL> ALTER TABLESPACE ts_name_of_df_77 OFFLINE; 3. Rename file dgn menggunakan OS command # mv /oracle/db10g/dbs/UNNAMED00077 /oradata/df77.dbf 4. Rename file (update info di data dictionary) dgn menggunakan SQL command SQL> ALTER DATABASE RENAME FILE '/oracle/db10g/dbs/UNNAMED00077' TO '/oradata/df77.dbf'; 5. Onlinekan tablespace dari datafile no 77 di standby site SQL> ALTER TABLESPACE ts_name_of_df_77 ONLINE; cmiiw, bw --- In [email protected], Andes Febrian <pejanta...@...> wrote: > > 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] >
