| RMAN recovery not working as I expected [message #690448] |
Mon, 29 December 2025 12:01  |
 |
jacklieb
Messages: 2
Registered: December 2025
|
Junior Member |
|
|
It will be difficult, but I'll try to be as brief as possible...
I'm working on a db refresh process that will use storage vendor snapshots and roll-forward to a point-in-time using rman recover. I created a test table in the source database and logged the current log sequence number. I copied the snapshot to the target server and I'm trying to get rman to perform an "until time" recovery. The rman logfile actually shows it finding the log sequence number in online redo and states: "media recovery complete". However, the table i created in the source is not there after open resetlogs.
Here's a log snippet:
starting media recovery
archived log for thread 1 with sequence 11780 is already on disk as file /u02/oradata/vtxprd/redo02a.log
archived log file name=/u02/oradata/******/redo02a.log thread=1 sequence=11780
media recovery complete, elapsed time: 00:00:00
Finished recover at 29-dec-2025 11:04:50
I'll happily provide more details if there's someone willing to help. I will say this - I do put the database in backup mode prior to taking the daily snapshot (I knew youd ask that). I can get this process to work but only up to the time the snapshot was taken. I can't get this figured out and really could use some help. I've seen and used many good posts from this site so I know there's someone who can help.
Thanks - Jack
|
|
|
|
|
|
|
|
| Re: RMAN recovery not working as I expected [message #690451 is a reply to message #690449] |
Mon, 05 January 2026 06:51  |
John Watson
Messages: 8996
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
There may be something else going on.
The presence or absence of online logfiles should have no effect on whether or not recovery will use archive logfiles, but if you delete them you will not be able to do a complete recovery: you can recover only up to the last archive logfile. Is that what you want? To deliberately lose all work after the last archive?
You have found a solution that works for you, but be aware that it may not be appropriate for all situations.
HT, John.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
