Home » RDBMS Server » Backup & Recovery » Hot backups without archive logs (Database 11G RHEL)
Hot backups without archive logs [message #433471] Wed, 02 December 2009 08:40 Go to next message
bank_master
Messages: 71
Registered: April 2007
Location: Guyana
Member

hi we took a hot backup of our system and placed ut ti another machine but we dont have the archive logs can we still recover the database up to that point.

thanks
Re: Hot backups without archive logs [message #433475 is a reply to message #433471] Wed, 02 December 2009 08:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Most likely no.

Regards
Michel
Re: Hot backups without archive logs [message #433476 is a reply to message #433475] Wed, 02 December 2009 08:52 Go to previous messageGo to next message
bank_master
Messages: 71
Registered: April 2007
Location: Guyana
Member

so is there anything that can be done.
Re: Hot backups without archive logs [message #433477 is a reply to message #433476] Wed, 02 December 2009 09:01 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

No it's impossible
To bring database to point in time, you need to apply archived redo log files. Having no archived redo log files, you can't bring database to past point in time
Re: Hot backups without archive logs [message #433480 is a reply to message #433477] Wed, 02 December 2009 09:06 Go to previous messageGo to next message
bank_master
Messages: 71
Registered: April 2007
Location: Guyana
Member

The database being recovered is not to point in time i just want to know if it will come back up at all and be of use its for testing actually. I heard that at least one log needs to be applied.

Kieron
Re: Hot backups without archive logs [message #433482 is a reply to message #433480] Wed, 02 December 2009 09:12 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Quote:
heard that at least one log needs to be applied.


As far as I know, you can't recover database. Do you have any proof on this?

- Babu
Re: Hot backups without archive logs [message #433489 is a reply to message #433482] Wed, 02 December 2009 09:32 Go to previous messageGo to next message
bank_master
Messages: 71
Registered: April 2007
Location: Guyana
Member

The situation is this i have the hot backup but i dont have any archive logs. I have never had this situation we have done recoveries before with archive logs and all was fine, unfortunately this time all were deleted before being backed up. My question is would the recovery bring the database up to the backup point and no further, the data point doesnt matter just getting a database point in time doesnt matter.
Re: Hot backups without archive logs [message #433491 is a reply to message #433489] Wed, 02 December 2009 09:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
the database up to the backup point

The main problem is that there is NO backup point, there is a backup period that starts when you start the backup and end when you finished to back up the last file.
This is why you at least need the logs that were generated during this period.

Regards
Michel
Re: Hot backups without archive logs [message #433492 is a reply to message #433491] Wed, 02 December 2009 09:44 Go to previous messageGo to next message
bank_master
Messages: 71
Registered: April 2007
Location: Guyana
Member

ok, thanks Michael would it matter if the database was not in use when the backup was taken?

Kieron
Re: Hot backups without archive logs [message #433493 is a reply to message #433492] Wed, 02 December 2009 09:46 Go to previous messageGo to next message
BlackSwan
Messages: 25049
Registered: January 2009
Location: SoCal
Senior Member
bank_master wrote on Wed, 02 December 2009 07:44
ok, thanks Michael would it matter if the database was not in use when the backup was taken?

Kieron

If the DB was open, during backups, then the restore will be inconsistent.
Re: Hot backups without archive logs [message #433495 is a reply to message #433493] Wed, 02 December 2009 09:56 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
The situation is this i have the hot backup but i dont have any archive logs.


Yes you can. Using redo log you can recover database.

http://www.orafaq.com/forum/m/425069/80704/#msg_425069

[Updated on: Wed, 02 December 2009 09:56]

Report message to a moderator

Re: Hot backups without archive logs [message #433496 is a reply to message #433493] Wed, 02 December 2009 09:56 Go to previous messageGo to next message
bank_master
Messages: 71
Registered: April 2007
Location: Guyana
Member

Sad guess i'll have to try with an import then.

Thanks alot guys.

Kieron
Re: Hot backups without archive logs [message #433500 is a reply to message #433495] Wed, 02 December 2009 10:10 Go to previous message
bank_master
Messages: 71
Registered: April 2007
Location: Guyana
Member

A ray of hope i'll look into this and get back to u, thanks a lot gentlebabu.
Previous Topic: 8i "until change is before resetlogs" error
Next Topic: Need to recover SYSTEM file
Goto Forum:
  


Current Time: Fri Dec 09 11:52:54 CST 2016

Total time taken to generate the page: 0.04911 seconds