Re: Database Cloning Qs

From: Sajid Iqbal <sajid_at_u-net.net>
Date: Fri, 26 May 2000 08:30:23 +0100 (BST)
Message-Id: <10509.106826@fatcity.com>

After copying all the datafiles, parameter files etc.. After backing up the control file to trace and then editing it up to the startup nomount..

When I ran this control file sql script I go the following errors

ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
ORA-01649: operation not allowed with a backup controlfile

ALTER DATABASE OPEN RESETLOGS
*
ORA-01195: online backup of file 1 needs more recovery to be consistent ORA-01110: data file 1: '/opt/var/m1/oradata/UNET/system01.dbf'

TIA Saj Iqbal

--
U-NET Ltd  a VIA NET.WORKS Inc company
Sajid Iqbal                    | Mail : sajid_at_u-net.net
Database DBA/Developer         | Ext  : 4485
U-NET Ltd                      | ICQ  : 43903417
Warrington, Cheshire, UK       |  


On Thu, 25 May 2000, Chris Royce wrote:



> When cloning you 're-create' the control files from the 'alter system backup

> controlfile to trace'  .trc file and No you do not need the redo logs as you

> will open the database with the 'resetlogs' option. If you require further

> help please contact me.  I 'clone' databases frequently and would be happy to

> assist.

> 

> Chris_at_Royce.net

> 

> Sajid Iqbal wrote:

> 

> > When cloning a Oracle Database.. do u have to copy accross the Control

> > files and redo log files.. Or are they created from the backup controlfile

> > to trace part ?

> >

> > TIA

> >

> > Saj Iqbal

> >

> > --

> > U-NET Ltd  a VIA NET.WORKS Inc company

> > Sajid Iqbal                    | Mail : sajid_at_u-net.net

> > Database DBA/Developer         | Ext  : 4485

> > U-NET Ltd                      | ICQ  : 43903417

> > Warrington, Cheshire, UK       |

> >

> > --

> > Author: Sajid Iqbal

> >   INET: sajid_at_u-net.net

> >

> > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> > San Diego, California        -- Public Internet access / Mailing Lists

> > --------------------------------------------------------------------

> > To REMOVE yourself from this mailing list, send an E-Mail message

> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> > the message BODY, include a line containing: UNSUB ORACLE-L

> > (or the name of mailing list you want to be removed from).  You may

> > also send the HELP command for other information (like subscribing).

> 

> -- 

> Author: Chris Royce

>   INET: Chris_at_Royce.net

> 

> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing Lists

> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message

> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> the message BODY, include a line containing: UNSUB ORACLE-L

> (or the name of mailing list you want to be removed from).  You may

> also send the HELP command for other information (like subscribing).

Received on Fri May 26 2000 - 02:30:23 CDT