vi duplicate.sh
rman target 'sys/"oracle"' auxiliary 'sys/"oracle"@backup' << EOF
run {
allocate auxiliary channel c1 type disk;
allocate auxiliary channel c2 type disk;
allocate auxiliary channel c3 type disk;
allocate channel c4 type disk;
allocate channel c5 type disk;
allocate channel c6 type disk;
duplicate target database for standby from active database dorecover;
}
EOF
sh duplicate.sh > /tmp/duplicate.log 2>&1 &
set line 999
col status format a10
col name format a50
select file#, status, bytes/1024/2024/2024 as GB, name from v$datafile;
set line 999
col file_name format a50
col tablespace_name format a20
select tablespace_name, status, file_name, bytes/1024/1024/1024 as GB from dba_temp_files;
再次执行duplicate
貌似成功了!!!
备库启动MRP进程