| Online backup on standby database [message #222468] |
Mon, 05 March 2007 00:21  |
kmkumar24
Messages: 69
Registered: January 2007
Location: Singapore
|
Member |
|
|
Hi All,
I have production database and standby database. There was a cronjob for backingup full database on primary database. Now i want to perform the same cronjob to backing up the full database on standby database instead of production database, because of the performance degradation in primary database while backup.
Kindly suggest me whether the scheduling of cronjob for backingup full db on standby database will be possible.
In this case also kindly suggest me whether the backup will be used at recovery time.
Thanks in advance
Magesh
|
|
|
|
|
|
| Re: Online backup on standby database [message #222709 is a reply to message #222533] |
Tue, 06 March 2007 01:44  |
kmkumar24
Messages: 69
Registered: January 2007
Location: Singapore
|
Member |
|
|
Hi,
Thanks for the link given, but from that webpage i understand that datafile and archive file can be backup in standby, controlfile and spfile can be backup in primary db.
But here my dataguard will be set on HIGHER PERFORMANCE mode. So is it work to backup the files at primary and standby db respectively for no data loss at recovery point of time, b'cos the controlfile and spfile will not be available incase of Disk Failure.
So, kindly suggest me how to overcome this problem.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
