rman backup database force 功能
FORCE
Causes RMAN to ignore backup optimization. In other words, even if CONFIGURE BACKUP OPTIMIZATION is set to ON, RMAN backs up all specified files.
Note: You can also specify this option in the backupSpecOperand clause.
加上FORCE選項,則RMAN忽略調CONFIGURE裡的最佳化功能選項.
比如:你配置了RMAN最佳化功能為ON,之前對只讀表空間作了備份,這時,再備份全庫,不加FORCE.
則RMAN不會備份只讀表空間,因為之前已經備份過,加上FORCE,則RMAN忽略掉最佳化功能,
作全庫備份.
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION ON;
SQL> alter tablespace tools read only;
Tablespace altered.
RMAN> backup tablespace tools;
Starting backup at 21-DEC-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00004 name=D:ORACLEORADATAPAULTOOLS01.DBF
channel ORA_DISK_1: starting piece 1 at 21-DEC-07
channel ORA_DISK_1: finished piece 1 at 21-DEC-07
piece handle=D:BACKUP3IJ454LF_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 21-DEC-07
Starting Control File and SPFILE Autobackup at 21-DEC-07
piece handle=D:BACKUPC-1605165889-20071221-03 comment=NONE
Finished Control File and SPFILE Autobackup at 21-DEC-07
RMAN> backup database;
Starting backup at 21-DEC-07
using channel ORA_DISK_1
skipping datafile 4; already backed up 3 time(s)
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=D:ORACLEORADATAPAULSYSTEM01.DBF
input datafile fno=00002 name=D:ORACLEORADATAPAULUNDOTBS01.DBF
input datafile fno=00003 name=D:ORACLEORADATAPAULINDX01.DBF
input datafile fno=00005 name=D:ORACLEORADATAPAULUSERS01.DBF
channel ORA_DISK_1: starting piece 1 at 21-DEC-07
channel ORA_DISK_1: finished piece 1 at 21-DEC-07
piece handle=D:BACKUP3KJ454M1_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
Finished backup at 21-DEC-07
Starting Control File and SPFILE Autobackup at 21-DEC-07
piece handle=D:BACKUPC-1605165889-20071221-04 comment=NONE
Finished Control File and SPFILE Autobackup at 21-DEC-07
RMAN> backup database force;
Starting backup at 21-DEC-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=D:ORACLEORADATAPAULSYSTEM01.DBF
input datafile fno=00002 name=D:ORACLEORADATAPAULUNDOTBS01.DBF
input datafile fno=00003 name=D:ORACLEORADATAPAULINDX01.DBF
input datafile fno=00005 name=D:ORACLEORADATAPAULUSERS01.DBF
input datafile fno=00004 name=D:ORACLEORADATAPAULTOOLS01.DBF
channel ORA_DISK_1: starting piece 1 at 21-DEC-07
channel ORA_DISK_1: finished piece 1 at 21-DEC-07
piece handle=D:BACKUP3MJ454NL_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
Finished backup at 21-DEC-07
Starting Control File and SPFILE Autobackup at 21-DEC-07
piece handle=D:BACKUPC-1605165889-20071221-05 comment=NONE
Finished Control File and SPFILE Autobackup at 21-DEC-07
RMAN>
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-1032/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Rman backup standby databaseDatabase
- How to use rman backup a noarchivelog databaseHiveDatabase
- 理解RMAN backup database plus archivelog命令DatabaseHive
- 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
- RMAN - backup archivelog all 與 backup database plus archivelog 區別HiveDatabase
- 理解RMAN backup database plus archivelog delete all input命令DatabaseHivedelete
- RMAN10g: backup copy of database (Doc ID 266980.1)Database
- rman backup database 出現 ORA-01422錯誤Database
- oracle full database backupOracleDatabase
- Cold Database backup scriptDatabase
- Oracle 11g RMAN備份-RMAN的backup database plus archivelog命令背後的操作OracleDatabaseHive
- rman backup script(引用)
- DP rman backup scripts
- Cold backup and restore the entire databaseRESTDatabase
- PostgreSQL DBA(138) - PG 13(Drop database force)SQLDatabase
- RMAN duplicat databaseDatabase
- rman recover databaseDatabase
- RMAN duplicate databaseDatabase
- Oracle 學習(Rman Backup)Oracle
- SQLBackupAndFTP12.0 failed to backup database with full backup typeSQLFTPAIDatabase
- T-SQL Verify Database BackupSQLDatabase
- rman 中delete 與delete force 的區別delete
- V$RMAN_BACKUP_JOB_DETAILSAI
- RMAN cumulative and differential incremental backupREM
- Oracle Database 12C 新功能 rman RECOVER TABLE (文件 ID 2047644.1)OracleDatabase
- oracle 11g rman backup scriptOracle
- 轉貼_RMAN-DBMS_BACKUP_RESTOREREST
- 通過rman duplicate database!Database
- Crunchy PostgreSQL database backup via pgo commandSQLDatabaseGo
- recover database using backup controlfileDatabase
- NBU report error 6 when RMAN backupError
- 10g R2 rman backup database 控制檔案備份後於備份集備份Database
- RMAN duplicate database到新主機Database
- rman 建 Standby Database 筆記Database筆記
- RMAN CONVERT DATABASE 的限制Database
- 425alter database force logging修改那裡Database