Home » RDBMS Server » Backup & Recovery » ORA-1031 signalled during backup routine
ORA-1031 signalled during backup routine [message #157864] Mon, 06 February 2006 15:49 Go to next message
TLegend33
Messages: 203
Registered: March 2005
Senior Member
Below is an entry I have in my alert log (there is an entry similar to the one below for each tablespace):

ALTER TABLESPACE "SMALL_D" BEGIN BACKUP
ORA-1031 signalled during: ALTER TABLESPACE "SMALL_D" BEGIN BACKUP...
Sat Feb 04 03:06:16 2006

My client is running Veritas Backup agent to backup the database and has multiple instances on this server. This particular instance had it's schema upgraded the prior evening for our application. To do so, I started the instance in 'Startup Restrict' mode. Once my work was done, I executed:
'alter system disable restricted session;'

All users can connect and the application functions properly, however the backup fails due to this error. Is the instance still restricted in some fashion?

Thanks.
Re: ORA-1031 signalled during backup routine [message #157887 is a reply to message #157864] Mon, 06 February 2006 23:15 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Grant the required privs to the user that issues the BEGIN BACKUP command:

01031, 00000, "insufficient privileges"
// *Cause: An attempt was made to change the current username or password
//         without the appropriate privilege. This error also occurs if
//         attempting to install a database without the necessary operating
//         system privileges.
//         When Trusted Oracle is configure in DBMS MAC, this error may occur
//         if the user was granted the necessary privilege at a higher label
//         than the current login.
// *Action: Ask the database administrator to perform the operation or grant
//          the required privileges.
//          For Trusted Oracle users getting this error although granted the
//          the appropriate privilege at a higher label, ask the database
//          administrator to regrant the privilege at the appropriate label.


Previous Topic: How restore undo tablespace
Next Topic: Old backup
Goto Forum:
  


Current Time: Wed Apr 24 17:27:16 CDT 2024