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: 

Error in backup

Former Member

on ‎07-19-2007 10:32 AM

0 Kudos

Dear All,

I have error in backup.

I scheduled the backup for (whole database + redolog backup ) in DB13.

The backup of datafiles completes sucussfully but it gives error in while switching to next redolog .

<b>I am attaching the few initial line which is below :-</b>

BR0319I Control file copy created: G:\oracle\MRP\sapbackup\CNTRLMRP.DBF 20103168

BR0101I Parameters

Name Value

oracle_sid MRP

oracle_home E:\oracle\MRP\102

oracle_profile E:\oracle\MRP\102\database\initMRP.ora

sapdata_home G:\oracle\MRP

sap_profile E:\oracle\MRP\102\database\initMRP.sap

backup_mode ALL

backup_type online

backup_dev_type tape

compress hardware

tape_copy_cmd dd

cpio_flags -ovB

cpio_in_flags -iuvB

dd_flags bs=64k

dd_in_flags bs=64k

rewind mt -f $ rewind

rewind_offline mt -f $ offline

tape_size 102400.000 MB

tape_address /dev/nmt0

tape_address_rew /dev/mt0

volume_backup SCRATCH

expir_period 7

tape_use_count 100

exec_parallel 0

system_info SAPServiceMRP SAPPRO Windows 5.2 Build 3790 Service Pack 1 Intel

oracle_info MRP 10.2.0.2.0 8192 3264 35480310

sap_info 700 SAPSR3 MRP G0754624292 R3_ORA 0020215773

make_info NTintel OCI_10103_SHARE Apr 2 2006

command_line brbackup -u / -jid ALLOG20070718171331 -c force -t online -m all -p initMRP.sap -v SCRATCH -a -c force -p initM

BR0116I ARCHIVE LOG LIST before backup for database instance MRP

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination F:\oracle\MRP\oraarch\MRParch

Archive format ARC%S_%R.%T

Oldest online log sequence 3261

Next log sequence to archive 3264

Current log sequence 3264 SCN: 35480310

Database block size 8192 Thread: 1

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSi

PSAPSR3 ONLINE* ONLINE+ G:\ORACLE\MRP\SAPDATA1\SR3_1\SR3.DATA1 2097160192 4 6 NOLINK FILE 104857600

PSAPSR3 ONLINE* ONLINE+ G:\ORACLE\MRP\SAPDATA1\SR3_2\SR3.DATA2 2097160192 5 6 NOLINK FILE 104857600

<b>These are the Lines where the error comes.</b>

BR0063I 43 of 43 files processed - 120279.500 MB of 120279.500 MB done

BR0204I Percentage done: 100.00%, estimated end time: 18:58

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2007-07-18 18.58.32

BR0340I Switching to next online redo log file for database instance MRP ...

BR0321I Switch to next online redo log file for database instance MRP successful

BR0117I ARCHIVE LOG LIST after backup for database instance MRP

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination F:\oracle\MRP\oraarch\MRParch

Archive format ARC%S_%R.%T

Oldest online log sequence 3262

Next log sequence to archive 3265

Current log sequence 3265 SCN: 35486991

Database block size 8192 Thread: 1

BR0018I Waiting for the next offline redo log file...

BR0017E Offline redo log file E:\oracle\MRP\102\RDBMS\ARC03264_0603728372.001 not found

BR0056I End of database backup: bdvspucy.ant 2007-07-18 18.58.39

BR0280I BRBACKUP time stamp: 2007-07-18 18.58.39

BR0054I BRBACKUP terminated with error.

Please suggest me.

Thanks n Regards

Bhaskar

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
‎07-26-2007 10:43 AM
0 Kudos

at http://service.sap.com

peter

Show replies
Show replies
Former Member
‎07-26-2007 11:24 AM
0 Kudos

Thanks....I will place it.

former_member204746
Active Contributor
‎07-19-2007 1:56 PM
0 Kudos

E:\oracle\MRP\102\RDBMS looks strange

it should be: E:\oracle\MRP\102\oraarach or E:\oracle\MRP\102\saparch

please provide initSR3.ora

also, are you operating with archive mode ON ?

Show replies
Show replies
Former Member
‎07-20-2007 7:10 AM
0 Kudos

Dear Eric,

Thanks for your reply.

I am sending you the<b> initMRP.ora file</b>,

OPTIMPEEK_USER_BINDS=FALSE

*.background_dump_dest='F:\oracle\MRP\saptrace\background'

*.compatible='10.2.0'

*.control_file_record_keep_time=30

*.control_files='G:\oracle\MRP\origlogA\cntrl\cntrlMRP.dbf','G:\oracle\MRP\origlogB\cntrl\cntrlMRP.dbf','G:\oracle\MRP\sapdata1\cntrl\cntrlMRP.dbf'

*.core_dump_dest='F:\oracle\MRP\saptrace\background'

*.db_block_size=8192

*.db_cache_size=281699942

*.db_files=254

*.db_name='MRP'

*.dml_locks=4000

*.event='10191 trace name context forever, level 1'

*.FILESYSTEMIO_OPTIONS='setall'

*.job_queue_processes=1

*.log_archive_dest='F:\oracle\MRP\oraarch\MRParch'

*.log_buffer=1048576

*.log_checkpoint_interval=0

*.log_checkpoints_to_alert=true

*.open_cursors=800

*.optimizer_features_enable='10.2.0.1'

*.pga_aggregate_target=375599923

*.processes=80

*.recyclebin='off'

*.remote_login_passwordfile='exclusive'

*.remote_os_authent=true

*.sessions=96

*.sga_max_size=563399884

*.shared_pool_reserved_size=28169994

*.shared_pool_size=281699942

*.sort_area_retained_size=0

*.sort_area_size=2097152

*.statistics_level='typical'

*.undo_management='AUTO'

*.undo_retention=43200

*.undo_tablespace='PSAPUNDO'

*.user_dump_dest='F:\oracle\MRP\saptrace\usertrace'

*.workarea_size_policy='AUTO'

Yes the Archive mode is on.

This error only come when I use DB13 to take backup, but if I use Brtools to take backup.........( brbackup) it completes succusfully take the whole database + redo log backup........error comes only in DB13.

Thanks

former_member204746
Active Contributor
‎07-20-2007 3:30 PM
0 Kudos

a few things:

update brtools to latest version.

supply full backup log to see which command is called

check environment variables of user SAPserviceSID.

Former Member
‎07-21-2007 10:09 AM
0 Kudos

I am sending the backup log file

BR0280I BRBACKUP time stamp: 2007-07-18 17.14.00

BR0319I Control file copy created: G:\oracle\MRP\sapbackup\CNTRLMRP.DBF 20103168

BR0101I Parameters

Name Value

oracle_sid MRP

oracle_home E:\oracle\MRP\102

oracle_profile E:\oracle\MRP\102\database\initMRP.ora

sapdata_home G:\oracle\MRP

sap_profile E:\oracle\MRP\102\database\initMRP.sap

backup_mode ALL

backup_type online

backup_dev_type tape

compress hardware

tape_copy_cmd dd

cpio_flags -ovB

cpio_in_flags -iuvB

dd_flags bs=64k

dd_in_flags bs=64k

rewind mt -f $ rewind

rewind_offline mt -f $ offline

tape_size 102400.000 MB

tape_address /dev/nmt0

tape_address_rew /dev/mt0

volume_backup SCRATCH

expir_period 7

tape_use_count 100

exec_parallel 0

system_info SAPServiceMRP SAPPRO Windows 5.2 Build 3790 Service Pack 1 Intel

oracle_info MRP 10.2.0.2.0 8192 3264 35480310

sap_info 700 SAPSR3 MRP G0754624292 R3_ORA 0020215773

make_info NTintel OCI_10103_SHARE Apr 2 2006

command_line brbackup -u / -jid ALLOG20070718171331 -c force -t online -m all -p initMRP.sap -v SCRATCH -a -c force -p initMRP.sap -cds

BR0116I ARCHIVE LOG LIST before backup for database instance MRP

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination F:\oracle\MRP\oraarch\MRParch

Archive format ARC%S_%R.%T

Oldest online log sequence 3261

Next log sequence to archive 3264

Current log sequence 3264 SCN: 35480310

Database block size 8192 Thread: 1

BR0118I Tablespaces and data files

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

PSAPSR3 ONLINE* ONLINE+ G:\ORACLE\MRP\SAPDATA1\SR3_1\SR3.DATA1 2097160192 4 6 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ G:\ORACLE\MRP\SAPDATA1\SR3_2\SR3.DATA2 2097160192 5 6 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ G:\ORACLE\MRP\SAPDATA1\SR3_3\SR3.DATA3 2097160192 6 6 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ G:\ORACLE\MRP\SAPDATA1\SR3_4\SR3.DATA4 2097160192 7 6 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ G:\ORACLE\MRP\SAPDATA1\SR3_5\SR3.DATA5 2097160192 8 6 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ H:\ORACLE\MRP\SAPDATA2\SR3_10\SR3.DATA10 2097160192 13 7 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ H:\ORACLE\MRP\SAPDATA2\SR3_6\SR3.DATA6 2097160192 9 7 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ H:\ORACLE\MRP\SAPDATA2\SR3_7\SR3.DATA7 2097160192 10 7 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ H:\ORACLE\MRP\SAPDATA2\SR3_8\SR3.DATA8 2097160192 11 7 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ H:\ORACLE\MRP\SAPDATA2\SR3_9\SR3.DATA9 2097160192 12 7 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\MRP\SAPDATA3\SR3_11\SR3.DATA11 2097160192 14 8 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\MRP\SAPDATA3\SR3_12\SR3.DATA12 2097160192 15 8 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\MRP\SAPDATA3\SR3_13\SR3.DATA13 2097160192 16 8 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\MRP\SAPDATA3\SR3_14\SR3.DATA14 2097160192 17 8 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\MRP\SAPDATA3\SR3_15\SR3.DATA15 2097160192 18 8 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ J:\ORACLE\MRP\SAPDATA4\SR3_16\SR3.DATA16 2097160192 19 9 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE J:\ORACLE\MRP\SAPDATA4\SR3_17\SR3.DATA17 2097160192 20 9 NOLINK FILE 0 0 8192

PSAPSR3 ONLINE* ONLINE J:\ORACLE\MRP\SAPDATA4\SR3_18\SR3.DATA18 2097160192 21 9 NOLINK FILE 0 0 8192

PSAPSR3 ONLINE* ONLINE+ J:\ORACLE\MRP\SAPDATA4\SR3_19\SR3.DATA19 2097160192 22 9 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ J:\ORACLE\MRP\SAPDATA4\SR3_20\SR3.DATA20 2097160192 23 9 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ G:\ORACLE\MRP\SAPDATA1\SR3700_1\SR3700.DATA1 4236255232 24 6 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ G:\ORACLE\MRP\SAPDATA1\SR3700_2\SR3700.DATA2 4026540032 25 6 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ G:\ORACLE\MRP\SAPDATA1\SR3700_3\SR3700.DATA3 3900710912 26 6 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ G:\ORACLE\MRP\SAPDATA1\SR3700_4\SR3700.DATA4 4110426112 27 6 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ H:\ORACLE\MRP\SAPDATA2\SR3700_5\SR3700.DATA5 3900710912 28 7 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ H:\ORACLE\MRP\SAPDATA2\SR3700_6\SR3700.DATA6 3963625472 29 7 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ H:\ORACLE\MRP\SAPDATA2\SR3700_7\SR3700.DATA7 4152369152 30 7 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ H:\ORACLE\MRP\SAPDATA2\SR3700_8\SR3700.DATA8 4152369152 31 7 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ I:\ORACLE\MRP\SAPDATA3\SR3700_10\SR3700.DATA10 4508884992 33 8 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ I:\ORACLE\MRP\SAPDATA3\SR3700_11\SR3700.DATA11 4257226752 34 8 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ I:\ORACLE\MRP\SAPDATA3\SR3700_12\SR3700.DATA12 4026540032 35 8 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ I:\ORACLE\MRP\SAPDATA3\SR3700_9\SR3700.DATA9 4299169792 32 8 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ J:\ORACLE\MRP\SAPDATA4\SR3700_13\SR3700.DATA13 4068483072 36 9 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ J:\ORACLE\MRP\SAPDATA4\SR3700_14\SR3700.DATA14 4068483072 37 9 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ J:\ORACLE\MRP\SAPDATA4\SR3700_15\SR3700.DATA15 3984596992 38 9 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ J:\ORACLE\MRP\SAPDATA4\SR3700_16\SR3700.DATA16 4047511552 39 9 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ J:\ORACLE\MRP\SAPDATA4\SR3700_17\SR3700.DATA17 4047511552 41 9 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE* ONLINE+ J:\ORACLE\MRP\SAPDATA4\SR3700_18\SR3700.DATA18 4047511552 42 9 NOLINK FILE 10485760000 20971520 8192

PSAPSR3USR ONLINE* ONLINE+ G:\ORACLE\MRP\SAPDATA1\SR3USR_1\SR3USR.DATA1 20979712 40 6 NOLINK FILE 10485760000 20971520 8192

PSAPTEMP ONLINE# ONLINE+ H:\ORACLE\MRP\SAPDATA2\TEMP_1\TEMP.DATA1 2097160192 -1 7 NOLINK FILE 10485760000 20971520 8192

PSAPUNDO ONLINE- ONLINE+ I:\ORACLE\MRP\SAPDATA3\UNDO_1\UNDO.DATA1 9206505472 2 8 NOLINK FILE 10485760000 20971520 8192

SYSAUX ONLINE* ONLINE+ G:\ORACLE\MRP\SAPDATA1\SYSAUX_1\SYSAUX.DATA1 272637952 3 6 NOLINK FILE 10485760000 20971520 8192

SYSTEM ONLINE* SYSTEM+ G:\ORACLE\MRP\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 859840512 1 6 NOLINK FILE 10485760000 20971520 8192

BR0119I Redo log files

File Size Group Device Status Link Type

G:\ORACLE\MRP\ORIGLOGA\LOG_G11M1.DBF 52429312 1 6 INUSE NOLINK FILE

H:\ORACLE\MRP\MIRRLOGA\LOG_G11M2.DBF 52429312 1 7 INUSE NOLINK FILE

G:\ORACLE\MRP\ORIGLOGB\LOG_G12M1.DBF 52429312 2 6 INUSE NOLINK FILE

H:\ORACLE\MRP\MIRRLOGB\LOG_G12M2.DBF 52429312 2 7 INUSE NOLINK FILE

G:\ORACLE\MRP\ORIGLOGA\LOG_G13M1.DBF 52429312 3 6 INUSE NOLINK FILE

H:\ORACLE\MRP\MIRRLOGA\LOG_G13M2.DBF 52429312 3 7 INUSE NOLINK FILE

G:\ORACLE\MRP\ORIGLOGB\LOG_G14M1.DBF 52429312 4 6 INUSE NOLINK FILE

H:\ORACLE\MRP\MIRRLOGB\LOG_G14M2.DBF 52429312 4 7 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

E:\oracle\MRP\102\database\CTL1MRP.ORA 8192 0 0 NOLINK FILE

BR0280I BRBACKUP time stamp: 2007-07-18 17.14.02

BR0057I Backup of database: MRP

BR0058I BRBACKUP action ID: bdvspucy

BR0059I BRBACKUP function ID: ant

BR0110I Backup mode: ALL

BR0077I Database file for backup: G:\oracle\MRP\sapbackup\CNTRLMRP.DBF

BR0061I 43 files found for backup, total size 120279.500 MB

BR0143I Backup type: online

BR0113I Files will be compressed by hardware

BR0130I Backup device type: tape

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

BR0104I 1 scratch volume will be used

BR0289I BRARCHIVE will be started at the end of processing

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

BR0237I Scratch volume required in device /dev/nmt0

BR0280I BRBACKUP time stamp: 2007-07-18 17.14.02

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

BR0351I Restoring G:\oracle\MRP\sapbackup\.tape.hdr0

BR0355I from /dev/nmt0 ...

BR0241I Checking label on volume in device /dev/nmt0

BR0280I BRBACKUP time stamp: 2007-07-18 17.14.06

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

BR0202I Saving G:\oracle\MRP\sapbackup\.tape.hdr0

BR0203I to /dev/nmt0 ...

BR0209I Volume in device /dev/nmt0 has name SCRATCH

BR0202I Saving init_ora

BR0203I to /dev/nmt0 ...

BR0202I Saving E:\oracle\MRP\102\database\initMRP.sap

BR0203I to /dev/nmt0 ...

BR0280I BRBACKUP time stamp: 2007-07-18 17.14.27

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2007-07-18 17.14.27

BR0315I 'Alter tablespace PSAPSR3 begin backup' successful

BR0202I Saving G:\ORACLE\MRP\SAPDATA1\SR3_1\SR3.DATA1

BR0203I to /dev/nmt0 ...

#FILE..... G:\ORACLE\MRP\SAPDATA1\SR3_1\SR3.DATA1

#SAVED.... SR3.DATA1 SCRATCH/4

BR0280I BRBACKUP time stamp: 2007-07-18 17.16.12

BR0063I 1 of 43 files processed - 2000.008 MB of 120279.500 MB done

BR0204I Percentage done: 1.66%, estimated end time: 19:24

BR0001I *_________________________________________________

BR0202I Saving G:\ORACLE\MRP\SAPDATA1\SR3_2\SR3.DATA2

BR0203I to /dev/nmt0 ...

#FILE..... G:\ORACLE\MRP\SAPDATA1\SR3_2\SR3.DATA2

#SAVED.... SR3.DATA2 SCRATCH/5

BR0280I BRBACKUP time stamp: 2007-07-18 17.18.38

BR0063I 2 of 43 files processed - 4000.016 MB of 120279.500 MB done

BR0204I Percentage done: 3.33%, estimated end time: 19:32

BR0001I **________________________________________________

BR0202I Saving G:\ORACLE\MRP\SAPDATA1\SR3_3\SR3.DATA3

BR0203I to /dev/nmt0 ...

#FILE..... G:\ORACLE\MRP\SAPDATA1\SR3_3\SR3.DATA3

#SAVED.... SR3.DATA3 SCRATCH/6

BR0280I BRBACKUP time stamp: 2007-07-18 17.20.09

BR0063I 3 of 43 files processed - 6000.023 MB of 120279.500 MB done

BR0204I Percentage done: 4.99%, estimated end time: 19:16

BR0001I **________________________________________________

BR0202I Saving G:\ORACLE\MRP\SAPDATA1\SR3_4\SR3.DATA4

BR0203I to /dev/nmt0 ...

#FILE..... G:\ORACLE\MRP\SAPDATA1\SR3_4\SR3.DATA4

#SAVED.... SR3.DATA4 SCRATCH/7

BR0280I BRBACKUP time stamp: 2007-07-18 17.22.27

BR0063I 4 of 43 files processed - 8000.031 MB of 120279.500 MB done

BR0204I Percentage done: 6.65%, estimated end time: 19:20

BR0001I ***_______________________________________________

BR0202I Saving G:\ORACLE\MRP\SAPDATA1\SR3_5\SR3.DATA5

BR0203I to /dev/nmt0 ...

#FILE..... G:\ORACLE\MRP\SAPDATA1\SR3_5\SR3.DATA5

#SAVED.... SR3.DATA5 SCRATCH/8

BR0280I BRBACKUP time stamp: 2007-07-18 17.24.12

BR0063I 5 of 43 files processed - 10000.039 MB of 120279.500 MB done

BR0204I Percentage done: 8.31%, estimated end time: 19:16

BR0001I ****______________________________________________

BR0202I Saving H:\ORACLE\MRP\SAPDATA2\SR3_10\SR3.DATA10

BR0203I to /dev/nmt0 ...

#FILE..... H:\ORACLE\MRP\SAPDATA2\SR3_10\SR3.DATA10

#SAVED.... SR3.DATA10 SCRATCH/9

BR0280I BRBACKUP time stamp: 2007-07-18 17.25.33

BR0063I 6 of 43 files processed - 12000.047 MB of 120279.500 MB done

BR0204I Percentage done: 9.98%, estimated end time: 19:09

BR0001I *****_____________________________________________

BR0202I Saving H:\ORACLE\MRP\SAPDATA2\SR3_6\SR3.DATA6

BR0203I to /dev/nmt0 ...

#FILE..... H:\ORACLE\MRP\SAPDATA2\SR3_6\SR3.DATA6

#SAVED.... SR3.DATA6 SCRATCH/10

BR0280I BRBACKUP time stamp: 2007-07-18 17.26.28

BR0063I 7 of 43 files processed - 14000.055 MB of 120279.500 MB done

BR0204I Percentage done: 11.64%, estimated end time: 19:00

BR0001I ******____________________________________________

BR0202I Saving H:\ORACLE\MRP\SAPDATA2\SR3_7\SR3.DATA7

BR0203I to /dev/nmt0 ...

#FILE..... H:\ORACLE\MRP\SAPDATA2\SR3_7\SR3.DATA7

#SAVED.... SR3.DATA7 SCRATCH/11

BR0280I BRBACKUP time stamp: 2007-07-18 17.27.26

BR0063I 8 of 43 files processed - 16000.063 MB of 120279.500 MB done

BR0204I Percentage done: 13.30%, estimated end time: 18:54

BR0001I *******___________________________________________

BR0202I Saving H:\ORACLE\MRP\SAPDATA2\SR3_8\SR3.DATA8

BR0203I to /dev/nmt0 ...

#FILE..... H:\ORACLE\MRP\SAPDATA2\SR3_8\SR3.DATA8

#SAVED.... SR3.DATA8 SCRATCH/12

BR0280I BRBACKUP time stamp: 2007-07-18 17.28.28

BR0063I 9 of 43 files processed - 18000.070 MB of 120279.500 MB done

BR0204I Percentage done: 14.97%, estimated end time: 18:50

BR0001I *******___________________________________________

BR0202I Saving H:\ORACLE\MRP\SAPDATA2\SR3_9\SR3.DATA9

BR0203I to /dev/nmt0 ...

#FILE..... H:\ORACLE\MRP\SAPDATA2\SR3_9\SR3.DATA9

#SAVED.... SR3.DATA9 SCRATCH/13

BR0280I BRBACKUP time stamp: 2007-07-18 17.31.03

BR0063I 10 of 43 files processed - 20000.078 MB of 120279.500 MB done

BR0204I Percentage done: 16.63%, estimated end time: 18:56

BR0001I ********__________________________________________

BR0202I Saving I:\ORACLE\MRP\SAPDATA3\SR3_11\SR3.DATA11

BR0203I to /dev/nmt0 ...

#FILE..... I:\ORACLE\MRP\SAPDATA3\SR3_11\SR3.DATA11

#SAVED.... SR3.DATA11 SCRATCH/14

BR0280I BRBACKUP time stamp: 2007-07-18 17.32.01

BR0063I 11 of 43 files processed - 22000.086 MB of 120279.500 MB done

BR0204I Percentage done: 18.29%, estimated end time: 18:52

BR0001I *********_________________________________________

BR0202I Saving I:\ORACLE\MRP\SAPDATA3\SR3_12\SR3.DATA12

BR0203I to /dev/nmt0 ...

#FILE..... I:\ORACLE\MRP\SAPDATA3\SR3_12\SR3.DATA12

#SAVED.... SR3.DATA12 SCRATCH/15

BR0280I BRBACKUP time stamp: 2007-07-18 17.32.56

BR0063I 12 of 43 files processed - 24000.094 MB of 120279.500 MB done

BR0204I Percentage done: 19.95%, estimated end time: 18:48

BR0001I **********________________________________________

BR0202I Saving I:\ORACLE\MRP\SAPDATA3\SR3_13\SR3.DATA13

BR0203I to /dev/nmt0 ...

#FILE..... I:\ORACLE\MRP\SAPDATA3\SR3_13\SR3.DATA13

#SAVED.... SR3.DATA13 SCRATCH/16

BR0280I BRBACKUP time stamp: 2007-07-18 17.34.35

BR0063I 13 of 43 files processed - 26000.102 MB of 120279.500 MB done

BR0204I Percentage done: 21.62%, estimated end time: 18:49

BR0001I ***********_______________________________________

BR0202I Saving I:\ORACLE\MRP\SAPDATA3\SR3_14\SR3.DATA14

BR0203I to /dev/nmt0 ...

#FILE..... I:\ORACLE\MRP\SAPDATA3\SR3_14\SR3.DATA14

#SAVED.... SR3.DATA14 SCRATCH/17

BR0280I BRBACKUP time stamp: 2007-07-18 17.36.07

BR0063I 14 of 43 files processed - 28000.109 MB of 120279.500 MB done

BR0204I Percentage done: 23.28%, estimated end time: 18:48

BR0001I ************______________________________________

BR0202I Saving I:\ORACLE\MRP\SAPDATA3\SR3_15\SR3.DATA15

BR0203I to /dev/nmt0 ...

#FILE..... I:\ORACLE\MRP\SAPDATA3\SR3_15\SR3.DATA15

#SAVED.... SR3.DATA15 SCRATCH/18

BR0280I BRBACKUP time stamp: 2007-07-18 17.37.55

BR0063I 15 of 43 files processed - 30000.117 MB of 120279.500 MB done

BR0204I Percentage done: 24.94%, estimated end time: 18:49

BR0001I ************______________________________________

BR0202I Saving J:\ORACLE\MRP\SAPDATA4\SR3_16\SR3.DATA16

BR0203I to /dev/nmt0 ...

#FILE..... J:\ORACLE\MRP\SAPDATA4\SR3_16\SR3.DATA16

#SAVED.... SR3.DATA16 SCRATCH/19

BR0280I BRBACKUP time stamp: 2007-07-18 17.39.28

BR0063I 16 of 43 files processed - 32000.125 MB of 120279.500 MB done

BR0204I Percentage done: 26.60%, estimated end time: 18:49

BR0001I *************_____________________________________

BR0202I Saving J:\ORACLE\MRP\SAPDATA4\SR3_17\SR3.DATA17

BR0203I to /dev/nmt0 ...

#FILE..... J:\ORACLE\MRP\SAPDATA4\SR3_17\SR3.DATA17

#SAVED.... SR3.DATA17 SCRATCH/20

BR0280I BRBACKUP time stamp: 2007-07-18 17.41.00

BR0063I 17 of 43 files processed - 34000.133 MB of 120279.500 MB done

BR0204I Percentage done: 28.27%, estimated end time: 18:49

BR0001I **************____________________________________

BR0202I Saving J:\ORACLE\MRP\SAPDATA4\SR3_18\SR3.DATA18

BR0203I to /dev/nmt0 ...

#FILE..... J:\ORACLE\MRP\SAPDATA4\SR3_18\SR3.DATA18

#SAVED.... SR3.DATA18 SCRATCH/21

BR0280I BRBACKUP time stamp: 2007-07-18 17.43.00

BR0063I 18 of 43 files processed - 36000.141 MB of 120279.500 MB done

BR0204I Percentage done: 29.93%, estimated end time: 18:50

BR0001I ***************___________________________________

BR0202I Saving J:\ORACLE\MRP\SAPDATA4\SR3_19\SR3.DATA19

BR0203I to /dev/nmt0 ...

#FILE..... J:\ORACLE\MRP\SAPDATA4\SR3_19\SR3.DATA19

#SAVED.... SR3.DATA19 SCRATCH/22

BR0280I BRBACKUP time stamp: 2007-07-18 17.44.44

BR0063I 19 of 43 files processed - 38000.148 MB of 120279.500 MB done

BR0204I Percentage done: 31.59%, estimated end time: 18:51

BR0001I ****************__________________________________

BR0202I Saving J:\ORACLE\MRP\SAPDATA4\SR3_20\SR3.DATA20

BR0203I to /dev/nmt0 ...

#FILE..... J:\ORACLE\MRP\SAPDATA4\SR3_20\SR3.DATA20

#SAVED.... SR3.DATA20 SCRATCH/23

BR0280I BRBACKUP time stamp: 2007-07-18 17.46.47

BR0063I 20 of 43 files processed - 40000.156 MB of 120279.500 MB done

BR0204I Percentage done: 33.26%, estimated end time: 18:52

BR0001I *****************_________________________________

BR0280I BRBACKUP time stamp: 2007-07-18 17.46.48

BR0317I 'Alter tablespace PSAPSR3 end backup' successful

BR0280I BRBACKUP time stamp: 2007-07-18 17.46.48

BR0315I 'Alter tablespace PSAPSR3700 begin backup' successful

BR0202I Saving G:\ORACLE\MRP\SAPDATA1\SR3700_1\SR3700.DATA1

BR0203I to /dev/nmt0 ...

#FILE..... G:\ORACLE\MRP\SAPDATA1\SR3700_1\SR3700.DATA1

#SAVED.... SR3700.DATA1 SCRATCH/24

BR0280I BRBACKUP time stamp: 2007-07-18 17.51.25

BR0063I 21 of 43 files processed - 44040.164 MB of 120279.500 MB done

BR0204I Percentage done: 36.61%, estimated end time: 18:56

BR0001I ******************________________________________

BR0202I Saving G:\ORACLE\MRP\SAPDATA1\SR3700_2\SR3700.DATA2

BR0203I to /dev/nmt0 ...

#FILE..... G:\ORACLE\MRP\SAPDATA1\SR3700_2\SR3700.DATA2

#SAVED.... SR3700.DATA2 SCRATCH/25

BR0280I BRBACKUP time stamp: 2007-07-18 17.55.26

BR0063I 22 of 43 files processed - 47880.172 MB of 120279.500 MB done

BR0204I Percentage done: 39.81%, estimated end time: 18:58

BR0001I ********************______________________________

BR0202I Saving G:\ORACLE\MRP\SAPDATA1\SR3700_3\SR3700.DATA3

BR0203I to /dev/nmt0 ...

#FILE..... G:\ORACLE\MRP\SAPDATA1\SR3700_3\SR3700.DATA3

#SAVED.... SR3700.DATA3 SCRATCH/26

BR0280I BRBACKUP time stamp: 2007-07-18 17.59.36

BR0063I 23 of 43 files processed - 51600.180 MB of 120279.500 MB done

BR0204I Percentage done: 42.90%, estimated end time: 19:00

BR0001I *********************_____________________________

BR0202I Saving G:\ORACLE\MRP\SAPDATA1\SR3700_4\SR3700.DATA4

BR0203I to /dev/nmt0 ...

#FILE..... G:\ORACLE\MRP\SAPDATA1\SR3700_4\SR3700.DATA4

#SAVED.... SR3700.DATA4 SCRATCH/27

BR0280I BRBACKUP time stamp: 2007-07-18 18.04.30

BR0063I 24 of 43 files processed - 55520.188 MB of 120279.500 MB done

BR0204I Percentage done: 46.16%, estimated end time: 19:03

BR0001I ***********************___________________________

BR0202I Saving H:\ORACLE\MRP\SAPDATA2\SR3700_5\SR3700.DATA5

BR0203I to /dev/nmt0 ...

#FILE..... H:\ORACLE\MRP\SAPDATA2\SR3700_5\SR3700.DATA5

#SAVED.... SR3700.DATA5 SCRATCH/28

BR0280I BRBACKUP time stamp: 2007-07-18 18.10.30

BR0063I 25 of 43 files processed - 59240.195 MB of 120279.500 MB done

BR0204I Percentage done: 49.25%, estimated end time: 19:08

BR0001I *************************_________________________

BR0202I Saving H:\ORACLE\MRP\SAPDATA2\SR3700_6\SR3700.DATA6

BR0203I to /dev/nmt0 ...

#FILE..... H:\ORACLE\MRP\SAPDATA2\SR3700_6\SR3700.DATA6

#SAVED.... SR3700.DATA6 SCRATCH/29

BR0280I BRBACKUP time stamp: 2007-07-18 18.14.34

BR0063I 26 of 43 files processed - 63020.203 MB of 120279.500 MB done

BR0204I Percentage done: 52.39%, estimated end time: 19:09

BR0001I **************************________________________

BR0202I Saving H:\ORACLE\MRP\SAPDATA2\SR3700_7\SR3700.DATA7

BR0203I to /dev/nmt0 ...

#FILE..... H:\ORACLE\MRP\SAPDATA2\SR3700_7\SR3700.DATA7

#SAVED.... SR3700.DATA7 SCRATCH/30

BR0280I BRBACKUP time stamp: 2007-07-18 18.17.31

BR0063I 27 of 43 files processed - 66980.211 MB of 120279.500 MB done

BR0204I Percentage done: 55.69%, estimated end time: 19:08

BR0001I ****************************______________________

BR0202I Saving H:\ORACLE\MRP\SAPDATA2\SR3700_8\SR3700.DATA8

BR0203I to /dev/nmt0 ...

#FILE..... H:\ORACLE\MRP\SAPDATA2\SR3700_8\SR3700.DATA8

#SAVED.... SR3700.DATA8 SCRATCH/31

BR0280I BRBACKUP time stamp: 2007-07-18 18.20.51

BR0063I 28 of 43 files processed - 70940.219 MB of 120279.500 MB done

BR0204I Percentage done: 58.98%, estimated end time: 19:07

BR0001I *****************************_____________________

BR0202I Saving I:\ORACLE\MRP\SAPDATA3\SR3700_10\SR3700.DATA10

BR0203I to /dev/nmt0 ...

#FILE..... I:\ORACLE\MRP\SAPDATA3\SR3700_10\SR3700.DATA10

#SAVED.... SR3700.DATA10 SCRATCH/32

BR0280I BRBACKUP time stamp: 2007-07-18 18.24.33

BR0063I 29 of 43 files processed - 75240.227 MB of 120279.500 MB done

BR0204I Percentage done: 62.55%, estimated end time: 19:06

BR0001I *******************************___________________

BR0202I Saving I:\ORACLE\MRP\SAPDATA3\SR3700_11\SR3700.DATA11

BR0203I to /dev/nmt0 ...

#FILE..... I:\ORACLE\MRP\SAPDATA3\SR3700_11\SR3700.DATA11

#SAVED.... SR3700.DATA11 SCRATCH/33

BR0280I BRBACKUP time stamp: 2007-07-18 18.27.54

BR0063I 30 of 43 files processed - 79300.234 MB of 120279.500 MB done

BR0204I Percentage done: 65.93%, estimated end time: 19:06

BR0001I *********************************_________________

BR0202I Saving I:\ORACLE\MRP\SAPDATA3\SR3700_12\SR3700.DATA12

BR0203I to /dev/nmt0 ...

#FILE..... I:\ORACLE\MRP\SAPDATA3\SR3700_12\SR3700.DATA12

#SAVED.... SR3700.DATA12 SCRATCH/34

BR0280I BRBACKUP time stamp: 2007-07-18 18.31.34

BR0063I 31 of 43 files processed - 83140.242 MB of 120279.500 MB done

BR0204I Percentage done: 69.12%, estimated end time: 19:06

BR0001I ***********************************_______________

BR0202I Saving I:\ORACLE\MRP\SAPDATA3\SR3700_9\SR3700.DATA9

BR0203I to /dev/nmt0 ...

#FILE..... I:\ORACLE\MRP\SAPDATA3\SR3700_9\SR3700.DATA9

#SAVED.... SR3700.DATA9 SCRATCH/35

BR0280I BRBACKUP time stamp: 2007-07-18 18.34.35

BR0063I 32 of 43 files processed - 87240.250 MB of 120279.500 MB done

BR0204I Percentage done: 72.53%, estimated end time: 19:05

BR0001I ************************************______________

BR0202I Saving J:\ORACLE\MRP\SAPDATA4\SR3700_13\SR3700.DATA13

BR0203I to /dev/nmt0 ...

#FILE..... J:\ORACLE\MRP\SAPDATA4\SR3700_13\SR3700.DATA13

#SAVED.... SR3700.DATA13 SCRATCH/36

BR0280I BRBACKUP time stamp: 2007-07-18 18.37.45

BR0063I 33 of 43 files processed - 91120.258 MB of 120279.500 MB done

BR0204I Percentage done: 75.76%, estimated end time: 19:04

BR0001I **************************************____________

BR0202I Saving J:\ORACLE\MRP\SAPDATA4\SR3700_14\SR3700.DATA14

BR0203I to /dev/nmt0 ...

#FILE..... J:\ORACLE\MRP\SAPDATA4\SR3700_14\SR3700.DATA14

#SAVED.... SR3700.DATA14 SCRATCH/37

BR0280I BRBACKUP time stamp: 2007-07-18 18.40.36

BR0063I 34 of 43 files processed - 95000.266 MB of 120279.500 MB done

BR0204I Percentage done: 78.98%, estimated end time: 19:03

BR0001I ***************************************___________

BR0202I Saving J:\ORACLE\MRP\SAPDATA4\SR3700_15\SR3700.DATA15

BR0203I to /dev/nmt0 ...

#FILE..... J:\ORACLE\MRP\SAPDATA4\SR3700_15\SR3700.DATA15

#SAVED.... SR3700.DATA15 SCRATCH/38

BR0280I BRBACKUP time stamp: 2007-07-18 18.43.48

BR0063I 35 of 43 files processed - 98800.273 MB of 120279.500 MB done

BR0204I Percentage done: 82.14%, estimated end time: 19:03

BR0001I *****************************************_________

BR0202I Saving J:\ORACLE\MRP\SAPDATA4\SR3700_16\SR3700.DATA16

BR0203I to /dev/nmt0 ...

#FILE..... J:\ORACLE\MRP\SAPDATA4\SR3700_16\SR3700.DATA16

#SAVED.... SR3700.DATA16 SCRATCH/39

BR0280I BRBACKUP time stamp: 2007-07-18 18.46.48

BR0063I 36 of 43 files processed - 102660.281 MB of 120279.500 MB done

BR0204I Percentage done: 85.35%, estimated end time: 19:02

BR0001I *******************************************_______

BR0202I Saving J:\ORACLE\MRP\SAPDATA4\SR3700_17\SR3700.DATA17

BR0203I to /dev/nmt0 ...

#FILE..... J:\ORACLE\MRP\SAPDATA4\SR3700_17\SR3700.DATA17

#SAVED.... SR3700.DATA17 SCRATCH/40

BR0280I BRBACKUP time stamp: 2007-07-18 18.48.59

BR0063I 37 of 43 files processed - 106520.289 MB of 120279.500 MB done

BR0204I Percentage done: 88.56%, estimated end time: 19:01

BR0001I ********************************************______

BR0202I Saving J:\ORACLE\MRP\SAPDATA4\SR3700_18\SR3700.DATA18

BR0203I to /dev/nmt0 ...

#FILE..... J:\ORACLE\MRP\SAPDATA4\SR3700_18\SR3700.DATA18

#SAVED.... SR3700.DATA18 SCRATCH/41

BR0280I BRBACKUP time stamp: 2007-07-18 18.50.51

BR0063I 38 of 43 files processed - 110380.297 MB of 120279.500 MB done

BR0204I Percentage done: 91.77%, estimated end time: 18:59

BR0001I **********************************************____

BR0280I BRBACKUP time stamp: 2007-07-18 18.50.52

BR0317I 'Alter tablespace PSAPSR3700 end backup' successful

BR0280I BRBACKUP time stamp: 2007-07-18 18.50.52

BR0315I 'Alter tablespace PSAPSR3USR begin backup' successful

BR0202I Saving G:\ORACLE\MRP\SAPDATA1\SR3USR_1\SR3USR.DATA1

BR0203I to /dev/nmt0 ...

#FILE..... G:\ORACLE\MRP\SAPDATA1\SR3USR_1\SR3USR.DATA1

#SAVED.... SR3USR.DATA1 SCRATCH/42

BR0280I BRBACKUP time stamp: 2007-07-18 18.50.58

BR0063I 39 of 43 files processed - 110400.305 MB of 120279.500 MB done

BR0204I Percentage done: 91.79%, estimated end time: 18:59

BR0001I **********************************************____

BR0280I BRBACKUP time stamp: 2007-07-18 18.50.59

BR0317I 'Alter tablespace PSAPSR3USR end backup' successful

BR0280I BRBACKUP time stamp: 2007-07-18 18.50.59

BR0315I 'Alter tablespace PSAPUNDO begin backup' successful

BR0202I Saving I:\ORACLE\MRP\SAPDATA3\UNDO_1\UNDO.DATA1

BR0203I to /dev/nmt0 ...

#FILE..... I:\ORACLE\MRP\SAPDATA3\UNDO_1\UNDO.DATA1

#SAVED.... UNDO.DATA1 SCRATCH/43

BR0280I BRBACKUP time stamp: 2007-07-18 18.57.37

BR0063I 40 of 43 files processed - 119180.313 MB of 120279.500 MB done

BR0204I Percentage done: 99.09%, estimated end time: 18:58

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2007-07-18 18.57.37

BR0317I 'Alter tablespace PSAPUNDO end backup' successful

BR0280I BRBACKUP time stamp: 2007-07-18 18.57.37

BR0315I 'Alter tablespace SYSAUX begin backup' successful

BR0202I Saving G:\ORACLE\MRP\SAPDATA1\SYSAUX_1\SYSAUX.DATA1

BR0203I to /dev/nmt0 ...

#FILE..... G:\ORACLE\MRP\SAPDATA1\SYSAUX_1\SYSAUX.DATA1

#SAVED.... SYSAUX.DATA1 SCRATCH/44

BR0280I BRBACKUP time stamp: 2007-07-18 18.57.49

BR0063I 41 of 43 files processed - 119440.320 MB of 120279.500 MB done

BR0204I Percentage done: 99.30%, estimated end time: 18:58

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2007-07-18 18.57.49

BR0317I 'Alter tablespace SYSAUX end backup' successful

BR0280I BRBACKUP time stamp: 2007-07-18 18.57.49

BR0315I 'Alter tablespace SYSTEM begin backup' successful

BR0202I Saving G:\ORACLE\MRP\SAPDATA1\SYSTEM_1\SYSTEM.DATA1

BR0203I to /dev/nmt0 ...

#FILE..... G:\ORACLE\MRP\SAPDATA1\SYSTEM_1\SYSTEM.DATA1

#SAVED.... SYSTEM.DATA1 SCRATCH/45

BR0280I BRBACKUP time stamp: 2007-07-18 18.58.23

BR0063I 42 of 43 files processed - 120260.328 MB of 120279.500 MB done

BR0204I Percentage done: 99.98%, estimated end time: 18:58

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2007-07-18 18.58.23

BR0317I 'Alter tablespace SYSTEM end backup' successful

BR0202I Saving G:\oracle\MRP\sapbackup\CNTRLMRP.DBF

BR0203I to /dev/nmt0 ...

#FILE..... G:\oracle\MRP\sapbackup\CNTRLMRP.DBF

#SAVED.... CNTRLMRP.DBF SCRATCH/46

BR0280I BRBACKUP time stamp: 2007-07-18 18.58.28

BR0063I 43 of 43 files processed - 120279.500 MB of 120279.500 MB done

BR0204I Percentage done: 100.00%, estimated end time: 18:58

BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2007-07-18 18.58.32

BR0340I Switching to next online redo log file for database instance MRP ...

BR0321I Switch to next online redo log file for database instance MRP successful

BR0117I ARCHIVE LOG LIST after backup for database instance MRP

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination F:\oracle\MRP\oraarch\MRParch

Archive format ARC%S_%R.%T

Oldest online log sequence 3262

Next log sequence to archive 3265

Current log sequence 3265 SCN: 35486991

Database block size 8192 Thread: 1

BR0018I Waiting for the next offline redo log file...

BR0017E Offline redo log file E:\oracle\MRP\102\RDBMS\ARC03264_0603728372.001 not found

BR0056I End of database backup: bdvspucy.ant 2007-07-18 18.58.39

BR0280I BRBACKUP time stamp: 2007-07-18 18.58.39

BR0054I BRBACKUP terminated with errors

Thanks

Former Member
‎07-19-2007 1:21 PM
0 Kudos

can you tell us the output of the sqlplus statement:

show parameter archive_log_dest

as well as the initMRP.ora parameter line containing archive_log_dest

?

Peter

Show replies
Show replies
Ask a Question