13、oracle中的幾個狀態,invalid,obsolete,expired,stale

yyycxhtx發表於2007-08-02

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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章