13、oracle中的几个状态，invalid,obsolete,expired,stale

oracle中经常会考到的几个状态，invalid,obsolete,expired,stale等等。自己试着总结一下

[@more@]

1、If one of the online redo log members is lost,the status in v$logfie will be INVALID

2、If the contents of the redo log file are incomplete ,the status of the file in the V$LOGFILE view will be STALE

3、You are using RMAN to perform backup and recovery on your database.The backup of one of the files was lost because it was located on a failed media.If you use CROSSCHECK command to verify the existence of the backup,the statues of this bakcup will be updated to EXPIRED

4、The status will be updated to OBSOLETE when the bakcup becomes older than the retention policy specified for the database.

其他的以后慢慢加~~~

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/248644/viewspace-930842/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/248644/viewspace-930842/