oracle數(shù)據(jù)庫備份-文庫吧
2025-06-13 07:57 本頁面
【正文】 %vi 加入log_archive_start = true if you want automatic archiving log_archive_dest = $ORACLE_HOME/dbs/arch log_archive_format = log% %dbstart %ps ef|grep arch oracle 1743 1 0 15:20:20 ? 0:00 ora_arch_oracle7 注：oracle database is in automatic archivelog mode ?full offline entire database backup, 當數(shù)據(jù)庫初始完成后 這份備份是將來備份的基礎(chǔ)。它提供了所有與數(shù)據(jù)庫有關(guān)的拷貝. %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/ backup directory %dbstart 注:以上*.dbf文件為數(shù)據(jù)文件,*.log文件為日志文件,*.ctl文件為控制文件 %exit %tar uvf /dev/rmt/0 backup files 注:如果為oracle ,則copy 相應(yīng)的 data files,relog files,control files. 、每天做一次 partial online with archiving backups . su oracle %svrmgrl %svrmgrlconnect internal %svrmgrlalter tablespace billsp begin backup %svrmgrlalter tablespace billtmpsp begin backup %svrmgrlalter tablespace billrlbksp begin backup %svrmgrlalter tablespace system begin backup %svrmgrlalter tablespace rbs begin backup %svrmgrlalter tablespace temp begin backup %svrmgrlalter tablespace tools begin backup %svrmgrlalter tablespace users begin backup %svrmgrlhost cp all datafile to the backup storage. . %svrmgrlalter tablespace billsp end backup %svrmgrlalter tablespace billtmpsp end backup %svrmgrlalter tablespace billrlbksp end backup
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1