I have set DEFER on the primary and moved the entire Standby database to another server this way. After I changed the tnsnames and set the primary back to ENABLE Data Guard just picked up where it left off.
set heading off set feedback off set pagesize 100 set linesize 400 select 'scp '||a.name ||' server_name:' || a.name as newname from v$datafile a; select 'scp '||a.name ||' server_name:' || a.name as newname from v$controlfile a; select 'scp '||a.member ||' server_name:' || a.member as newname from v$logfile a;
Fayn_dba wrote:in addition to mseberg copy method....i like to set these parameters
In my environment Oracle database 11gR1 is running & dg is configured i.e >> 1 primary & 1 standby. In near future space issues will arise for standby. I want to create 1 more standby with max disk space, but how?? Active dataguard is configured where report are generated from Standby, i dont have any idea where & what changes should be made in Primary pfile & new standby pfile.