| ORA-00271 and ORA-00959 Error [message #51636] |
Tue, 04 June 2002 05:12  |
Rafael Mazzeo
Messages: 1
Registered: June 2002
|
Junior Member |
|
|
Hi all...
I've been having problems when I try to backup my prod database with Arcserve 2000 + Arcserve Agent for Oracle. It always worked fine, but suddenly I've got the following error messages:
05/26/2002 18:43:53 Connect Oracle Backup Agent
05/26/2002 18:43:54 Tablespace DRSYS in PROD in Backup mode
05/26/2002 18:43:54 Oracle message: ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 8
ORA-00271: there are no logs that need archiving
05/26/2002 18:43:54 Oracle Server Error.
05/26/2002 18:43:54 Oracle message: ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 8
ORA-00959: tablespace '' does not exist
05/26/2002 18:43:54 Disconnect Oracle Backup Agent
I have another database on the same server which the arcserve works fine.
Could somebody help me?
Rafael.
|
|
|
|
| Re: ORA-00271 and ORA-00959 Error [message #51643 is a reply to message #51636] |
Tue, 04 June 2002 09:13  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Did you change the format of your archived logs recently? What are the values for
LOG_ARCHIVE_DEST
LOG_ARCHIVE_FORMAT
LOG_ARCHIVE_START
Check if you don't have any datafile left in active backup mode: status from v$backup. If so close the backup for this file and try again.
Hope that helps,
Trifon Anguelov
Senior Oracle DBA
visit the latest Oracle DBA forums:
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
