Re: rolling forward after import

"Peter Laursen" <pl_at_invalid.dk> wrote in message news:4068aaae$0$18660$ba624c82_at_nntp05.dk.telia.net...
> System: 8.1.7.4, Win2k
>
> Suppose I have an 8.1.7.4 db in archivelogmode and do a full export.
> Some days later I import the full export. Now, how do I roll forward
> using the existing archivelogs? The database does not need recovery,
> so I expect that no variation of the "recover" cmd will work?
>
> TIA
> Peter Laursen
>

Peter,

I hope you do not mean "a full export" as in doing "exp full=y" because an export is a logical copy of the data and does not contain any SCN information. Without the SCN information, the Oracle server cannot roll forward data using the redo logs (online and archived) directly. For a more realistic description, see the "Backup and Recovery Guide".

However if you are very keen, you can extract the DML applied to the tables that you have exported from the archive redo logs via the LogMiner utility as long as you do not have any 'special' data types. You may wish to consult Appendix A of "Expert One-on-One Oracle" by Thomas Kyte (A-Press:2003) for an overview or search www.asktom.oracle.com .

Using that DML (assuming that you took a consistent export (consistent=Y) and that you know when the export started), it is very likely that can 'roll forward' the imported copy. Whether you are able to ever to catch up using this method depends when you decide to stop all activity on the tables concerned.

I have not tried this scenario myself because I prefer to be lazy and use RMAN for backup and recovery.

The exp/imp utilities have their place but not realisticly in a database recovery scenario.

Douglas Hawthorne Received on Mon Mar 29 2004 - 17:26:48 CST