今天在删除主库归档日志的时候又遇到一样的错误:
[oracle@DB1 ~]$ ll /dbdat/orclprd/oracle/archivelog(篇幅有限,没全部复制)
总用量 8134040
-rw-r-----. 1 oracle oinstall 176324608 8月 27 17:32 1_8352_840379839.dbf
-rw-r-----. 1 oracle oinstall 199037440 8月 27 17:33 1_8353_840379839.dbf
-rw-r-----. 1 oracle oinstall 176882176 8月 28 08:42 1_8354_840379839.dbf
-rw-r-----. 1 oracle oinstall 175932928 8月 28 08:44 1_8355_840379839.dbf
-rw-r-----. 1 oracle oinstall 182687744 8月 28 08:46 1_8356_840379839.dbf
-rw-r-----. 1 oracle oinstall 221465600 8月 28 12:39 1_8357_840379839.dbf
-rw-r-----. 1 oracle oinstall 181895680 8月 28 13:16 1_8358_840379839.dbf
-rw-r-----. 1 oracle oinstall 178913280 8月 28 13:17 1_8359_840379839.dbf
-rw-r-----. 1 oracle oinstall 172002816 8月 28 22:00 1_8360_840379839.dbf
-rw-r-----. 1 oracle oinstall 170728448 8月 29 15:58 1_8361_840379839.dbf
-rw-r-----. 1 oracle oinstall 189336576 8月 30 08:08 1_8362_840379839.dbf
-rw-r-----. 1 oracle oinstall 172001280 8月 31 06:00 1_8363_840379839.dbf
-rw-r-----. 1 oracle oinstall 170754560 8月 31 20:03 1_8364_840379839.dbf
-rw-r-----. 1 oracle oinstall 170733568 9月 1 16:18 1_8365_840379839.dbf
-rw-r-----. 1 oracle oinstall 170728448 9月 1 23:42 1_8366_840379839.dbf
-rw-r-----. 1 oracle oinstall 171007488 9月 2 12:00 1_8367_840379839.dbf
-rw-r-----. 1 oracle oinstall 172413440 9月 3 00:00 1_8368_840379839.dbf
-rw-r-----. 1 oracle oinstall 170728960 9月 3 13:51 1_8369_840379839.dbf
RMAN> delete archivelog all completed before 'sysdate-7';
This command is forbidden
user interrupt received
主库归档日志信息:
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /dbdat/orclprd/oracle/archivelog
Oldest online log sequence 8404
Next log sequence to archive 8406
Current log sequence 8406
rman>CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
备库归档日志信息:
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /dbdat/orclprd/oracle/archivelog
Oldest online log sequence 8405
Next log sequence to archive 0
Current log sequence 8406
SQL> select process,client_process,sequence#,status from v$managed_standby;
PROCESS CLIENT_P SEQUENCE# STATUS
--------- -------- ---------- ------------
ARCH ARCH 0 CONNECTED
ARCH ARCH 0 CONNECTED
ARCH ARCH 0 CONNECTED
ARCH ARCH 0 CONNECTED
RFS N/A 0 IDLE
RFS LGWR 8406 IDLE
RFS UNKNOWN 0 IDLE
MRP0 N/A 8406 WAIT_FOR_LOG
rman>CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;