test* [ ] ````-------> -----------------------------------~~_***nohup rman target / cmdfile=rman.sql msglog=rman.log &####select 'set newname for data... ...
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<
