cancel
Showing results for 
Search instead for 
Did you mean: 

backup problem

Former Member
0 Kudos

Dear All,

Having problem in taking development backup.

BR0055I Start of database backup: bdxxiprp.ant 2008-05-13 17.40.29

BR0477I Oracle pfile E:\oracle\MRD\102\database\initMRD.ora created from spfile E:\oracle\MRD\102\database\spfileMRD.ora

BR0280I BRBACKUP time stamp: 2008-05-13 17.40.32

BR0319I Control file copy created: G:\oracle\MRD\sapbackup\CNTRLMRD.DBF 24461312

BR0328E Database file Q:\SAPDATA1\SR3_1\SR3.DATA1 of tablespace PSAPSR3 is already in backup status

BR0328E Database file Q:\SAPDATA1\SR3_2\SR3.DATA2 of tablespace PSAPSR3 is already in backup status

BR0328E Database file Q:\SAPDATA1\SR3_3\SR3.DATA3 of tablespace PSAPSR3 is already in backup status

BR0328E Database file Q:\SAPDATA1\SR3_4\SR3.DATA4 of tablespace PSAPSR3 is already in backup status

BR0328E Database file G:\ORACLE\MRD\SAPDATA1\SR3_5\SR3.DATA5 of tablespace PSAPSR3 is already in backup status

BR0328E Database file H:\ORACLE\MRD\SAPDATA2\SR3_6\SR3.DATA6 of tablespace PSAPSR3 is already in backup status

BR0328E Database file H:\ORACLE\MRD\SAPDATA2\SR3_7\SR3.DATA7 of tablespace PSAPSR3 is already in backup status

BR0328E Database file H:\ORACLE\MRD\SAPDATA2\SR3_8\SR3.DATA8 of tablespace PSAPSR3 is already in backup status

BR0328E Database file H:\ORACLE\MRD\SAPDATA2\SR3_9\SR3.DATA9 of tablespace PSAPSR3 is already in backup status

BR0328E Database file H:\ORACLE\MRD\SAPDATA2\SR3_10\SR3.DATA10 of tablespace PSAPSR3 is already in backup status

BR0328E Database file I:\ORACLE\MRD\SAPDATA3\SR3_11\SR3.DATA11 of tablespace PSAPSR3 is already in backup status

BR0328E Database file I:\ORACLE\MRD\SAPDATA3\SR3_12\SR3.DATA12 of tablespace PSAPSR3 is already in backup status

BR0328E Database file I:\ORACLE\MRD\SAPDATA3\SR3_13\SR3.DATA13 of tablespace PSAPSR3 is already in backup status

BR0328E Database file I:\ORACLE\MRD\SAPDATA3\SR3_14\SR3.DATA14 of tablespace PSAPSR3 is already in backup status

BR0328E Database file I:\ORACLE\MRD\SAPDATA3\SR3_15\SR3.DATA15 of tablespace PSAPSR3 is already in backup status

BR0328E Database file J:\ORACLE\MRD\SAPDATA4\SR3_16\SR3.DATA16 of tablespace PSAPSR3 is already in backup status

BR0328E Database file J:\ORACLE\MRD\SAPDATA4\SR3_17\SR3.DATA17 of tablespace PSAPSR3 is already in backup status

BR0328E Database file J:\ORACLE\MRD\SAPDATA4\SR3_18\SR3.DATA18 of tablespace PSAPSR3 is already in backup status

BR0328E Database file J:\ORACLE\MRD\SAPDATA4\SR3_19\SR3.DATA19 of tablespace PSAPSR3 is already in backup status

BR0328E Database file J:\ORACLE\MRD\SAPDATA4\SR3_20\SR3.DATA20 of tablespace PSAPSR3 is already in backup status

BR0056I End of database backup: bdxxiprp.ant 2008-05-13 17.40.35

BR0280I BRBACKUP time stamp: 2008-05-13 17.40.35

BR0054I BRBACKUP terminated with errors

note : 1.i m new in the basis can any1 plz tell me hoe to resolve this issue.

2.how to know in oracle which table space in backup mode?

3.if i restart my development sever will it kill the process?

plz suggest me...(its Urgent)

Regard's

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

You can also check whether any other files in backup mode useing the below query..

SELECT * FROM v$backup;

SELECT tablespace_name, FILE_NAME from dba_data_files, v$backup where file_id = 'x';

the value of x will be the File no dipalyes in 1st query.

If you want to end back of all files, you can use the below query.

ALTER DATABASE END BACKUP;

Rgds,JP..

Former Member
0 Kudos

Dear Jp,

Thanx for ur needful Answer,but from the log files i think that only one tablespace in backup mode.ie PSAPSR3.SO if i only alter this tablespace..it will work..as i m new in Basis..i dont have so much idea.

Thanx and Regard's

Former Member
0 Kudos

Dear Jp,

Thanx for ur needful Answer,but from the log files i think that only one tablespace in backup mode.ie PSAPSR3.SO if i only alter this tablespace..it will work..as i m new in Basis..i dont have so much idea.

Thanx and Regard's

Former Member
0 Kudos

Hi,

yes. only PSAPSR3 is in backup status

regards,

kaushal

Former Member
0 Kudos

Hi,

BR0328E Database file Q:\SAPDATA1\SR3_1\SR3.DATA1 of tablespace PSAPSR3 is already in backup status.

If the last backup was cancelled, manually enter the SQLDBA command ALTER TABLESPACE <tablespace name> END BACKUP

i.e ALTER TABLESPACE PSAPSR3 END BACKUP

regards,

kaushal

Former Member
0 Kudos

HI Mr Malvia,

Thanx a lot for ur needful reply,Executing this command will it resolve my issue.OR if i restart my development server will it kill the process.

Thanx and Regard's

Former Member
0 Kudos

Hi,

yes just execute the command manually.

regards,

kaushal