sekedar tambahan lagi, Kalau gak mau re-create control file-nya bisa juga dengan :
Shutdown dulu databasenya Pindahkan file-nya ke direktori yang dimaui Sqlplus /nolog Connect sebagai sysdba startup mount alter database rename file 'c:\datafile\namafile.dbf' to 'd:\datafile\namafile.dbf' alter database open semoga membantu --- In [email protected], agus winarta <[EMAIL PROTECTED]> wrote: > > sekedar menambahkan.., mungkin bisa membantu..: > > langkah-langkah yang harus dilakukan dalam pemindahan datafile.., > > > > Sqlplus /nolog > > Connect sebagai sysdba > > Dalam kondisi database up, backup control file nya > > Sql>startup mount; > > Sql>alter database backup controlfile to trace; > > (control file akan terbentuk di bawah direktori udump) > > sql>exit; > > $ cd $ORACLE_BASE/admin/{oracle_sid}/udump > > > > kemudian edit file tersebut sebelum dijalankan > > > > misalnya : file ctlfile.sql > > isinya mungkin seperti ini...: > > > > STARTUP NOMOUNT > > CREATE CONTROLFILE REUSE DATABASE "JLINDO" NORESETLOGS NOARCHIVELOG > > MAXLOGFILES 5 > > MAXLOGMEMBERS 3 > > MAXDATAFILES 100 > > MAXINSTANCES 1 > > MAXLOGHISTORY 226 > > LOGFILE > > GROUP 1 '/software/oracle/app/oradata/JLINDO/system/redo01.log' SIZE 100M, > > GROUP 2 '/software/oracle/app/oradata/JLINDO/system/redo02.log' SIZE 100M, > > GROUP 3 '/software/oracle/app/oradata/JLINDO/system/redo03.log' SIZE 100M > > DATAFILE > > '/data1/XXX/trans/PARTC01.ORA' > > CHARACTER SET WE8ISO8859P1 > > ; > > # Recovery is required if any of the datafiles are restored backups, > > # or if the last shutdown was not normal or immediate. > > RECOVER DATABASE > > # Database can now be opened normally. > > ALTER DATABASE OPEN; > > # Commands to add tempfiles to temporary tablespaces. > > # Online tempfiles have complete space information. > > # Other tempfiles may require adjustment. > > ALTER TABLESPACE TS_TEMP ADD TEMPFILE '/data1/XXXX/temp/TEMP01.ORA' > > SIZE 5000M REUSE AUTOEXTEND OFF; > > > > Keterangan..: > > Pada path alamat file diatas.., disesuaikan dengan path dimana datafile akan dicopy.., > > > > Kalau proses edit sudah selesai.., dan sudah dipastikan bahwa file yang dimaksud sudah ada di path yang bersangkutan, maka proses bisa dilanjutkan.. > > Yaitu dengan menjalankan controlfile yang sudah di edit melalui sql.. > > > > Caranya adalah sebagai berikut : > > $sqlplus /nolog > > sql> connect / as sysdba; > > sql>@ctlfile.sql; > > (kalau ada yang kurang lengkap biasanya akan muncul errors , lihat petunjuk errornya, > > biasanya hanya berkaitan dengan datafile yang tidak sesuai dengan path di controfile ..) > > kalau tidak ada error, artinya proses create controlfile berhasil > > > > untuk perintah pemindahan data file nya..,dengan cara pakai perintah copy file biasa (dengan kondisi oracle database harus mati!!!) > > > > sekian.. > > > henri <[EMAIL PROTECTED]> wrote:Teman teman > > > > Saya coba dikit, tapi kira2 bener ga ya, > > > > Untuk masalah yg di utarakan sdr huda,saya kira bisa aja , > > > > Misalnya sekarang tablespacenya x ada di drive d, mau dipindah ke e: > > > > Langakanya, > > > > Connect dulu ke database as sysdba > > Trus alter database backup control file to trace as 'c:\controlfile.sql'; > > > > Kemudian shutdown database, > > > > Trus pindah table space x ke e > > > > Hbs itu create ulang control file berdasakan trace ctrlfile tadi, jangan > lupa isi di dalam c:\controlfile.sql dirubah lokasi table spacenya > > > > Mudah2an bisa membantu, kalau cara ini menurut teman2 yg expert ga bener tlg > dikoreksi ya > > > > Thx > > > > Henri > > > > FIF > > > > > > > > > > > > _____ > > From: [email protected] [mailto:indo- [EMAIL PROTECTED] On > Behalf Of dingin00hs > Sent: Monday, July 18, 2005 1:31 AM > To: [email protected] > Subject: [indo-oracle] [ASK]pindah lokasi tablespace file > > > > > to the point... > > bisa nggak ya pindah lokasi tablespace? drive C: yg kami pakai sudah > hampir penuh. sy berencana memindahkan tablespace file ke drive lain. > baru nambah hardisk nih... :) > > yg sekarang terpikir sih sy dump trus hapus user, create ulang > tablespace, restore. tapi koq gimanaaa gitu. > > konfigurasi system yg ada : server IBM (lupa tipenya), OS Win2K > Advanced Server, Oracle 9i Enterprise Ed, ada TOAD > > tools apa ya yg bisa sy pake? sy sudah nyoba ubek2 tools2 bawaan > oracle & TOAD, masih belum ketemu. > > btw, kalo produk Microsoft, cari2 help kan ada MSDN. di oracle apa > ya?? kalo sy ngintip ke help yg ikut terinstal isinya, yg sy tau, > cuma penjelasan "How to use this tool" (CMIIW). nyari2/belajar PLSQL > misalnya, selama ini nyonteknya ke file2 bawaan TOAD. alhamdulillah, > masih teratasi. yg bawaan oracle blm ketemu. atau memang gak ada ya?? > tapi kalo nyari2 info spt di atas misal,... ??? apa harus selalu > ngenet ya?? > > terima kasih... > > salam, > huda, beginner > > > > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.blogspot.com > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > > > > > _____ > > YAHOO! GROUPS LINKS > > > > * Visit your group "indo-oracle > <http://groups.yahoo.com/group/indo-oracle> " on the web. > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] subject=Unsubscribe> > > * Your use of Yahoo! Groups is subject to the Yahoo! > <http://docs.yahoo.com/info/terms/> Terms of Service. > > > > _____ > > > > [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.blogspot.com > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > > > > --------------------------------- > 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. > > > --------------------------------- > > > > > > --------------------------------- > Start your day with Yahoo! - make it your home page > > [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.blogspot.com ----------------------------------------------- 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/
