ORA-01113: file 1 needs media recovery

[yls177]

SVRMGR> startup
ORACLE instance started.
Total System Global Area 18538956345 bytes
Fixed Size 76934 bytes
Variable Size 363345334 bytes
Database Buffers 457235340 bytes
Redo Buffers 34637221 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/SAP/sapdata1/system_1/system.data1'


http://www.cryer.co.uk/brian/oracle/ORA01113.htm

from the link ,
"If the database is a standby database then check the procedure for copying the file in the first place. A common mistake is to perform a hot backup of a database but without issuing a ‘alter tablespace ... begin backup ... end backup’ for the tablespace in question.

Once the media error has been recovered from the database can be opened normally (i.e. ‘startup’ or ‘alter database open’).

is it right?

[aarroyob]

Nop, as the error say your file needs media recovery.

Try first:

sqlplus> recover database;
sqlplus> alter database open;

Cheers

[yls177]

can i do the below?


alter database mount;


basically, do these two

alter database open;

alter database datafile 'output of the above' end backup;

and then repeats, depending on the number of datafiles which are affected?