RE: Duplicating 8.1.7 database to a scn

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Wed, 31 Aug 2005 14:30:06 -0500
Message-ID: <270A0BDDFDE54E41B78F0F06D82A66B801346E0A@okcexg3.kmg.com>

SQL> archive log list?

	-----Original Message-----
	From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Peter Hitchman
	Sent: Wednesday, August 31, 2005 2:26 PM
	To: oracle-l_at_freelists.org
	Subject: Duplicating 8.1.7 database to a scn
	
	
	Hi,
	I need to duplicate an Oracle 8.1.7 database to a given point in

time. I have seen problems when trying to do this with the set command specifying a date, but I have done it using an scn number when I got the scn number from a duplication that did a full recovery.         

        If I stop all transactions in the database how do I find out what scn number to use? I have it in mind to archive the current log so that all of the changes are in the redo stream, will the most recent archive log give me the scn number and if so where do I get this information from.         

        Thanks         

        Pete

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 31 2005 - 14:32:14 CDT