resetlog oracle,resetlog与noresetlog的问题

为什么会少一个instance的redlog文件呢，

在noresetlog方式下可以全部备份出来，而在resetlog方式下只能备份本地下的redolog文件，另一个instance没有。?????

RAC 的环境下进行rman备份时

>backup database  controlfile to trace

生成如下的:

cat trace     whdx2 _ora _2195516.trc

/ora9i_dump/sh9702/udump/whdx2_ora_2195516.trc

Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production

With the Partitioning and Real Application Clusters options

JServer Release 9.2.0.3.0 - Production

ORACLE_HOME = /ora9i_sys/product/9.2.0

System name:    AIX

Node name:      sh9702

Release:        1

Version:        5

Instance name: whdx2

Redo thread mounted by this instance: 2

Oracle process number: 30

Unix process pid: 2195516, image: oracle@sh9702 (TNS V1-V3)

*** SESSION ID

65.19626) 2003-08-15 10:49:28.457

*** 2003-08-15 10:49:28.457

# The following are current System-scope REDO Log Archival related

# parameters and can be included in the database initialization file.

#

# LOG_ARCHIVE_DEST=''

# LOG_ARCHIVE_DUPLEX_DEST=''

#

# LOG_ARCHIVE_FORMAT=arch_%t_%s.log

# REMOTE_ARCHIVE_ENABLE=TRUE

# LOG_ARCHIVE_START=TRUE

# LOG_ARCHIVE_MAX_PROCESSES=2

# STANDBY_FILE_MANAGEMENT=MANUAL

# STANDBY_ARCHIVE_DEST=?/dbs/arch

# FAL_CLIENT=''

# FAL_SERVER=''

#

# LOG_ARCHIVE_DEST_1='LOCATION=/archvg02'

# LOG_ARCHIVE_DEST_1='OPTIONAL REOPEN=300 NODELAY'

# LOG_ARCHIVE_DEST_1='ARCH NOAFFIRM SYNC'

# LOG_ARCHIVE_DEST_1='REGISTER NOALTERNATE NODEPENDENCY'

# LOG_ARCHIVE_DEST_1='NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED'

# LOG_ARCHIVE_DEST_STATE_1=ENABLE

#

# Below are two sets of SQL statements, each of which creates a new

# control file and uses it to open the database. The first set opens

# the database with the NORESETLOGS option and should be used only if

# the current versions of all online logs are available. The second

# set opens the database with the RESETLOGS option and should be used

# if online logs are unavailable.

# The appropriate set of statements can be copied from the trace into

# a script file, edited as necessary, and executed when there is a

# need to re-create the control file.

#

#     Set #1. NORESETLOGS case

#

# The following commands will create a new control file and use it

# to open the database.

# Data used by the recovery manager will be lost. Additional logs may

# be required for media recovery of offline data files. Use this

# only if the current version of all online logs are available.

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "WHDX" NORESETLOGS  ARCHIVELOG

--  SET STANDBY TO MAXIMIZE PERFORMANCE

MAXLOGFILES 192

MAXLOGMEMBERS 3

MAXDATAFILES 1024

MAXINSTANCES 32

MAXLOGHISTORY 3403

LOGFILE

GROUP 1 (

'/dev/rlvyw_redoa11',

'/dev/rlvyw_redoa12'

) SIZE 100M,

GROUP 2 (

'/dev/rlvyw_redoa21',

'/dev/rlvyw_redoa22'

) SIZE 100M,

GROUP 3 (

'/dev/rlvyw_redoa31',

'/dev/rlvyw_redoa32'

) SIZE 100M,

GROUP 4 (

'/dev/rlvyw_redoa41',

'/dev/rlvyw_redoa42'

) SIZE 100M,

GROUP 5 (

'/dev/rlvyw_redoa51',

'/dev/rlvyw_redoa52'

) SIZE 100M,

GROUP 6 (

'/dev/rlvyw_redoa61',

'/dev/rlvyw_redoa62'

) SIZE 100M,

GROUP 7 (

'/dev/rlvyw_redob11',

'/dev/rlvyw_redob12'

) SIZE 100M,

GROUP 8 (

'/dev/rlvyw_redob21',

'/dev/rlvyw_redob22'

) SIZE 100M,

GROUP 9 (

'/dev/rlvyw_redob31',

'/dev/rlvyw_redob32'

) SIZE 100M,

GROUP 10 (

'/dev/rlvyw_redob41',

'/dev/rlvyw_redob42'

) SIZE 100M,

GROUP 11 (

'/dev/rlvyw_redob51',

'/dev/rlvyw_redob52'

) SIZE 100M,

GROUP 12 (

'/dev/rlvyw_redob61',

'/dev/rlvyw_redob62'

) SIZE 100M

-- STANDBY LOGFILE

DATAFILE

'/dev/rlvyw_sys01',

'/dev/rlvyw_rbs01',

'/dev/rlvyw_index',

'/dev/rlvyw_tools',

'/dev/rlvyw_rbs02',

'/dev/rlvyw_users',

'/dev/rlvyw_rbs03',

'/dev/rlvyw_rbs04',

'/dev/rlvyw_resdata01',

'/dev/rlvyw_cdata01',

'/dev/rlvyw_infindx01',

'/dev/rlvyw_infdata01',

'/dev/rlvyw_actdata01',

'/dev/rlvyw_cindx01',

'/dev/rlvyw_resdata02',

'/dev/rlvyw_infdata02',

'/dev/rlvyw_user01',

'/dev/rlvyw_infdata03',

'/dev/rlvyw_resindx01',

'/dev/rlvyw_actindx01',

'/dev/rlvyw_bk2G09',

'/dev/rlvyw_bk2G08',

'/dev/rlvyw_bk2G01',

'/dev/rlvyw_bk2G02',

'/dev/rlvyw_bk2G03',

'/dev/rlvyw_bk2G04'

CHARACTER SET ZHS16GBK

;

# Recovery is required if any of the datafiles are restored backups,

# or if the last shutdown was not normal or immediate.

RECOVER DATABASE

# All logs need archiving and a log switch is needed.

ALTER SYSTEM ARCHIVE LOG ALL;

# Database can now be opened normally.

ALTER DATABASE OPEN;

# Commands to add tempfiles to temporary tablespaces.

# Online tempfiles have complete space information.

# Other tempfiles may require adjustment.

ALTER TABLESPACE TEMP ADD TEMPFILE '/dev/rlvyw_temp01'

SIZE 2040M REUSE AUTOEXTEND ON NEXT 10485760  MAXSIZE 2040M;

ALTER TABLESPACE TEMP ADD TEMPFILE '/dev/rlvyw_temp02'

SIZE 2040M REUSE AUTOEXTEND ON NEXT 10485760  MAXSIZE 2040M;

ALTER TABLESPACE TEMP ADD TEMPFILE '/dev/rlvyw_temp03'

SIZE 2040M REUSE AUTOEXTEND ON NEXT 10485760  MAXSIZE 2040M;

ALTER TABLESPACE TEMP ADD TEMPFILE '/dev/rlvyw_temp04'

SIZE 2040M REUSE AUTOEXTEND ON NEXT 10485760  MAXSIZE 2040M;

# End of tempfile additions.

#

#     Set #2. RESETLOGS case

#

# The following commands will create a new control file and use it

# to open the database.

# The contents of online logs will be lost and all backups will

# be invalidated. Use this only if online logs are damaged.

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "WHDX" RESETLOGS  ARCHIVELOG

--  SET STANDBY TO MAXIMIZE PERFORMANCE

MAXLOGFILES 192

MAXLOGMEMBERS 3

MAXDATAFILES 1024

MAXINSTANCES 32

MAXLOGHISTORY 3403

LOGFILE

GROUP 1 (

'/dev/rlvyw_redoa11',

'/dev/rlvyw_redoa12'

) SIZE 100M,

GROUP 2 (

'/dev/rlvyw_redoa21',

'/dev/rlvyw_redoa22'

) SIZE 100M,

GROUP 3 (

'/dev/rlvyw_redoa31',

'/dev/rlvyw_redoa32'

) SIZE 100M,

GROUP 4 (

'/dev/rlvyw_redoa41',

'/dev/rlvyw_redoa42'

) SIZE 100M,

GROUP 5 (

'/dev/rlvyw_redoa51',

'/dev/rlvyw_redoa52'

) SIZE 100M,

GROUP 6 (

'/dev/rlvyw_redoa61',

'/dev/rlvyw_redoa62'

) SIZE 100M

-- STANDBY LOGFILE

DATAFILE

'/dev/rlvyw_sys01',

'/dev/rlvyw_rbs01',

'/dev/rlvyw_index',

'/dev/rlvyw_tools',

'/dev/rlvyw_rbs02',

'/dev/rlvyw_users',

'/dev/rlvyw_rbs03',

'/dev/rlvyw_rbs04',

'/dev/rlvyw_resdata01',

'/dev/rlvyw_cdata01',

'/dev/rlvyw_infindx01',

'/dev/rlvyw_infdata01',

'/dev/rlvyw_actdata01',

'/dev/rlvyw_cindx01',

'/dev/rlvyw_resdata02',

'/dev/rlvyw_infdata02',

'/dev/rlvyw_user01',

'/dev/rlvyw_infdata03',

'/dev/rlvyw_resindx01',

'/dev/rlvyw_actindx01',

'/dev/rlvyw_bk2G09',

'/dev/rlvyw_bk2G08',

'/dev/rlvyw_bk2G01',

'/dev/rlvyw_bk2G02',

'/dev/rlvyw_bk2G03',

'/dev/rlvyw_bk2G04'

CHARACTER SET ZHS16GBK

;

# Recovery is required if any of the datafiles are restored backups,

# or if the last shutdown was not normal or immediate.

RECOVER DATABASE USING BACKUP CONTROLFILE

# Database can now be opened zeroing the online logs.

ALTER DATABASE OPEN RESETLOGS;

# Commands to add tempfiles to temporary tablespaces.

# Online tempfiles have complete space information.

# Other tempfiles may require adjustment.

ALTER TABLESPACE TEMP ADD TEMPFILE '/dev/rlvyw_temp01'

SIZE 2040M REUSE AUTOEXTEND ON NEXT 10485760  MAXSIZE 2040M;

ALTER TABLESPACE TEMP ADD TEMPFILE '/dev/rlvyw_temp02'

SIZE 2040M REUSE AUTOEXTEND ON NEXT 10485760  MAXSIZE 2040M;

ALTER TABLESPACE TEMP ADD TEMPFILE '/dev/rlvyw_temp03'

SIZE 2040M REUSE AUTOEXTEND ON NEXT 10485760  MAXSIZE 2040M;

ALTER TABLESPACE TEMP ADD TEMPFILE '/dev/rlvyw_temp04'

SIZE 2040M REUSE AUTOEXTEND ON NEXT 10485760  MAXSIZE 2040M;

# End of tempfile additions.

#

# Enable threads after logs have been created.

ALTER DATABASE ENABLE PUBLIC THREAD 2;

oracle@sh9702:/ora9i_dump/sh9702/udump$