Home » RDBMS Server » Backup & Recovery » recovery (10.1.0.2)
recovery [message #281657] Sun, 18 November 2007 23:48 Go to next message
pratik123
Messages: 41
Registered: October 2007
Location: hyderabad
Member
Hi seniours

How do we recover from the loss of datafile if the DB is running in NOARCHIVELOG mode?

please give me some idea i am new persion as dba

Report message to a moderator

Re: recovery [message #281662 is a reply to message #281657] Sun, 18 November 2007 23:55 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>How do we recover from the loss of datafile if the DB is running in NOARCHIVELOG mode?
You do NOT recover when in NOARCHIVE mode.
You have nothing with which to recover.
The data is gone. Such is life.

Report message to a moderator

Re: recovery [message #281672 is a reply to message #281657] Mon, 19 November 2007 00:17 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
Restore , recover no...

Report message to a moderator

Re: recovery [message #281689 is a reply to message #281657] Mon, 19 November 2007 00:56 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
How do we recover from the loss of datafile if the DB is running in NOARCHIVELOG mode?
Restore last valid backup or open your database and lost your all data after last backup.

Report message to a moderator

Previous Topic: Can I recovery the whole Database from failed media?
Next Topic: rman
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 20 08:17:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.