oracle???????
???????????? ???????[ 2014/5/7 10:30:38 ] ????????oracle ?????
????1. ?????
?????????????????????????????????£?
????select file#?? status?? enabled?? name from V$datafile;--?????????
????select * from v$controlfile;--???????
????select * from v$logfile;--??????
????2. ??????????
????1??????/??????import/export??
????1.???????? table?? user?? tablespace?? full database
????2. ???????????
exp system/manager@TEST file=d:export.dmp full=y--???????TEST??????????????????????system ????manager ??????D:daochu.dmp??
exp system/manager@TEST file=d:export.dmp owner=(system??sys)--??system??sys??????
exp aichannel/aichannel@TEST file= d:export.dmp tables= (tab1??tab2)--??tab1???tab2?????
imp system/manager@TEST file=d:export.dmp tables=(tab1??tab2);--??export.dmp??tab1???tab2?????
imp system/manager@TEST file=d:export.dmp;
????3. ????????????????????????
????--????system/manager???
????--???????
????grant exp_full_database?? imp_full_database to username;
????2?????????鵵????
????1. ???裺shutdown?????---> copy???---> start?????
????2. ?????
connect tigger/sccot as sysdba;
shutdown immediate;
cp d:/test*.dbf d:export --cp ??? ???????? ???????
cp d:/test*.ctl d:export --???????
cp d:/test*.log d:export --??????
startup;
????3?????????鵵????
????1. ?????????????????????????鵵????oracle????????????????鵵????
????2. ????????????鵵?????£?????????????????????????????????κ?????д???
????--????????????????????
shutdown immediate;
startup mount;--??startup nomount ????????startup mount ??????????????? startup ?????????????????????
alter database archivelog;--???????????????????????????κ?????д?
????3. ?鵵??????
archive log list;--????????鵵??;
alter system set log_archive_start =true scope =spfile; --?????????鵵
select name from v$archived_log; --????鵵???
alter system set log_achive_start=false scope=spfile;--????????л???鵵??
archive log stop;
archive log start;
??????
???·???
??????????????????
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