生成RMAN rename写法脚本

最新推荐文章于 2024-07-23 19:28:58 发布

道行尚浅

最新推荐文章于 2024-07-23 19:28:58 发布

阅读量1.4k

点赞数 1

分类专栏： ORACLE备份

本文链接：https://blog.csdn.net/daohengshangqian/article/details/51763910

版权

ORACLE备份专栏收录该内容

3 篇文章 0 订阅

订阅专栏


select  'set newname for datafile ' || x.FILE# || ' to ' ||  
       new_file_Location ||   substr(x.NAME,instr(x.name,'/',-1)+1 ,length(x.name)-instr(x.name,'/',-1))                  
  from v$datafile x,(select &new_loc new_file_Location from dual);

实验一下

<pre code_snippet_id="1730831" snippet_file_name="blog_20160626_1_5099860" name="code" class="sql">SQL> select  'set newname for datafile ' || x.FILE# || ' to ' ||  
  2         new_file_Location ||   substr(x.NAME,instr(x.name,'/',-1)+1 ,length(x.name)-instr(x.name,'/',-1))                  
  3    from v$datafile x,(select &new_loc new_file_Location from dual);
Enter value for new_loc: '/home/oracle/'
old   3:   from v$datafile x,(select &new_loc new_file_Location from dual)
new   3:   from v$datafile x,(select '/home/oracle/' new_file_Location from dual)


'SETNEWNAMEFORDATAFILE'||X.FILE#||'TO'||NEW_FILE_LOCATION||SUBSTR(X.NAME,INSTR(X.NAME,'/',-1)+1,LENGTH(X.NAME)-INSTR(X.NAME,'/',-1))
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
set newname for datafile 1 to /home/oracle/system01.dbf
set newname for datafile 2 to /home/oracle/sysaux01.dbf
set newname for datafile 3 to /home/oracle/undotbs01.dbf
set newname for datafile 4 to /home/oracle/users01.dbf
set newname for datafile 5 to /home/oracle/example01.dbf