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