????1??????
????Oracle???????????????????????????????????????????????????????????????????С??????????????????????export??ó????????????????Oracle????????????Oracle??????????Oracle???з??????????Oracle????????Oracle?????????????????????????????????????????????????????????export??ó?????????????Oracle?????Oracle?????????????????????????????????????????????????????????????????????????Щ????????????????
????2????????????????
????????
??????????Oracle???????????????????????????????????ò???????ù????????????????????????????????????
???????:??????????????????????????м???
???????:?????????????????е?????
?????????
?????????????????????????????????????????????????????????????????????鵵?????????????24X7????????е??????????
???????:??????????????????????????????????е????????????????????鵵????????????????????????????ò?????????????
???????:??й??????????????????????У?????????????????ò???????ù??????????????????????Oracle????ocopy??????????????????????????????CPU??I/O???????????????????С?
????Export????????????
???????????????????????????????????????????????????export??????????????????????????????
???????:????ж???????л????????????????????????????????????????????????С?
???????:export?????????????????????????????????????????Ч??export???????????????????
????3?????????????
????3.1 ?????????????
??????1??????????
??????2???????????????????????????????????????????????????select name from v$controlfile;?г?????
????????????????????????????select name from v$datafile;?г????????????????Redo?????????select member from v$logfile;?г?????redo???????????鵵??Redo?????????select sequence#??first_time from v$loghist;?г????й鵵redo?????????????????????
????3.2 ???????????????coldbackup.bat
????4??????????????
????4.1 ???????????????????????????????鵵??
????Oracle??????redo?????????????????е????л???LGWR??????????????????д??Щ??????????????redo???????????????????????????????????????д??
???????鵵???￡??????д?????????????????д????????????????鵵???μ????????????????????
??????鵵???￡???redo???????????ARCH????????????redo??????????д???鵵?????????????????????????????鵵??????￡?????鵵????????????????????????????????????Щ??????????????????С??????background_dump_destination??????????????????????鵵?????????
????Oracle????????????????鵵??????????2????????鵵???????鵵????
??????1???????????init.ora?????????2???
????# ?????????????鵵
????log_archive_start = true
????# ???ù鵵??????????????????????????????????д????????????
????log_archive_dest_1="location=%oracle_base% oradata\%oracle_sid%archive"
????# ???ù鵵??????????????%s????????%t????????
????log_archive_format = "%oracle_sid%%T%S.ARC"
??????2????sqlplus??????????????
sqlplus>;connect sys/qazwsx as sysdba
sqlplus>;shutdown immediate;
sqlplus>;startup mount exclusive;
sqlplus>;alter database archivelog;
sqlplus>;alter database open;
sqlplus>;shutdown immediate;
??????3??????????????
?????????????????鵵???￡??????????????????????????鵵??????????
??????4??????????????????????????????鵵??
sqlplus >; startup;
sqlplus >; select * from v$database; ??log_mode?????????????鵵??
sqlplus >; archive log list; ??????????????鵵??