www.dbatoolz.com › ORACLE DBA Forums › Ask DBA › Question Id: 3964 | Permalink

About BAckup

Question ID: 3964
Created By:	2010-MAR-18 20:45:39 [Singireddidba]
Updated By:	2010-MAR-19 14:50:33 [Vitaliy]
Status:	Open
Severity:	Normal
Read Only:	No

11177

2010-MAR-18 20:45:39

Singireddidba

User

Registered On: Feb 2010

Total Posts: 24

Hi 
we lost some data files and we  don't have any full backup and the database was 
running in NOARCHIVELOG mode. What we  can do now?

11183

2010-MAR-19 14:50:33

Vitaliy

Moderator

Registered On: Mar 2006

Total Posts: 289

If you lost the datafiles and have no COLD backup of the complete database you 
are done.  If there's any data (in other tablespaces) that you need from this 
database then you can OFFLINE DROP the MISSING datafiles and it's tablespace -- 
that will let you use the rest of the database.

Learn your lesson -- ARCHIVE MODE = ON + RMAN backups for every database that 
you care about.

Permalink