Home » SQL & PL/SQL » SQL & PL/SQL » HELP! sql server dba covering Oracle
HELP! sql server dba covering Oracle [message #10592] Mon, 02 February 2004 07:27
Adria
Messages: 3
Registered: August 2003
Junior Member
OK.  So I'm probably every Oracle DBA's biggest nightmare... a SQL Server DBA called in to cover for an Oracle DBA.

And, as luck would have it, we've had a disk error come up and I hardly even know where to start.

Can someone tell me how to:
(1) find a list of all datafiles that are on the same disk as the one bad datafile we've identified?
(2) take the selected files offline before shutting down the database (when file restores will begin)?

I'm in need of some very quick assistance, so I would appreciate any available help.

TIA,
Adria
a-carbo@tamu.edu
Previous Topic: create multiple instances on database
Next Topic: How to Update a DATE type item?
Goto Forum:
  


Current Time: Fri Apr 26 04:02:34 CDT 2024