Home » RDBMS Server » Backup & Recovery » Hot dmp backup + recovery (Windows)
Hot dmp backup + recovery [message #601918] Wed, 27 November 2013 05:38 Go to next message
azoracle
Messages: 8
Registered: November 2013
Junior Member
Embarassed

Hello!
I have a hot backup (dmp) and my oracle is in archivelog mode.
I had a problem with oracle and i reinstall oracle10g and restire the last backup.
I want to ask how can get the last transaction in my new database reading from the archivelogs before the problem?

Thanks u all end best regards.

Report message to a moderator

Re: Hot dmp backup + recovery [message #601919 is a reply to message #601918] Wed, 27 November 2013 05:59 Go to previous messageGo to next message
gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, UK
Senior Member
Look at LogMiner.

HTH
-g

Report message to a moderator

Re: Hot dmp backup + recovery [message #601921 is a reply to message #601919] Wed, 27 November 2013 06:11 Go to previous messageGo to next message
azoracle
Messages: 8
Registered: November 2013
Junior Member
Ok let me read from there, i'll be back

Report message to a moderator

Re: Hot dmp backup + recovery [message #601923 is a reply to message #601918] Wed, 27 November 2013 06:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If your "backups" are (export) dumps then they are not database backup but just data backup and you can't apply archived logs on them you can just create a new database and import your dump at the time when the dump was created and you lose everything that have been done since.

Regards
Michel

Report message to a moderator

Re: Hot dmp backup + recovery [message #601946 is a reply to message #601923] Wed, 27 November 2013 11:45 Go to previous messageGo to next message
azoracle
Messages: 8
Registered: November 2013
Junior Member
Thk u Michel! so i should make a database backup via rman for example at 12 o'clock and when i have problem at 18'; i just restore this database backup of 12' and apply archivelogs??? and how can i apply them??? very nice to here you teching oracle!

Report message to a moderator

Re: Hot dmp backup + recovery [message #601947 is a reply to message #601946] Wed, 27 November 2013 11:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You just have to execute "recover database;" RMAN command, or if you lose some database files "restore database; recover database;" and RMAN will find what it needs to do the job.

Report message to a moderator

Re: Hot dmp backup + recovery [message #601990 is a reply to message #601947] Thu, 28 November 2013 03:38 Go to previous message
azoracle
Messages: 8
Registered: November 2013
Junior Member
Thanks a lot!!!!!!!!!!!!!!!!!!

Report message to a moderator

Previous Topic: Oracle software desintall inadvertently
Next Topic: Oracle Queue tables gets corrupted
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 02 07:00:19 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.