Re: Urgent:DBA question

Victor Slootsky <slootsky_at_erols.com> wrote in article <34568577.7BE487A3_at_erols.com>...
> Data file was corrupted and can't be restored.
> The datafile size does not match the size specified in the control file.
>
> Startup does not go.
> What is the way around?

From RevealNet's Oracle Administration Knowledge Base. A fully-functional demo can be downloaded from http://www.revealnet.com  

To recover from the loss of a single tablespace's data file(s) from X_ORA_DB or X_ORA_IDX:

1. Login to the ORACLE user.
2. If the tablespace that uses the data file is online, take the tablespace off-line with the SQLDBA commands:

		CONNECT INTERNAL 
		ALTER TABLESPACE [name] OFFLINE

		Where [name] is the tablespace name, such as DEV or PROD.

3. Correct the problem, or find a new location for the file(s).

4. Have the system manager recover the latest copy of the data file from the latest Oracle backup tape into the selected location.

5. If the file had to be relocated, alter the name in the Database with the following SQLDBA command to reflect the change:

                ALTER DATABASE RENAME FILE 'old' TO 'new'

                Where 'old' and 'new' are full path file names enclosed in single quotes.

6. Execute the SQLDBA RECOVER command using the TABLESPACE option:

                RECOVER TABLESPACE [name]

                Where [name] is the tablespace name such as DMS or AEONIC.

7. Oracle will prompt for the names of the archive files required, beginning with the oldest file. The archive files are stored in:

                [X_ORA_ARC:[ORACLE.DB_<DB_NAME>]             

All required logs should be online. Each file begins with a DBA specified string followed by filler zero's, then the log number, followed by '.ARC'. The format is specified via the LOG_ARCHIVE_FORMAT parameter in the INIT.ORA file.

8. Once all logs have been applied to the effected tablespace, the system will respond:

                Media recovery complete.

9. Bring the tablespace back online with the SQLDBA command:

                ALTER TABLESPACE [name] ONLINE

                Where [name] is the tablespace name such as DEV or PROD.

 This completes the recovery of the data file.

Best wishes,

Cam White
RevealNet, Inc. Received on Wed Oct 29 1997 - 00:00:00 CET