[20201103]set newname for datafile.txt

--//在rman克隆或者不完全恢复时,经常需要执行如上类似命令:

SELECT    'set newname for datafile '
         || file#
         || ' to ''&1'
         || SUBSTR (name, INSTR (name, '/', -1) + 1)
         || ''';'
            c120
    FROM v$dbfile
ORDER BY FILE#;

--//生成的脚本在加入头尾就ok了：

run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
set until time '2020-11-02 05:30:00';
....

restore database;
switch datafile all;
recover database;
release channel c1;
release channel c2;
release channel c3;
}

--//注意环境变量，设置如下，不然可能日期格式不对。
$ env | grep -i nls
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
NLS_TIME_TZ_FORMATx=HH24.MI.SSXFF TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT=YYYY-MM-DD HH24:MI:SS.FF TZH:TZM
NLS_TIMESTAMP_FORMAT=YYYY-MM-DD HH24:MI:SS.FF
NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SS

ITPub博客

[20201103]set newname for datafile.txt

最新文章