OraFAQ Forum: Backup & Recovery » Hot backups without archive logs

Home » RDBMS Server » Backup & Recovery » Hot backups without archive logs (Database 11G RHEL)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Hot backups without archive logs [message #433471]

Wed, 02 December 2009 08:40

bank_master
Messages: 73
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

Report message to a moderator

Re: Hot backups without archive logs [message #433475 is a reply to message #433471]

Wed, 02 December 2009 08:50

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Most likely no.

Regards
Michel

Report message to a moderator

Re: Hot backups without archive logs [message #433476 is a reply to message #433475]

Wed, 02 December 2009 08:52

bank_master
Messages: 73
Registered: April 2007
Location: Guyana

Member

so is there anything that can be done.

Report message to a moderator

Re: Hot backups without archive logs [message #433477 is a reply to message #433476]

Wed, 02 December 2009 09:01

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

Report message to a moderator

Re: Hot backups without archive logs [message #433480 is a reply to message #433477]

Wed, 02 December 2009 09:06

bank_master
Messages: 73
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

Report message to a moderator

Re: Hot backups without archive logs [message #433482 is a reply to message #433480]

Wed, 02 December 2009 09:12

babuknb
Messages: 1736
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

Report message to a moderator

Re: Hot backups without archive logs [message #433489 is a reply to message #433482]

Wed, 02 December 2009 09:32

bank_master
Messages: 73
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.

Report message to a moderator

Re: Hot backups without archive logs [message #433491 is a reply to message #433489]

Wed, 02 December 2009 09:41

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator