Re: Taking Backup from standby database

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: Vadim Keylis <vkeylis2009@xxxxxxxxx>
  • Date: Fri, 2 Dec 2016 19:37:41 -0500

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

--
//www.freelists.org/webpage/oracle-l


Other related posts: