文档介绍:: .
(OracleORACLE管理)数
n
svrmgrl>exit
%
加入 log_archive_start=true#ifyouwantautomaticarchiving
log_archive_dest=$ORACLE_HOME/dbs/arch
log_archive_format=log%
%dbstart
%ps-ef|greparch
oracle17431015:20:20?0:00ora_arch_oracle7
注:oracledatabaseisinautomaticarchivelogmode
?fullofflineentiredatabasebackup,当数据库初始完成后这份备份是将来备份的基础。它
提供了所有与数据库有关的拷贝.
%dbshut
%cp/oracle/oradata/oracle7/
/oracle/oradata/oracle7/
/oracle/oradata/oracle7/
/oracle/oradata/oracle7/
/oracle/oradata/oracle7/
/oraclecle/app/oracle/product/
/oracle/app/oracle/product/
/oracle/app/oracle/product/
/oracle/oradata/oracle7/
/oracle/oradata/oracle7/
/oracle/oradata/oracle7/
/oracle/oradata/oracle7/
<backupdirectory>
%dbstart
注:以上*.dbf 文件为数据文件,*.log 文件为日志文件,*.ctl 文件为控制文件
%exit
%taruvf/dev/rmt/0<backupfiles>
注:如果为 ,则 copy 相应的 datafiles,relogfiles,controlfiles.
、每天做一次 partialonlinewitharchivingbackups.#su-oracle
%svrmgrl
%svrmgrl>connectinternal
%svrmgrl>altertablespacebillspbeginbackup
%svrmgrl>altertablespacebilltmpspbeginbackup
%svrmgrl>altertablespacebillrlbkspbeginbackup
%svrmgrl>altertablespacesystembeginbackup
%svrmgrl>altertablespacerbsbeginbackup
%svrmgrl>altertablespacetempbeginbackup
%svrmgrl>altertablespacetoolsbeginbackup
%svrmgrl>altertablespaceusersbeginbackup
%svrmgrl>hostcpalldatafiletothebackupstorage.
# 结尾的.
%svrmgrl>altertablespacebillspendbackup
%svrmgrl>altertablespacebilltmpspendbackup
%svrmgrl>altertablespacebillrlbkspendbackup
%svrmgrl>altertablespacesystemendbackup
%svrmgrl>altertablespacerbsendbackup
%svrmgrl>altertablespacetempendbackup
%svrmgrl>altertablespacetoolsendbackup
%svrmgrl>altertablespaceusersendbackup
做一个 sql 文件,如上所写.
T