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 ." <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> 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 ." <[EMAIL PROTECTED]> 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/
