Start Databse Manually getting Error

[Former Member]

Dear All,

We are using Ecc 6.0 with Eph 4 oracle 10 g with Patch 4

Os Linux 64 Bit Rhel 5.

when i have started Lsnrctl start. it started Succesfully. after thar i go to >SQL promt and right >startup then coming Output Mentioned Below.

1. su - oraprd

yahoo:oraprd 51> sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Sun Nov 13 11:05:40 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

SQL> startup

ORA-01081: cannot start already-running ORACLE - shut it down first

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1191182336 bytes

Fixed Size 2083496 bytes

Variable Size 603981144 bytes

Database Buffers 570425344 bytes

Redo Buffers 14692352 bytes

Database mounted.

ORA-01113: file 4 needs media recovery

ORA-01110: data file 4: '/oracle/PRD/sapdata2/sr3_1/sr3.data1'

SQL> startup

ORA-01081: cannot start already-running ORACLE - shut it down first

SQL> shutdown

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1191182336 bytes

Fixed Size 2083496 bytes

Variable Size 603981144 bytes

Database Buffers 570425344 bytes

Redo Buffers 14692352 bytes

Database mounted.

ORA-01122: database file 4 failed verification check

ORA-01110: data file 4: '/oracle/PRD/sapdata2/sr3_1/sr3.data1'

ORA-01200: actual file size of 121901 is smaller than correct size of 299520

blocks

SQL> exit

ERROR:

ORA-03135: connection lost contact

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options (with complications)

[Former Member]

Thanks Everybody,

Thanks Deepak.

Now Our team is working on Recover Databse. now closing this thread.

With Regards

[former_member188883]

Hi,

ORA-01113: file 4 needs media recovery
ORA-01110: data file 4: '/oracle/PRD/sapdata2/sr3_1/sr3.data1'

Above error is a result of system build using database restore procedure

ORA-01122: database file 4 failed verification check
ORA-01110: data file 4: '/oracle/PRD/sapdata2/sr3_1/sr3.data1'
ORA-01200: actual file size of 121901 is smaller than correct size of 299520 blocks

Above error is a result of difference in the data file state recorded into controfile and its actual size.

Above posts in this thread already have some pointers to it resolution.

From my perspective you have not followed all the steps of system copy procedure. As a result of which you have landed up into these issue. Probably you have tried to open the database without performing proper recovery.

My suggestion here would be to repeat the restoration process and recover the database by applying logs. Later open the database.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi,

You faced with this error because the datafile size and it's size in the control file and header is different.

When did you faced with this error? After restored the database? Althought there are some ways to solve this problem, it requires to play with the datafile which may cause an unexpected result.

For the further information, check the note 696141 - Composite SAP Note: ORA-01122;

1. ORA-01200: actual file size of <act_blocks> is smaller than correct size of <def_blocks> blocks
Reason: The size of a data file does not correspond to the expected size.
Solution: If the problem occurs after you import patch set 8.1.7.4 on HP-UX with a raw device data file larger than 4 GB, it is triggered by bug 2444951. In this case, contact SAP.
           If the problem occurs when you import a patch on WINDOWS, check whether another service is still accessing the data file.

           Otherwise: Restore/recovery

At this stage, i recommend you restore the database from the scratch.

Best regards,

Orkun Gedik

[Former Member]

> Database mounted.
> ORA-01122: database file 4 failed verification check
> ORA-01110: data file 4: '/oracle/PRD/sapdata2/sr3_1/sr3.data1'
> ORA-01200: actual file size of 121901 is smaller than correct size of 299520
> blocks

Error seems clear.

Thanks