ORA-1031 signalled during backup routine [message #157864] |
Mon, 06 February 2006 15:49 |
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 |
Frank Naude
Messages: 4587 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.
|
|
|