This content has been marked as final. Show 4 replies
It depends on the recovery scenario.You can recover the database without archivelog files if the necessary data is available in your online redo log files to make the dabase synchronised.
In your case, if you are recovering the database by restoring 6 months old backup and you want to make the database upto date, you must need archivelog files. Otherwise you have to go for incomplete recovery.
If you have everything online and you just want to restore some data from one table which is 6 months old you can do it without archivelog file.
Thx for the reply.
The process used is as follows:
create snapshot of all DB files
During the backup the logs are written and archived. Usually this logfiles are necessary to get a consistent state after a restore/recovery. My question is what to do if I still have the files from that hot backup but all archives logs are missing.
As you made an inconsistent backup, you will still need the old archivelogs.
If you don't have them anymore, no restore and recovery is possible.
Senior Oracle DBA
Thx for your hint. I just received a explanation from the support. There is a way to get the data by doin the following (in short):
SQL> recover database using backup controlfile until cancel;
WHEN PROMPTED FOR AN ARCHIVELOG FILE TYPE cancel THEN PRESS ENTER.
SQL> ALTER DATABASE OPEN RESETLOGS;
This allows me then to export the data from the DB but the DB itself needs to be rebuild and the data imported to avoid DB corruption.
Message was edited by: