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
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: 25050
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.
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...
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.
Previous Topic: Can I recovery the whole Database from failed media?
Next Topic: rman
Goto Forum:
  


Current Time: Sat Dec 10 03:10:12 CST 2016

Total time taken to generate the page: 0.23176 seconds