Q

Archive files not automatically transferring after power failure

I'm working as a DBA in a hospital. Currently there are two servers, 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.

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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close