[20171208]强制删除归档日志文件.txt
--//测试环境,产生日志太多,想强制删除.
RMAN> delete archivelog all ;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=106 device type=DISK
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/u01/app/oracle/archivelog/book/1_790_896605872.dbf thread=1 sequence=790
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/u01/app/oracle/archivelog/book/1_791_896605872.dbf thread=1 sequence=791
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
--//提示:RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
$ oerr rman 08137
8137, 3, "WARNING: archived log not deleted, needed for standby or upstream capture process"
// *Cause: An archived log that should have been deleted was not as it was
// required by upstream capture process or Data Guard.
// The next message identifies the archived log.
// *Action: This is an informational message. The archived log can be
// deleted after it is no longer needed. See the
// documentation for Data Guard to alter the set of active
// Data Guard destinations. See the documentation for
// Streams to alter the set of active streams.
--//dataguard 备库已经停用很久了.要强制删除归档日志:
RMAN> delete archivelog all force ;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "force": expecting one of: "backed, completed, device, for, like, tag, ;"
RMAN-01007: at line 2 column 23 file: standard input
RMAN> delete
2>
3>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "end-of-file": expecting one of: "archivelog, backuppiece, backupset, backup, controlfilecopy, copy, datafilecopy, expired, force, foreign, global, noprompt, obsolete, proxy, script"
RMAN-01007: at line 3 column 1 file: standard input
--//提示看force要写前面...
RMAN> delete force archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=106 device type=DISK
List of Archived Log Copies for database with db_unique_name BOOK
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - -------------------
1330 1 790 A 2017-11-13 09:48:53
Name: /u01/app/oracle/archivelog/book/1_790_896605872.dbf
...
1497 1 957 A 2017-12-07 13:44:31
Name: /u01/app/oracle/archivelog/book/1_957_896605872.dbf
Do you really want to delete the above objects (enter YES or NO)? YES
--//我经常习惯性写后面.做一个笔记.
