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:[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]>
* 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/
