Re: Is ADG required for backing up from a standby

The explanation for that is really simple: without the catalog, rman records the backup into the database control file.  Without the catalog, rman will only recognize the backups recorded in the control file. As standby control file and primary control file are different,  primary will not recognize the standby backup as its own. On the other hand, DBID is the primary key for the catalog tables and the primary has the same DBID as the standby so rman catalog will immediately recognize that backups of those 2 databases are backups of the same database. There are some nuances there: backup of the control file on the standby are backups of standby control file. You will need control file backup on the primary side. You will also need to clean archive logs on both sides. I usually backup the logs on the primary and delete them on the standby side.

However, this is the usual practice on busy primary databases. Backups are expensive and sometimes disruptive. Standby DB, especially if it isn't an ADG, doesn't do much work so it can be safely used for backup.

On 4/19/21 4:22 PM, Andrew Kerber wrote:
> ADG is not required, however you must use an rman catalog in order to
> do it.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

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