RE: help "cloning" a database

From: John P Weatherman <asahoshi_at_infionline.net>
Date: Tue, 18 May 2004 13:51:41 -0400
Message-ID: <410-220045218175141267@infionline.net>

Well, for one thing that 401 arc file has the "end backup" in it. When working off a hot, always recover through the end backup. That means:

Begin backup
Copy all files
end backup
archive log all
copy log files
apply

You may be able to force an open with the datafiles still in backup mode, but I've never done it that way. I have no idea from the SCN standpoint.

FWIW, John P Weatherman
Oracle DBA
Advance America

> [Original Message]
> From: Rich Holland <holland_at_guidancetech.com>
> To: <oracle-l_at_freelists.org>
> Date: 5/18/2004 1:40:26 PM
> Subject: help "cloning" a database
>
> For all tablespaces except TEMP, I do:
> SQL> alter tablespace <TS> begin backup;
>
> Then I copy the file systems from SRC to DST system:
> $ cd /oracle/SRC
> $ tar -cf -./sapdata* | cd (/oracle/DST ; tar -xvpf - )
>
> Then I force log switches (four, just to be safe):
> SQL> alter system archive log current;
> SQL> alter system archive log current;
> SQL> alter system archive log current;
> SQL> alter system archive log current;
>
> Then I copy the redo & archived redo logs:
> $ cd /oracle/SRC
> $ tar -cf - ./mirr* ./orig* ./ora* | (cd /oracle/DST ; tar -xvpf -)
>
> At this point it should be safe to take the source system out of backup
mode,
> so I do that. I also fix the ownership of all the copied files:
>
> $ cd /oracle/DST
> $ find . -user orasrc -exec chown oradst {} ';'
>
> So I press <RET> to take it's suggestion and it goes to the next one; it
does
> this all the way until it rolls through log 400, which was the last of
the 4 I
> created with the 'alter system archive log current' commands earlier.
When it
> asks for 401, there isn't anything to give it, so I CANCEL the recovery,
but I
> see this error:
>
> ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get
> error
> below
> ORA-01195: online backup of file 1 needs more recovery to be consistent
> ORA-01110: data file 1: '/oracle/DST/sapdata1/system_1/system.data1'

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_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
-----------------------------------------------------------------

Received on Tue May 18 2004 - 12:49:04 CDT