Oracle Point in time Recovery while no archivelog is created

All posts relating to Oracle database administration.

Moderator: Tim...

Senior Member
Posts: 208
Joined: Wed Feb 09, 2011 7:07 am

Oracle Point in time Recovery while no archivelog is created

Postby peterx » Wed Oct 10, 2012 3:31 pm

hi Tim,

I have a question want to ask:

I have a oracle database running in archivelog mode.

This oracle instance finished a full backup at 15:00pm every day and will delete all the archivelog together.

if only a few transactions is finished while no any archivelog is created at the time = 15:00pm to 15:30pm,
then i take another full backup at 16:00pm.

Then, i transfer this 16:00pm full backup to another machine.

Seems, 1500 - 1530 have no archivelog is created, PIT recovery needs archivelog to re-apply the changes.
Can I restore and recover this database to the time of 15:15pm ?


Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Oracle Point in time Recovery while no archivelog is cre

Postby Tim... » Wed Oct 10, 2012 5:01 pm


Your backup will/should include a log switch, which will force a new archived redo log to be created, thus filling in the gap.

Typically, what I would expect to see is:

- Backup Database.
- Log Switch.
- Backup archived redo logs.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 2 guests