The situation described as follows:
After the disk is full, can't log in Oracle, so want to remove some installation package files, as a result of the mistaken delete/Oracle/home/sysdata01 file,
Also have several WEB system connection in this database, WEB system now some modules are not affected, can find the data of normal, but some module is affected, the query error,
In PLSQL, some table (recent) using can check, some table did not, the following error,


The current database is not restart, don't know what's the sysdata01 file? The database how to recover?

CodePudding user response:

Is there a backup? There is one can use the RMAN recovery

CodePudding user response:

No backup, I put the file offline, and then create a new file with the same online, by logging recover again

CodePudding user response:

Brother above, please ask next,//home/oracle sysdate01 what is the function of this file, feel should not be user data files?
Because the oracle installation path is:/u01/app/oracle/product/11.2.0/db_1/
All of the data file in this path:/u01/app/oracle/oradata/tcscb2/

refer to the second floor yaiger response:

no backup, put the file offline, and then create a new file with the same online, again through the log recover

CodePudding user response:

In addition, the/home/oracle/below itself has no special file, the current structure is as follows:

CodePudding user response:

Correct, the path of the above have the wrong number, not/oracle/home,/home/oracle/

CodePudding user response:

This file is not a system, should be a user-defined data files

CodePudding user response:

Have to use the backup,

CodePudding user response:

If the deleted file, as long as not covered, we can from the bottom to recover, as far as possible to reduce the data loss

If really can not be recovered, we can according to the data, the other documents to process the data above the table space, ensure access is not an error

Specific see: precious little fly back