Database Backup and Recovery (MOSC)

MOSC Banner

offloading backup of primary database using standby database.

edited Nov 26, 2012 11:50PM in Database Backup and Recovery (MOSC) 3 commentsAnswered ✓
Hi,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center