Replicação OnLine

Esse eu utilizo com criação de chave pública entre servidores usando SSH - consulte
http://dicasoracledba.blogspot.com/2009/11/criando-chaves-publicas-ssh.html

col comando format a300
set linesize 300
set serveroutput on size 100000

spool script.sql

col comando format a300

set linesize 300

set serveroutput on size 100000

set trimspool on

spool script.sql

begin

for rTS in (select tablespace_name from dba_tablespaces) loop

dbms_output.put_line('alter tablespace '|| rTS.tablespace_name ||' begin backup;');

for rDados in (select '!scp -B '|| file_name ||' oracle@10.11.246.131:'||file_name comando from dba_data_files where tablespace_name=rTS.tablespace_name ) loop

dbms_output.put_line(rDados.comando);

end loop;

dbms_output.put_line('alter tablespace '|| rTS.tablespace_name ||' end backup;');

end loop;

dbms_output.put_line('ALTER DATABASE BACKUP CONTROLFILE TO ''/tmp/control_bkp.ctl';'');

dbms_output.put_line('!scp -B /tmp/control_bkp.ctl' oracle@10.11.246.131:/tmp/control_bkp.ctl');

end;

/

spool off;

spool off;