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 ?
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
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
Who is online
Users browsing this forum: No registered users and 10 guests