Welcome! Guest
New User? Register | Login

Home » Forums » BASIS

Error in Taking incremental Backup

By: Shailesh Singh | 13 Aug 2008 10:37 am

Hi,

i am facing one prblem that when i take Full Backup it works but when i take incremental Backup is givs this error..

Please check

Detail log: bdyooltt . int

BR0051I BRBACKUP 6.40 (36)

BR0055I Start of database backup: bdyooltt.int 2008-08-12 20.10.29

BR0477I Oracle pfile I:\ORACLE\PRD\920_32\database\initPRD.ora created from spfile I:\ORACLE\PRD\920_32\database\spfilePRD.ora

BR0101I Parameters

Name Value

oracle_sid PRD

oracle_home I:\ORACLE\PRD\920_32

oracle_profile I:\ORACLE\PRD\920_32\database\initPRD.ora

sapdata_home H:\oracle\PRD

sap_profile I:\ORACLE\PRD\920_32\database\initPRD.sap

backup_mode INCR

backup_type online

backup_dev_type tape

compress no

tape_copy_cmd dd

cpio_flags -ovB

cpio_in_flags -iuvB

dd_flags bs=32k

dd_in_flags bs=32k

rewind mt -f $ rewind

rewind_offline mt -f $ offline

tape_size 204800.000 MB

tape_address /dev/nmt0

tape_address_rew /dev/mt0

volume_backup PRDB312

expir_period 30

tape_use_count 100

exec_parallel 0

system_info SAPServicePRD SAPPRD Windows 5.2 Build 3790 Service Pack 1 Intel

oracle_info PRD 9.2.0.6.0 8192 4645 103501535

sap_info 640 SAPPRD PRD Q1830408869 R3_ORA 0020197118

make_info NTintel OCI_920_SHARE Jan 15 2006

command_line brbackup -u / -c force -t online -m incr -p initPRD.sap -v PRDB312 -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 G:\oracle\PRD\oraarch\PRDarch

Archive format ARC%S.%T

Oldest online log sequence 4642

Next log sequence to archive 4645

Current log sequence 4645 SCN: 103501535

Database block size 8192 Thread: 1

BR0118I Tablespaces and data files

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

PSAPPRD ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA3\PRD_1\PRD.DATA1 2998935552 3 9 NOLINK FILE 10485760000 20971520

PSAPPRD ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA3\PRD_2\PRD.DATA2 3145736192 4 9 NOLINK FILE 10485760000 20971520

PSAPPRD ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA3\PRD_3\PRD.DATA3 3061850112 5 9 NOLINK FILE 10485760000 20971520

PSAPPRD ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA3\PRD_4\PRD.DATA4 2956992512 6 9 NOLINK FILE 10485760000 20971520

PSAPPRD ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA4\PRD_6\PRD.DATA6 2956992512 8 9 NOLINK FILE 10485760000 20971520

PSAPPRD ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA4\PRD_8\PRD.DATA8 3061850112 10 9 NOLINK FILE 10485760000 20971520

PSAPPRD ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA4\PRD_10\PRD.DATA10 2810191872 12 9 NOLINK FILE 10485760000 20971520

PSAPPRD ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA4\PRD_9\PRD.DATA9 2956992512 11 9 NOLINK FILE 10485760000 20971520

PSAPPRD ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA4\PRD_7\PRD.DATA7 2873106432 9 9 NOLINK FILE 10485760000 20971520

PSAPPRD ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA5\PRD_11\PRD.DATA11 2810191872 27 9 NOLINK FILE 10485760000 20971520

PSAPPRD ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA3\PRD_5\PRD.DATA5 3103793152 7 9 NOLINK FILE 10485760000 20971520

PSAPPRD640 ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA1\PRD640_1\PRD640.DATA1 2097160192 13 9 NOLINK FILE 10485760000 20971520

PSAPPRD640 ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA1\PRD640_2\PRD640.DATA2 2097160192 14 9 NOLINK FILE 10485760000 20971520

PSAPPRD640 ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA1\PRD640_4\PRD640.DATA4 2097160192 16 9 NOLINK FILE 10485760000 20971520

PSAPPRD640 ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA2\PRD640_6\PRD640.DATA6 2097160192 18 9 NOLINK FILE 10485760000 20971520

PSAPPRD640 ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA2\PRD640_8\PRD640.DATA8 2097160192 20 9 NOLINK FILE 10485760000 20971520

PSAPPRD640 ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA2\PRD640_10\PRD640.DATA10 2097160192 22 9 NOLINK FILE 10485760000 20971520

PSAPPRD640 ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA4\PRD640_12\PRD640.DATA12 2097160192 24 9 NOLINK FILE 10485760000 20971520

PSAPPRD640 ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA5\PRD640_14\PRD640.DATA14 2097160192 28 9 NOLINK FILE 10485760000 20971520

PSAPPRD640 ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA4\PRD640_13\PRD640.DATA13 2097160192 25 9 NOLINK FILE 10485760000 20971520

PSAPPRD640 ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA3\PRD640_11\PRD640.DATA11 2097160192 23 9 NOLINK FILE 10485760000 20971520

PSAPPRD640 ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA2\PRD640_9\PRD640.DATA9 2097160192 21 9 NOLINK FILE 10485760000 20971520

PSAPPRD640 ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA2\PRD640_7\PRD640.DATA7 2097160192 19 9 NOLINK FILE 10485760000 20971520

PSAPPRD640 ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA1\PRD640_5\PRD640.DATA5 2097160192 17 9 NOLINK FILE 10485760000 20971520

PSAPPRD640 ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA1\PRD640_3\PRD640.DATA3 2097160192 15 9 NOLINK FILE 10485760000 20971520

PSAPPRDUSR ONLINE* ONLINE+ J:\ORACLE\PRD\SAPDATA4\PRDUSR_1\PRDUSR.DATA1 20979712 26 9 NOLINK FILE 10485760000 20971520

PSAPTEMP ONLINE# ONLINE+ J:\ORACLE\PRD\SAPDATA1\TEMP_1\TEMP.DATA1 702554112 -1 9 NOLINK FILE 10485760000 20971520

PSAPUNDO ONLINE- ONLINE+ J:\ORACLE\PRD\SAPDATA1\UNDO_1\UNDO.DATA1 9143590912 2 9 NOLINK FILE 10485760000 20971520

SYSTEM ONLINE* SYSTEM+ J:\ORACLE\PRD\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 597696512 1 9 NOLINK FILE 10485760000 20971520

BR0119I Redo log files

File Size Group Device Status Link Type

M:\ORACLE\PRD\ORIGLOGA\LOG_G11M1.DBF 52429312 1 12 INUSE NOLINK FILE

O:\ORACLE\PRD\MIRRLOGA\LOG_G11M2.DBF 52429312 1 14 INUSE NOLINK FILE

N:\ORACLE\PRD\ORIGLOGB\LOG_G12M1.DBF 52429312 2 13 INUSE NOLINK FILE

P:\ORACLE\PRD\MIRRLOGB\LOG_G12M2.DBF 52429312 2 15 INUSE NOLINK FILE

M:\ORACLE\PRD\ORIGLOGA\LOG_G13M1.DBF 52429312 3 12 INUSE NOLINK FILE

O:\ORACLE\PRD\MIRRLOGA\LOG_G13M2.DBF 52429312 3 14 INUSE NOLINK FILE

N:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF 52429312 4 13 INUSE NOLINK FILE

P:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF 52429312 4 15 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

M:\oracle\PRD\origlogA\cntrl\cntrlPRD.dbf 6791168 0 12 NOLINK FILE

J:\oracle\PRD\sapdata1\system_1\cntrl\cntrlPRD.dbf 6791168 0 9 NOLINK FILE

H:\oracle\PRD\saparch\cntrl\cntrlPRD.dbf 6791168 0 7 NOLINK FILE

BR0514I Following files created after the last full database backup (level 0) will be fully saved:

J:\ORACLE\PRD\SAPDATA5\PRD_11\PRD.DATA11

J:\ORACLE\PRD\SAPDATA5\PRD640_14\PRD640.DATA14

BR0280I BRBACKUP time stamp: 2008-08-12 20.10.32

BR0057I Backup of database: PRD

BR0058I BRBACKUP action ID: bdyooltt

BR0059I BRBACKUP function ID: int

BR0110I Backup mode: INCR

BR0077I Database files for backup:

J:\ORACLE\PRD\SAPDATA5\PRD_11\PRD.DATA11

J:\ORACLE\PRD\SAPDATA5\PRD640_14\PRD640.DATA14

H:\oracle\PRD\sapbackup\cntrlPRD.dbf

BR0061I 4 files found for backup, total size 5378.494 MB

BR0513I Last full database backup (level 0): bdynuunn.fnt 2008-08-08 20.10.31

BR0143I Backup type: online

BR0112I Files will not be compressed

BR0130I Backup device type: tape

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

BR0103I Following backup volume will be used: PRDB312

BR0289I BRARCHIVE will be started at the end of processing

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

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

BR0280I BRBACKUP time stamp: 2008-08-12 20.10.32

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

BR0351I Restoring H:\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 PRDB312

BR0280I BRBACKUP time stamp: 2008-08-12 20.10.32

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

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

BR0203I to /dev/nmt0 ...

BR0209I Volume in device /dev/nmt0 has name PRDB312

BR0202I Saving init_ora

BR0203I to /dev/nmt0 ...

BR0202I Saving I:\ORACLE\PRD\920_32\database\initPRD.sap

BR0203I to /dev/nmt0 ...

BR0280I BRBACKUP time stamp: 2008-08-12 20.10.42

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2008-08-12 20.10.42

BR0510I Starting full backup for new database files using RMAN...

BR0202I Saving J:\ORACLE\PRD\SAPDATA5\PRD_11\PRD.DATA11

BR0202I Saving J:\ORACLE\PRD\SAPDATA5\PRD640_14\PRD640.DATA14

BR0203I to /dev/nmt0 ...

BR0252E Function SetTapeParameters() failed for '/dev/nmt0' at location BrTapeSetup-6

BR0253E errno 87: The parameter is incorrect.

BR0280I BRBACKUP time stamp: 2008-08-12 20.10.42

BR0512I Full backup for new database files using RMAN failed

BR0222E Copying J:\ORACLE\PRD\SAPDATA5\PRD_11\PRD.DATA11 to/from /dev/nmt0 failed due to previous errors

BR0056I End of database backup: bdyooltt.int 2008-08-12 20.10.42

BR0280I BRBACKUP time stamp: 2008-08-12 20.10.45

BR0054I BRBACKUP terminated with errors

Comments

No Comments Posted for this Article.

Leave a comment

You must be Loged in to post a comment.

Tutorials
Forum
Books
Interview Questions

Backup Log Overview DB12
Through this T-Code we can check the Backup logs Run T-Code DB12 Now Click on the Overview of database Backup button in Database Backup Tab This will bring you to Database backup Logs Screen ...
Backup Media is not Recognizing
While taking backup via DB13, i am getting the following error ... "Executed as user: NT AUTHORITY\\SYSTEM. The user-specified MEDIANAME "R D24S" does not match the MEDIANAME...
backup restore our system crash due to hardware problem after hardware problem solveing
our system crash due to hardware problem after hardware problem solveing we restore sap database backup but the system state is dated on when we take backup during backup taking to system crash we...
SAP Backup in DB2
Hi Friends, I have installed Ecc6.0 with DB2 9.0 as back-end in Windows 2008 Environment. Since I am very new to DB2, could any one please tell me the steps to follow to take SAP backup (SAP Full...
How to take Databse Backup in more then one Tape
Hi all I have to take offline Whole database backup but my database is of 400GB and my Tape Drive is of 200/400 GB, and in my Tape Drive can only store one tape at a time so pleas tell me if my tape...
ECC Backup Strategy
generic backup strategy you have follow as the below 1. daily prd system as you prepared time 2. weekly once non prd system as you prepared time you need backup operator or storgae people to...
Homogeneous system copy with MaxDB (SAP DB)
This note is used as an addition for the notes "INST: X.XX R/3 Inst. - Homogeneous System Copy" You want to import a backup from a SAP DB or MaxDB database instance into another SAP DB...
Backup of customized request
Hi can anybody guide me how to take back up of customized request. since my project is completed i need to take a backup of my customized project to make use of the same in future. rgds
Full R/3 Backup
The Full R/3 Backup Transaction Log Backup Full Master Backup Full MSDB Backup is scheduled on all the servers to happen daily at different time on the different server in the...
How to Take Backup through SAP DBA in DBA Planning Clendar, take Backup in Disk Drive DB12
How to take backup from SAP DBA in Disk drive... T-Code DB12 DBA Planning Clendar for Oracle Database DEV: Maintain in the DBA Planning Clendar click select the date where u want to set the...
Dbase backup and restore
Dear Basis GURUS, I need some help in configuring my server to take a backup on the DISK which is attached to the same server, i want to know what are all the config steps i need to follow in order...
FAQ: MaxDB Administration
1. What are the tasks of a MaxDB database administrator? The MaxDB administrator is responsible for monitoring the active database and also for the following activities: - Backing up the dataset...
Scheduling a backup as a time-controlled task
SQL Server offers an ideal and reliable solution with the task scheduler. A backup can be periodically scheduled to start automatically. The procedure described is based on the backup strategy in...
System Copy Guides
Homogeneous System Copy using Online/Offline Database Backup Reasons for Copying a SAP System SAP recommends that you make a system copy in order to build a test, demo, training or standby...
STAT SAP R/3 Statistics record
STAT STAT SAP R/3 Statistics record Fields:User, Transactions, Program, Task type, Work process, Start date, Start time, End Date, End Time, Number of records, etc Will give u the Stats of ...

Error in Taking Online Backup
Hi, When i am taking a online backup I am getting error.How to reslove this error? "Backup_Dev: SQL Message: SQL2044N An error occurred while accessing a message" Bye
What command is used for backup restore.
i am taking backup of production on DAT daily. but i want restore backup from DAT to server. What command i use for restore backup.
Backup and restore for disaster recovery
Dear all, i want to take daily backup of Production server on DR server while i am taking backup of PRD server with NTBackup utility. Hardware specification and system number, system ID, oracle DB...
SAP TAPE initialize error
Dear Gurus, My Default backdevice was disk. now i I want take back on tape drive. i had change backup_dev_type = tape from backup_dev_type = disk. Still i am getting same error while initialize...
how to take backup in ECC 6.0 server by brtools
Hello i am subhra chakraborty. how to take backup in ECC 6.0 server by brtools. tell me.
Brarchive error-BR105E 0 backup volume found, 1 required.
Hi, When i am running archive log backup using sapdba i am getting below error BR105E 0 backup volume found, 1 required. Plz help me out to solve the error. very urgent i am unable to...
SAP DB2 with AIX 6.1 backup issue with Commvault
Hello, We are using DB2 9.7 with SAP ECC 6.0 EHP5 on AIX 6.1 We have taken Commvault 9 as our backup tool. But we are facing problem while taking online backup with Commvault. Although we can...
We need backup restore
Hai, Please give me the steps or link we restore the backup due to Syntax Error in Program SAPMSSYD for logon time.I am taking backup thru DB13 .This is very urgent for me. So please help me. ...
Backup files
Hi guys, If i need to take a backup , What are the files i need to copy, also from where ?
How to take backups (Online and Offline)
Hi Friends, This is Banuprakash, i have a doubt about backups. How to take backups (Online and Offline) please send answers and What is the commands in unix taking the backups. Thanks &...
techsunny
Can any one tell me how to take online backup server is suse linux 10
I try to take the backup via tape but it's throw an error.
Dear All, Please any one help me on the below issue. I try to take the backup via tape but it's throw an error. Please very urgent. BR0241I Checking label on volume in device /dev/nmt0 BR0216E...
How can we Change the Backup Media in DB13
Hi all, I am working on sap 4.7 and my operating system is Windows 2003 and my Oracle version is 8i. When I schedule backup through T-Code DB13 is by default take Backup in Tape Drive, is their...
Backup timing Issues
Hi, We are facing a strange problem of backup end timing in our BW Production Server.The issue is dat the backup end time is getting increased day by day. Previously backup was getting completed in...
How to take sap backup on mssql server 2005
How to take sap backup on mssql server 2005 i have ECC 6 installed on the MSSQL 2005 db13----------.>full back up------------> gives the option for backup of Master database , system...

Database Administration (Oracle) with SAPDBA
Database Administration (Oracle) with SAPDBA The administration tool SAPDBA for Oracle and its backup tools BRBACKUP, BRARCHIVE and BRRESTORE support the database administrator both in daily...
SAP NetWeaver 04 Database Administration
SAP Database Guide: Oracle (BC-DB-ORA-DBA) ..........16 1 New Features.....................................................................................17 1.1 New Features in SAP Release 6.40...
Technical Consultant Training ORACLE Week 4
Technical Consultant Training ORACLE Week 4 Contents Course Overview ....................................................................1 Target Group...
IBM Certification Study Guide
Contents Figures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv Tables...
Upgrade to SAP R/3 Enterprise: Windows
1 Introduction This section of the documentation contains general information on: • Naming conventions This section explains the terminology and abbreviations used in this documentation. ...
Backup and Recovery Concepts
Glossary Index Backup and Recovery Overview This chapter introduces concepts that are fundamental to backup and recovery. It is intended as a general overview. Subsequent chapters explore...
Starter tips trickes
Starter tips trickes Contents 1 SAP R/3.................................................... 2 1.1 Tables................................................. 2 1.2...
R/3 Database Guide: Informix (BC-DB-INF-DBA)
R/3 Database Guide: Informix (BC-DB-INF-DBA) Purpose This component lets you administer your Informix database with the R/3 System. Read this documentation to make sure that you administer your...
SAP Technical Operation Manual
Table of Contents 1. Preface 1.1 About This Document 1.2 How to Use This Document 2. Global system Description 2.1 R/3 Systems 2.1.1 Development System 2.1.2 Quality Assurance System ...
Golive Pre and Post BASIS Activities Major Activities
SAP Basis Administration Major Post Golive Activities. SAP/Oracle Activity Down Time Minimum Down Time ...
DB2 UDB V8.2 on the Windows Environment
DB2 UDB V8.2 on the Windows Environment Introduction In this chapter we introduce the DB2 technology strategy for the IBM DB2 family, especially the DB2 Universal Database (UDB) Version 8.2. We...
The SAP R/3 Handbook, Second Edition
Chapter 1: What Is SAP R/3?...........................................................................................................................4 ...
Microsoft SQL Server to IBM DB2 UDB Conversion Guide
Microsoft SQL Server to IBM DB2 UDB Conversion Guide Introduction Database management software is now the core of enterprise computing. Companies need access to a wide range of information such as...
System Administratorâ��s Guide for Windows
System Administrator’s Guide for Windows This guide describes how to install, configure and use VERITAS NetBackup SAP Extension for Oracle on a Windows platform. In this guide, VERITAS...
iBs RRA 2.2 Regulatory Reporting Analyzer by iBS
Contents 1 Getting Started ...................5 1.1 Global Definitions .............5 1.2 Important SAP Notes6..............6 1.3 History of Changes................7 2 Technical System...

What is the procedure/command for taking a backup and restore database backup in db2?
Hi, Can you tell me what is the procedure/command for taking a backup and restore database backup in db2? Regards,
Backup tool
Hi, In oracle taking a backup with the help of BRTOOLS.Similarly Db2 using which backup tools? Regards,
FAQ: MaxDB high availability
This note deals with questions and answers on the subject of the MaxDB/liveCache high availability. It describes options on database level. 1. Costs and uses for high availability 2. How can I...
Which two features of RMAN would must likely influence your decision to incorporate RMAN into your backup and recover strategy, if your most important requirement is to reduce the time of recovery? (Choose two)
Q. Which two features of RMAN would must likely influence your decision to incorporate RMAN into your backup and recover strategy, if your most important requirement is to reduce the time of...
Oracle Certified Professional Exams IZ032 Questions Set 7
Q. You want to perform an incomplete recovery of your database. You plan to use these commands to recover your database: SET UNTIL TIME = `2000-12-09:11:44:00'; RESTORE DATABASE; RECOVER...
How we restore backup due to my server crashed. I am taking backup thru DB13
Hi Please give me step or link how we restore backup due to my server crashed. I am taking backup thru DB13 .It's urgent for me. So please help Thanks
how to take backup and restore using sapdba
Hi all, could you please tell me how to take backup and restore using sapdba Thanks&Regards Teja
Is it possible to take backup of particular client and restore it on another server?
Hi all, Is it possible I will take backup of particular client and restore it on another server? thanks
Oracle Certified Professional Exams IZ032 Questions Set 5
Q. The Log Writer (LGWR) process reads information from the __________ and writes it to the online logs. A. large pool B. shared pool C. data buffer cache D. redo log buffer E. data dictionary...
FAQ: SAP MaxDB backup/recovery
This note deals with questions and answers about MaxDB backup/recovery. 1. Which database backup types are there? 2. Is the log area also saved during a data backup? 3. What must I bear in...
What is the difference between Database Whole Backup and Full Backup
What is the difference between Database Whole Backup and Full Backup
Oracle Certified Professional Exams IZ032 Questions Set 3
Q. When performing incomplete recovery using UNTIL SEQUENCE with RMAN, which two pieces of information are required? (Choose two) A. Thread number. B. Log Sequence number. C. Control file sequence...
Oracle Certified Professional Exams IZ032 Questions Set 11
Q. You have used the CROSSCHECK BACKUP command to verify that the backups recorded in the RMAN repository actually exist. Which command should you now use to check if any of the files were missing? ...
how to take sap daily backup using db13?
Use T-Code DB13 Bye
How to restore the database backup?
How to restore the database backup?