Home » RDBMS Server » Backup & Recovery » Extract archivelog from backupset. (Linux, 10g)
Extract archivelog from backupset. [message #349447] Sun, 21 September 2008 21:08 Go to next message
Bangla
Messages: 49
Registered: August 2008
Member
Can I apply archive log from a database backupset?
I have full backups of database to date 15. And a full backup of database at date 16. No archive between them. Can I restore my database to any point between 15 and 16?
Re: Extract archivelog from backupset. [message #349452 is a reply to message #349447] Sun, 21 September 2008 21:55 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You originally say that you want to "apply archivelogs from a database backupset", then you mention that you don't have archivelogs ??

If you don't have any archivelogs between the 15th & 16th backups, then no you can not restore to a time between those times (course this is assuming that the redo logs have completely switched out between those times). If you do have the archivelogs, then you can restore between those two times.

[Updated on: Sun, 21 September 2008 21:57]

Report message to a moderator

Re: Extract archivelog from backupset. [message #349540 is a reply to message #349452] Mon, 22 September 2008 02:56 Go to previous messageGo to next message
dilip56
Messages: 6
Registered: September 2008
Junior Member
You cannot do a point in time recovery untill and unless you have the archive logs till that praticular time. here since you are having only full backups on 15th and 16th, and dont have any archive logs between these days, you cannot restore the database to any time between 15 and 16.

[Updated on: Mon, 22 September 2008 02:57]

Report message to a moderator

Re: Extract archivelog from backupset. [message #349595 is a reply to message #349540] Mon, 22 September 2008 05:33 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
dilip56 wrote on Mon, 22 September 2008 03:56
You cannot do a point in time recovery untill and unless you have the archive logs till that praticular time. here since you are having only full backups on 15th and 16th, and dont have any archive logs between these days, you cannot restore the database to any time between 15 and 16.


Pretty much a complete re-hash of what has already been stated. How does this add any substantive value?
Previous Topic: ORA-01033 - Oracle Initialization in Progress
Next Topic: Performance impact in backup mode
Goto Forum:
  


Current Time: Wed Dec 04 19:48:26 CST 2024