| RMAN from Feb 28th [message #501826] |
Thu, 31 March 2011 17:37  |
shaneone1
Messages: 8
Registered: August 2009
|
Junior Member |
|
|
Hi guys,
I have an scheduled RMAN backup that kicks off everyday around 2pm, goes to an external hard-drive and only the last two backups are kept on that hard-drive since the backup is roughly around 292GB. Archive logs are only kept up to 14days. RMAN manages this and deletes them for us. Now I saved a backup from Feb 28th, I have archive logs all the way to about 7:15pm and I am trying to create a clone database up until around 3pm using a restore by sequence number. Now I've created lots of clones but for some reason this restore just stops at "Starting Duplicate Db at 24-mar-11" for no apparent reason. Bad backup maybe? I'll attach the logs and maybe someone can help me out here.
Thanks
|
|
|
|
|
|
|
|
| Re: RMAN from Feb 28th [message #501936 is a reply to message #501845] |
Fri, 01 April 2011 09:36  |
shaneone1
Messages: 8
Registered: August 2009
|
Junior Member |
|
|
Trying to read the control file on the production server? Or the soon to be clone, because the soon to be clone doesn't have a control file yet. I unfortunately do not have the alert log from that far back. I have the Rman backup log from that day though. No errors are noted inside the backup. It wouldn't have anything to do with the RMAN recovery catalog only keeping 14 days back worth of archive logs would it?
Thanks for your reply
[Updated on: Fri, 01 April 2011 09:37] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: RMAN from Feb 28th [message #503213 is a reply to message #503072] |
Wed, 13 April 2011 10:04 |
kudur_kv
Messages: 75
Registered: February 2005
|
Member |
|
|
Are you doing this on teh same server as the production DB or on a different server?
If you are doing on a different server, then you will do better to simply do a full recovery (retore controlfile from backup).
You should be able to restrict the recovery up the time you want by using the 'restore database until' command with the option of either time, SCN(which i doubt you'd have handy) or the sequence number.
If you are trying to do this on the same server as the production DB and with all the restrictions you have mentioned, you will probably need lady luck literally standing next to you.
Hope that helps.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
