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?

04-25-2003, 12:08 PM

aarroyob

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

Try first:

sqlplus> recover database;
sqlplus> alter database open;

Cheers

04-25-2003, 11:43 PM

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?