啟用catalog後控制檔案依舊會寫入備份資訊

我們知道在未開啟了catalog時，oracle的備份資訊會寫到控制檔案中

開啟了catalog後，oracle的備份資訊會寫到catalog資料庫内，那控制檔案中是否還會記錄備份資訊呢？

用strings檢視目前控制檔案

[[email protected] disk1]$ strings control01.ctl > 1.st

[[email protected] disk1]$vi 1.st

}|{z

PROD

33PROD

33PROD

PROD

PROD

/u01/app/oracle/oradta/PROD/disk1/redo01.log

/u01/app/oracle/oradta/PROD/disk1/redo02.log

/u01/app/oracle/oradta/PROD/disk1/redo03.log

/u01/app/oracle/oradta/PROD/disk1/system01.dbf

/u01/app/oracle/oradta/PROD/disk1/undotbs01.dbf

/u01/app/oracle/oradta/PROD/disk1/sysaux01.dbf

/u01/app/oracle/oradta/PROD/disk1/temp01.dbf

/u01/app/oracle/oradta/PROD/disk1/temp1.dbf

/u01/app/oracle/oradta/PROD/disk2/temp2.dbf

/u01/app/oracle/oradta/PROD/disk3/EXAMPLE.dbf

/u01/app/oracle/oradta/PROD/disk4/dss.dbf

/u01/app/oracle/oradta/PROD/disk5/indx01.dbf

/u01/app/oracle/oradta/PROD/disk1/tools01.dbf

/u01/app/oracle/oradta/PROD/disk2/users.dbf

/u01/app/oracle/oradta/PROD/disk3/oltp.dbf

/u01/app/oracle/oradta/PROD/disk4/redo4_a.log

/u01/app/oracle/oradta/PROD/disk5/redo4_b.log

/u01/app/oracle/oradta/PROD/disk2/redo1_b.log

/u01/app/oracle/oradta/PROD/disk2/redo2_b.log

/u01/app/oracle/oradta/PROD/disk3/redo3_b.log

/u01/app/oracle/oradta/PROD/disk1/REGISTRATION.dbf

/u01/app/oracle/oradta/PROD/disk1/redo01.log

/u01/app/oracle/oradta/PROD/disk1/redo02.log

/u01/app/oracle/oradta/PROD/disk1/redo03.log

/u01/app/oracle/oradta/PROD/disk1/system01.dbf

/u01/app/oracle/oradta/PROD/disk1/undotbs01.dbf

/u01/app/oracle/oradta/PROD/disk1/sysaux01.dbf

/u01/app/oracle/oradta/PROD/disk1/temp01.dbf

/u01/app/oracle/oradta/PROD/disk1/temp1.dbf

/u01/app/oracle/oradta/PROD/disk2/temp2.dbf

/u01/app/oracle/oradta/PROD/disk3/EXAMPLE.dbf

/u01/app/oracle/oradta/PROD/disk4/dss.dbf

/u01/app/oracle/oradta/PROD/disk5/indx01.dbf

/u01/app/oracle/oradta/PROD/disk1/tools01.dbf

/u01/app/oracle/oradta/PROD/disk2/users.dbf

/u01/app/oracle/oradta/PROD/disk3/oltp.dbf

/u01/app/oracle/oradta/PROD/disk4/redo4_a.log

/u01/app/oracle/oradta/PROD/disk5/redo4_b.log

/u01/app/oracle/oradta/PROD/disk2/redo1_b.log

/u01/app/oracle/oradta/PROD/disk2/redo2_b.log

/u01/app/oracle/oradta/PROD/disk3/redo3_b.log

SYSTEM

UNDOTBS

SYSAUX

TEMPTS1

TEMP1

TEMP2

EXAMPLE

INDX

TOOLS

USERS

OLTP

REGISTRATION

SYSTEM

UNDOTBS

SYSAUX

TEMPTS1

TEMP1

TEMP2

EXAMPLE

INDX

TOOLS

USERS

OLTP

REGISTRATION

BACKUP OPTIMIZATION

CONTROLFILE AUTOBACKUP

BACKUP OPTIMIZATION

2014-09-23T09:57:50

RMAN

PROD

UNNAMED_INSTANCE_1

可見控制檔案中沒用備份的資訊

連接配接catalog，做一個全備

[[email protected] EMREP]$ rman target sys/[email protected] catalog rc_admin/[email protected]

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Sep 23 10:55:18 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: PROD (DBID=270858313)

connected to recovery catalog database

RMAN> show all;

RMAN> show all;

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/control/cf_%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/home/oracle/backup/db_%U';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_PROD.f'; # default

RMAN> BACKUP AS COMPRESSED BACKUPSET full DATABASE 

include  current controlfile  spfile

PLUS ARCHIVELOG delete all input;

2> 3> 

Starting backup at 23-SEP-14

current log archived

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=271 devtype=DISK

channel ORA_DISK_1: starting compressed archive log backupset

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

input archive log thread=1 sequence=5 recid=1 stamp=859028125

channel ORA_DISK_1: starting piece 1 at 23-SEP-14

channel ORA_DISK_1: finished piece 1 at 23-SEP-14

piece handle=/home/oracle/backup/db_01pj7ekv_1_1 tag=TAG20140923T105527 comment=NONE

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

channel ORA_DISK_1: deleting archive log(s)

archive log filename=/u01/app/oracle/product/10.2.0/db_1/dbs/arch1_5_859019977.dbf recid=1 stamp=859028125

Finished backup at 23-SEP-14

Starting backup at 23-SEP-14

using channel ORA_DISK_1

channel ORA_DISK_1: starting compressed full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00004 name=/u01/app/oracle/oradta/PROD/disk3/EXAMPLE.dbf

input datafile fno=00005 name=/u01/app/oracle/oradta/PROD/disk4/dss.dbf

input datafile fno=00001 name=/u01/app/oracle/oradta/PROD/disk1/system01.dbf

input datafile fno=00003 name=/u01/app/oracle/oradta/PROD/disk1/sysaux01.dbf

input datafile fno=00002 name=/u01/app/oracle/oradta/PROD/disk1/undotbs01.dbf

input datafile fno=00010 name=/u01/app/oracle/oradta/PROD/disk1/REGISTRATION.dbf

input datafile fno=00008 name=/u01/app/oracle/oradta/PROD/disk2/users.dbf

input datafile fno=00009 name=/u01/app/oracle/oradta/PROD/disk3/oltp.dbf

input datafile fno=00006 name=/u01/app/oracle/oradta/PROD/disk5/indx01.dbf

input datafile fno=00007 name=/u01/app/oracle/oradta/PROD/disk1/tools01.dbf

channel ORA_DISK_1: starting piece 1 at 23-SEP-14

channel ORA_DISK_1: finished piece 1 at 23-SEP-14

piece handle=/home/oracle/backup/db_02pj7el4_1_1 tag=TAG20140923T105531 comment=NONE

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

channel ORA_DISK_1: starting compressed full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current control file in backupset

channel ORA_DISK_1: starting piece 1 at 23-SEP-14

channel ORA_DISK_1: finished piece 1 at 23-SEP-14

piece handle=/home/oracle/backup/db_03pj7epb_1_1 tag=TAG20140923T105531 comment=NONE

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

channel ORA_DISK_1: starting compressed full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current SPFILE in backupset

channel ORA_DISK_1: starting piece 1 at 23-SEP-14

channel ORA_DISK_1: finished piece 1 at 23-SEP-14

piece handle=/home/oracle/backup/db_04pj7epc_1_1 tag=TAG20140923T105531 comment=NONE

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

Finished backup at 23-SEP-14

Starting backup at 23-SEP-14

current log archived

using channel ORA_DISK_1

channel ORA_DISK_1: starting compressed archive log backupset

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

input archive log thread=1 sequence=6 recid=2 stamp=859028269

channel ORA_DISK_1: starting piece 1 at 23-SEP-14

channel ORA_DISK_1: finished piece 1 at 23-SEP-14

piece handle=/home/oracle/backup/db_05pj7epf_1_1 tag=TAG20140923T105751 comment=NONE

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

channel ORA_DISK_1: deleting archive log(s)

archive log filename=/u01/app/oracle/product/10.2.0/db_1/dbs/arch1_6_859019977.dbf recid=2 stamp=859028269

Finished backup at 23-SEP-14

Starting Control File and SPFILE Autobackup at 23-SEP-14

piece handle=/home/oracle/backup/control/cf_c-270858313-20140923-00 comment=NONE

Finished Control File and SPFILE Autobackup at 23-SEP-14

[[email protected] disk1]$ strings control01.ctl > 2.st

[[email protected] disk1]$ vi 2.st 

}|{z

PROD

33PROD

33PROD

PROD

PROD

/u01/app/oracle/oradta/PROD/disk1/redo01.log

/u01/app/oracle/oradta/PROD/disk1/redo02.log

/u01/app/oracle/oradta/PROD/disk1/redo03.log

/u01/app/oracle/oradta/PROD/disk1/system01.dbf

/u01/app/oracle/oradta/PROD/disk1/undotbs01.dbf

/u01/app/oracle/oradta/PROD/disk1/sysaux01.dbf

/u01/app/oracle/oradta/PROD/disk1/temp01.dbf

/u01/app/oracle/oradta/PROD/disk1/temp1.dbf

/u01/app/oracle/oradta/PROD/disk2/temp2.dbf

/u01/app/oracle/oradta/PROD/disk3/EXAMPLE.dbf

/u01/app/oracle/oradta/PROD/disk4/dss.dbf

/u01/app/oracle/oradta/PROD/disk5/indx01.dbf

/u01/app/oracle/oradta/PROD/disk1/tools01.dbf

/u01/app/oracle/oradta/PROD/disk2/users.dbf

/u01/app/oracle/oradta/PROD/disk3/oltp.dbf

/u01/app/oracle/oradta/PROD/disk4/redo4_a.log

/u01/app/oracle/oradta/PROD/disk5/redo4_b.log

/u01/app/oracle/oradta/PROD/disk2/redo1_b.log

/u01/app/oracle/oradta/PROD/disk2/redo2_b.log

/u01/app/oracle/oradta/PROD/disk3/redo3_b.log

/u01/app/oracle/oradta/PROD/disk1/REGISTRATION.dbf

/u01/app/oracle/oradta/PROD/disk1/redo01.log

/u01/app/oracle/oradta/PROD/disk1/redo02.log

/u01/app/oracle/oradta/PROD/disk1/redo03.log

/u01/app/oracle/oradta/PROD/disk1/system01.dbf

/u01/app/oracle/oradta/PROD/disk1/undotbs01.dbf

/u01/app/oracle/oradta/PROD/disk1/sysaux01.dbf

/u01/app/oracle/oradta/PROD/disk1/temp01.dbf

/u01/app/oracle/oradta/PROD/disk1/temp1.dbf

/u01/app/oracle/oradta/PROD/disk2/temp2.dbf

/u01/app/oracle/oradta/PROD/disk3/EXAMPLE.dbf

/u01/app/oracle/oradta/PROD/disk4/dss.dbf

/u01/app/oracle/oradta/PROD/disk5/indx01.dbf

/u01/app/oracle/oradta/PROD/disk1/tools01.dbf

/u01/app/oracle/oradta/PROD/disk2/users.dbf

/u01/app/oracle/oradta/PROD/disk3/oltp.dbf

/u01/app/oracle/oradta/PROD/disk4/redo4_a.log

/u01/app/oracle/oradta/PROD/disk5/redo4_b.log

/u01/app/oracle/oradta/PROD/disk2/redo1_b.log

/u01/app/oracle/oradta/PROD/disk2/redo2_b.log

/u01/app/oracle/oradta/PROD/disk3/redo3_b.log

/u01/app/oracle/oradta/PROD/disk1/REGISTRATION.dbf

SYSTEM

UNDOTBS

SYSAUX

TEMPTS1

TEMP1

TEMP2

EXAMPLE

INDX

TOOLS

USERS

OLTP

REGISTRATION

SYSTEM

UNDOTBS

SYSAUX

TEMPTS1

TEMP1

TEMP2

EXAMPLE

INDX

TOOLS

USERS

OLTP

REGISTRATION

BACKUP OPTIMIZATION

CONTROLFILE AUTOBACKUP

RETENTION POLICY

TO RECOVERY WINDOW OF 7 DAYS

CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE

DISK TO '/home/oracle/backup/control/cf_%F'

BACKUP OPTIMIZATION

CONTROLFILE AUTOBACKUP

RETENTION POLICY

TO RECOVERY WINDOW OF 7 DAYS

CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE

DISK TO '/home/oracle/backup/control/cf_%F'

CHANNEL

DEVICE TYPE DISK FORMAT   '/home/oracle/backup/db_%U'

u01/app/oracle/product/10.2.0/db_1/dbs/arch1_5_859019977.dbf

u01/app/oracle/product/10.2.0/db_1/dbs/arch1_6_859019977.dbf

u01/app/oracle/product/10.2.0/db_1/dbs/arch1_5_859019977.dbf

/u01/app/oracle/product/10.2.0/db_1/dbs/arch1_6_859019977.dbf

DISK

/home/oracle/backup/db_01pj7ekv_1_1

TAG20140923T105527

DISK

/home/oracle/backup/db_02pj7el4_1_1

TAG20140923T105531

DISK

/home/oracle/backup/db_03pj7epb_1_1

TAG20140923T105531

DISK

/home/oracle/backup/db_04pj7epc_1_1

TAG20140923T105531

DISK

/home/oracle/backup/db_05pj7epf_1_1

TAG20140923T105751

DISK

/home/oracle/backup/control/cf_c-270858313-20140923-00

TAG20140923T105754

DISK

/home/oracle/backup/db_01pj7ekv_1_1

TAG20140923T105527

DISK

/home/oracle/backup/db_02pj7el4_1_1

TAG20140923T105531

DISK

/home/oracle/backup/db_03pj7epb_1_1

TAG20140923T105531

DISK

/home/oracle/backup/db_04pj7epc_1_1

TAG20140923T105531

DISK

/home/oracle/backup/db_05pj7epf_1_1

TAG20140923T105751

2014-09-23T09:57:50

RMAN

2014-09-23T10:55:18

RMAN

2014-09-23T10:55:18

backup

2014-09-23T10:55:18

backup

2014-09-23T10:55:18

backup

2014-09-23T10:55:18

Control File and SPFILE Autoback

2014-09-23T09:57:50

RMAN

2014-09-23T10:55:18

RMAN

2014-09-23T10:55:18

backup

2014-09-23T10:55:18

backup

2014-09-23T10:55:18

backup

2014-09-23T10:55:18

Control File and SPFILE Autoback

PROD

UNNAMED_INSTANCE_1

控制檔案末位添加了備份的資訊，證明oracle在catalog開啟時，控制檔案内也會寫入備份資訊，而且catalog中的配置記錄也會記錄其中