Ask the Expert

Archive files not automatically transferring after power failure

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.

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: