Home » RDBMS Server » Backup & Recovery » How to recover Database with no archive
How to recover Database with no archive [message #271815] Wed, 03 October 2007 01:20 Go to next message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
HI

I am practising recovery with RMAN hot backup.

I Don't have any archive and am trying to recover with at least less data lose.

could any one guide me for this

Database - Oracle 10.2.0.3.0 Standard Edition

O/S - Windows 2003 server

Thanks regards
Re: How to recover Database with no archive [message #271818 is a reply to message #271815] Wed, 03 October 2007 01:23 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmrecov001.htm#sthref719
Re: How to recover Database with no archive [message #271820 is a reply to message #271818] Wed, 03 October 2007 01:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Arju,
If OP did a hot backup then it was in ARCHIVELOG mode, so link to NOARCHIVELOG mode is useless.

aslamkhalife,
If you didn't also backup archived logs, I'm afraid your hot backup is useless (unless you are very lucky).

Regards
Michel
Re: How to recover Database with no archive [message #271822 is a reply to message #271815] Wed, 03 October 2007 01:29 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Oh! Yes, I focused on title noarchivelog.
Re: How to recover Database with no archive [message #271827 is a reply to message #271820] Wed, 03 October 2007 01:41 Go to previous messageGo to next message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
Hi Michel,

then what should i do is there way that i can recover with less data loss.


Thanks & Regards
Re: How to recover Database with no archive [message #271851 is a reply to message #271827] Wed, 03 October 2007 02:57 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing, you're out of luck.
Next time also save your archived logs.

Regards
Michel
Previous Topic: EXP-00056:Oracle error 31600
Next Topic: RMAN recovery
Goto Forum:
  


Current Time: Sat Dec 10 07:11:54 CST 2016

Total time taken to generate the page: 0.04401 seconds