疑问测试：在primary上rman全备份删除归档的疑问(2)

Wed Dec 6 10:08:39 2006

ORACLE Instance orcl - Archival Error. Archiver continuing.

Wed Dec 6 10:09:43 2006

Error 12541 received logging on to the standby

Check whether the listener is up and running.

Suppressing further error logging of LOG_ARCHIVE_DEST_2.

Wed Dec 6 10:10:23 2006

Expanded controlfile section 15 from 215 to 2150 records

Requested to grow by 1935 records; added 9 blocks of records

Wed Dec 6 10:10:43 2006

Error 12541 received logging on to the standby

Check whether the listener is up and running.

Suppressing further error logging of LOG_ARCHIVE_DEST_2.

Wed Dec 6 10:11:44 2006

Error 12541 received logging on to the standby

Check whether the listener is up and running.

Suppressing further error logging of LOG_ARCHIVE_DEST_2.

Wed Dec 6 10:12:44 2006

Error 12541 received logging on to the standby

Check whether the listener is up and running.

Suppressing further error logging of LOG_ARCHIVE_DEST_2.

www.ixdba.net

Wed Dec 6 10:13:44 2006

Thread 1 advanced to log sequence 303

Current log# 1 seq# 303 mem# 0: /free/oracle/oradata/orcl/redo01.log

2：备库归档信息如下：

oracle@linux:/free/oracle/orabak> sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 12月 7 02:57:49 2006

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /free/oracle/orabak

Oldest online log sequence 294

Next log sequence to archive 0

Current log sequence 296

SQL>

3：主库归档信息如下：

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /free/oracle/orabak

Oldest online log sequence 300

Next log sequence to archive 302

Current log sequence 302

从主备库的归档信息可知，主备库之间相差的归档日志是296-301直间的信息。

4：在主库上进行rman全备份：

RMAN> backup database

2> format '/free/oracle/full_%d_%T_%s'

3> plus archivelog

4> format '/free/oracle/gaojf/arch_%d_%T_%s'

5> delete all input;

Starting backup at 06-DEC-06

current log archived

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=144 devtype=DISK

channel ORA_DISK_1: starting archive log backupset

channel ORA_DISK_1: specifying archive log(s) in backup set

input archive log thread=1 sequence=82 recid=81 stamp=607787727

input archive log thread=1 sequence=83 recid=83 stamp=607787845

input archive log thread=1 sequence=84 recid=85 stamp=607789457

input archive log thread=1 sequence=85 recid=86 stamp=607789534

input archive log thread=1 sequence=86 recid=89 stamp=607810983

input archive log thread=1 sequence=87 recid=90 stamp=607810983

input archive log thread=1 sequence=88 recid=91 stamp=607810983

input archive log thread=1 sequence=89 recid=92 stamp=607810983

input archive log thread=1 sequence=90 recid=93 stamp=607810983

input archive log thread=1 sequence=91 recid=94 stamp=607810983

input archive log thread=1 sequence=92 recid=88 stamp=607810927

input archive log thread=1 sequence=93 recid=95 stamp=607810998

input archive log thread=1 sequence=94 recid=96 stamp=607811064

input archive log thread=1 sequence=95 recid=97 stamp=607812794

input archive log thread=1 sequence=96 recid=98 stamp=607812995

input archive log thread=1 sequence=97 recid=99 stamp=607813144

input archive log thread=1 sequence=98 recid=100 stamp=607813323

input archive log thread=1 sequence=99 recid=101 stamp=607813391

input archive log thread=1 sequence=100 recid=102 stamp=607813454

channel ORA_DISK_1: starting piece 1 at 06-DEC-06

channel ORA_DISK_1: finished piece 1 at 06-DEC-06

piece handle=/free/oracle/gaojf/arch_ORCL_20061206_32 tag=TAG20061206T100841 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26

channel ORA_DISK_1: deleting archive log(s)

archive log filename=/free/oracle/orabak/arc821605985194.arc recid=81 stamp=607787727

archive log filename=/free/oracle/orabak/arc831605985194.arc recid=83 stamp=607787845

archive log filename=/free/oracle/orabak/arc841605985194.arc recid=85 stamp=607789457

archive log filename=/free/oracle/orabak/arc851605985194.arc recid=86 stamp=607789534

archive log filename=/free/oracle/orabak/arc861605985194.arc recid=89 stamp=607810983

archive log filename=/free/oracle/orabak/arc871605985194.arc recid=90 stamp=607810983

archive log filename=/free/oracle/orabak/arc881605985194.arc recid=91 stamp=607810983

archive log filename=/free/oracle/orabak/arc891605985194.arc recid=92 stamp=607810983

archive log filename=/free/oracle/orabak/arc901605985194.arc recid=93 stamp=607810983

archive log filename=/free/oracle/orabak/arc911605985194.arc recid=94 stamp=607810983

archive log filename=/free/oracle/orabak/arc921605985194.arc recid=88 stamp=607810927

archive log filename=/free/oracle/orabak/arc931605985194.arc recid=95 stamp=607810998

archive log filename=/free/oracle/orabak/arc941605985194.arc recid=96 stamp=607811064

archive log filename=/free/oracle/orabak/arc951605985194.arc recid=97 stamp=607812794

archive log filename=/free/oracle/orabak/arc961605985194.arc recid=98 stamp=607812995

archive log filename=/free/oracle/orabak/arc971605985194.arc recid=99 stamp=607813144

archive log filename=/free/oracle/orabak/arc981605985194.arc recid=100 stamp=607813323

archive log filename=/free/oracle/orabak/arc991605985194.arc recid=101 stamp=607813391

archive log filename=/free/oracle/orabak/arc1001605985194.arc recid=102 stamp=607813454

channel ORA_DISK_1: starting archive log backupset

channel ORA_DISK_1: specifying archive log(s) in backup set

input archive log thread=1 sequence=101 recid=103 stamp=607813488

input archive log thread=1 sequence=102 recid=104 stamp=607813528

input archive log thread=1 sequence=103 recid=106 stamp=607814712

input archive log thread=1 sequence=104 recid=105 stamp=607814654

input archive log thread=1 sequence=105 recid=107 stamp=607814745

input archive log thread=1 sequence=106 recid=108 stamp=607856169

input archive log thread=1 sequence=107 recid=110 stamp=607864115

input archive log thread=1 sequence=108 recid=111 stamp=607864115

input archive log thread=1 sequence=109 recid=112 stamp=607864116

input archive log thread=1 sequence=110 recid=113 stamp=607864116

input archive log thread=1 sequence=111 recid=114 stamp=607864116

input archive log thread=1 sequence=112 recid=109 stamp=607864059

input archive log thread=1 sequence=113 recid=115 stamp=607865826

input archive log thread=1 sequence=114 recid=116 stamp=607866762

input archive log thread=1 sequence=115 recid=117 stamp=607866774

input archive log thread=1 sequence=116 recid=118 stamp=607867158

input archive log thread=1 sequence=117 recid=119 stamp=607867474

input archive log thread=1 sequence=118 recid=120 stamp=607867476

input archive log thread=1 sequence=119 recid=121 stamp=607867491

input archive log thread=1 sequence=120 recid=122 stamp=607868194

input archive log thread=1 sequence=121 recid=125 stamp=607868260

input archive log thread=1 sequence=122 recid=127 stamp=607868352

input archive log thread=1 sequence=123 recid=129 stamp=607868479

input archive log thread=1 sequence=124 recid=131 stamp=607868921

input archive log thread=1 sequence=125 recid=133 stamp=607870911

input archive log thread=1 sequence=126 recid=134 stamp=607870980