DB Copies
From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Fri, 27 May 94 09:09:00 -0500
Message-ID: <12a.2267.905.0N3E1F89_at_compudata.com>
Date: Fri, 27 May 94 09:09:00 -0500
Message-ID: <12a.2267.905.0N3E1F89_at_compudata.com>
I'd like to be able to copy an instance to a different partition, recreate the control file, and rename the sid.
I've got it working on a shutdown database, but can't do it live as in marking begin backup, copying data, marking end, because when creating the control file you have to use the RESETLOGS option, which destroys pending transactions.
Anybody done this? (Oracle 7, of course) Received on Fri May 27 1994 - 16:09:00 CEST