Oracle Initialization Parameters
這裏集合了所有Oracle的啟始參數,並且有列出在各個版本的適用情況。非常值得參考。
Friday, October 22, 2004
Wednesday, October 20, 2004
Sunday, October 17, 2004
Simple on-line backup script (put tablespaces in backup mode and copy out)
是用來產生如下之script
alter tablespace SYSTEM begin backup;
!cp -p /array/oracle/u02/oradata/DB/system01.dbf /array/db_mirror/
alter tablespace SYSTEM end backup;
alter tablespace TEMP begin backup;
!cp -p /array/oracle/u02/oradata/DB/temp01.dbf /array/db_mirror/
alter tablespace TEMP end backup;
alter tablespace SYSTEM begin backup;
!cp -p /array/oracle/u02/oradata/DB/system01.dbf /array/db_mirror/
alter tablespace SYSTEM end backup;
alter tablespace TEMP begin backup;
!cp -p /array/oracle/u02/oradata/DB/temp01.dbf /array/db_mirror/
alter tablespace TEMP end backup;
Saturday, October 16, 2004
Oracle Recovery Procedure
Oracle Recovery Procedure
這是O'Reilly的Unix Backup & Recovery中的第十五章,非常棒。
遇到問題時可按圖索驥。
內容偏Oracle 7.3.3的語法。
這是O'Reilly的Unix Backup & Recovery中的第十五章,非常棒。
遇到問題時可按圖索驥。
內容偏Oracle 7.3.3的語法。
Subscribe to:
Posts (Atom)