Home » RDBMS Server » Backup & Recovery » RMAN Backup on DataGaurd Database (10.2, AIX)
RMAN Backup on DataGaurd Database [message #497241] Fri, 04 March 2011 10:32 Go to next message
Jagdeep
Messages: 15
Registered: August 2004
Junior Member
We are running a 5Tb database backup which takes really a long time to backup and impacts the performance in general during the backup. We got a DataGaurd database in place which we want to utilize to run the RMAN backup on to avoid performance impacts and just use DG database for backup and DR purposes. My Question is if we run the backups on DataGaurd Database, How would a RMAN DG database backup would clear the archive logs from Primary production and from DataGaurd Database during the backup process? Any suggestions?
Re: RMAN Backup on DataGaurd Database [message #497243 is a reply to message #497241] Fri, 04 March 2011 10:47 Go to previous messageGo to next message
Michel Cadot
Messages: 58855
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It does it as usual on DG site and does nothing on primary one.
The way you have to or can do it on primary depends on your architecture: do you a RMAN catalog, are the backup on tape or disk, are the disks visible from both sites...

Regards
Michel
Re: RMAN Backup on DataGaurd Database [message #497248 is a reply to message #497243] Fri, 04 March 2011 11:12 Go to previous messageGo to next message
Jagdeep
Messages: 15
Registered: August 2004
Junior Member
We have RMAN catalog running on Primary Server for now. So you are saying it would clearn the files from DG but not from Primary...? I am not sure if delete input would delete archivelogs from Primary or DG database.. Any suggestions..?
Re: RMAN Backup on DataGaurd Database [message #497249 is a reply to message #497248] Fri, 04 March 2011 11:13 Go to previous messageGo to next message
Jagdeep
Messages: 15
Registered: August 2004
Junior Member
Backups are going over to tape and disks are not visible to DG server..
Re: RMAN Backup on DataGaurd Database [message #497258 is a reply to message #497249] Fri, 04 March 2011 12:03 Go to previous messageGo to next message
Michel Cadot
Messages: 58855
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Backups are going over to tape and disks are not visible to DG server..

Do you mean "Backups are going over to tape and disks, and both are not visible to DG server" or "Backups are going over to tape, disks are not visible to DG server"?

Regards
Michel
Re: RMAN Backup on DataGaurd Database [message #497259 is a reply to message #497258] Fri, 04 March 2011 12:10 Go to previous messageGo to next message
Michel Cadot
Messages: 58855
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
We have RMAN catalog running on Primary Server for now. So you are saying it would clearn the files from DG but not from Primary...?

Yes.

Regards
Michel
Re: RMAN Backup on DataGaurd Database [message #497290 is a reply to message #497259] Fri, 04 March 2011 14:11 Go to previous messageGo to next message
Jagdeep
Messages: 15
Registered: August 2004
Junior Member
Existing configuration is to send backups over to tape directly via rman/tdp from primary node. We want to have these backups to tape configured on Datagaurd server/db to reduce the performance impact. Regarding disk are not accessible means was "database disks of Primary datbaase/archive location are not accessible from Datagaurd Server."...
Re: RMAN Backup on DataGaurd Database [message #497760 is a reply to message #497241] Mon, 07 March 2011 01:23 Go to previous message
hkchital
Messages: 128
Registered: September 2008
Location: Singapore
Senior Member
See the CONFIGURE command in RMAN.
At the Primary you can
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

which allows the FRA at the Primary to delete archivelogs that have been applied on the Standby.
(The Primary and Standby must be communicating in a DataGuard configuration, not a manual standby)


Hemant K Chitale
Previous Topic: TO Make A Copy Of Oracle DB in Local PC
Next Topic: Clone using OEM Db Control
Goto Forum:
  


Current Time: Thu Aug 21 11:34:21 CDT 2014

Total time taken to generate the page: 0.10318 seconds