为什么会少一个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$