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 <*> 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/
