ya pak file tersebut tidak ada On 4/18/06, Yulius Wibowo <[EMAIL PROTECTED]> wrote: > Yakin file tsb ada ??? > 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\CSA\SYSTEM01.DBF' > > > Bowo > > > --- In [email protected], "betabetha ." <[EMAIL PROTECTED]> > wrote: > > > > sudah saya hapus pak, tapi masih error seperti ini > > 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 > > CREATE CONTROLFILE REUSE DATABASE "CSA" NORESETLOGS NOARCHIVELOG > > * > > ERROR at line 1: > > ORA-01503: CREATE CONTROLFILE failed > > ORA-01565: error in identifying file > > 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\CSA\SYSTEM01.DBF' > > ORA-27041: unable to open file > > OSD-04002: unable to open file > > O/S-Error: (OS 2) The system cannot find the file specified. > > > > > > 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 > > > > padahal direktorynya sudah saya sesuaikan dengan letak database > > ini c:\my_ctl.txt hasil edit-an saya: > > STARTUP NOMOUNT > > CREATE CONTROLFILE REUSE DATABASE "CSA" NORESETLOGS NOARCHIVELOG > > MAXLOGFILES 16 > > MAXLOGMEMBERS 3 > > MAXDATAFILES 100 > > MAXINSTANCES 8 > > MAXLOGHISTORY 454 > > LOGFILE > > GROUP 1 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\CSA\REDO01.LOG' SIZE > 10M, > > GROUP 2 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\CSA\REDO02.LOG' SIZE > 10M, > > GROUP 3 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\CSA\REDO03.LOG' SIZE > 10M > > DATAFILE > > 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\CSA\SYSTEM01.DBF', > > 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\CSA\UNDOTBS01.DBF', > > 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\CSA\SYSAUX01.DBF', > > 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\CSA\USERS01.DBF' > > CHARACTER SET WE8MSWIN1252 > > ; > > RECOVER DATABASE USING BACKUP CONTROLFILE; > > ALTER DATABASE OPEN RESETLOGS; > > ALTER TABLESPACE TEMP ADD TEMPFILE > > 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\CSA\TEMP01.DBF' > > SIZE 20971520 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE > 32767M; > > > > salam > > betty > > > > > > On 4/18/06, Yulius Wibowo <[EMAIL PROTECTED]> wrote: > > > 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 ." <betabetha@> > > > 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 <yulius_wibowo@> 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > -----------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/
