Backup Strategy

. What is the database size in my SAP systems (DEV, QAS, and PRD)

Check the space using DB02.

2. Media?

Generally there are two medias frequently used in the real time.

a. TAPE drive

b. Hard disk drive (HDD)

Based on your comfort ability and talking to your System admin you have to decide which one is better to use.

3. Level of backup

In real time we use two levels of backups generally

a. DISK-to -DISK

b. DISK-to-TAPE

First level backup will be performed to local disk of server as it is faster and server will not be busy for long time

2nd level is backup is performed as per the available time and before the next backup starts.

4. Time of Backup

Find out when the server idle time is or when server is less load. This time is more critical when your server is used by diff users from diff geographical region.

So you have to find the time when there is very less users load to server so that server doesn't go into hand position.

5. Frequency : Hourly/Daily / Weekly/Monthly / Quarterly

Recommended: DEV , QAS, PRD daily full online backup

Recommended: Weekly on DEV and QAS , Monthly/Quarterly on Production (PRD) offline backup.

6. Type of backup

a. Online (Recommended: DEV , QAS, PRD daily full online backup)

b. Offline ( Recommended Weekly on DEV and QAS , Monthly/Quarterly on Production (PRD))

7. Backup mode (All, Full, Table space, Incremental etc.)

All : This is highly recommended

8. Scheduler

Scheduler is the software or utility provided by most of Operating systems. In order to perform backup automatically without running daily manually the command ,we take the help of scheduler to perform the backup either daily /weekly/Monthly

Unix: There is scheduler available in Unix called " Crontab" . In order to put backup into scheduler you have to write a script which will have your backup command.

This script generally an executable file called .sh file

and call this .sh file using crontab.

Take the help of your Unix admin guy to setup this because to configure crontab u needs user "root" access.

NT: There is a scheduler available in Windows called "Scheduled Task"

Similarly you put your command into an executable file like .bat file or .exe file

And call this executable file from Schedule Task

Backup Parameter files

1. init.sap (ex. initS10.sap where S10 is the SID)

2. init.dba

Location of the parameter file

Unix: $ORACLE_HOME/dbs

NT : %ORACLE_HOME%/database

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk