offloading backup of primary database using standby database.
I have a question regarding offloading backup of primary database using standby database.
For example we will consider primary database PRIM on Host A and physical standby database STBY on Host B.
We are not using active standby option in our environment so STBY database will be in mounted mode.
I use following RMAN command for taking backup from standby database:
connect target sys/***@STBY
connect catalog rmancat/***@RMANCAT
backup database plus archivelog format '/oracle/stage/RMAN/%U';
This will create STBY database backup on HOST B at location '/oracle/stage/RMAN/'
Now NFS filessystem '/oracle/stage/RMAN/' is also available on HOST A server.