Wrong file type v recover_file

Results 1 to 5 of 5. Join Date Oct Posts Join Date Sep Posts Do you have a backup of that datafile and all the archivelogs from that backup to the point the datafile was removed? Read up on "Note At the sqlplus prompt, connect to the database i. If there are any rows returned, note each file number the first column data returned to use later.

To get the database back online, we need to take the files out of backup mode, and bring them online. Multiple commands can be used to take data files out of backup mode. Check for Data Files That Need Recovery This type of recovery will be required for systems that have a sudden loss of power or database crash while not running a tape backup.

Note all file numbers that require recovery. The following commands will assist in the recovery of each of the data files. The examples assume datafiles 12 and 15 need recovery. Type the following SQL examples use file 12 and 15 : Alter database datafile 12 online; Alter database datafile 15 online; After all files are back online, continue to the next step Open the Database. If the database does not open, go to the next step, Recover Database. Type: Shutdown immediate; Startup mount; Recover database; Once these steps are complete, go back to the section Bring All Data Files Online and follow the steps there and in the Open the Database section.

I'd say the general rule should be to avoid backupsets manual manipulation using asmcmd. It should be managed by RMAN. Search BC Oracle Sites. However, as a best practice, you should save the file with a file name extension that reflects its actual file format. As a first step, however, it's important to decide whether or not you trust the source of the file.

If you can't verify that the originator of the file is a trusted source, you shouldn't open the file. A hacker malicious user might have renamed the file with the intent of misleading you to open it in Excel. An issue with a file name extension might occur when a workbook that you are trying to open is unreadable and the contents no longer resemble the expected file format. If a workbook has become corrupted, you can try to repair it before you open it. For information about how to recover a corrupted workbook, see Repair a corrupted workbook.

If you see this message when you try to open a workbook that a trusted source sent to you in an email, you can't open it from your email program. Alternatively, you can save the attached workbook on your computer, and then open it in Excel.