道行尚浅（老道）的博客

REM ------------------------------- REM Script to monitor rman backup/restore operations REM To run from sqlplus: @monitor '' REM Example: --SQL>spool monitor.out --SQL>@monitor '06-aug-12 16:38:

RMAN> startup nomount connected to target database (not started) Oracle instance started Total System Global Area 289406976 bytes Fixed Size 1219016 bytes Variable Size

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, '