Oracle Point in time Recovery while no archivelog is created

[peterx]

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...]

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...