<div>
It looks like there was a problem with a query issued against a fixed table view. See the following link for more details: 
<a href="http://www.error-code.org.uk/view.asp?e=ORACLE-ORA-01220" rel="ugc">http://www.error-code.org.uk/view.asp?e=ORACLE-ORA-01220</a> 
&nbsp; 
&nbsp; 

</div>

<div>
Hi jgmontgo 
 
Thanks for responding, 
 
Are these only two parameters need to be increased only to correct error and If so where we can find these query. 
 
Action: 
Re-phrase the query to avoid a large sort, increase the values of the SORT_AREA_SIZE and/or SORT_AREA_RETAINED_SIZE initialization parameters to enable the sort to be done in memory.
</div>

<div>
<div class="content wysiwyg-content">
Hi mates, 
 
I work in netbackup team, one database backup policy fails, under bpdbsbora log, &nbsp;I can see error : 
 
RMAN-00571: =========================================================== 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== 
RMAN-00571: =========================================================== 
ORA-01220: file based sort illegal before database is open 
 
Backup policy type is ORACLE 
Failed Status : 6 ( the &nbsp;backup failed to backup the requested files) 
 
Client : 
 
SUNW,Sun-Fire-V890 
 
Please advise, what I should ask DBA to look in , so he can resolve ISSUE or is there anything I need to do from Netbackup. Pleas advice 
 
Any response would appreciate.. 
 

</div>
</div>

Hi mates, 

I work in netbackup team, one database backup policy fails, under bpdbsbora log,  I can see error : 

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01220: file based sort illegal before database is open

Backup policy type is ORACLE
Failed Status : 6 ( the  backup failed to backup the requested files)

Client : 

SUNW,Sun-Fire-V890

Please advise, what I should ask DBA to look in , so he can resolve ISSUE or is there anything I need to do from Netbackup. Pleas advice

Any response would appreciate..



It looks like there was a problem with a query issued against a fixed table view. See the following link for more details:
http://www.error-code.org.uk/view.asp?e=ORACLE-ORA-01220
 
 


Hi jgmontgo

Thanks for responding, 

Are these only two parameters need to be increased only to correct error and If so where we can find these query.

Action:
Re-phrase the query to avoid a large sort, increase the values of the SORT_AREA_SIZE and/or SORT_AREA_RETAINED_SIZE initialization parameters to enable the sort to be done in memory.

Database Backup failed

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.