OraFAQ Forum: Backup & Recovery » How to recover Database with no archive

Home » RDBMS Server » Backup & Recovery » How to recover Database with no archive

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

How to recover Database with no archive [message #271815]

Wed, 03 October 2007 01:20

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

Report message to a moderator

Re: How to recover Database with no archive [message #271818 is a reply to message #271815]

Wed, 03 October 2007 01:23

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

Report message to a moderator

Re: How to recover Database with no archive [message #271820 is a reply to message #271818]

Wed, 03 October 2007 01:26

Michel Cadot
Messages: 68653
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

Report message to a moderator

Re: How to recover Database with no archive [message #271822 is a reply to message #271815]

Wed, 03 October 2007 01:29

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Oh! Yes, I focused on title noarchivelog.

Report message to a moderator

Re: How to recover Database with no archive [message #271827 is a reply to message #271820]

Wed, 03 October 2007 01:41

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

Report message to a moderator

Re: How to recover Database with no archive [message #271851 is a reply to message #271827]

Wed, 03 October 2007 02:57

Michel Cadot
Messages: 68653
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

Report message to a moderator

Previous Topic:	EXP-00056:Oracle error 31600
Next Topic:	RMAN recovery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 13:42:40 CDT 2024