on 08-08-2007 3:36 PM
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 !
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.