This forum is currently locked. You can't register or post questions at this time. (read more)

Oracle Point in time Recovery while no archivelog is created

All posts relating to Oracle database administration.

Moderator: Tim...

peterx
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 ?


thanks.

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

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

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

Hi.

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.

Cheers

Tim...
Tim...
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: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 7 guests

cron