oracle full database backup
#!/bin/sh
source /home/oracle/.bash_profile
DICPATH=/oafile/archlog
LOGPATH=$DICPATH/backuplog
DATPATH=$DICPATH/backup
rman target / nocatalog msglog=$LOGPATH/rman_db_`date '+%Y%m%d%H%M%S'`.log <<EOF
#rman target sys/c21nzhxg24cd@20.1.1.11/c2db1.19pay.com nocatalog msglog=$LOGPATH/rman_db_`date '+%Y%m%d%H%M%S'`.log <<EOF
run{
REPORT OBSOLETE;
crosscheck archivelog all;
DELETE force NOPROMPT OBSOLETE;
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
backup as compressed backupset full database tag 'dbfull' format '$DATPATH/dbfull_%u_%s_%p' ;
sql 'alter system archive log current';
backup as compressed backupset filesperset 3 archivelog all tag 'arch' format '$DATPATH/arch_%u_%s_%p' delete input;
backup current controlfile tag 'ctl' format '$DATPATH/ctl_%s_%p_%t';
release channel c1;
release channel c2;
release channel c3;
release channel c4;
DELETE force NOPROMPT OBSOLETE;
}
exit;
EOF
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/16976507/viewspace-2132431/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- SQLBackupAndFTP12.0 failed to backup database with full backup typeSQLFTPAIDatabase
- full backup 與 level 0 incremental backupREM
- Oracle 10.2.0.1 exp 之 full database export and import(實戰)OracleDatabaseExportImport
- Rman backup standby databaseDatabase
- Cold Database backup scriptDatabase
- full database export and import(實戰)DatabaseExportImport
- imp full database (轉官檔)Database
- oracle database backup and recovery user's guide part IVOracleDatabaseGUIIDE
- oracle database backup and recovery user's guide part IIIOracleDatabaseGUIIDE
- PostgreSQL xlog格式之no backup full pageSQL
- PostgreSQL xlog格式之backup full pageSQL
- oracle database backup and recovery user's guide part VII & VIIIOracleDatabaseGUIIDE
- oracle database backup and recovery user's guide part V & VIOracleDatabaseGUIIDE
- oracle database backup and recovery user's guide part I & IIOracleDatabaseGUIIDE
- oracle create a new database using backup controlfile to traceOracleDatabase
- Cold backup and restore the entire databaseRESTDatabase
- rman backup database force 功能Database
- Oracle 12C Transport a Database to a Different Platform Using Backup SetsOracleDatabasePlatform
- T-SQL Verify Database BackupSQLDatabase
- How to use rman backup a noarchivelog databaseHiveDatabase
- Oracle OCP 1Z0 053 Q559(Alter Database Begin Backup)OracleDatabase
- RMAN - backup archivelog all 與 backup database plus archivelog 區別HiveDatabase
- Crunchy PostgreSQL database backup via pgo commandSQLDatabaseGo
- 理解RMAN backup database plus archivelog命令DatabaseHive
- recover database using backup controlfileDatabase
- recover database using backup controlfile與 recover database 的區別Database
- Oracle Secure BackupOracle
- recover database using backup controlfile理解Database
- recover database using backup control fileDatabase
- How to restore and recover a database from an RMAN backup_881395.1RESTDatabase
- RMAN backup validate database on databases in noarchivelog modeDatabaseHive
- rman backup as copy database format '/tmp/%U.dbf'DatabaseORM
- SQL SERVER BACKUP DATABASE 加快備份速度方法SQLServerDatabase
- Manually Backup - Restore or Clone a Database to Another Node [ID 562556.1]RESTDatabase
- SQLSERVER事務日誌已滿 the transaction log for database 'xx' is fullSQLServerDatabase
- Oracle 安裝Full Text searchOracle
- recover database until cancel using backup controlfileDatabase
- Recover database using backup controlfile until cancelDatabase