cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Oracle backup keeps on failing

Cinu
Participant

on ‎01-22-2015 9:02 AM

0 Kudos

Hi,

Since last week, our production backup failed with RC- 9999 Started. Somedays 'BR0049W Last BRBACKUP run was probably killed'  appeared in detailed log. We have scheduled Whole Dtabase Offline + Redolog backup since very long time.  Now everyday Oracle DB start is  required. We are on Oracle 10.2.0.5.1 over windows 2003 sever. We found a file lock.brb in F:\oracle\SID\sapbackup once backup started. In DB13 yesterday's backup is still in 'running' status. Kindly suggest.

Regards,

Cinu.....

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (15)

Answers (15)

former_member182657
Active Contributor
‎02-04-2015 10:50 AM
0 Kudos

Hi Cinu,



I found one log archSID.log in saparch directory. Its content updated only up to last 15th, the day in which our last backup from DB13 succeeded to tape.

archSID.log file logs backup history of your archives.



Does it related to failure of backup?

I don't think this would be the issue for failure of backup.But for analysis could you share the log file arch<SID>.log



If I take backup of archive log using BRtools, will it work?

Yes it'll work with brtools if archives are still present in system.

Regards,

Show replies
Show replies
Cinu
Participant
‎02-04-2015 12:53 PM
0 Kudos

Thank you gaurav

Cinu
Participant
‎02-04-2015 10:28 AM
0 Kudos

Hi,

I found one log archSID.log in saparch directory. Its content updated only up to last 15th, the day in which our last backup from DB13 succeeded to tape. Does it need any attention? When I check archive log directory, files upto 15th were deleted and rest of archive logs till today are available. Does it related to failure of backup? If I take backup of archive log using BRtools, will it work?

Regards,

Cinu

Show replies
Show replies
Reagan
Advisor
Advisor
‎02-04-2015 9:38 PM
0 Kudos

Hello Cinu

Is it possible to run a backup with a higher trace level? There is a good chance that the issue could be at the backup server side and I strongly believe the issue should be there. Have you got a chance to investigate possible issues at the backup server side? I would consider that as well.

RB

Cinu
Participant
‎02-05-2015 5:35 AM
0 Kudos

Hi Reagan,

After failed backups to tape, I am now taking backups to disk in PRD server itself. From BRtools backup succeeded: both Online and Offline. Any backups from DB13, either to disk or tape keep on failing.

Let me turn on trace and perform backup today.

Regards,

Cinu

former_member182657
Active Contributor
‎02-05-2015 5:48 AM
0 Kudos

Hi Cinu,

Have you applied latest support package for SAP_BASIS which i suggested you earlier ? Kindly confirm for same.

Regards,

former_member182657
Active Contributor
‎02-04-2015 7:04 AM
0 Kudos

Hi Cinu,

If backup is successful with brtools than here might be an issue with support package level.Previously you mentioned that you're on SAP_BASIS 702 with SP level 10,if possible could you update the level with latest available at SMP (might be SP 13 ) .

After that try once again & i also suggest you to open ticket with SAP in parallel.

Regards,

Gaurav

Show replies
Show replies
Cinu
Participant
‎02-04-2015 9:09 AM
0 Kudos

Thanks Gaurav,

I have raised it to SAP and waiting for their reply.

Regards,

Cinu

Former Member
‎02-02-2015 11:05 AM
0 Kudos

Dear Cinu,

Why cant you raise the same to SAP..?..

You can try for a dbtools patch any way.

Show replies
Show replies
former_member182657
Active Contributor
‎01-31-2015 4:05 AM
0 Kudos

Hi Cinu,

As you're using



BRBACKUP 7.20 (1)

If possible could you try to patch the brtools first with the latest available at SMP by following SAP KBA's 1428529 - Corrections in BR*Tools Version 7.20

and  12741 - Current versions of BR*Tools

In addition you also need to follow SAP KBA's as suggested by to increase the trace level for br*tools to locate more details.

After following all could you try once more by taking offline backup and share details again.

Regards,

Gaurav

Show replies
Show replies
Cinu
Participant
‎02-04-2015 6:35 AM
0 Kudos

Dear Gaurav,

I have updated BRTOOLS with latest patchset - 40. Then after i tried backup using DB13, both online and offline but failed with same error '9999 started'. It seems backup was hanged. Offline backup hanged at ' shutting down database' and online backup hanged at backing up first datafile itself. Does it point to any permission issue? Its windows 2003 server and backup is succeeded in BRTOOLS level. 

Please advice.

Regards,

Cinu

Cinu
Participant
‎01-30-2015 10:02 AM
0 Kudos

Hi,

alertlog file size is around 23 MB and I copied relevant lines here:

Log for succeeded backup by brtools:

Shutting down instance (immediate)

Fri Jan 30 00:12:13  2015

Shutting down instance: further logons disabled

Fri Jan 30 00:12:13  2015

Stopping background process QMNC

Fri Jan 30 00:12:14  2015

Stopping background process CJQ0

Fri Jan 30 00:12:14  2015

Background process QMNC not dead after 150 seconds

Fri Jan 30 00:12:14  2015

Stopping background process MMNL

Fri Jan 30 00:12:15  2015

Background process MMNL not dead after 10 seconds

Fri Jan 30 00:12:15  2015

Stopping background process MMON

Fri Jan 30 00:12:16  2015

Background process MMON not dead after 30 seconds

License high water mark = 28

Fri Jan 30 00:12:16  2015

Job queue slave processes stopped

Fri Jan 30 00:12:22  2015

ALTER DATABASE CLOSE NORMAL

Fri Jan 30 00:12:22  2015

SMON: disabling tx recovery

SMON: disabling cache recovery

Fri Jan 30 00:12:25  2015

Shutting down archive processes

Archiving is disabled

Fri Jan 30 00:12:30  2015

ARCH shutting down

ARC1: Archival stopped

Fri Jan 30 00:12:35  2015

ARCH shutting down

ARC0: Archival stopped

Fri Jan 30 00:12:37  2015

Thread 1 closed at log sequence 30269

Successful close of redo thread 1

Fri Jan 30 00:12:37  2015

Completed: ALTER DATABASE CLOSE NORMAL

Fri Jan 30 00:12:37  2015

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Fri Jan 30 00:12:45  2015

Instance shutdown complete

Fri Jan 30 04:07:42  2015

Adjusting the default value of parameter parallel_max_servers

from 320 to 65 due to the value of parameter processes (80)

Fri Jan 30 04:07:42  2015

LOG for failed backup:

Fri Jan 30 00:00:50  2015

Shutting down instance (immediate)

Fri Jan 30 00:00:50  2015

Shutting down instance: further logons disabled

Fri Jan 30 00:00:51  2015

Stopping background process QMNC

Fri Jan 30 00:00:52  2015

Stopping background process CJQ0

Fri Jan 30 00:00:52  2015

Background process QMNC not dead after 150 seconds

Fri Jan 30 00:00:52  2015

Stopping background process MMNL

Fri Jan 30 00:00:53  2015

Background process MMNL not dead after 10 seconds

Fri Jan 30 00:00:53  2015

Stopping background process MMON

Fri Jan 30 00:00:55  2015

Background process MMON not dead after 30 seconds

License high water mark = 28

Fri Jan 30 00:00:55  2015

Job queue slave processes stopped

Fri Jan 30 00:01:03  2015

ALTER DATABASE CLOSE NORMAL

Fri Jan 30 00:01:03  2015

SMON: disabling tx recovery

SMON: disabling cache recovery

Fri Jan 30 00:01:04  2015

Shutting down archive processes

Archiving is disabled

Fri Jan 30 00:01:09  2015

ARCH shutting down

ARC1: Archival stopped

Fri Jan 30 00:01:14  2015

ARCH shutting down

ARC0: Archival stopped

Fri Jan 30 00:01:15  2015

Thread 1 closed at log sequence 30269

Successful close of redo thread 1

Fri Jan 30 00:01:16  2015

Completed: ALTER DATABASE CLOSE NORMAL

Fri Jan 30 00:01:16  2015

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Fri Jan 30 00:01:27  2015

Instance shutdown complete

No files are getting generated in backup folder in this case and started oracle again.

Show replies
Show replies
Reagan
Advisor
Advisor
‎01-31-2015 1:42 AM
0 Kudos

Hello Cinu

The alert log doesn't show anything more than shutting down the database during the backup. Try to increase the trace level of BR*Tools and see what exactly happens when the backup is run.

29321 - Creating traces for BR Tools

1780001 - How to increase the trace level for the br*tools jobs which are scheduled in DB13

Regards

RB

Cinu
Participant
‎01-30-2015 7:11 AM
0 Kudos

Hi,

I took offline backup to disk using brtools. But failed in same using  DB13. In initSID.SAP file I have added  backup_dev_type = disk and provided location. compress = yes, compress = brtools are maintained.Full permissions for disk location has also done. Even then, backup from DB13 failed. Please help.

Thanks,

Cinu

Show replies
Show replies
former_member182657
Active Contributor
‎01-30-2015 7:16 AM
0 Kudos

Could you share updated logs for brconnect as well as alert_<SID>.log file.

Regards,

Cinu
Participant
‎01-27-2015 7:34 AM
0 Kudos

Hi,

Last day I took a online backup to disk using brtools and succeeded. Backup size is 300 GB with out compression. If initSID.sap has modified for compression = brtools; will it compress the backup on disk drive? Earler it was hardware and we used tape for backup. Please suggest.

One more doubt, Offline and Offline_force - does it have any difference?

Pls help...

Cinu

Show replies
Show replies
Reagan
Advisor
Advisor
‎01-27-2015 8:03 AM
0 Kudos

Hello Cinu

>>One more doubt, Offline and Offline_force - does it have any difference?<<

  • offline: database backup in offline mode, in other words, the database is shut down during backup. When you select this parameter, BRBACKUP checks that no SAP system users are connected to the database. If an SAP System is active, the database is not shut down and BRBACKUP terminates the process with an error message (message number BR0068E).
  • offline_force: database backup in offline mode, in other words, the database is shut down during backup. BRBACKUP always shuts down the database, even if the SAP System is active.

Source: backup_type - SAP Database Guide: Oracle - SAP Library

If you were able to take an online backup successfully to disk then taken an offline backup to disk and see how it goes.

Cheers

RB

Cinu
Participant
‎01-27-2015 8:11 AM
0 Kudos

Hi Reagan,

Thank you for the valuable information. The URL provided is so helpful.......

Regards,

Cinu

former_member182657
Active Contributor
‎01-23-2015 9:38 AM
0 Kudos

Hi Cinu,

Are you using any third party software's in between SAP & the tape lib itself ? If yes try to check with the scripts of the software as scripting plays role to up your database even when you're performing offline backups (Best e.g for the scenario are Veritas Netbackup or Net vault).

One more thing here i would like to check with same scheduling of backup on disk instead of tape drives.

Regards,

Show replies
Show replies
Cinu
Participant
‎01-23-2015 7:31 AM
0 Kudos

Hi,

Yesterday I tried to take online backup to tape after failed scheduled offline backup.

During offline backup, Oracle shutdown and even after 2 hours, it  did not come up. I manually start Oracle and in DB12 backup failed with RC 9999.

Detail log:beprreko.aft

BR0051I BRBACKUP 7.20 (1)

BR0055I Start of database backup: beprreko.aft 2015-01-23 00.45.06

BR0484I BRBACKUP log file: F:\oracle\PRD\sapbackup\beprreko.aft

BR0477I Oracle pfile E:\oracle\PRD\102\database\initPRD.ora created from spfile E:\oracle\PRD\102\database\spfilePRD.ora

BR0101I Parameters

Name                           Value

oracle_sid                     PRD

oracle_home                    E:\oracle\PRD\102

oracle_profile                 E:\oracle\PRD\102\database\initPRD.ora

sapdata_home                   F:\oracle\PRD

sap_profile                    E:\oracle\PRD\102\database\initprd.sap

backup_mode                    ALL

backup_type                    offline_force

backup_dev_type                tape

compress                       hardware

tape_copy_cmd                  brtools

tape_block_size                64K

rewind                         mt -f $ rewind

rewind_offline                 mt -f $ offline

tape_size                      184320.000 MB

tape_address                   /dev/nmt0

tape_address_rew               /dev/mt0

volume_backup                  PRDB04

expir_period                   7

tape_use_count                 100

exec_parallel                  0

system_info                    SAPServicePRD DHPLPRD Windows 5.2 Build 3790 Service Pack 2 AMD64

oracle_info                    PRD 10.2.0.5.0 8192 30020 651309399 DHPLPRD UTF8 UTF8 1845028390

sap_info                       702 SAPSR3 0002LK0003PRD0011F17716453480015Maintenance_ORA

make_info                      NTAMD64 OCI_10201_SHARE Mar 10 2010

command_line                   brbackup -jid ALGOF20150123004500 -u / -c force -t offline_force -m all -p initprd.sap -v PRDB04 -a -c force -p initprd.sap -cds

BR0116I ARCHIVE LOG LIST before backup for database instance PRD

Parameter                      Value

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            H:\oracle\PRD\oraarch\PRDarch

Archive format                 ARC%S_%R.%T

Oldest online log sequence     30017

Next log sequence to archive   30020

Current log sequence           30020            SCN: 651309399

Database block size            8192             Thread: 1

Current system change number   651312602        ResetId: 781364774

BR0118I Tablespaces and data files

Tablespace     TS-Status  F-Status  File                                                       Size   Id.     Device  Link    Type       MaxSize     IncrSize  BlkSize

PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_66\SR3.DATA66             4294975488   83           5  NOLINK  FILE    4404019200     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_67\SR3.DATA67             4294975488   84           5  NOLINK  FILE    4404019200     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_68\SR3.DATA68             4294975488   85           5  NOLINK  FILE    4404019200     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_69\SR3.DATA69             4294975488   86           5  NOLINK  FILE    4404019200     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_70\SR3.DATA70             4294975488   87           5  NOLINK  FILE    4404019200     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_71\SR3.DATA71             8589942784   88           5  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_72\SR3.DATA72             8589942784   89           5  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_73\SR3.DATA73             8589942784   90           5  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_74\SR3.DATA74             8589942784   91           5  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_75\SR3.DATA75             4294975488   92           5  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_76\SR3.DATA76             4294975488   93           5  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_77\SR3.DATA77             4294975488   94           5  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_10\SR3.DATA10             2453676032   13           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_11\SR3.DATA11             2285903872   14           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_12\SR3.DATA12             2285903872   15           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_13\SR3.DATA13             2285903872   16           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_14\SR3.DATA14             2202017792   17           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_15\SR3.DATA15             2285903872   18           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_16\SR3.DATA16             2222989312   19           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_17\SR3.DATA17             2285903872   20           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_18\SR3.DATA18             2285903872   21           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_19\SR3.DATA19             2222989312   22           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_1\SR3.DATA1               2243960832    4           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_20\SR3.DATA20             2306875392   23           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_21\SR3.DATA21             2222989312   24           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_22\SR3.DATA22             2202017792   25           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_23\SR3.DATA23             2202017792   26           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_24\SR3.DATA24             2222989312   27           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_25\SR3.DATA25             2202017792   28           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_26\SR3.DATA26             2202017792   29           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_27\SR3.DATA27             2202017792   30           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_28\SR3.DATA28             2202017792   31           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_29\SR3.DATA29             2202017792   32           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_2\SR3.DATA2               2243960832    5           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_30\SR3.DATA30             7361011712   33           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_31\SR3.DATA31             5221916672   34           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_32\SR3.DATA32             4299169792   35           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_33\SR3.DATA33             4110426112   36           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_34\SR3.DATA34             3816824832   37           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_35\SR3.DATA35             3481280512   38           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_36\SR3.DATA36             3229622272   39           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_37\SR3.DATA37             3082821632   40           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_38\SR3.DATA38             2915049472   41           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_39\SR3.DATA39             2663391232   42           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_3\SR3.DATA3               2243960832    6           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_40\SR3.DATA40             2810191872   43           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_41\SR3.DATA41             2579505152   44           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_42\SR3.DATA42             2558533632   45           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_43\SR3.DATA43             2390761472   46           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_44\SR3.DATA44             2390761472   47           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_45\SR3.DATA45             2390761472   48           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_46\SR3.DATA46             2558533632   49           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_47\SR3.DATA47             2474647552   50           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_48\SR3.DATA48             2306875392   51           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_49\SR3.DATA49             2306875392   52           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_4\SR3.DATA4               2243960832    7           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_50\SR3.DATA50             2327846912   53           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_51\SR3.DATA51             2348818432   54           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_52\SR3.DATA52             2495619072   55           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_53\SR3.DATA53             2327846912   56           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_54\SR3.DATA54             2327846912   57           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_55\SR3.DATA55             2327846912   58           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_56\SR3.DATA56             1447043072   59           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_57\SR3.DATA57             2147491840   72           6  NOLINK  FILE    3145728000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_58\SR3.DATA58             2147491840   73           6  NOLINK  FILE    3145728000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_59\SR3.DATA59             4294975488   76           6  NOLINK  FILE    4404019200     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_5\SR3.DATA5               2222989312    8           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_60\SR3.DATA60             4294975488   77           6  NOLINK  FILE    4404019200     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_61\SR3.DATA61             4294975488   78           6  NOLINK  FILE    4404019200     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_62\SR3.DATA62             4294975488   79           6  NOLINK  FILE    4404019200     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_63\SR3.DATA63             6442459136   80           6  NOLINK  FILE    6501171200     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_64\SR3.DATA64             6442459136   81           6  NOLINK  FILE    6501171200     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_65\SR3.DATA65             4294975488   82           6  NOLINK  FILE    4404019200     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_6\SR3.DATA6               2222989312    9           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_7\SR3.DATA7               2222989312   10           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_8\SR3.DATA8               2222989312   11           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_9\SR3.DATA9               2285903872   12           6  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_10\SR3702.DATA10       3439337472   69           5  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_11\SR3702.DATA11       3303022592   70           5  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_12\SR3702.DATA12       4194312192   74           5  NOLINK  FILE    4404019200     20971520     8192

PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_1\SR3702.DATA1         3376422912   60           5  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_2\SR3702.DATA2         3439337472   61           5  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_3\SR3702.DATA3         7549755392   62           5  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_4\SR3702.DATA4         6228549632   63           5  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_5\SR3702.DATA5         4781514752   64           5  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_6\SR3702.DATA6         4278198272   65           5  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_7\SR3702.DATA7         3858767872   66           5  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_8\SR3702.DATA8         3628081152   67           5  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_9\SR3702.DATA9         3460308992   68           5  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3USR     ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA4\SR3USR_1\SR3USR.DATA1           31465472   71           6  NOLINK  FILE   10485760000     20971520     8192

PSAPTEMP       ONLINE#    ONLINE+   F:\ORACLE\PRD\SAPDATA1\TEMP_1\TEMP.DATA1             4005568512   -1           5  NOLINK  FILE   10485760000     20971520     8192

PSAPUNDO       ONLINE-    ONLINE+   F:\ORACLE\PRD\SAPDATA1\UNDO_1\UNDO.DATA1             8367644672    2           5  NOLINK  FILE   10485760000     20971520     8192

SYSAUX         ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA1\SYSAUX_1\SYSAUX.DATA1          482353152    3           5  NOLINK  FILE   10485760000     20971520     8192

SYSTEM         ONLINE*    SYSTEM+   F:\ORACLE\PRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1          891297792    1           5  NOLINK  FILE   10485760000     20971520     8192

SYSTEM         ONLINE*    SYSTEM+   F:\ORACLE\PRD\SAPDATA1\SYSTEM_2\SYSTEM.DATA2          891297792   75           5  NOLINK  FILE   10485760000     20971520     8192

BR0119I Redolog files

File                                                Size  Group     Device  Status    Link    Type

J:\ORACLE\PRD\MIRRLOGA\LOG_G11M2.DBF            52429312    1            9  INUSE     NOLINK  FILE

I:\ORACLE\PRD\ORIGLOGA\LOG_G11M1.DBF            52429312    1            8  INUSE     NOLINK  FILE

J:\ORACLE\PRD\MIRRLOGB\LOG_G12M2.DBF            52429312    2            9  INUSE     NOLINK  FILE

I:\ORACLE\PRD\ORIGLOGB\LOG_G12M1.DBF            52429312    2            8  INUSE     NOLINK  FILE

J:\ORACLE\PRD\MIRRLOGA\LOG_G13M2.DBF            52429312    3            9  INUSE     NOLINK  FILE

I:\ORACLE\PRD\ORIGLOGA\LOG_G13M1.DBF            52429312    3            8  INUSE     NOLINK  FILE

J:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF            52429312    4            9  INUSE     NOLINK  FILE

I:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF            52429312    4            8  INUSE     NOLINK  FILE

BR0120I Control files

File                                                Size   Id.      Device  Link    Type

I:\oracle\PRD\origlogA\cntrl\cntrlPRD.dbf       17711104    0            8  NOLINK  FILE

I:\oracle\PRD\origlogB\cntrl\cntrlPRD.dbf       17711104    0            8  NOLINK  FILE

F:\oracle\PRD\sapdata1\cntrl\cntrlPRD.dbf       17711104    0            5  NOLINK  FILE

BR0280I BRBACKUP time stamp: 2015-01-23 00.45.11

BR0057I Backup of database: PRD

BR0058I BRBACKUP action ID: beprreko

BR0059I BRBACKUP function ID: aft

BR0110I Backup mode: ALL

BR0077I Database files for backup:

J:\ORACLE\PRD\MIRRLOGA\LOG_G11M2.DBF

J:\ORACLE\PRD\MIRRLOGB\LOG_G12M2.DBF

J:\ORACLE\PRD\MIRRLOGA\LOG_G13M2.DBF

J:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF

I:\oracle\PRD\origlogA\cntrl\cntrlPRD.dbf

BR0061I 100 files found for backup, total size 304697.635 MB

BR0143I Backup type: offline_force

BR0113I Files will be compressed by hardware

BR0130I Backup device type: tape

BR0102I Following backup device will be used: /dev/nmt0

BR0103I Following backup volume will be used: PRDB04

BR0289I BRARCHIVE will be started at the end of processing

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0208I Volume with name PRDB04 required in device /dev/nmt0

BR0280I BRBACKUP time stamp: 2015-01-23 00.45.13

BR0226I Rewinding tape volume in device /dev/mt0 ...

BR0351I Restoring F:\oracle\PRD\sapbackup\.tape.hdr0

BR0355I from /dev/nmt0 ...

BR0241I Checking label on volume in device /dev/nmt0

BR0242I Scratch volume in device /dev/nmt0 will be renamed to PRDB04

BR0280I BRBACKUP time stamp: 2015-01-23 00.45.14

BR0226I Rewinding tape volume in device /dev/mt0 ...

BR0202I Saving F:\oracle\PRD\sapbackup\.tape.hdr0

BR0203I to /dev/nmt0 ...

BR0209I Volume in device /dev/nmt0 has name PRDB04

BR0202I Saving init_ora

BR0203I to /dev/nmt0 ...

BR0202I Saving E:\oracle\PRD\102\database\initprd.sap

BR0203I to /dev/nmt0 ...

BR0280I BRBACKUP time stamp: 2015-01-23 00.45.24

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2015-01-23 00.45.24

BR0307I Shutting down database instance PRD ...

Does this point to any issues with tape volume or tape drive? I restarted oracle & SAP. Again tried to take online backup, but failed.  I am planning to take backup to disk drive tonight.

Do I need to update BRTOOLS with latest patch set?

Please suggest.....

Cinu....

Show replies
Show replies
Reagan
Advisor
Advisor
‎01-23-2015 9:13 AM
0 Kudos

Hello Cinu

The above log shows the backup you have started is an Oflline backup and NOT an online one.

The database is expected to be down (including SAP) during an offline backup. The backup log is not showing any errors during the backup.

According to the log it shows "BR0307I Shutting down database instance PRD"

Check the state of the Oracle database at this state. Also check Oracle alert log for any errors.

If the database has been **** down completely then check the backup server where the backup is taken to see progress of the backup (seek the support of a backup specialist).

RB

Cinu
Participant
‎01-23-2015 1:19 PM
0 Kudos

Hi Reagan,

During offline backup after DB shutdown, can we able to find any logs other than alert log?

Reagan
Advisor
Advisor
‎01-23-2015 1:54 PM
0 Kudos

Hello Cinu

Apart from the backup log in the sapbackup directory there isn't any other log created. If the database has been shutdown completely then check the backup server where the backup is taken to see progress of the backup (seek the support of a backup specialist). There should be a possibility to see the backup progress from there.

RB

Former Member
‎01-23-2015 2:00 PM
0 Kudos

Check Oracle alert log file at the time of database shutdown performed by brbackup.

former_member182657
Active Contributor
‎01-22-2015 10:53 AM
0 Kudos

Hi Cinu,

Try to implement the SAP Note 1753289 - Incorrect alert for database backup

and you not need to create any directory on the system,in thread which i mentioned suggesting for parameter under init<SID>.sap file.

Regards,

Show replies
Show replies
former_member182657
Active Contributor
‎01-22-2015 9:59 AM
0 Kudos

Could you check with SCN thread

Regards,

Show replies
Show replies
Cinu
Participant
‎01-22-2015 10:38 AM
0 Kudos

Hi,

We are on SAP_BASIS 702 SP10.  I have checked above SCN thread, but where does this directories created, is it in tape?  We have asked system team to restart tape library once.

former_member182657
Active Contributor
‎01-22-2015 9:50 AM
0 Kudos

Hi Cinu,

Logs seems fine here.Could yopu share release level and support package level for SAP_BASIS from the system.Check with SAP KBA  1753289 - Incorrect alert for database backup

Also check for restart of your tape library once and share alert_<SID>.log file as well.

Regards,

Show replies
Show replies
Cinu
Participant
‎01-22-2015 9:36 AM
0 Kudos

Hi Gaurav,


Detail log: beprmcen . aft

BR0051I BRBACKUP 7.20 (1)
BR0055I Start of database backup: beprmcen.aft 2015-01-21 23.55.17
BR0484I BRBACKUP log file: F:\oracle\PRD\sapbackup\beprmcen.aft
BR0477I Oracle pfile E:\oracle\PRD\102\database\initPRD.ora created from spfile E:\oracle\PRD\102\database\spfilePRD.ora
BR0101I Parameters
Name                           Value
oracle_sid                     PRD
oracle_home                    E:\oracle\PRD\102
oracle_profile                 E:\oracle\PRD\102\database\initPRD.ora
sapdata_home                   F:\oracle\PRD
sap_profile                    E:\oracle\PRD\102\database\initprd.sap
backup_mode                    ALL
backup_type                    offline_force
backup_dev_type                tape
compress                       hardware
tape_copy_cmd                  brtools
tape_block_size                64K
rewind                         mt -f $ rewind
rewind_offline                 mt -f $ offline
tape_size                      184320.000 MB
tape_address                   /dev/nmt0
tape_address_rew               /dev/mt0
volume_backup                  PRDB03
expir_period                   7
tape_use_count                 100
exec_parallel                  0
system_info                    SAPServicePRD DHPLPRD Windows 5.2 Build 3790 Service Pack 2 AMD64
oracle_info                    PRD 10.2.0.5.0 8192 29982 649998231 DHPLPRD UTF8 UTF8 1845028390
sap_info                       702 SAPSR3 0002LK0003PRD0011F17716453480015Maintenance_ORA
make_info                      NTAMD64 OCI_10201_SHARE Mar 10 2010
command_line                   brbackup -jid ALGOF20130801235500 -u / -c force -t offline_force -m all -p initprd.sap -v PRDB03 -a -c force -p initprd.sap -cds
BR0116I ARCHIVE LOG LIST before backup for database instance PRD
Parameter                      Value
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            H:\oracle\PRD\oraarch\PRDarch
Archive format                 ARC%S_%R.%T
Oldest online log sequence     29979
Next log sequence to archive   29982
Current log sequence           29982            SCN: 649998231
Database block size            8192             Thread: 1
Current system change number   650295951        ResetId: 781364774
BR0118I Tablespaces and data files
Tablespace     TS-Status  F-Status  File                                                       Size   Id.     Device  Link    Type       MaxSize     IncrSize  BlkSize
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_66\SR3.DATA66             4294975488   83           5  NOLINK  FILE    4404019200     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_67\SR3.DATA67             4294975488   84           5  NOLINK  FILE    4404019200     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_68\SR3.DATA68             4294975488   85           5  NOLINK  FILE    4404019200     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_69\SR3.DATA69             4294975488   86           5  NOLINK  FILE    4404019200     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_70\SR3.DATA70             4294975488   87           5  NOLINK  FILE    4404019200     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_71\SR3.DATA71             8589942784   88           5  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_72\SR3.DATA72             8589942784   89           5  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_73\SR3.DATA73             8589942784   90           5  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_74\SR3.DATA74             8589942784   91           5  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_75\SR3.DATA75             4294975488   92           5  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_76\SR3.DATA76             4294975488   93           5  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA5\SR3_77\SR3.DATA77             4294975488   94           5  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_10\SR3.DATA10             2453676032   13           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_11\SR3.DATA11             2285903872   14           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_12\SR3.DATA12             2285903872   15           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_13\SR3.DATA13             2285903872   16           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_14\SR3.DATA14             2202017792   17           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_15\SR3.DATA15             2285903872   18           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_16\SR3.DATA16             2222989312   19           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_17\SR3.DATA17             2285903872   20           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_18\SR3.DATA18             2285903872   21           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_19\SR3.DATA19             2222989312   22           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_1\SR3.DATA1               2243960832    4           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_20\SR3.DATA20             2306875392   23           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_21\SR3.DATA21             2222989312   24           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_22\SR3.DATA22             2202017792   25           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_23\SR3.DATA23             2202017792   26           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_24\SR3.DATA24             2222989312   27           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_25\SR3.DATA25             2202017792   28           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_26\SR3.DATA26             2202017792   29           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_27\SR3.DATA27             2202017792   30           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_28\SR3.DATA28             2202017792   31           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_29\SR3.DATA29             2202017792   32           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_2\SR3.DATA2               2243960832    5           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_30\SR3.DATA30             7361011712   33           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_31\SR3.DATA31             5221916672   34           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_32\SR3.DATA32             4299169792   35           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_33\SR3.DATA33             4110426112   36           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_34\SR3.DATA34             3816824832   37           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_35\SR3.DATA35             3481280512   38           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_36\SR3.DATA36             3229622272   39           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_37\SR3.DATA37             3082821632   40           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_38\SR3.DATA38             2915049472   41           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_39\SR3.DATA39             2663391232   42           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_3\SR3.DATA3               2243960832    6           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_40\SR3.DATA40             2810191872   43           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_41\SR3.DATA41             2579505152   44           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_42\SR3.DATA42             2558533632   45           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_43\SR3.DATA43             2390761472   46           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_44\SR3.DATA44             2390761472   47           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_45\SR3.DATA45             2390761472   48           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_46\SR3.DATA46             2558533632   49           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_47\SR3.DATA47             2474647552   50           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_48\SR3.DATA48             2306875392   51           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_49\SR3.DATA49             2306875392   52           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_4\SR3.DATA4               2243960832    7           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_50\SR3.DATA50             2327846912   53           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_51\SR3.DATA51             2348818432   54           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_52\SR3.DATA52             2495619072   55           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_53\SR3.DATA53             2327846912   56           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_54\SR3.DATA54             2327846912   57           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_55\SR3.DATA55             2327846912   58           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_56\SR3.DATA56             1447043072   59           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_57\SR3.DATA57             2147491840   72           6  NOLINK  FILE    3145728000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_58\SR3.DATA58             2147491840   73           6  NOLINK  FILE    3145728000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_59\SR3.DATA59             4294975488   76           6  NOLINK  FILE    4404019200     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_5\SR3.DATA5               2222989312    8           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_60\SR3.DATA60             4294975488   77           6  NOLINK  FILE    4404019200     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_61\SR3.DATA61             4294975488   78           6  NOLINK  FILE    4404019200     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_62\SR3.DATA62             4294975488   79           6  NOLINK  FILE    4404019200     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_63\SR3.DATA63             6442459136   80           6  NOLINK  FILE    6501171200     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_64\SR3.DATA64             6442459136   81           6  NOLINK  FILE    6501171200     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_65\SR3.DATA65             4294975488   82           6  NOLINK  FILE    4404019200     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_6\SR3.DATA6               2222989312    9           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_7\SR3.DATA7               2222989312   10           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_8\SR3.DATA8               2222989312   11           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3        ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA2\SR3_9\SR3.DATA9               2285903872   12           6  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_10\SR3702.DATA10       3439337472   69           5  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_11\SR3702.DATA11       3303022592   70           5  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_12\SR3702.DATA12       4194312192   74           5  NOLINK  FILE    4404019200     20971520     8192
PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_1\SR3702.DATA1         3376422912   60           5  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_2\SR3702.DATA2         3439337472   61           5  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_3\SR3702.DATA3         7549755392   62           5  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_4\SR3702.DATA4         6228549632   63           5  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_5\SR3702.DATA5         4781514752   64           5  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_6\SR3702.DATA6         4278198272   65           5  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_7\SR3702.DATA7         3858767872   66           5  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_8\SR3702.DATA8         3628081152   67           5  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3702     ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA3\SR3702_9\SR3702.DATA9         3460308992   68           5  NOLINK  FILE   10485760000     20971520     8192
PSAPSR3USR     ONLINE*    ONLINE+   G:\ORACLE\PRD\SAPDATA4\SR3USR_1\SR3USR.DATA1           31465472   71           6  NOLINK  FILE   10485760000     20971520     8192
PSAPTEMP       ONLINE#    ONLINE+   F:\ORACLE\PRD\SAPDATA1\TEMP_1\TEMP.DATA1             3061850112   -1           5  NOLINK  FILE   10485760000     20971520     8192
PSAPUNDO       ONLINE-    ONLINE+   F:\ORACLE\PRD\SAPDATA1\UNDO_1\UNDO.DATA1             8367644672    2           5  NOLINK  FILE   10485760000     20971520     8192
SYSAUX         ONLINE*    ONLINE+   F:\ORACLE\PRD\SAPDATA1\SYSAUX_1\SYSAUX.DATA1          482353152    3           5  NOLINK  FILE   10485760000     20971520     8192
SYSTEM         ONLINE*    SYSTEM+   F:\ORACLE\PRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1          891297792    1           5  NOLINK  FILE   10485760000     20971520     8192
SYSTEM         ONLINE*    SYSTEM+   F:\ORACLE\PRD\SAPDATA1\SYSTEM_2\SYSTEM.DATA2          891297792   75           5  NOLINK  FILE   10485760000     20971520     8192
BR0119I Redolog files
File                                                Size  Group     Device  Status    Link    Type
J:\ORACLE\PRD\MIRRLOGA\LOG_G11M2.DBF            52429312    1            9  INUSE     NOLINK  FILE
I:\ORACLE\PRD\ORIGLOGA\LOG_G11M1.DBF            52429312    1            8  INUSE     NOLINK  FILE
J:\ORACLE\PRD\MIRRLOGB\LOG_G12M2.DBF            52429312    2            9  INUSE     NOLINK  FILE
I:\ORACLE\PRD\ORIGLOGB\LOG_G12M1.DBF            52429312    2            8  INUSE     NOLINK  FILE
J:\ORACLE\PRD\MIRRLOGA\LOG_G13M2.DBF            52429312    3            9  INUSE     NOLINK  FILE
I:\ORACLE\PRD\ORIGLOGA\LOG_G13M1.DBF            52429312    3            8  INUSE     NOLINK  FILE
J:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF            52429312    4            9  INUSE     NOLINK  FILE
I:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF            52429312    4            8  INUSE     NOLINK  FILE
BR0120I Control files
File                                                Size   Id.      Device  Link    Type
I:\oracle\PRD\origlogA\cntrl\cntrlPRD.dbf       17711104    0            8  NOLINK  FILE
I:\oracle\PRD\origlogB\cntrl\cntrlPRD.dbf       17711104    0            8  NOLINK  FILE
F:\oracle\PRD\sapdata1\cntrl\cntrlPRD.dbf       17711104    0            5  NOLINK  FILE
BR0280I BRBACKUP time stamp: 2015-01-21 23.55.23
BR0057I Backup of database: PRD
BR0058I BRBACKUP action ID: beprmcen
BR0059I BRBACKUP function ID: aft
BR0110I Backup mode: ALL
BR0077I Database files for backup:
J:\ORACLE\PRD\MIRRLOGA\LOG_G11M2.DBF
J:\ORACLE\PRD\MIRRLOGB\LOG_G12M2.DBF
J:\ORACLE\PRD\MIRRLOGA\LOG_G13M2.DBF
J:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF
I:\oracle\PRD\origlogA\cntrl\cntrlPRD.dbf
BR0061I 100 files found for backup, total size 303797.635 MB
BR0143I Backup type: offline_force
BR0113I Files will be compressed by hardware
BR0130I Backup device type: tape
BR0102I Following backup device will be used: /dev/nmt0
BR0103I Following backup volume will be used: PRDB03
BR0289I BRARCHIVE will be started at the end of processing
BR0134I Unattended mode with 'force' active - no operator confirmation allowed
BR0208I Volume with name PRDB03 required in device /dev/nmt0
BR0280I BRBACKUP time stamp: 2015-01-21 23.55.25
BR0226I Rewinding tape volume in device /dev/mt0 ...
BR0351I Restoring F:\oracle\PRD\sapbackup\.tape.hdr0
BR0355I from /dev/nmt0 ...
BR0241I Checking label on volume in device /dev/nmt0
BR0242I Scratch volume in device /dev/nmt0 will be renamed to PRDB03
BR0280I BRBACKUP time stamp: 2015-01-21 23.55.26
BR0226I Rewinding tape volume in device /dev/mt0 ...
BR0202I Saving F:\oracle\PRD\sapbackup\.tape.hdr0
BR0203I to /dev/nmt0 ...

===================================================

I have already checked the backup status of datafiles. It shows not active...

Show replies
Show replies
Brindavan_M
Contributor
‎01-22-2015 9:58 AM
0 Kudos

Hi ,

I think there is a problem in tabe and disk side. Can you check the disk or tabe where the backup files are storing.Also paste the backup log files upto date.

Thanks,

Brindavan

former_member182657
Active Contributor
‎01-22-2015 9:17 AM
0 Kudos

Hi Cinu,

Please share brbackup,alert_SID>.log files for analysis of your issue.Apart from this kindly check status as well as backup status of table spaces from db02old,if possible share snapshot for same.

Meanwhile follow SCn thread

Regards,

Show replies
Show replies
Ask a Question