oracle是什么軟件 oracle數(shù)據(jù)庫如何打開歸檔?
oracle數(shù)據(jù)庫如何打開歸檔?xp system/manager file=d:道處.dmp滿=y1。連接windows系統(tǒng):open CMD window,Linux/Unix系統(tǒng):open te
oracle數(shù)據(jù)庫如何打開歸檔?
xp system/manager file=d:道處.dmp滿=y
1。連接windows系統(tǒng):open CMD window,Linux/Unix系統(tǒng):open terminal RMAN target/nocatalogsqlplus/nologconn/as SYSDBA
2。Open archive sqlplus>shutdown immediate(在啟動(dòng)存檔之前停止數(shù)據(jù)庫)sqlplus>startup mount(在裝載模式下啟動(dòng)數(shù)據(jù)庫)sqlplus>alter database Archivelog sqlplus>alter system set loguarchiveuudestu1=“/arch”(更改存檔日志的路徑,windows系統(tǒng)使用驅(qū)動(dòng)器號(hào))sqlplus>alter database open(打開數(shù)據(jù)庫)sqlplus>archive log list(檢查存檔是否已打開)close archive alter database NOARCHIVELOG