on 11-23-2011 12:50 PM
Hi Experts,
How I can schedule offline backup in DB13 in ECC6.0 MSCS clusters. If I schedule offline backup in db13 then the SAP will stop and it will switch over from it's current node to another node and whole offline backup will be stopped. My online backup in db13 is working fine
And what is the difference between Whole database online and Full database online backup in DB13?
Regards,
Nilesh
Hi Nilesh,
When you schedule offline backup from DB13 in MSCS cluste environment, then the DB will switch over to other node when DB is brought down by backup. In such case as per my knowledge you can follow the below methods.
1) You have to Pause the Secondary Node till the backup is completed when you trigger the backup from DB13 and again enable the node after the backup is completed.
2) Other option is via installing stanalone gaetway and then you can trigger the backup from DB13 without having the need to pause the other node. Please check the Note 657999 - Installing a Standalone Gateway in an MSCS Environment
Also please check the below notes for information:
Note 648480 - Performing oracle administration tasks in a MSCS environment
Note 378648 - Offline backup support with Oracle Fail Safe
Thanks & Regards,
Sharath Babu M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nilesh,
And what is the difference between Whole database online and Full database online backup in DB13?
Whole backup
Backs up all database files, but this backup is not cataloged, which
means that you cannot use it as a reference backup for an incremental
backup with RMAN.
Full backup
Backs up all database files. You can perform a full backup with or
without RMAN. If you do not use RMAN, then RMAN is called separately to
catalog the backup. This means that you can use this backup as a
reference backup for an incremental backup with RMAN.
You can take an offline backup by pausing the second node and schedule the DB13 offline backup.
The other option is, you can also take an OFFLINE snapshot of the drives and mount the snapshot as a different drive and take the backup to tape or drive. You might reduce your downtime, in this case.
Thanks,
Arjun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nilesh,
Please check this thread:
and this inf you´re using oracle: http://help.sap.com/saphelp_nwpi71/helpdata/en/47/0936e6cc995bebe10000000a1553f7/frameset.htm
You must close the database for an offline backup, which means that you have to stop work in the SAP System. However, the SAP System does not have to be shut down for an offline backup. If the RECONNECT mechanism is set in the SAP start profiles, the connection to the SAP System is remade after the database is restarted. This means that the information in the buffers of the SAP System is not lost, which implies better performance immediately following the database startup.
regards,
Diego.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.