欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

测试1

程序员文章站 2023-09-28 21:10:16
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