Re: Taking Backup from standby database
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 2 Dec 2016 19:37:41 -0500
Message-ID: <3f6fe4b6-fa06-ff63-bdc6-c04bbb811b22_at_gmail.com>
Date: Fri, 2 Dec 2016 19:37:41 -0500
Message-ID: <3f6fe4b6-fa06-ff63-bdc6-c04bbb811b22_at_gmail.com>
On 12/02/2016 07:31 PM, Vadim Keylis wrote:
> I did. Here is there error I am getting when taking backup on standby
> database:
>
> Starting backup at 02-DEC-16
> RMAN-06820: WARNING: failed to archive current log at primary database
> ORACLE error from target database:
> ORA-17629: Cannot connect to the remote database server
> ORA-17627: ORA-00942: table or view does not exist
Ah, your standby is not correctly configured. When you do "BACKUP ARCHIVELOG ALL", Oracle will contact the primary database and perform a log switch there. Try setting up DG Broker, it is an excellent tool for diagnosing problems with the standby DB.
-- Mladen Gogala Oracle DBA Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Sat Dec 03 2016 - 01:37:41 CET