sore pak, bisakah pak bowo uraikan langkah2 restore database ke database yang sudah ada? soalnya masih gagal pak? jadi database yang baru ini akan saya tumpuki dengan yang lama.
salam betty On 4/18/06, betabetha . <[EMAIL PROTECTED]> wrote: > 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/
