闪回恢复区满，oracle10G起不来，解决方法

four methods as follows:




1) Increase the parameter db_recovery_file_dest_size, which is dynamic.




SQL> alter system set db_recovery_file_dest_size=XG; (larger amount)




2) Stop using the db_recovery_file_dest by unsetting the parameter.
   ( This assumes you never really wanted to use this option )




3) Remove the Entries from the rman repository/Controlfile
   a) delete unwanted archive log files from disk ( rm /del )
   b) connect to rman 
   c) rman crosscheck archivelog all - marks the controlfile that the archives have been deleted
   d) rman delete expired archivelog all - deletes the log entries identified above. 


4)don't care the results, you can user RMAN delete all archivelog,but don't suggest do it.
rman>delete archivelog all