Mas Bowo, 1. Mungkin bisa sharing informasi mengapa 'TEMP' tablespace tidak bisa di backup dg menggunakan metode Online ? (Hot bck & RMAN) karena di tempat customer saya yg menjalankan script hot backup yg mana logic nya adalah select semua tablespace yg ada, pasti ada error message ketika akan begin backup tablespace TEMP, walaupun saya sudah informasikan bahwa error tsb dapat di ignore.
2. Kalau punya script hot backup yg exclude temp tablespace boleh juga di share. Rgds, Luthfi Yulius Wibowo <[EMAIL PROTECTED]> wrote: Kalau anda menggunakan RMAN sebagai tools utk backup dan recovery, yang perlu dicatat adalah : TEMPORARY file TIDAK ikut dibackup/restore. Jadi, setelah melakukan restore & recovery, yg harus dilakukan adalah membuat sebuah temp file yg baru. (asumsi: Temporary tablespace = TEMP) SQL> ALTER TABLESPACE temp ADD TEMPFILE 'new_tempfile.dbf' SIZE xxM; SQL> ALTER DATABASE TEMPFILE 'old_tempfile.dbf' DROP; CMIIW, Bowo --- In [email protected], "fafan ." <[EMAIL PROTECTED]> wrote: > > Rekan milis semua, > > saya mohon bantuan berkaitan dgn error di bawah ini, > Database : Oracle 9i (9.3.)--> LINUX > Appl : Oracle EBSSE (11.9.5) > saat Backup dan Recovery Database dengan RMAN semua > berjalan lancar, > namun setelah proses Recovery selesai dan saya start > aplikasi > muncul error dibawah ini setelah login. > -----------------Error Message------------------------ > Oracle error -20001:ORA-20001:Error occurred during > product > initialization for MO when executing 'begin > MO-GLOBAL.INIT; end'; > SQLCODE=-20001 > SQLERROR=ORA-20001:SQL_PLSQL_ERROR:N,ROUTONE, > MO_GLOBAL.INIT,N,ERRNO,-20001,N,REASON,ORA-20001: > SQL_PLSQL_ERROR:N,ROUTONE,MO_GLOBAL.SET_ORG_ACCESS,N,ERRNO, > -20001,N,REASON,ORA-20001:SQL_PLSQL_ERROR:N,ROUTONE, > MO_GLOBAL.SET_ORG_ACCESS_INTERNAL,N,ERRNO,-25153,N,REASON, > ORA-25153: Temporary Tablespace is Empty has been > detected in > FND_GLOBAL.INITIALIZE > > Mohon sekali penjelasan dan bantuan dari rekan" semua > > Best Regards, > .:Fafan (IT-Dept):. > > __________________________________________________ > Apakah Anda Yahoo!? > Lelah menerima spam? Surat Yahoo! memiliki perlindungan terbaik terhadap spam > http://id.mail.yahoo.com > -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com SPONSORED LINKS Membership database software Database mortgage software Pda database software Database management software Oracle database administration Oracle database management --------------------------------- YAHOO! GROUPS LINKS Visit your group "indo-oracle" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
