Time/Date of a Log Archive File
606490Nov 3 2007 — edited Nov 3 2007We had a problem here which caused me to have to move logarchive files out of the logarchive filesystem temporarily so that it would not fill. After the DBA fixed and bounced the database, 24 hours later, I copied all of the moved logarchives back into the logarchive directory and ran an RMAN backup.
Now, we're restoring this database for a different reason (to a different server to pull some data), but after restoring the database, I need to restore archive logs only to a particular time. Data was deleted and if I restore past the deletion time, that data is again deleted. But because my logarchives were moved and copied back, the time of their being backed up doesn't coincide with anything that can help me estimate when they were created and I need to be able to restore the db to near a particular time.
My question is, is there a way that I can get the timestamp from a logarchive file? Is there a way to look inside it to get that info?
Thank you.