Memang ada "bug" pada saat control file dibackup ke trace file, yaitu pada bagian antara LOGFILE dan DATAFILE (pada bagian ####):
STARTUP MOUNT CREATE CONTROLFILE ... ... ... LOGFILE ... ... #### space yg ada di sini dihapus !!!! kalau tidak akan error pada saat dijalankan .... #### DATAFILE ... ... CHARACTER SET .... ; Bowo --- In [email protected], "betabetha ." <[EMAIL PROTECTED]> wrote: > > Pagi pak, > > Ma kasih atas jawaban pak bowo, > Step 1 dan 2 telah berhasil, tapi pada waktu jalankan c:\my_ctl.txt > muncul error: > SQL> @c:\my_ctl.txt > ORACLE instance started. > > Total System Global Area 171966464 bytes > Fixed Size 787988 bytes > Variable Size 145750508 bytes > Database Buffers 25165824 bytes > Redo Buffers 262144 bytes > SP2-0042: unknown command "DATAFILE" - rest of line ignored. > SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored. > SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored. > SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored. > SP2-0044: For a list of known commands enter HELP > and to leave enter EXIT. > SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored. > SP2-0734: unknown command beginning "CHARACTER ..." - rest of line ignored. > 1 CREATE CONTROLFILE REUSE DATABASE "CSA" RESETLOGS NOARCHIVELOG > 2 MAXLOGFILES 16 > 3 MAXLOGMEMBERS 3 > 4 MAXDATAFILES 100 > 5 MAXINSTANCES 8 > 6 MAXLOGHISTORY 454 > 7 LOGFILE > 8 GROUP 1 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\CSA\REDO01.LOG' SIZE 10M, > 9 GROUP 2 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\CSA\REDO02.LOG' SIZE 10M, > 10* GROUP 3 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\CSA\REDO03.LOG' SIZE 10M > ORA-01507: database not mounted > > > ALTER DATABASE OPEN > * > ERROR at line 1: > ORA-01507: database not mounted > > > ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\PRODUCT\10.1.0 \ORADATA\CSA\TEMP01. > DBF' > * > ERROR at line 1: > ORA-01109: database not open > > > ORA-01081: cannot start already-running ORACLE - shut it down first > SP2-0042: unknown command "DATAFILE" - rest of line ignored. > SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored. > SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored. > SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored. > SP2-0044: For a list of known commands enter HELP > and to leave enter EXIT. > SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored. > SP2-0734: unknown command beginning "CHARACTER ..." - rest of line ignored. > 1 CREATE CONTROLFILE REUSE DATABASE "CSA" RESETLOGS NOARCHIVELOG > 2 MAXLOGFILES 16 > 3 MAXLOGMEMBERS 3 > 4 MAXDATAFILES 100 > 5 MAXINSTANCES 8 > 6 MAXLOGHISTORY 454 > 7 LOGFILE > 8 GROUP 1 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\CSA\REDO01.LOG' SIZE 10M, > 9 GROUP 2 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\CSA\REDO02.LOG' SIZE 10M, > 10 GROUP 3 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\CSA\REDO03.LOG' SIZE 10M > 11* -- STANDBY LOGFILE > ORA-01507: database not mounted > > > ALTER DATABASE OPEN RESETLOGS > * > ERROR at line 1: > ORA-01507: database not mounted > > > ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORACLE\PRODUCT\10.1.0 \ORADATA\CSA\TEMP01. > DBF' > * > ERROR at line 1: > ORA-01109: database not open > sehingga control file belum terbentuk. > > salam > betty > > > On 4/18/06, Yulius Wibowo <[EMAIL PROTECTED]> wrote: > > Restore (cloning) tanpa control file? > > > > Bisa, dgn cara: > > 1. Betty tahu scipt utk membuat database-nya, > > kemudian ganti perintah CREATE DATABASE ..., dengan CREATE > > CONTROLFILE ... > > > > 2. Dari database yg baru dibuat, coba create script utk membuat > > controlfile > > > > SQL> conn / as sysdba > > SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS 'C:\my_ctl.txt'; > > > > Lalu edit isi file C:\my_ctl.txt tsb, sesuaikan lokasi dari file2 yg > > akan dipakai (dari hasil restore). Kemudian jalankan isi script tsb. > > Kalau di Windows, create terlebih dulu service-nya. Dan jangan lupa > > password file & parameter file dibuat terlebih dulu. > > > > > > Bowo > > > > > > > > > > --- In [email protected], "betabetha ." <betabetha@> > > wrote: > > > > > > Terima kasih atas jawabannya, memang saya kemudian menemukan bahwa > > > control file ini sangat penting bagi restore data. > > > selanjutnya, bisakah saya merestore backup saya yang tidak punya > > > control file tersebut ke database yang baru saya create dari dbca? > > > Kalo bisa tolong pak, caranya bagaimanakah karena backup saya > > letaknya > > > di disk lain yang tidak sama dengan keberadaan database baru. > > > > > > rgds > > > betty > > > > > > > > > > > > On 4/13/06, Tomi Wijanto <restomi_w@> wrote: > > > > gak bisa tuh, mesti restore dulu datafile-nya sebelum > > > > direcover. > > > > Lain halnya kalau cuma datafile non-system yg tidak > > > > pernah dibackup tapi mau direstore, kasus ini > > > > memungkinkan kita utk menggunakan HANYA archive log. > > > > > > > > regards, > > > > tomi > > > > > > > > --- "betabetha ." <betabetha@> wrote: > > > > > > > > > Sore semuanya, > > > > > > > > > > Bagaimana cara restore ulang backup kita ke mesin > > > > > yang berbeda yang > > > > > telah mempunyai oracle? Karena backup set saya hanya > > > > > berdasarkan > > > > > archivelog saja? > > > > > > > > > > rgds > > > > > betty > > > > > > > > > > > > __________________________________________________ > > > > Do You Yahoo!? > > > > Tired of spam? Yahoo! Mail has the best spam protection around > > > > http://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 > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > -----------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 > > > > > > > > > > > > > > > -- -----------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/
