pak bw, yg ini sudah di saya lakukan pak, tapi kemudian muncul lagi, kali ini dgn nomer 78, setelah saya liat pada SELECT name FROM v$datafile WHERE file#=78;
ternyata ini adalah undotbs02.dbf. fyi, saya tambahkan 3 datafile pada primary, yg satu datafile77.dbf yg dua, undotbs02.dbf dan undotbs03.dbf. ketika saya mau apply, masih muncul error tp nomer nya ganti ke 78. apa yg harus saya lakukan skrg ? mohon bantuan. 2009/5/7 Yulius Wibowo <[email protected]> > > > 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] <indo-oracle%40yahoogroups.com>, 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] > > > > > -- Cheers, ^_^ Andes ^_^ [Non-text portions of this message have been removed]
