question

[Amjadbo]

Good Morning

you have a current control file and SPFILE but all datafiles are
damaged or lost. You must restore and recover the whole database.

The database has one read-only tablespace(ITEM_TS), which must be restored
from backup but which does not need media recovery.

Write the commands and scripts needed to restore and recover the
database when the current control file is available.

thx

[gandolf989]

Assuming that your environment variables are correct and you are using Linux and logged in as the Oracle user.

rman

connect target /

startup nomount;

catalog start with '/u01/orabackup/mydatabasebackup';

RESTORE CONTROLFILE;

alter database mount;

restore database;

recover database;

alter database open resetlogs;

Do you have a valid backup? Do you have access to all of the archive logs that you need?
Will you need to do an incomplete restore given that you don't have all of the redo?
I don't know, since you did not say. But the answer is in the url below.

http://docs.oracle.com/cd/E11882_01/...e10642/toc.htm

As a DBA doing a restore is something that you test and practice so that if you ever need
to do a restore in a real situation you aren't then trying to learn how to do it and hoping
that you have what you need. Practice in advance and know that you have what you need.