Oracle????????????
???????????? ???????[ 2013/11/14 14:51:20 ] ????????
???????Oracle???????????鵵?????????????????????????????????????鵵??????????????????????鵵??????????2???????鵵????????鵵????
sqlplus>;connect sys/qazwsx as sysdba
sqlplus>;shutdown immediate;
sqlplus>;startup mount exclusive;
sqlplus>;alter database noarchivelog;
sqlplus>;alter database open;
sqlplus >; select * from v$database; ??log_mode?????????????鵵??
sqlplus >; archive log list; ??????????????鵵??
????4.2 ??????????????
??????1??????init.ora??????????????????????????????????????????
??????2?????????????????????????????????
??????3?????ocopy.exe??????????????????????????????У?ocopy.exe????????????????????????????????
??????4??????????е??????????в???2??3????????????dba_tablespaces??v$datafile?????????????Щ????????????????
??????5???????sqlplus?????archive log list?????????????????????oldest online log sequence?????current log sequence??????redo????????????????????
??????6????sqlplus?????alter system switch logfile;?????????????л?????????е?????????鵵??
??????7?????alter database backup controlfile to trace;???????????????????????????%oracle_base%admin\%oracle_sid%udump????????μ?????????????????????????????????
??????8?????windows nt???????%log_archive_dest%?п????鵵??????????????????
????4.3 ????????????????hotbackup.bat
????5?????export??????????
????5.1 export????????????
????Oracle??????exp??????tables??users??full database??tablespace??????????????????????????????????????????????oracle??????????У?????????????imp???????????imp????????????imp help=y???????
????????????????? EXP ??????????????????????“????”?????з??????????????????????ù?????
?????????EXP KEYWORD=value ?? KEYWORD=(value1??value2??...??valueN)
?????????EXP SCOTT/TIGER GRANTS=Y TABLES=(EMP??DEPT??MGR)
?????? TABLES=(T11??T12)????? T1 ???????
????USERID ?????????????е???????????
???????й?????????????????
????TRANSPORT_TABLESPACE ?????????????????? (N)
????TABLESPACES ???????????б?
????5.2 export???????????????expbackup.bat
????6??????????????????з???
?????????????????????????export???????????unix????????windows??????????????at?????????????????????????????AT ?????????????????????????????????windows nt??????????????е??????schedule???????????at???
????AT?????÷????£?
????AT [\computername] [ [id] [/DELETE] | /DELETE [/YES]]
????AT [\computername] time [/INTERACTIVE]
????[ /EVERY:date[??...] | /NEXT:date[??...]] "command"
????\computername ???????????? ?????????????????????????????????????
????id ???????????????????
????/delete ????????????????????? id??????????????????????????????
????/yes ???????????????????????????????????????á?
????time ???????????????
????/interactive ?????????????????????????????????н?????
????/every:date[??...] ????????????????????????????????????????????????????μ???????С?
????/next:date[??...] ?????????????????(????????)????????????????????????????μ???????С?
????"command" ??????е? Windows NT ??????????????
???????????£?
????(1) ?????19:00???????
????at 19:00 /every:F "coldbak.cmd"
????(2) ????20:00????????
????at 20:00 /every:T "coldbak.cmd"
????(3) ???????????????????21:00???export????
????at 20:00 /every:M??T??W??Th??F "expbak.cmd"
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11