Home | Contact Us | Submit Troubleshooting Info | Search | Help
Output | Software Solutions | Proofing | Color, Screening and Calibration | Scanning | Digital Photography | Consumables | POS
Home | Contact Us | Submit Troubleshooting Info | Search | Help
Output | Software Solutions | Proofing | Color, Screening and Calibration | Scanning | Digital Photography | Consumables | POS
|
|
||
Product |
Prinergy 1.1; Prinergy Connect 2.0 ; Prinergy Direct 2.0 ; Prinergy Access 2.0 ; Prinergy PowerPack 1.0 ; Prinergy Connect 2.1 ; Prinergy Direct 2.1 ; Prinergy Access 2.1 ; Prinergy Powerpack 2.1 ; Prinergy Satellite | |
Platform |
||
Operating system |
||
|
|
||
Error |
RMAN-06003: ORACLE error from target database: ORA-01220: file based sort illegal before database is open |
|
|
|
||
Symptoms |
OracleBackupManager fails to restore the database. The \Ora816\Creo\Logs\OracleBackupLogFile.log shows the error message "file based sort illegal before database is open". |
|
|
|
||
Cause |
RMAN is attempting to perform a sort and it does not have enough memory to perform the sort. It cannot perform the sort on disk because the database is not opened and the data files are not accessible. | |
|
|
||
Solution |
Add the parameter "sort_area_size = 1000000" to the \Ora816\Database\initCreo.ora file and retry the restore. Remove the parameter after the database has been restored. If you still get the same error, try using a larger value. The example above sets the sort_area_size to 1MB, try using a larger value such as 10MB. Permanent fix: |
|
|
|
||
See also |
||
|
|
||
Keywords |
oracle |
|
|
|
||
Technical contact(s) |
Stan Yoshida |
|
Submitted by |
Stan Yoshida |
|
Date submitted |
05 Jun 2002 |
|