SMB and ONline backup

[former_member199632]

Hi,

In Our R/3 environment, online backup is consisting with archived logs.

Online Backup = DB Files + archived logs

When getting the SMB backup and Online Backup (BRBACKUP), will that going to backup "Online Redo Logs"

(Not Offline Redo logs - archived logs)

When checking the logfile (Online backup) in /oracle/PRD/sapbackup/beejdgaz.anf , it shows the online redologs files also. (Just show, Not saying it is backing up)

But when checking through DP, it is not mentioning that , Online Redo logs are backing up!

I just want to know , for SMB and Online backups will that include Online REDO logs? Is it possible to backup these Online Redo Logs. Since they are currently in use

regards,

[Former Member · Accepted solution]

There will be no backup for your online redo log files. When the DB online backup completes then the brbackup issues below commands which will switch your online logs to offline.

Switching to next online redo log file for database instance <SID> ...

Switch to next online redo log file for database instance <SID> successful

ARCHIVE LOG LIST after backup for database instance <SID>

and can you please also paste the command which you are using for your online consistence backup?

brbackup -t online_cons -u / -c -a -cds -c

[former_member199632 · Accepted solution]

Hi,

we are using:

brbackup -t online -d util_file -c -m all -u

brbackup issues below commands which will switch your online logs to offline.
Switching to next online redo log file for database instance <SID> ...
Switch to next online redo log file for database instance <SID> successful
ARCHIVE LOG LIST after backup for database instance <SID>

online logs to offline.

That means, when time of getting the backup, current online redo logs will be taken in to offline mode. (As archived redo logs) ?

then those archived logs will be backing up.

Is that the way that happens.

[Former Member · Accepted solution]

I suggest you should change your backup command as below:

brbackup -t online_cons -d util_file -c -m all -u

Using above command brbackup (brtools) will make sure that you have a consistant backup for restore, this will backup all the required logs to perform a complete restore.

follow: http://help.sap.com/saphelp_nw70ehp1/helpdata/en/d7/839e9f72dd4049896dab7d153662c5/frameset.htm