Home » RDBMS Server » Backup & Recovery » restoring backup (oracle ,10.2.0.4,sun solaris)
restoring backup [message #416306] Fri, 31 July 2009 10:07 Go to next message
replicated
Messages: 31
Registered: July 2009
Member
Hi

I have a doubt.
If i have level 0 backup from 01-07-09 and another level 0 backup from 30-07-09 on tape and no backup of archivelogs between 01-07-09 and 30-07-09(between two backups).
Cani restore the db till 15-07-09.

Regards
Re: restoring backup [message #416307 is a reply to message #416306] Fri, 31 July 2009 10:11 Go to previous messageGo to next message
BlackSwan
Messages: 23133
Registered: January 2009
Senior Member
>Cani restore the db till 15-07-09.
no
Re: restoring backup [message #417117 is a reply to message #416307] Thu, 06 August 2009 03:43 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
WHY, your are telling NO, i think we can restore upto 15-07-09
he having backup upto 30-07-09, backup means all transaction uptp 30-07-09.

example, if he have backup upto 10-07-09 and dont have archive log, in this case if he wants restore up to 15-07-09 is difficult, bcause he having backup uptp 10-07-09 and he dont have archivelog
Re: restoring backup [message #417118 is a reply to message #417117] Thu, 06 August 2009 04:02 Go to previous messageGo to next message
ThomasG
Messages: 3121
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:
i think we can restore upto 15-07-09


Then show us EXACTLY how. Because I think it's not possible, too.
Re: restoring backup [message #417152 is a reply to message #417117] Thu, 06 August 2009 05:22 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
goracle9 wrote on Thu, 06 August 2009 04:43

example, if he have backup upto 10-07-09 and dont have archive log, in this case if he wants restore up to 15-07-09 is difficult, bcause he having backup uptp 10-07-09 and he dont have archivelog

Are you saying you do NOT have backups of the archivelogs, BUT you do actually have the archivelogs between 01-07-09 and 15-07-09 available?
Re: restoring backup [message #417176 is a reply to message #417118] Thu, 06 August 2009 06:43 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
if we have backup upto 30-07-09, then we want restore upto 15-07-09, we can do that by

RECOVER DATABASE UNTIL TIME '2009-07-15:12:00:00'

am i correct???
Re: restoring backup [message #417178 is a reply to message #417176] Thu, 06 August 2009 06:51 Go to previous messageGo to next message
ThomasG
Messages: 3121
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You would be correct if there had been a backup of the archive logs.

But since the person with the problem clearly stated "no backup of archivelogs", you can only restore a backup at the time of the level 0 backups. So either 01-07-09 OR 30-07-09, not anything in between.
Re: restoring backup [message #417181 is a reply to message #417176] Thu, 06 August 2009 06:56 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
goracle9 wrote on Thu, 06 August 2009 07:43
if we have backup upto 30-07-09, then we want restore upto 15-07-09, we can do that by

RECOVER DATABASE UNTIL TIME '2009-07-15:12:00:00'

am i correct???


If we have ALL our questions answered MAYBE we could answer your questions !!!

Re: restoring backup [message #417255 is a reply to message #416306] Thu, 06 August 2009 14:34 Go to previous messageGo to next message
replicated
Messages: 31
Registered: July 2009
Member
thanks all for the replies .

As i dont have any test system to try to restore to a point which is earlier than a level 0 backup taken.I was wondering if someone has actually faced or done this before..If anybody wants to try to test it..please do post your findings..it would be grateful to all..
Re: restoring backup [message #417260 is a reply to message #416306] Thu, 06 August 2009 15:19 Go to previous messageGo to next message
BlackSwan
Messages: 23133
Registered: January 2009
Senior Member
>As i dont have any test system
Since Oracle can be installed on any PC or laptop, I find this "excuse" to be nothing more than a total cop-out.
You have no legitimate reason not to have a functioning Oracle in front of you whenever you are online.
You don't need multiple GB of storage to run most applications.
RMAN can backup empty or sparse tables with the same commands that are used in Production.
Re: restoring backup [message #419407 is a reply to message #416306] Fri, 21 August 2009 22:37 Go to previous message
purple73
Messages: 7
Registered: August 2009
Junior Member
If you want to restore a particular date/time in past - you need to have backups taken prior to that data/time and all archived logs leading to that date and time since the backup initiated.

Based on the details you have provided if you want to restore prior to Jul 15, then you need to have backups performed before that date and time and all the archived logs since the backup initiated.

If you only have backups that you have documented then you cannot restore to the point you are hoping to restore to.
Previous Topic: database migration from MS SQL Server 7.0 to Oracle Database 9i.
Next Topic: Can I Use These RMAN backups
Goto Forum:
  


Current Time: Wed Dec 17 18:53:12 CST 2014

Total time taken to generate the page: 0.10900 seconds