Re: Oracle Backup

Jacinta,
 On windows environment, u need to transfer the following files(if not 
planning for cloning):
 1) all control,dbf and log files
2) 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@xxxxxxxxx> 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@xxxxxxxxxx>* 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@xxxxxxxxx> 
> *To:* rgramolini@xxxxxxxxxxxxxxx 
> *Cc:* oracle-l <oracle-l@xxxxxxxxxxxxx> ; jacintakean@xxxxxxxxx 
> *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@xxxxxxxxxxxxxxx> 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@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx

Other related posts: