coba cari di $ORACLE_HOME/dbs On 8/28/06, Safik <[EMAIL PROTECTED]> wrote: > > Mohon informasi saya akan merestore db menggunakan prosedur spt di > bawah ini > (ini sudah pernah dibahas). > > Yg ditanyakan dimana lokasi spfile ....? > Klo Saya lihat di didirectory databasenya, datafilenya ada, contor filenya > ada, redo lognya jga ada, password filenya jga ada... dimana/ nama file > dri > spfile yang mana ..? > > -----Original Message----- > From: [email protected] <indo-oracle%40yahoogroups.com> [mailto: > [email protected] <indo-oracle%40yahoogroups.com>] On > Behalf Of Yulius Wibowo > Sent: Monday, February 27, 2006 10:45 > To: [email protected] <indo-oracle%40yahoogroups.com> > Subject: [indo-oracle] Re: Replikasi / restore database > > Apakah anda punya backup dari database yg sebelumnya anda pakai ? > Atau apakah datafiles + control files + redo log files + spfile + > password file, masih bisa diselamatkan ? > > Asumsi kalau datafiles + control files + redo log files + spfile + > password file, masih bisa diselamatkan , yg harus anda lakukan : > > 1. Copy datafiles + control files + redo log files + spfile + > password file ke media backup. misal ke external harddisk > > 2. Install OS, jika perlu lengkap dgn format hardisk . > > 3a. Install Oracle software , tanpa harus create starter database > 4a. Restore/Copy datafiles + control files + redo log files + spfile > + password file dari media backup. > 5a. Create Oracle Service, menggunakan ORADIM > > Atau > 3b. Install Oracle software , dengan opsi create starter database, > dengan nama instance yg sama dgn yg sebelumnya > 4b. Matikan Oracle service-nya > > 5b.Restore/Copy datafiles + control files + redo log files + spfile > + password file dari media backup ke lokasi semula. Overwrite yg ada > (starter database) > > CMIIW, > > Bowo > > --- In [email protected] <indo-oracle%40yahoogroups.com>, Neo > <[EMAIL PROTECTED]> wrote: > > > > Oracle Version : 9.2.0 > > Windows XP Prof > > > > Dear all ...! > > beberapa hari lalu windows saya crash dan harus install ulang > > saya mau restore database oracle saya kembali ...! > > ada yang bisa kasih petunjuk atau link or tutorial yang ngebahas > kesitu ..! > > sorry kalo pertanyaannya engga jelas > > > > thanks in advance > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED]<indo-oracle-unsubscribe%40yahoogroups.com> > 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 > > >
-- (¨`·.·´¨) Always `·.¸(¨`·.·´¨ ) Keep (¨`·.·´¨)¸.·´Smiling! `·.¸.·´ [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.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/
