Shital Patel wrote:Not if you have backup of primary .... BUT you can take the main backup from standby and release the load from your primary.
1) Is is necessary to take Physical standby database backup?
2) If 1) yes then Which RMAN backup is preferred?with catalog or default?How to take backup as different location?Better use catalog.
2) ......How to take backup as different location?What do you mean? Just configure "format" on the disk "channels".
3)how to Restore that backup?How to ensure backup is valid?Restore as normal procedure detailed in the fine:
Shital Patel wrote:Just do the backup same as you are doing it in production, some rman configuration parameters that are set on the primary db will be inherited by the standby backup.
Now i want to take backup of physical standby database(DR) on another server using RMAN catalog.
I am totally confused with all this...Kindly provide me steps for physical database backup using RMAN catalog with it's pros and cons...!! :)