测试1

test * [ ] ““ ——- > ——- ——- ——- ——- ——- ~~_***nohup rman target / cmdfile=rman.sql msglog=rman.log & ####select ‘set newname for datafile ‘||file#||’ to ‘+r9t24db/orat24a/datafile’||substr(name,instr(name,’/’,-1))||’;’ from v$datafile where ts# not in (8,10); select ‘set newname for datafile ‘||file# ||’ to ‘ || ””|| ‘/data1/oradata/acct’||substr(name,instr(name,’/’,-1))||””||’;’ from v$datafile; 同名datafile select * from (select substr(name,instr(name,’/’,-1)+1) a,count(1) b from v$datafile group by substr(name,instr(name,’/’,-1)+1)) where b>1; select a.file# from v$datafile a,v$tablespace b where a.ts#=b.ts# and b.name in (‘tbs_partition_indx’,’tbs_user_ibss_data’); select file# from v$datafile_header where checkpoint_time is null ***********skip tablespace export oracle_sid=orat24a . ~/env11 rman target / log=restore_data.log append