Utk file 78 & 79, lakukan hal yg sama spt file no 77. Seharusnya diset agar pembuatan file di standby dibuat otomatis. Coba check file permission di direktori dimana datafile seharusnya terbentuk.
bw --- In [email protected], Andes Febrian <pejanta...@...> wrote: > > 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 <yulius_wib...@...> > > > > > > > 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 <pejantan4u@> 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] >
