How to Recover the Data from a DEFUNCT file in SQL Database?

Answered

By: Sugandh | 30 Dec 2015 5:00 pm | 1 Comments

Hello Experts,

Is there a way to recover my data from a DEFUNCT file in SQL database? The file became DEFUNCT after I deleted the filegroup. I don't have any backup. Is it still possible to recover data from the file ?

Thanks in advance.

Comments

Abhijeet Mudgal |

| 30 Dec 2015 5:01 pm

Helpful answer

First Run Data recovery tool to get your data file. Caution: Your recovery is high when you don't save any new files in the same volume. Your will be lucky if your data files size is small else you need to pay money to purchase the full version.

Recovering Oracle 10G Database With Missing Data File
how to recover 10G database with missing data file: After a bad blocks on hard disk that corrupt data file, I ran fsck to repair the problem, but the datafile been deleted from disk...
How to Read a Hexadecimal Value from a Binary File Using Oracle SQL Loader
I have a Mainframe file which is FTP'ed to Oracle server in Binary. It's a fixed width file having a field with hexadecimal values. I need to read those values and convert those to decimal...
How to Recover Database?
Hello Friends,I have a query that I need to share with you guys. Please have a look:I issued the following command \"rman>backup current controlfile;\" and then I deleted all the controlfiles of...
File management with SQL Server
With the restructuring of hardware or with a lack of space, you may need to change or create individual database files or all database files for the SQL Server. This note describes the file...

Forums

Books

Jobs

Opening for Sr. SAP Basis Consultant @ Bangalore (Immediate
Exp :6 - 15 years | City : Bangalore
SAP Hana Cloud Integeration | 6 - 9 Years | Pune | Atos
Exp :6 - 9 years | City : Pune
SAP with Portuguese & English Langauge Support | 3 - 6 Years
Exp :3 - 6 years | City : Hyderabad
Solution Architect for the Oracle Hyperion EPM Suite | 8 - 1
Exp :8 - 13 years | City : Bangalore
Sr. SAP ABAP FI Developer | 8 - 13 yrs | Hyderabad / Secunde
Exp :8 - 13 years | City : Hyderabad

ASK US !

Get solutions from our experts!

A&D (Aerospace & Defense)
ABAP
About SAP
Android
Announcement of Legal Change
APO (Advanced Planner and Optimizer)
Audit Management
BASIS
BCM (Business Communication Management)
BI (Business Intelligence)
BI Suite - Business Explorer
BO (Business Objects)
BODS (Business Objects Data Services)
BOPF (Business Object Processing Framework)
BPC (Business Planning and Consolidation)
BPM (Business Process Management)
Business ByDesign
Business One
Business Suite
BW (Business Warehousing)
C++
CLM (Contract Lifecycle Management)
Cloud
CRM (Customer Relationship Management)
CS (Customer Service)
Do It Yourself
DSiM (Demand Signal Management)
E-Recruitment
EAM (Enterprise Asset Management)
EC (Enterprise Controlling)
EHS ( Environment, Health, and Safety Management )
EP (Enterprise Portal)
ERP (Enterprise Resource Planning)
Event Management
EWM (Extended Warehouse Management)
FICO (Financial Accounting and Controlling)
FIN-FSCM (Financial Supply Chain Management)
Fiori
FS-BA (Bank Analyzer)
FS-CD (Collections and Disbursements)
GRC (Governance Risk Compliance)
GST (Goods And Service Tax)
GTS (Global Trade Services)
GUI (Graphical User Interface)
GWM (Gateway for Microsoft)
HANA
HCM (HCM Human Capital Management)
HR (Human Resource)
Hybris (SAP E-Commerce Software)
IdM (Identity Management)
IFRS (International Financial Reporting Standards)
IM (Investment Management)
Integration Server
IS (Industry Solutions)
IT Management
Java
KW (Knowledge Warehouse)
Landscape Transformation of Replication Server
Lightroom
Logistics Information System
Lumira
MaxDB
MDM (Master Data Management)
ME (Manufacturing Execution)
MM (Materials Management)
Mobile
MRS (Multi Resource Scheduling)
MySAP
MySQL
NetWeaver
OCM (Order Change Management)
OM (Organisational Management)
Oracle
Oracle SQL
PE (Product Enhancement)
Photoshop
PHP
PI (Process Integration)
PLM (Product Lifecycle Management)
PM (Plant Maintenance)
PO (Process Orchestration)
Point-of-Sale (POS) Data Management (DM)
Postalsoft
PP (Production Planning)
PPM (Portfolio and Project Management)
Predictive Analytics
Project Manager
PS (Project Systems)
Python
QA (Quality Assurance)
QM (Quality Management)
SAP Office
SCM (Supply Chain Management)
SD (Sales and Distribution)
SEM (Strategic Enterprise Management Software)
SEO (Search Engine Optimization)
Shared Service Framework
SOD (Segregation of Duties)
Solution Manager
SQL
SRM (Supplier Relationship Management)
SSO (Single Sign-On)
TAO (Test Acceleration and Optimization)
TDMS (Test Data Migration Server )
Telecommunications
Third Party
TM (Travel Management)
TR (Treasury)
UI5
UNIX
User Experience (UX)
Warranty Management
WEB DYNPRO
Web IDE
Windows
WMS (Warehouse Management System)
XI (Exchange Infrastructure)