I'm working as a DBA in a hospital. Currently there are two servers (HP Proliant ML 370 and Oracle8i), one running as a primary server and the other working as a standby server. An archive file generated in the primary server transfers automatically to the standby server. Due to a power failure in the hospital, now archive files from the primary server are not transferring to the standby server. Kindly provide me with the solution for manually transferring the archive file from the primary server to the standby server.
Note: I have already transferred total gap archive file from primary server to standby server and started the standby server in recovery mode ("Recover managed standby database"). When I have typed the following command on the SVRMGR prompt ("alter system archive log current") the archive file that is created on the primary server does not automatically tranfer to the standby server.
To manually ship archived redo logs, use any file transfer mechanism. For instance, you can copy the missing archived redo logs to the standby database with FTP. Or, you can burn the logs to a CD or DVD and use a "sneaker-net" approach. This should only be a one-time solution as your newly generated archived redo logs should be shipped to the standby database automatically.
If your newly generated archived redo logs are not automatically shipped, then it is most likely due to a network issue or a configuration issue. Verify that your LOG_ARCHIVE_DEST_n parameters are set correctly. Also verify that you have network connectivity between the servers.
This was first published in April 2006