Re: recovering datafiles while the database is up

  • From: "Tim Gorman" <tim@xxxxxxxxx>
  • To: Carmelinda.Richard@xxxxxxx, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 24 Oct 2011 19:42:18 +0000

They would get an error message.
Doing this while the database is online and applications are active is 
dependent on the probability that the application code would not try to touch 
the corrupted blocks/files. It is a judgement call, but if in doubt, anticipate 
having to request downtime for the entire application(s) during any restore 
operations.


-----Original Message-----
From: Richard, Carmelinda [mailto:Carmelinda.Richard@xxxxxxx]
Sent: Monday, October 24, 2011 12:51 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: recovering datafiles while the database is up

Oracle says you can recover individual blocks or datafiles while the database 
is online. Does that mean you can leave a front-end application connected to 
the database? What would be the effect on users if they attempt to view or 
change data in the corrupted files?Thanks from a newbie 
DBA.--//www.freelists.org/webpage/oracle-l

--
//www.freelists.org/webpage/oracle-l


Other related posts: