Restore views, parameter, commands

Put the data file offline

alter database datafile 4 offline; - data file ID used to identify datafile.

alter database datafile ’<DATA_FILE_LOCATION>\DATAF01.DBF’ offline;

From this view  you can get data file id`s

select file_id, file_name from dba_data_files;

Renaming data file name is used when changing data file location:

alter database rename file ’<DATA_FILE_OLD_LOCATION>/system01.dbf’ to ’<DATA_FILE_NEW_LOCATION>/system01.dbf’;

Recovering database:

recover database
recover tablespace
recover datafile

Figuring Out Which archived Redo logs You need from views:
V$RECOVER_FILE
V$LOG_HISTORY

Select a.file#, a.change#, b.first_change#, b.next_change#, b.sequence# from v$recover_file a, v$log_history b

To find the a name of the archived log use the V$ARCHIVED_LOG view:

Select a.file#, a.change#, b.first_change#, b.next_change#,
b.sequence#, b.name
from v$recover_file a, v$archived_log b
where a.change#<=b.next_change#;