| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Rman, Duplicating without set untill.... & cloning with
My experience has been that RMAN will try to restore the database right up to the current point-in-time of the production database. So if you are on a remote system, it will be looking for data in the current redo logs (or logs that were archived since the backup), which it can't access. Oracle claims that RMAN will restore the last backup, but I think it is trying to bring the duplicated DB in sync with production.
I am on 8.1.7 on Tru64. I haven't investigated this enough to prove the theory, so I could be wrong. All I know is that if I don't use SET UNTIL when duplicating a database, RMAN complains about missing archivelogs.
Jay
>>> rgramolini_at_tax.state.vt.us 04/12/02 10:13AM >>>
I duplicate without at set until time using 8.0.6.3. I follow the
instructions from Metalink. I duplicate our production databases to another
box and change the names from prdxxxx to rptxxxx. I do clone all of the
tablespaces.
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Friday, April 12, 2002 5:58 AM
tablespaces
Hi All,
I'm currently in the middle of a tar with Oracle about duplicating without
set until time/scn.... According to the doc's it must be possible but when
trying I get an error message about an archive log file that it needs but
is not yet there.
Any of you duplicating without set untill time/scn etc.. w/o problems
if so what version RMAN/Oracle What OS/version What sequence of actions do you perform?
Second I try to find the rman alternative to cloning just a part of the database but can't find anything in the Doc's Anybody
TIA Jack
Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen.
Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden.
If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies.
In carrying out its engagements, Ernst & Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: nlzanen1_at_EY.NL 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: rgramolini_at_tax.state.vt.us 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: jhostetter_at_decommunications.com 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 Apr 12 2002 - 10:18:50 CDT
 |
 |