Home » RDBMS Server » Backup & Recovery » RMAN from Feb 28th (Oracle 10gr4)
RMAN from Feb 28th [message #501826] Thu, 31 March 2011 17:37 Go to next message
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 #501827 is a reply to message #501826] Thu, 31 March 2011 17:39 Go to previous messageGo to next message
shaneone1
Messages: 8
Registered: August 2009
Junior Member
Wanted to add that I am trying to restore until 3pm on feb 28th.
Re: RMAN from Feb 28th [message #501845 is a reply to message #501827] Fri, 01 April 2011 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can't say more from what you posted.
Check in target alert.log if there was any messages.
Check in target if RMAN session is not waiting for something. It could happen that RMAN was waiting to read the control file.

Regards
Michel
Re: RMAN from Feb 28th [message #501936 is a reply to message #501845] Fri, 01 April 2011 09:36 Go to previous messageGo to next message
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 #501941 is a reply to message #501936] Fri, 01 April 2011 10:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Could be, did you have a look at the alert.log?

Regards
Michel
Re: RMAN from Feb 28th [message #503067 is a reply to message #501941] Tue, 12 April 2011 11:43 Go to previous messageGo to next message
shaneone1
Messages: 8
Registered: August 2009
Junior Member
Hi Michel,
The Alert_log from the target database or the Production database?
Re: RMAN from Feb 28th [message #503072 is a reply to message #503067] Tue, 12 April 2011 11:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Both.

Regards
Michel
Re: RMAN from Feb 28th [message #503213 is a reply to message #503072] Wed, 13 April 2011 10:04 Go to previous messageGo to next message
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.
Re: RMAN from Feb 28th [message #503225 is a reply to message #503213] Wed, 13 April 2011 11:01 Go to previous message
shaneone1
Messages: 8
Registered: August 2009
Junior Member
I'm doing this on another server. And I have been restoring using a particular sequence number.

Thanks guys for the responses so far.
Previous Topic: Control files dropped
Next Topic: Tranfer Database from Windows 2003 32 bit to Windows 2008 64 bit
Goto Forum:
  


Current Time: Thu Mar 28 17:39:55 CDT 2024