From oracle-l-bounce@freelists.org Sun Jun 27 19:19:41 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5S0JQ129990 for ; Sun, 27 Jun 2004 19:19:36 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5S0JG629981 for ; Sun, 27 Jun 2004 19:19:26 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5B2B372C3CF; Sun, 27 Jun 2004 19:02:07 -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 26184-78; Sun, 27 Jun 2004 19:02:07 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A6AFA72C3F1; Sun, 27 Jun 2004 19:02:06 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 27 Jun 2004 19:00:47 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8AF8E72C1F3 for ; Sun, 27 Jun 2004 19:00:46 -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 26184-51 for ; Sun, 27 Jun 2004 19:00:46 -0500 (EST) Received: from gw0.commbank.com.au (gw0.commbank.com.au [203.17.185.170]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5436072C0BE for ; Sun, 27 Jun 2004 19:00:45 -0500 (EST) Received: (from mail@localhost) by gw0.commbank.com.au (8.12.9/8.12.5) id i5S08tVi029302 for ; Mon, 28 Jun 2004 10:08:55 +1000 (EST) Received: from UNKNOWN(172.16.1.1), claiming to be "msgw03.cba.com.au" via SMTP by bh0, id smtpdAAAOfaaK4; Mon Jun 28 10:08:33 2004 Message-ID: From: "Hodgkinson, Stephen" To: "'oracle-l@freelists.org'" Subject: RE: Hot Backup Theory Revisited: Date: Mon, 28 Jun 2004 09:29:53 +1000 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2655.55) Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 3779 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Stephen.Hodgkinson@cba.com.au Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Thanks everybody, After I have backed up all the tablespaces I issue an ' alter database backup controlfile to trace' I then recreate the controlfile using the SQL. I have to do it this way as the database name and file structure names change slightly. Mike the idea that it might already be in backup mode could be a good one. We do get alarms if our tablespace our left in Backup mode but this now seems the only logical explanation. Stephen. -----Original Message----- From: Khedr, Waleed [mailto:Waleed.Khedr@FMR.COM] Sent: Saturday, 26 June 2004 3:20 To: oracle-l@freelists.org Subject: RE: Hot Backup Theory Revisited: Updates/Writes to the file during the O/S copy process, possibly, makes = the copied file inconsistent. Waleed -----Original Message----- From: Guang Mei [mailto:gmei@incyte.com] Sent: Friday, June 25, 2004 1:03 PM To: oracle-l@freelists.org Subject: RE: Hot Backup Theory Revisited: Why OS copy of control file won't work? Guang > -----Original Message----- Guang, Under normal circumstances yes, but the control file has to be a "alter database backup controlfile . . .", not a OS copy. Mike -----Original Message----- From: Guang Mei [mailto:gmei@incyte.com] Sent: Friday, June 25, 2004 11:17 AM To: oracle-l@freelists.org Subject: RE: Hot Backup Theory Revisited: I am trying to understand: Is it true that if the copy of control file (just an OS copy) is done = AFTER issuing ALTER SYSTEM ARCHIVE LOG CURRENT; then no earlier (than the log switch) archive log is needed? We still = need the archive logs generated during tablespace backup process. Guang=20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ************** IMPORTANT MESSAGE ************** This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: www.commbank.com.au ************************************************** ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------