I ran an rman validate for an standalone instance to verify aux copy. Where in the rman log it specifies that I select an aux copy instead of the primary copy?
Rman Script:
[run {
allocate channel ch1 type 'sbt_tape'
PARMS="SBT_LIBRARY=/u02/commvault/Base/libobk.so, BLKSIZE=1048576 ENV=(CV_mmsApiVsn=2,ThreadCommandLine= -cn docemgcdacs01 -cs docapgalaxy)"
TRACE 0;
send " -jm 131082 -a 2:-1 -cl 72 -ins 74 -at 22 -j 771848 -jt 771848:2:1:0:0:27868 -rcp 3 -ms 2 -p 1 -oscAppId 401 -useCvNwSrv";
restore controlfile from 'c-3165165137-20250204-02' validate;
}
exit;
]
Rman Log:[
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Feb 4 13:59:06 2025
Version 19.25.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target *
connected to target database: EMGCDB (DBID=3165165137)
using target database control file instead of recovery catalog
RMAN> run {
2> allocate channel ch1 type 'sbt_tape'
3> PARMS="SBT_LIBRARY=/u02/commvault/Base/libobk.so, BLKSIZE=1048576 ENV=(CV_mmsApiVsn=2,ThreadCommandLine= -cn docemgcdacs01 -cs docapgalaxy)"
4> TRACE 0;
5> send " -jm 131082 -a 2:-1 -cl 72 -ins 74 -at 22 -j 771848 -jt 771848:2:1:0:0:27868 -rcp 3 -ms 2 -p 1 -oscAppId 401 -useCvNwSrv";
6> restore controlfile from 'c-3165165137-20250204-02' validate;
7> }
allocated channel: ch1
channel ch1: SID=6599 device type=SBT_TAPE
channel ch1: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
sent command to channel: ch1
Starting restore at Feb 04 2025 13:59:08
channel ch1: starting validation of datafile backup set
channel ch1: validation complete, elapsed time: 00:00:07
Finished restore at Feb 04 2025 13:59:15
released channel: ch1
RMAN> exit;
Recovery Manager complete.
]
Rman Script:
[run {
allocate channel ch1 type 'sbt_tape'
PARMS="SBT_LIBRARY=/u02/commvault/Base/libobk.so, BLKSIZE=1048576 ENV=(CV_mmsApiVsn=2,ThreadCommandLine= -cn docemgcdacs01 -vm Instance001)"
TRACE 0;
allocate channel ch2 type 'sbt_tape'
PARMS="SBT_LIBRARY=/u02/commvault/Base/libobk.so, BLKSIZE=1048576 ENV=(CV_mmsApiVsn=2,ThreadCommandLine= -cn docemgcdacs01 -vm Instance001)"
TRACE 0;
send " -jm 262286 -a 2:-1 -cl 72 -ins 74 -at 22 -j 771848 -jt 771848:3:1:0:0:27868 -rcp 3 -ms 2 -p 2 -oscAppId 401 -useCvNwSrv";
restore database validate ;
}
exit;
]
Rman Log:[
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Feb 4 13:59:26 2025
Version 19.25.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target *
connected to target database: EMGCDB (DBID=3165165137)
using target database control file instead of recovery catalog
RMAN> run {
2> allocate channel ch1 type 'sbt_tape'
3> PARMS="SBT_LIBRARY=/u02/commvault/Base/libobk.so, BLKSIZE=1048576 ENV=(CV_mmsApiVsn=2,ThreadCommandLine= -cn docemgcdacs01 -vm Instance001)"
4> TRACE 0;
5> allocate channel ch2 type 'sbt_tape'
6> PARMS="SBT_LIBRARY=/u02/commvault/Base/libobk.so, BLKSIZE=1048576 ENV=(CV_mmsApiVsn=2,ThreadCommandLine= -cn docemgcdacs01 -vm Instance001)"
7> TRACE 0;
8> send " -jm 262286 -a 2:-1 -cl 72 -ins 74 -at 22 -j 771848 -jt 771848:3:1:0:0:27868 -rcp 3 -ms 2 -p 2 -oscAppId 401 -useCvNwSrv";
9> restore database validate ;
10> }
allocated channel: ch1
channel ch1: SID=4401 device type=SBT_TAPE
channel ch1: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
allocated channel: ch2
channel ch2: SID=3151 device type=SBT_TAPE
channel ch2: CommVault Systems for Oracle: Version 11.0.0(BUILD80)
sent command to channel: ch1
sent command to channel: ch2
Starting restore at Feb 04 2025 13:59:28
new media label is "V_1212107_944712" for piece "771527_EMGCDB_hd3go91l_26157_1_1"
new media label is "V_1212284_944711" for piece "771527_EMGCDB_hb3go91l_26155_1_1"
new media label is "V_1212283_944709" for piece "771527_EMGCDB_hc3go91l_26156_1_1"
new media label is "V_1212052_944710" for piece "771527_EMGCDB_he3go91l_26158_1_1"
channel ch1: starting validation of datafile backup set
channel ch2: starting validation of datafile backup set
channel ch1: reading from backup piece 771527_EMGCDB_he3go91l_26158_1_1
channel ch2: reading from backup piece 771527_EMGCDB_hc3go91l_26156_1_1
channel ch1: piece handle=771527_EMGCDB_he3go91l_26158_1_1 tag=TAG20250202T010036
channel ch1: restored backup piece 1
channel ch1: validation complete, elapsed time: 00:18:35
channel ch1: starting validation of datafile backup set
channel ch1: reading from backup piece 771527_EMGCDB_hd3go91l_26157_1_1
channel ch2: piece handle=771527_EMGCDB_hc3go91l_26156_1_1 tag=TAG20250202T010036
channel ch2: restored backup piece 1
channel ch2: validation complete, elapsed time: 00:24:60
channel ch2: starting validation of datafile backup set
channel ch2: reading from backup piece 771527_EMGCDB_hb3go91l_26155_1_1
channel ch1: piece handle=771527_EMGCDB_hd3go91l_26157_1_1 tag=TAG20250202T010036
channel ch1: restored backup piece 1
channel ch1: validation complete, elapsed time: 00:18:00
channel ch2: piece handle=771527_EMGCDB_hb3go91l_26155_1_1 tag=TAG20250202T010036
channel ch2: restored backup piece 1
channel ch2: validation complete, elapsed time: 00:28:05
Finished restore at Feb 04 2025 14:52:36
released channel: ch1
released channel: ch2
RMAN> exit;
Recovery Manager complete.
]
