help "cloning " a database 2004-05-18 - By John P Weatherman
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@(protected) >
> To: <oracle-l@(protected) >
> 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 (See ORA-01547.ora-code.com): warning: RECOVER succeeded but OPEN RESETLOGS would get
> error
> below
> ORA-01195 (See ORA-01195.ora-code.com): online backup of file 1 needs more recovery to be consistent
> ORA-01110 (See ORA-01110.ora-code.com): 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
