测试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
下一篇: php中流行的rpc框架详解