Andes saya bantu jawab ya Yup, itu juga harus anda lakukan,
kedepannya setting undo_management di parameter file anda set jadi auto, sekarang pasti masih manual regards Henri ----- Original Message ----- From: Andes Febrian<mailto:[email protected]> To: [email protected]<mailto:[email protected]> Sent: Thursday, May 07, 2009 5:06 PM Subject: External Email : --> Re: [indo-oracle] Re: ORA-01111: name for data file 77 is unknown - rename to correct file 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]<mailto:yulius_wibowo%40yahoo.com>> > > > 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]<mailto:indo-oracle%40yahoogroups.com> > <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] ________________________________ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this e-mail in whole or in part is strictly prohibited. PT Federal International Finance, which has its seat at North of Jakarta, Indonesia, including its affiliated companies, shall not be liable for the improper or incomplete transmission of the information contained in this e-mail nor for any delay in its receipt or damage to your system. PT Federal International Finance (or its affiliated companies) does not guarantee that the integrity of this communication has been maintained nor that this communication is free of viruses, interceptions or interference. [Non-text portions of this message have been removed]
