Home » RDBMS Server » Backup & Recovery » How to apply archives to roll foward data changes in db?
How to apply archives to roll foward data changes in db? [message #212052] Wed, 03 January 2007 11:44 Go to next message
Messages: 4
Registered: August 2006
Junior Member
Hello, we had an oracle 9i R2 instance ( that started running in archivelog mode on 2006/Dec/16. In that day, we took a cold backup of it (a simple full exp) and let de db in operation generating archivelogs. On 2006/Dec/28 we had a crash in the system and all that we have are the archivelogs and the dump (from the cold backup).

The instance was recreated and the dump was imported over the new created instance using imp with ignore=yes and full=yes parameters set. This put us in the very same state of the db before we started its production operation on 2006/Dec/16. Now, we need to 'import'/recover all the archivelogs generated until the crash (2006/Dec/28) but just can not find how to do it. Have already read some articles in metalink but can't get it to work. Tried a simple "recover database until cancel;" but it does not ask for the archivelog file to recover and almost instantly, shows the "media recovery complete".


SQL> startup mount;
InstÔncia ORACLE iniciada.

Total System Global Area 1141974988 bytes
Fixed Size 456652 bytes
Variable Size 335544320 bytes
Database Buffers 805306368 bytes
Redo Buffers 667648 bytes
Banco de dados montado.
SQL> recover database until cancel;
RecuperaşÒo de mİdia concluİda.


Put the database in archivelog mode and don't know for sure how to specify from where the database should read the archivelog files to recover. I imagine that it is not from archivelog_dest. Can you help me with this issue? Thanks you all in advance.
Re: How to apply archives to roll foward data changes in db? [message #212053 is a reply to message #212052] Wed, 03 January 2007 11:47 Go to previous message
Messages: 2794
Registered: April 2006
Senior Member
You can NOT apply archive logs to an export.
Previous Topic: DataFile Issues
Next Topic: explain about backup and recovery(very urgent)
Goto Forum:

Current Time: Sun Oct 23 13:39:49 CDT 2016

Total time taken to generate the page: 0.14483 seconds