Offline backup in DB13

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.