Re: Oracle Backup

From: Kean Jacinta <jacintakean_at_yahoo.com>
Date: Fri, 29 Jul 2005 07:51:23 -0700 (PDT)
Message-ID: <20050729145123.38993.qmail@web52905.mail.yahoo.com>

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

install oracle
recreate the instance using oradim (with new password)
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
To: rgramolini_at_tax.state.vt.us
Cc: oracle-l ; 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
--

http://www.freelists.org/webpage/oracle-l Received on Fri Jul 29 2005 - 09:53:22 CDT