1. Temporary tablespace tidak menyimpan data. Tapi hanya menyimpan sort segment. Jadi tidak critical. Bisa dicreate ulang tanpa ada kehilangan data.
2. SELECT stmt dari tablespace YG BUKAN temp SQL> SELECT DISTINCT tablespace_name FROM dba_tablespaces WHERE contents != 'TEMPORARY'; Bowo --- In [email protected], luthfi M <[EMAIL PROTECTED]> wrote: > > 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/
