Cacher is the code snippet organizer for pro developers

show parameter standby_file_management

select * from v$recover_file where error like '%FILE%';

select file#,name from v$datafile where file#=536;

alter database create datafile '/oracle/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00536' as '+DATA/INLP/datafile/undotbs9_595_750444337';

alter system set standby_file_management='AUTO' scope=both;