This forum is currently locked. You can't register or post questions at this time. (read more)

Disk have become damage and we have datafile on it.

All posts relating to Oracle database administration.

Moderator: Tim...

dba707
Member
Posts: 9
Joined: Thu Mar 14, 2013 8:44 pm

Disk have become damage and we have datafile on it.

Postby dba707 » Wed Mar 20, 2013 1:21 pm

I have some datafiles were there on a secondary disk and that disk has become damaged and new disk at this time not available. How will I recover from this situation?

Ibrahim

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Disk have become damage and we have datafile on it.

Postby Tim... » Wed Mar 20, 2013 1:46 pm

Hi.

- Restore them from a backup.
- Rename the files. http://www.oracle-base.com/articles/mis ... php#manual
- Recover them.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

dba707
Member
Posts: 9
Joined: Thu Mar 14, 2013 8:44 pm

Re: Disk have become damage and we have datafile on it.

Postby dba707 » Thu Mar 21, 2013 1:51 pm

Thanks Tim,
It's worked.

Your help is much appreciated.

Ibrahim

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Disk have become damage and we have datafile on it.

Postby Tim... » Thu Mar 21, 2013 2:20 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 4 guests

cron