oracle數(shù)據(jù)庫(kù)由linux平臺(tái)向ｗindows平臺(tái)遷移-全文預(yù)覽
【正文】 udump查找最新修改文件*.trc,用UltraEdit打開，并查找這行：“ Set 1. NORESETLOGS case”選中并復(fù)制到“ End of tempfile additions. Set 2. RESETLOGS case”為止。 MAXLOGFILES 16 MAXLOGHISTORY 292LOGFILEGROUP 1 39。 SIZE 50M,GROUP 3 39。,39。,39。保存一個(gè)sql語句文本如c:\最后在空閑例程狀態(tài)下，執(zhí)行c:\在sqlplusw里執(zhí)行保存的腳本,如SQL c:\。 (ORACLE_HOME = D:\oracle\product\\db_1) ) (GLOBAL_DBNAME = ORCL) (SID_DESC = (CONNECT_DATA =完.轉(zhuǎn)自：。 (SERVER = DEDICATED) (ADDRESS = (PROTOCOL = TCP)(HOST = zjhmobile)(PORT = 1521)) ))重起監(jiān)聽程序c:\lsnrctl stopc:\lsnrctl start 最后面加入如下內(nèi)容:LINUX =(DESCRIPTION = (ORACLE_HOME = D:\oracle\product\\db_1) (SID_NAME = ORCL) (SID_DESC =檢查里面數(shù)據(jù)是否有丟失等等。CHARACTER SET ZHS16GBK。,39。 SIZE 50M STANDBY LOGFILEDATAFILE39。 SIZE 50M,GROUP 2 39。 MAXDATAFILES 100已經(jīng)卸載數(shù)據(jù)庫(kù)。SQL alter database backup controlfile to trace。39。Total System Global Area 167772160 bytesFixed Size*.user_dump_dest=39。*.sga_target=167772160*.undo_management=39。*.nls_territory=39。*.db_recovery_file_dest=39。*.db_block_size=8192*.db_domain=39。,39。*.control_files=39。*.background_dump_de
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1