Manual Archive Shipping From Prod to Standby

Standby Archive Location:/arch_destination/Arch/

Scp from Prod to standby :go to the archive location and then give scp command.

PROD:

[Prod.DB]scp *65351* oracle@10.80.34.90:/arch_destination/Arch/

[Prod.DB]scp *65352* oracle@10.80.34.90:/arch_destination/Arch/

After SCP:Register the Archive logfile

Standby:

alter database register logfile '/arch_destination/Arch/1_65351_1016024259.dbf';

alter database register logfile '/arch_destination/Arch/1_65352_1016024259.dbf';

MRP:

Stop & Start.

 Start MRP Process:

==================

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Stop MRP Process:
==================

 ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

 

 Note:Archive log should be available in physical location in both prod & standby if not ,we need to move it manually by below steps