Jacinta,
On windows environment, u need to transfer the following files(if not
planning for cloning):
- all control,dbf and log files
- init<sid>.ora,tnsnames.ora,listener.ora,sqlnet.ora.
This is just for the condition u want to create a new db with the same
thing but u don want to create standby. If u mean for a standby db then u
don need to copy the control files from the old server. In that condition
refer oracle docs for configuring standby server.
Hope this helps u.
cheers
On 7/29/05, Kean Jacinta <jacintakean_at_yahoo.com> wrote:
>
> Hi ,
> Can i know what are the files i need to transfer from the old database to
> new database. For example ... system, user ??
> Thank in advance .
> JKean
>
> *Sinardy <all_about_oracle_at_hotpop.com>* wrote:
>
> Hi Jacinta,
> As for windows, usually for me is only 3 steps
> 1. install oracle
> 2. recreate the instance using oradim (with new password)
> 3. put back all the files into the same directory (exclude the password
> file)
> As for the backup
> 1. shutdown database, perhaps follow by stop the services from control
> panel will be best.
> 2. copy database files.
> Sinardy
>
> ----- Original Message -----
> *From:* Jared Still <jkstill_at_gmail.com>
> *To:* rgramolini_at_tax.state.vt.us
> *Cc:* oracle-l <oracle-l_at_freelists.org> ; jacintakean_at_yahoo.com
> *Sent:* Friday, July 29, 2005 7:03 AM
> *Subject:* Re: Oracle Backup
>
> You can also do this in 8i. It just isn't easy. :(
>
> Jared
>
>
> On 7/28/05, Ruth Gramolini <rgramolini_at_tax.state.vt.us> wrote:
> >
> > Are you using rman for backup and recovery? If your version is 9i or
> > later you can use the duplicate command to create a copy of the database. It
> > is very easy!
> > HTH,
> > Ruth
> > -----Original Message-----
> > **
> >
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
--
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
to_onkar_at_yahoo.com
onkarnath.tiwary_at_gmail.com
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jul 30 2005 - 00:31:06 CDT
