cancel
Showing results for 
Search instead for 
Did you mean: 

Online backup without PSAPTEMP

Former Member
0 Kudos

Hello,

one question, i have recover a database 10.2.0.2 from a online backup.

before i have delete all files in the sapdata's.

the database and the sap-system runs well.

now i became this error:

orasms> brbackup -q

BR0051I BRBACKUP 7.00 (18)

BR0055I Start of database backup: bdvwpovw.qub 2007-08-08 16.29.28

BR0477I Oracle pfile /oracle/SMS/102_64/dbs/initSMS.ora created from spfile /oracle/SMS/102_64/dbs/spfileSMS.ora

BR0280I BRBACKUP time stamp: 2007-08-08 16.29.29

BR0301E SQL error -1187 at location BrDbfInfoGet-1, SQL statement:

'OPEN curs_3 CURSOR FOR'

'SELECT TS.TABLESPACE_NAME, TS.STATUS, TS.BLOCK_SIZE, TS.CONTENTS, TS.EXTENT_MANAGEMENT, DF.FILE_NAME, DF.FILE_ID, NVL(DF.STATUS, ' '), NVL(DF.BYTES, 0), NVL(DF.AUTOEXTENSIBLE, 'NO'), NVL(DF.MAXBYTES, 0), NVL(DF.INCREMENT_BY, 0) FROM DBA_TABLESPACES TS, DBA_DATA_FILES DF WHERE TS.TABLESPACE_NAME = DF.TABLESPACE_NAME UNION ALL SELECT TS.TABLESPACE_NAME, TS.STATUS, TS.BLOCK_SIZE, TS.CONTENTS, TS.EXTENT_MANAGEMENT, TF.FILE_NAME, TF.FILE_ID * -1, NVL(TF.STATUS, ' '), NVL(TF.BYTES, 0), NVL(TF.AUTOEXTENSIBLE, 'NO'), NVL(TF.MAXBYTES, 0), NVL(TF.INCREMENT_BY, 0) FROM DBA_TABLESPACES TS, DBA_TEMP_FILES TF WHERE TS.TABLESPACE_NAME = TF.TABLESPACE_NAME ORDER BY 1, 6'

ORA-01187: cannot read from file 255 because it failed verification tests

ORA-01110: data file 255: '/oracle/SMS/sapdata1/temp_1/temp.data1'

BR0314E Collection of information on database files failed

BR0056I End of database backup: bdvwpovw.qub 2007-08-08 16.29.29

BR0280I BRBACKUP time stamp: 2007-08-08 16.29.29

BR0054I BRBACKUP terminated with errors

orasms>

the file oracle/SMS/sapdata1/temp_1/temp.data1 come not with the online-backup.

in my other systems with oracle 9.2. i find the psaptemp in the protocol from online-backup. is this new with oracle 10... ?? how can i create the tablespace psaptemp ?

Thanks !

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member204746
Active Contributor
0 Kudos

most probably PSAPTEMP is now temporary locally managed. If this is the case, it is not backed up with brbackup and you must create it's datafile. Check in the backup controlfile to know how to create them:

sqlplus / as sysdba

ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/oracle/SMS/CONTROLFILE_TRACE.txt' reuse;

exit

then, add the temp datafile such as :

ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '/oracle/SMS/sapdata1/TEMP_1/TEMP.DATA1' SIZE 20704M REUSE AUTOEXTEND ON NEXT 67108864 MAXSIZE 24000M;

good luck

Former Member
0 Kudos

Hi Eric,

thank you for the help. the psaptemp runs fine !