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

piece handle=/free/oracle/full_ORCL_20061206_37 tag=TAG20061206T101027 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:03:15

Finished backup at 06-DEC-06

下面是备份在rman全备份过程中产生的归档日志，由于这个归档日志也没有传到备库应用，因此rman也保留了这份归档日志。

Starting backup at 06-DEC-06

current log archived

using channel ORA_DISK_1

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=302 recid=401 stamp=608465624

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_38 tag=TAG20061206T101345 comment=NONE

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

IXDBA.NET社区论坛

RMAN-08137: WARNING: archive log not deleted as it is still needed

archive log filename=/free/oracle/orabak/arc3021605985194.arc thread=1 sequence=302

Finished backup at 06-DEC-06

下面是备份控制文件：

Starting Control File Autobackup at 06-DEC-06

piece handle=/free/oracle/orabak/c-1132959697-20061206-00 comment=NONE

Finished Control File Autobackup at 06-DEC-06

RMAN>

5：恢复备库的监听：

启动备库的监听，此时查看备库日志信息：

Thu Dec 7 03:52:10 2006

Redo Shipping Client Connected as PUBLIC

-- Connected User is Valid

RFS[2]: Assigned to RFS process 9015

RFS[2]: Identified database type as 'physical standby'

RFS[2]: Archived Log: '/free/oracle/orabak/1_296_605985194.dbf'

RFS[2]: Archived Log: '/free/oracle/orabak/1_297_605985194.dbf'

RFS[2]: Archived Log: '/free/oracle/orabak/1_298_605985194.dbf'

RFS[2]: Archived Log: '/free/oracle/orabak/1_299_605985194.dbf'

RFS[2]: Archived Log: '/free/oracle/orabak/1_300_605985194.dbf'

RFS[2]: Archived Log: '/free/oracle/orabak/1_301_605985194.dbf'

RFS[2]: Archived Log: '/free/oracle/orabak/1_302_605985194.dbf'

Thu Dec 7 03:52:14 2006

Media Recovery Log /free/oracle/orabak/1_296_605985194.dbf

Media Recovery Log /free/oracle/orabak/1_297_605985194.dbf

Media Recovery Log /free/oracle/orabak/1_298_605985194.dbf

Media Recovery Log /free/oracle/orabak/1_299_605985194.dbf

Media Recovery Log /free/oracle/orabak/1_300_605985194.dbf

Media Recovery Log /free/oracle/orabak/1_301_605985194.dbf

Media Recovery Log /free/oracle/orabak/1_302_605985194.dbf

Media Recovery Waiting for thread 1 sequence 303

可以看到，监听启动后，主库的一些没有传递过来的归档可以马上传到备库，然后Media Recovery。

6：查看主备库的归档信息：

主库：

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /free/oracle/orabak

Oldest online log sequence 302

Next log sequence to archive 303

Current log sequence 303

备库：

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /free/oracle/orabak

Oldest online log sequence 296

Next log sequence to archive 0

Current log sequence 303