restore_oralce_psddata_recover_until_time

xxoo080095: > cat /pfile/psddata/psddata.ora
instance_name=psddata
service_names=psddata.world
db_name=psddata
audit_trail=none
audit_file_dest=/oracle/admin/psddata/adump
core_dump_dest=/oracle/admin/psddata/cdump
control_files=/control_file/psddata/control01.ctl
log_archive_dest=/arch/psddata
compatible=11.2.0.4.0
log_archive_format=%t_%s_%r.dbf
db_files=9000
log_archive_start=true
NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
large_pool_size=2G
pga_aggregate_target=4G
sga_max_size=16G
shared_pool_size=3G
db_cache_size=5G
db_block_size=8192


xxoo080095: > sqlplus / as sysdba
SYS@psddata(rs)> shutdown abort
ORACLE instance shut down.
SYS@psddata(rs)> startup mount pfile='/pfile/psddata/psddata.ora';
ORA-32006: LOG_ARCHIVE_START initialization parameter has been deprecated
ORACLE instance started.

Total System Global Area 1.7103E+10 bytes
Fixed Size                  2270360 bytes
Variable Size            1.1643E+10 bytes
Database Buffers         5368709120 bytes
Redo Buffers               88793088 bytes
Database mounted.


xxoo080095: > tail  -40 /logs/oracle/psddata/20240510084447/recover_until_time.log

Recovery Manager: Release 11.2.0.4.0 - Production on Mon May 13 09:08:54 2024
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: DSPDATA (DBID=1111111111, not open)

RMAN> run{
2>  set dbid 1111111111;
3>  set until time "to_date('2024-05-03 10:10:20' , 'yyyy-mm-dd hh24:mi:ss')";
4>  allocate channel ch0 type 'SBT_TAPE';
5>  allocate channel ch1 type 'SBT_TAPE';
6>  allocate channel ch2 type 'SBT_TAPE';
7>  allocate channel ch3 type 'SBT_TAPE';
8>  send 'NB_ORA_CLIENT=xxoo080272,NB_ORA_SERV=szbk-zq.szdc.paic.com.cn';
9>  recover database;
10>  release channel ch0;
11>  release channel ch1;
12>  release channel ch2;
13>  release channel ch3;
14>
15> }
16>

executing command: SET DBID  ------------------------------ mount状态下已经知道了dbid 不能使用
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 05/13/2024 09:08:54
RMAN-06188: cannot use command when connected to a mounted target database

Recovery Manager complete.

------------------------------------------------------------- mount状态下已经知道了dbid 不需要set dbid 1111111111;
RMAN> run{
 set until time "to_date('2024-05-03 10:10:20' , 'yyyy-mm-dd hh24:mi:ss')";
 allocate channel ch0 type 'SBT_TAPE';
 allocate channel ch1 type 'SBT_TAPE';
 allocate channel ch2 type 'SBT_TAPE';
 allocate channel ch3 type 'SBT_TAPE';
 send 'NB_ORA_CLIENT=xxoo080272,NB_ORA_SERV=szbk-zq.szdc.paic.com.cn';
 recover database;
 release channel ch0;
 release channel ch1;
 release channel ch2;
 release channel ch3;

}