Document Type | Troubleshooting
Category | Utility
Applicable Product Version | 6FS06
Error Code | 90613
Document Number | TUTTS006
Issue
The tbrmgr backup was performed by granting rmgr privileges to a general account, but a recovery failure occurred during the tbrmgr recovery process.
Cause
When rmgr privileges are granted to a general account, tbrmgr backup is possible, but recovery is not possible due to login failure except for the sys account in mount mode during recovery.
Solutions
Apply a temporary workaround.
1. Create a dedicated backup account.
CREATE USER SYSBACKUP IDENTIFIED BY TIBERO DEFAULT TABLESPACE SYSTEM;
2. Grant minimum privileges to perform rmgr backup.
GRANT CREATE SESSION TO SYSBACKUP; GRANT ALTER SESSION TO SYSBACKUP; GRANT ALTER SYSTEM TO SYSBACKUP; GRANT CREATE TABLESPACE TO SYSBACKUP; GRANT ALTER TABLESPACE TO SYSBACKUP; GRANT DROP TABLESPACE TO SYSBACKUP; GRANT ALTER DATABASE TO SYSBACKUP; GRANT ALTER RMGR TO SYSBACKUP; GRANT SELECT_CATALOG_ROLE TO SYSBACKUP;