Offline Drop and offline difference

in archive modeOffline dropand theOfflineoffline DropDemo

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M01/89/52/wKiom1gPZHnS8wAPAAB-mitzFDU362.png-wh_500x0-wm_3 -wmp_4-s_4284970892.png "style=" Float:none; "title=" 1.png "alt=" Wkiom1gpzhns8wapaab-mitzfdu362.png-wh_50 "/>

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M01/89/50/wKioL1gPZHnQsC0iAABMAEVmlRA264.png-wh_500x0-wm_3 -wmp_4-s_2447878225.png "style=" Float:none; "title=" 2.png "alt=" Wkiol1gpzhnqsc0iaabmaevmlra264.png-wh_50 "/>

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M02/89/52/wKiom1gPZHmimh0YAABmg0gOv7Y452.png-wh_500x0-wm_3 -wmp_4-s_4131931957.png "style=" Float:none; "title=" 3.png "alt=" Wkiom1gpzhmimh0yaabmg0gov7y452.png-wh_50 "/>

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M02/89/50/wKioL1gPZHnixS0-AABKuiGb37E617.png-wh_500x0-wm_3 -wmp_4-s_2415245712.png "style=" Float:none; "title=" 4.png "alt=" Wkiol1gpzhnixs0-aabkuigb37e617.png-wh_50 "/>

Offline demo in archive mode

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/89/52/wKiom1gPZMyi8VYjAABNitSGTq4694.png-wh_500x0-wm_3 -wmp_4-s_1557418681.png "style=" Float:none; "title=" 5.png "alt=" Wkiom1gpzmyi8vyjaabnitsgtq4694.png-wh_50 "/>

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/89/50/wKioL1gPZMyDkGyiAABl4XZF42Y208.png-wh_500x0-wm_3 -wmp_4-s_1649484443.png "style=" Float:none; "title=" 6.png "alt=" Wkiol1gpzmydkgyiaabl4xzf42y208.png-wh_50 "/>

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/89/50/wKioL1gPZMzzVOxCAABNYX1Dax8228.png-wh_500x0-wm_3 -wmp_4-s_1307588297.png "style=" Float:none; "title=" 7.png "alt=" Wkiol1gpzmzzvoxcaabnyx1dax8228.png-wh_50 "/>

you can see that in archive mode,the effect of offline drop and offline is the same as the data file as in the Recover state, if you need online thedata file status changes to the Fline state, andthe DBA can go online manually , recover.

Switch database to non-archive mode

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M02/89/52/wKiom1gPZOrysfOcAABix7c7Jxw094.png-wh_500x0-wm_3 -wmp_4-s_152080770.png "title=" 8.png "alt=" Wkiom1gpzorysfocaabix7c7jxw094.png-wh_50 "/>

Test with test03.dbf data File

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M00/89/50/wKioL1gPZTXCNt6PAABfsXzBJ7c557.png-wh_500x0-wm_3 -wmp_4-s_3914070994.png "title=" 9.png "alt=" Wkiol1gpztxcnt6paabfsxzbj7c557.png-wh_50 "/>

you can see that non-archive mode does not allow the use of offline to directly test the effect of offline drop innon-archive mode

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/89/52/wKiom1gPZWSiX6T4AABrvUJTebI320.png-wh_500x0-wm_3 -wmp_4-s_3879132481.png "style=" Float:none; "title=" 10.png "alt=" Wkiom1gpzwsix6t4aabrvujtebi320.png-wh_50 "/>

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/89/52/wKiom1gPZWSTftJjAACSr2elxMg838.png-wh_500x0-wm_3 -wmp_4-s_1975665864.png "style=" Float:none; "title=" 11.png "alt=" Wkiom1gpzwstftjjaacsr2elxmg838.png-wh_50 "/>

You can see that the offline drop effect in offline drop and archive mode in non-archive mode is the same as the data file as in recover state, if necessary Online is recover first , and then the data file status becomes fline state, and thedba can manually online.

This article is from the "Rabbit" blog, please make sure to keep this source http://buertu.blog.51cto.com/7159900/1865620

Offline Drop and offline difference