From oracle-l-bounce@freelists.org Thu Jul 28 22:55:05 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j6T3t5Bn014839 for ; Thu, 28 Jul 2005 22:55:05 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j6T3t3IP014828 for ; Thu, 28 Jul 2005 22:55:03 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 87ADD1D95A4; Thu, 28 Jul 2005 22:54:56 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08342-03; Thu, 28 Jul 2005 22:54:56 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EA0BA1D99B6; Thu, 28 Jul 2005 22:54:55 -0500 (EST) Message-ID: <001201c593f1$2fde8200$0600a8c0@ncs.corp.intads> From: "Sinardy" To: , Cc: "oracle-l" , References: <20050728153511.18385.qmail@web52901.mail.yahoo.com> <006a01c5939c$c7801b50$6759000a@vttaxnet.tax.state.vt.us> Subject: Re: Oracle Backup Date: Fri, 29 Jul 2005 11:54:08 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000F_01C59434.3A716F50" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-HotPOP: ----------------------------------------------- Sent By HotPOP.com FREE Email Get your FREE POP email at www.HotPOP.com ----------------------------------------------- X-archive-position: 23033 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: all_about_oracle@hotpop.com Precedence: normal Reply-To: all_about_oracle@hotpop.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.5 required=5.0 tests=AWL,BAYES_00,HTML_50_60, HTML_MESSAGE autolearn=no version=2.63 ------=_NextPart_000_000F_01C59434.3A716F50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Jacinta, As for windows, usually for me is only 3 steps 1. install oracle=20 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 -----=20 From: Jared Still=20 To: rgramolini@tax.state.vt.us=20 Cc: oracle-l ; jacintakean@yahoo.com=20 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 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----- ------=_NextPart_000_000F_01C59434.3A716F50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi Jacinta,
 
As for windows, usually for me is only = 3=20 steps
 
1. install oracle
2. recreate the instance using oradim = (with new=20 password)
3. put back all the files into the same = directory=20 (exclude the password file)
 
 
As for the backup
1. shutdown database, perhaps follow by = stop the=20 services from control panel will be best.
2. copy database files.
 
Sinardy
----- Original Message -----
From:=20 Jared = Still=20
Cc: oracle-l ; jacintakean@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. =20 :(

Jared


On 7/28/05, Ruth=20 Gramolini <rgramolini@tax.state.vt.us= >=20 wrote:
Are you using rman for backup = and=20 recovery?  If your version is 9i or later you can use the = duplicate=20 command to create a copy of the database.  It is very=20 easy!
 
HTH,
Ruth
-----Original=20 = Message-----

------=_NextPart_000_000F_01C59434.3A716F50-- -- http://www.freelists.org/webpage/oracle-l