当前位置： 首页 > news >正文

19C之前恢复drop 掉的PDB 创建另一个实例

news 2025/7/12 16:50:10

--------恢复PDB------------------

 create pluggable database testpdb admin user test identified by test;
 backup database plus archivelog tag 'full db  backup';
 
RMAN>  backup database plus archivelog tag 'full db  backup';
ORA-15012: ASM file '+DATA1/CDB/ARCHIVELOG/2024_06_01/thread_2_seq_90.424.1170496125' does not exist
RMAN> crosscheck archivelog all;


crosscheck backup all;
delete expired backup;
list backup summary;
RMAN> list backup;
  
 
SQL> drop pluggable database testpdb;
Pluggable database dropped.
 
·     In case if we try to restore PDB as a database, we will get below error 
RMAN> restore pluggable database testpdb;
 
Starting restore at 17-JUN-15
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/17/2015 16:46:46
RMAN-06813: could not translate pluggable database TESTPDB
 
Restore procedure
 
Pluggable database (PDB) can’t be restored as a database. It needs to be restored as database object. 
For that auxiliary instance has to be created temporarily where CDB and required PDB will be restored. Later PDB will be unplugged from auxiliary instance and attached to target instance
 

Create a temporary auxiliary instance to restore container database (CDB) and required pluggable database (PDB)
 
Create password file for auxiliary instance
 
[oracle@Server dbs]$ orapwd file=orapwtestcdb1 password=sys entries=5
[oracle@Server dbs]$ ls -lrt orapwtestcdb1
-rw-r-----. 1 oracle oinstall 5120 Jun 17 17:04 orapwtestcdb1
 
Create init file for auxiliary instance
 

*.compatible='12.1.0.0.0'
*.control_files='/u01/app/oracle/oradata/TESTCDB1/controlfile/o1_mf_bfsn3k7o_.ctl'
*.db_block_size=8192
*.db_create_file_dest='/u01/app/oracle/oradata'
*.db_name='testcdb1'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=testcdb1XDB)'
*.enable_pluggable_database=true
*.open_cursors=300
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
 
Start the auxiliary instance in nomount state
 

[oracle@Server dbs]$ export ORACLE_SID=testcdb1
[oracle@Server dbs]$ sqlplus sys/sy as sysdba
 
SQL*Plus: Release 12.1.0.1.0 Production on Wed Jun 17 17:04:57 2015
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.
SQL>  startup nomount pfile=inittestcdb1.ora
ORACLE instance started.
Total System Global Area          242208768 bytes
Fixed Size                                 2849120 bytes
Variable Size                             184551072 bytes
Database Buffers                      50331648 bytes
Redo Buffers                4476928 bytes
 
Connect auxiliary instance through RMAN
 
[oracle@Server dbs]$ rman auxiliary sys/sys
Recovery Manager: Release 12.1.0.1.0 - Production on Wed Jun 17 17:08:45 2015
Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.
connected to auxiliary database: TESTCDB1 (not mounted)
 
Execute Duplicate command for CDB and particular PDB using backup location

-----多个备份下的情况

[oracle@rac1 dbs]$ rman auxiliary /

Recovery Manager: Release 19.0.0.0.0 - Production on Sat Jun 15 21:16:36 2024
Version 19.20.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to auxiliary database: TSTCDB1 (not mounted)

RMAN> Duplicate database to 'tstcdb1' noopen backup location '+data1';

Starting Duplicate Db at 15-JUN-24
searching for database ID
found backup of database ID 1017019486
found backup of database ID 2265125454
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/15/2024 21:16:57
RMAN-05501: aborting duplication of target database
RMAN-05657: There are multiple database IDs present.

RMAN> set dbid 1017019486

executing command: SET DBID

RMAN> Duplicate database to 'tstcdb1' noopen backup location '+data1';

-----基于PTTR-------------------------------------------------------

run {
set until time "to_date('15-JUN-2024 18:10:00','DD-MON-YYYY HH24:MI:SS')";
 Duplicate database to 'testcdb1' noopen backup location '+data1';
 }


 
RMAN>  Duplicate database to 'testcdb1' noopen backup location '/u01/app/oracle/fast_recovery_area/TESTCDB/backup/';
 
Starting Duplicate Db at 17-JUN-15
contents of Memory Script:
{
   sql clone "create spfile from memory";
}
executing Memory Script
sql statement: create spfile from memory
contents of Memory Script:
{
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script
 
Oracle instance shut down
 
connected to auxiliary database (not started)
Oracle instance started
 
Total System Global Area          242208768 bytes
Fixed Size                                 2849120 bytes
Variable Size                184551072 bytes
Database Buffers                      50331648 bytes
Redo Buffers                            4476928 bytes
 
contents of Memory Script:
{
   sql clone "alter system set  control_files =
  ''/u01/app/oracle/oradata/TESTCDB1/controlfile/o1_mf_bfsn3k7o_.ctl'' comment=
 ''Set by RMAN'' scope=spfile";
   sql clone "alter system set  db_name =
 ''TESTCDB'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name =
 ''TESTCDB1'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   restore clone primary controlfile from  '/u01/app/oracle/fast_recovery_area/TESTCDB/backup/o1_mf_s_882636099_br359n4j_.bkp';
   alter clone database mount;
}
executing Memory Script
 
sql statement: alter system set  control_files =   ''/u01/app/oracle/oradata/TESTCDB1/controlfile/o1_mf_bfsn3k7o_.ctl'' comment= ''Set by RMAN'' scope=spfile
 
sql statement: alter system set  db_name =  ''TESTCDB'' comment= ''Modified by RMAN duplicate'' scope=spfile
 
sql statement: alter system set  db_unique_name =  ''TESTCDB1'' comment= ''Modified by RMAN duplicate'' scope=spfile
 
Oracle instance shut down
Oracle instance started
Total System Global Area     242208768 bytes
 
Fixed Size                     2849120 bytes
Variable Size                184551072 bytes
Database Buffers              50331648 bytes
Redo Buffers                   4476928 bytes
 
Starting restore at 17-JUN-15
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=19 device type=DISK
 
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/TESTCDB1/controlfile/o1_mf_bfsn3k7o_.ctl
Finished restore at 17-JUN-15
 
database mounted
released channel: ORA_AUX_DISK_1
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=19 device type=DISK
 
contents of Memory Script:
{
   set until scn  1926434;
   set newname for clone datafile  1 to new;
   set newname for clone datafile  3 to new;
   set newname for clone datafile  4 to new;
   set newname for clone datafile  5 to new;
   set newname for clone datafile  6 to new;
   set newname for clone datafile  7 to new;
   set newname for clone datafile  15 to new;
   set newname for clone datafile  16 to new;
   restore
   clone database
   ;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 17-JUN-15
using channel ORA_AUX_DISK_1
 
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_system_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_sysaux_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_undotbs1_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_users_%u_.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/TESTCDB/backup/testpdb117q9nt34_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/TESTCDB/backup/testpdb117q9nt34_1_1 tag=TAG20150617T163756
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:05
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_system_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_sysaux_%u_.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/TESTCDB/backup/testpdb118q9nt5f_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/TESTCDB/backup/testpdb118q9nt5f_1_1 tag=TAG20150617T163756
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:45
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00015 to /u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_system_%u_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00016 to /u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_sysaux_%u_.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/TESTCDB/backup/testpdb119q9nt6i_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/TESTCDB/backup/testpdb119q9nt6i_1_1 tag=TAG20150617T163756
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 17-JUN-15
 
contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script
 
datafile 1 switched to datafile copy
input datafile copy RECID=9 STAMP=882637965 file name=/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_system_br36zdcj_.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=10 STAMP=882637965 file name=/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_sysaux_br36zdcn_.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=11 STAMP=882637965 file name=/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_undotbs1_br36zdcq_.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=12 STAMP=882637965 file name=/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_system_br371fvr_.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=13 STAMP=882637965 file name=/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_users_br36zdfb_.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=14 STAMP=882637966 file name=/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_sysaux_br371frz_.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=15 STAMP=882637966 file name=/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_system_br372tts_.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=16 STAMP=882637966 file name=/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_sysaux_br372ttf_.dbf
 
contents of Memory Script:
{
   set until scn  1926434;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script
 
executing command: SET until clause
 
Starting recover at 17-JUN-15
using channel ORA_AUX_DISK_1
 
starting media recovery
 
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=23
channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/TESTCDB/backup/testpdb11dq9nta2_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/TESTCDB/backup/testpdb11dq9nta2_1_1 tag=TAG20150617T164113
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/app/oracle/fast_recovery_area/TESTCDB1/archivelog/2015_06_17/o1_mf_1_23_br373zdg_.arc thread=1 sequence=23
channel clone_default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/TESTCDB1/archivelog/2015_06_17/o1_mf_1_23_br373zdg_.arc RECID=1 STAMP=882637967
media recovery complete, elapsed time: 00:00:02
Finished recover at 17-JUN-15
Oracle instance started
 
Total System Global Area     242208768 bytes
 
Fixed Size                     2849120 bytes
Variable Size                184551072 bytes
Database Buffers              50331648 bytes
Redo Buffers                   4476928 bytes
 
contents of Memory Script:
{
   sql clone "alter system set  db_name =
 ''TESTCDB1'' comment=
 ''Reset to original value by RMAN'' scope=spfile";
   sql clone "alter system reset  db_unique_name scope=spfile";
}
executing Memory Script
 
sql statement: alter system set  db_name =  ''TESTCDB1'' comment= ''Reset to original value by RMAN'' scope=spfile
 
sql statement: alter system reset  db_unique_name scope=spfile
Oracle instance started
 
Total System Global Area     242208768 bytes
 
Fixed Size                     2849120 bytes
Variable Size                184551072 bytes
Database Buffers              50331648 bytes
Redo Buffers                   4476928 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "TESTCDB1" RESETLOGS ARCHIVELOG
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES     1024
  MAXINSTANCES     8
  MAXLOGHISTORY      292
 LOGFILE
  GROUP   1  SIZE 50 M ,
  GROUP   2  SIZE 50 M ,
  GROUP   3  SIZE 50 M
 DATAFILE
  '/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_system_br36zdcj_.dbf',
  '/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_system_br371fvr_.dbf',
  '/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_system_br372tts_.dbf'
 CHARACTER SET WE8MSWIN1252
 
 
contents of Memory Script:
{
   set newname for clone tempfile  1 to new;
   set newname for clone tempfile  2 to new;
   set newname for clone tempfile  3 to new;
   switch clone tempfile all;
   catalog clone datafilecopy  "/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_sysaux_br36zdcn_.dbf",
 "/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_undotbs1_br36zdcq_.dbf",
 "/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_users_br36zdfb_.dbf",
 "/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_sysaux_br371frz_.dbf",
 "/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_sysaux_br372ttf_.dbf";
   switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
 
renamed tempfile 1 to /u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_temp_%u_.tmp in control file
renamed tempfile 2 to /u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_temp_%u_.tmp in control file
renamed tempfile 3 to /u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_temp_%u_.tmp in control file
 
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_sysaux_br36zdcn_.dbf RECID=1 STAMP=882637984
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_undotbs1_br36zdcq_.dbf RECID=2 STAMP=882637984
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_users_br36zdfb_.dbf RECID=3 STAMP=882637984
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_sysaux_br371frz_.dbf RECID=4 STAMP=882637984
cataloged datafile copy
datafile copy file name=/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_sysaux_br372ttf_.dbf RECID=5 STAMP=882637984
 
datafile 3 switched to datafile copy
input datafile copy RECID=1 STAMP=882637984 file name=/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_sysaux_br36zdcn_.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=2 STAMP=882637984 file name=/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_undotbs1_br36zdcq_.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=3 STAMP=882637984 file name=/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_users_br36zdfb_.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=4 STAMP=882637984 file name=/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_sysaux_br371frz_.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=5 STAMP=882637984 file name=/u01/app/oracle/oradata/TESTCDB1/datafile/o1_mf_sysaux_br372ttf_.dbf
Leaving database unopened, as requested
Cannot remove created server parameter file
Finished Duplicate Db at 17-JUN-15
 
RMAN> exit
 
Connect to auxiliary CDB instance and check PDB existence

 
[oracle@Server dbs]$ sqlplus "/ as sysdba"
 
SQL*Plus: Release 12.1.0.1.0 Production on Wed Jun 17 17:31:47 2015
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
 
SQL> alter database open resetlogs;
Database altered.
 
SQL> show pdbs
 
    CON_ID        CON_NAME                              OPEN MODE     RESTRICTED
----------          ------------------------------      ----------          ----------
         2             PDB$SEED                               READ ONLY       NO
         3             TESTPDB                                  MOUNTED
 
Check validity of PDB by opening it

SQL> alter pluggable database testpdb open;
Pluggable database altered.
 
SQL> show pdbs
 
    CON_ID        CON_NAME                              OPEN MODE     RESTRICTED
----------          ------------------------------      ----------          ----------
         2             PDB$SEED                               READ ONLY       NO
         3             TESTPDB                                  READ WRITE     NO
 
Close the PDB to unplug it

 
SQL> alter pluggable database testpdb close immediate;
Pluggable database altered.
 
SQL> show pdbs
 
    CON_ID        CON_NAME                              OPEN MODE     RESTRICTED
----------          ------------------------------      ----------          ----------
         2             PDB$SEED                               READ ONLY       NO
         3             TESTPDB                                  MOUNTED
 
Execute unplug command to detach PDB from auxiliary CDB

 
SQL>  alter pluggable database testpdb unplug into '/tmp/testpdb.xml';
Pluggable database altered.
 
Plug PDB into Target database

 
·     Check existing PDBs

 
SQL> show pdbs
 
    CON_ID        CON_NAME                              OPEN MODE     RESTRICTED
----------          ------------------------------      ----------          ----------
         2             PDB$SEED                               READ ONLY       NO
 
Execute create pluggable database using XML file created through unplug command. Use copy command to move pdb data files to new location

SQL>  create pluggable database testpdb using '/tmp/testpdb.xml'
COPY   2  ;
Pluggable database created.
 
SQL> show pdbs
 

    CON_ID        CON_NAME                              OPEN MODE     RESTRICTED
----------          ------------------------------      ----------          ----------
         2             PDB$SEED                               READ ONLY       NO
         3             TESTPDB                                  MOUNTED
 
Summary: If Pluggable database (PDB) is dropped mistakenly in Container Database (CDB), it has to be restored through Point in time recovery (PITR) method as we recover other database objects.

----------------------------ASM 恢复                  

[oracle@rac1 ~]$ orapwd file=orapwtestcdb1 password=A#qwert#12 entries=5
[oracle@rac1 ~]$ cd $ORACLE_HOME/dbs
[oracle@rac1 dbs]$ ls -ltr orapw
ls: cannot access orapw: No such file or directory


[oracle@rac1 ~]$ pwd
/home/oracle
[oracle@rac1 ~]$
-rw-r-----. 1 oracle oinstall     6144 Jun 15 13:53 orapwtestcdb1

--没有放到合适的位置，也没用这个文件

[oracle@rac1 ~]$ cd $ORACLE_HOME/dbs
[oracle@rac1 dbs]$ cat inittestcdb1.ora
*.compatible='19.0.0.0.0'
*.control_files='+data1/TESTCDB1/controlfile/o1_mf_bfsn3k7o_.ctl'----之前没这个目录
*.db_block_size=8192
*.db_create_file_dest='+data1'----不用详细
*.db_name='testcdb1'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=testcdb1XDB)'
*.enable_pluggable_database=true
*.open_cursors=300
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
[oracle@rac1 dbs]$ 

[oracle@rac1 dbs]$ export ORACLE_SID=testcdb1
[oracle@rac1 dbs]$ sqlplus sys/A#qwert#12 as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jun 15 13:55:32 2024
Version 19.20.0.0.0


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

Connected to an idle instance.

SQL>  startup nomount pfile=inittestcdb1.ora
ORACLE instance started.

Total System Global Area  390067064 bytes
Fixed Size                  9163640 bytes
Variable Size             339738624 bytes
Database Buffers           33554432 bytes
Redo Buffers                7610368 bytes
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0


[oracle@rac1 dbs]$ rman auxiliary sys/A#qwert#1254455        

------------password no use................

Recovery Manager: Release 19.0.0.0.0 - Production on Sat Jun 15 18:26:32 2024
Version 19.20.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to auxiliary database: TESTCDB1 (DBID=1016994380)

RMAN> 

[oracle@rac1 dbs]$ rman auxiliary sys/A#qwert#12

Recovery Manager: Release 19.0.0.0.0 - Production on Sat Jun 15 13:57:56 2024
Version 19.20.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to auxiliary database: TESTCDB1 (not mounted)

RMAN> Duplicate database to 'testcdb1' noopen backup location '+data1';

Starting Duplicate Db at 15-JUN-24
searching for database ID
found backup of database ID 2265125454

contents of Memory Script:
{
   sql clone "create spfile from memory";
}
executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:
{
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     390067064 bytes

Fixed Size                     9163640 bytes
Variable Size                339738624 bytes
Database Buffers              33554432 bytes
Redo Buffers                   7610368 bytes

contents of Memory Script:
{
   sql clone "alter system set  db_name = 
 ''CDB'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name = 
 ''testcdb1'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   restore clone primary controlfile from  '+DATA1/CDB/AUTOBACKUP/2024_06_15/s_1171720335.532.1171677135';
   alter clone database mount;
}
executing Memory Script

sql statement: alter system set  db_name =  ''CDB'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''testcdb1'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area     390067064 bytes

Fixed Size                     9163640 bytes
Variable Size                339738624 bytes
Database Buffers              33554432 bytes
Redo Buffers                   7610368 bytes

Starting restore at 15-JUN-24
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=23 device type=DISK

channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:05
output file name=+DATA1/TESTCDB1/controlfile/o1_mf_bfsn3k7o_.ctl
Finished restore at 15-JUN-24

database mounted
released channel: ORA_AUX_DISK_1
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=23 device type=DISK
duplicating Online logs to Oracle Managed File (OMF) location
duplicating Datafiles to Oracle Managed File (OMF) location

contents of Memory Script:
{
   set until scn  9566546;
   set newname for clone datafile  1 to new;
   set newname for clone datafile  3 to new;
   set newname for clone datafile  4 to new;
   set newname for clone datafile  5 to new;
   set newname for clone datafile  6 to new;
   set newname for clone datafile  7 to new;
   set newname for clone datafile  8 to new;
   set newname for clone datafile  9 to new;
   set newname for clone datafile  10 to new;
   restore
   clone database
   ;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 15-JUN-24
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to +data1
channel ORA_AUX_DISK_1: restoring datafile 00003 to +data1
channel ORA_AUX_DISK_1: restoring datafile 00004 to +data1
channel ORA_AUX_DISK_1: restoring datafile 00007 to +data1
channel ORA_AUX_DISK_1: restoring datafile 00009 to +data1
channel ORA_AUX_DISK_1: restoring datafile 00010 to +data1
channel ORA_AUX_DISK_1: reading from backup piece +DATA1/CDB/BACKUPSET/2024_06_15/nnndf0_tag20240615t134035_0.427.1171676435
channel ORA_AUX_DISK_1: piece handle=+DATA1/CDB/BACKUPSET/2024_06_15/nnndf0_tag20240615t134035_0.427.1171676435 tag=TAG20240615T134035
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to +data1
channel ORA_AUX_DISK_1: restoring datafile 00006 to +data1
channel ORA_AUX_DISK_1: restoring datafile 00008 to +data1
channel ORA_AUX_DISK_1: reading from backup piece +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_15/nnndf0_tag20240615t134035_0.404.1171676439
channel ORA_AUX_DISK_1: piece handle=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_15/nnndf0_tag20240615t134035_0.404.1171676439 tag=TAG20240615T134035
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 15-JUN-24

contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafile copy RECID=14 STAMP=1171720789 file name=+DATA1/TESTCDB1/DATAFILE/system.350.1171677579
datafile 3 switched to datafile copy
input datafile copy RECID=15 STAMP=1171720789 file name=+DATA1/TESTCDB1/DATAFILE/sysaux.506.1171677579
datafile 4 switched to datafile copy
input datafile copy RECID=16 STAMP=1171720789 file name=+DATA1/TESTCDB1/DATAFILE/undotbs1.387.1171677579
datafile 5 switched to datafile copy
input datafile copy RECID=17 STAMP=1171720789 file name=+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.440.1171677587
datafile 6 switched to datafile copy
input datafile copy RECID=18 STAMP=1171720789 file name=+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.468.1171677587
datafile 7 switched to datafile copy
input datafile copy RECID=19 STAMP=1171720789 file name=+DATA1/TESTCDB1/DATAFILE/users.402.1171677579
datafile 8 switched to datafile copy
input datafile copy RECID=20 STAMP=1171720789 file name=+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.480.1171677587
datafile 9 switched to datafile copy
input datafile copy RECID=21 STAMP=1171720789 file name=+DATA1/TESTCDB1/DATAFILE/undotbs2.431.1171677579
datafile 10 switched to datafile copy
input datafile copy RECID=22 STAMP=1171720789 file name=+DATA1/TESTCDB1/DATAFILE/undotbs3.401.1171677579

contents of Memory Script:
{
   set until scn  9566546;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 15-JUN-24
using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 45 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_45.540.1171676445
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_45.540.1171676445 thread=1 sequence=45
media recovery complete, elapsed time: 00:00:00
Finished recover at 15-JUN-24
Oracle instance started

Total System Global Area     390067064 bytes

Fixed Size                     9163640 bytes
Variable Size                339738624 bytes
Database Buffers              33554432 bytes
Redo Buffers                   7610368 bytes

contents of Memory Script:
{
   sql clone "alter system set  db_name = 
 ''TESTCDB1'' comment=
 ''Reset to original value by RMAN'' scope=spfile";
   sql clone "alter system reset  db_unique_name scope=spfile";
}
executing Memory Script

sql statement: alter system set  db_name =  ''TESTCDB1'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset  db_unique_name scope=spfile
Oracle instance started

Total System Global Area     390067064 bytes

Fixed Size                     9163640 bytes
Variable Size                339738624 bytes
Database Buffers              33554432 bytes
Redo Buffers                   7610368 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "TESTCDB1" RESETLOGS ARCHIVELOG 
  MAXLOGFILES    192
  MAXLOGMEMBERS      3
  MAXDATAFILES     1024
  MAXINSTANCES    32
  MAXLOGHISTORY      292
 LOGFILE
  GROUP     1  SIZE 50 M ,
  GROUP     2  SIZE 50 M ,
  GROUP     3  SIZE 50 M ,
  GROUP     4  SIZE 50 M ,
  GROUP     5  SIZE 50 M ,
  GROUP     6  SIZE 50 M 
 DATAFILE
  '+DATA1/TESTCDB1/DATAFILE/system.350.1171677579',
  '+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.440.1171677587'
 CHARACTER SET AL32UTF8

sql statement: ALTER DATABASE ADD LOGFILE 
  
  
  
  
  
  INSTANCE 'i2' 
  GROUP     7  SIZE 100 M ,
  GROUP     8  SIZE 100 M 
sql statement: ALTER DATABASE ADD LOGFILE 
  
  
  
  
  
  
  INSTANCE 'i3' 
  GROUP     9  SIZE 100 M ,
  GROUP    10  SIZE 100 M 

contents of Memory Script:
{
   catalog clone datafilecopy  "+DATA1/TESTCDB1/DATAFILE/sysaux.506.1171677579", 
 "+DATA1/TESTCDB1/DATAFILE/undotbs1.387.1171677579", 
 "+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.468.1171677587", 
 "+DATA1/TESTCDB1/DATAFILE/users.402.1171677579", 
 "+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.480.1171677587", 
 "+DATA1/TESTCDB1/DATAFILE/undotbs2.431.1171677579", 
 "+DATA1/TESTCDB1/DATAFILE/undotbs3.401.1171677579";
   switch clone datafile all;
}
executing Memory Script

cataloged datafile copy
datafile copy file name=+DATA1/TESTCDB1/DATAFILE/sysaux.506.1171677579 RECID=1 STAMP=1171720811
cataloged datafile copy
datafile copy file name=+DATA1/TESTCDB1/DATAFILE/undotbs1.387.1171677579 RECID=2 STAMP=1171720811
cataloged datafile copy
datafile copy file name=+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.468.1171677587 RECID=3 STAMP=1171720811
cataloged datafile copy
datafile copy file name=+DATA1/TESTCDB1/DATAFILE/users.402.1171677579 RECID=4 STAMP=1171720811
cataloged datafile copy
datafile copy file name=+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.480.1171677587 RECID=5 STAMP=1171720811
cataloged datafile copy
datafile copy file name=+DATA1/TESTCDB1/DATAFILE/undotbs2.431.1171677579 RECID=6 STAMP=1171720811
cataloged datafile copy
datafile copy file name=+DATA1/TESTCDB1/DATAFILE/undotbs3.401.1171677579 RECID=7 STAMP=1171720811

datafile 3 switched to datafile copy
input datafile copy RECID=1 STAMP=1171720811 file name=+DATA1/TESTCDB1/DATAFILE/sysaux.506.1171677579
datafile 4 switched to datafile copy
input datafile copy RECID=2 STAMP=1171720811 file name=+DATA1/TESTCDB1/DATAFILE/undotbs1.387.1171677579
datafile 6 switched to datafile copy
input datafile copy RECID=3 STAMP=1171720811 file name=+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.468.1171677587
datafile 7 switched to datafile copy
input datafile copy RECID=4 STAMP=1171720811 file name=+DATA1/TESTCDB1/DATAFILE/users.402.1171677579
datafile 8 switched to datafile copy
input datafile copy RECID=5 STAMP=1171720811 file name=+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.480.1171677587
datafile 9 switched to datafile copy
input datafile copy RECID=6 STAMP=1171720811 file name=+DATA1/TESTCDB1/DATAFILE/undotbs2.431.1171677579
datafile 10 switched to datafile copy
input datafile copy RECID=7 STAMP=1171720811 file name=+DATA1/TESTCDB1/DATAFILE/undotbs3.401.1171677579
Leaving database unopened, as requested
Cannot remove created server parameter file
Finished Duplicate Db at 15-JUN-24

RMAN> report schema;

RMAN-06139: warning: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name TESTCDB1

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    1180     SYSTEM               ***     +DATA1/TESTCDB1/DATAFILE/system.350.1171677579
3    1010     SYSAUX               ***     +DATA1/TESTCDB1/DATAFILE/sysaux.506.1171677579
4    615      UNDOTBS1             ***     +DATA1/TESTCDB1/DATAFILE/undotbs1.387.1171677579
5    510      PDB$SEED:SYSTEM      ***     +DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.440.1171677587
6    480      PDB$SEED:SYSAUX      ***     +DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.468.1171677587
7    5        USERS                ***     +DATA1/TESTCDB1/DATAFILE/users.402.1171677579
8    215      PDB$SEED:UNDOTBS1    ***     +DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.480.1171677587
9    250      UNDOTBS2             ***     +DATA1/TESTCDB1/DATAFILE/undotbs2.431.1171677579
10   25       UNDOTBS3             ***     +DATA1/TESTCDB1/DATAFILE/undotbs3.401.1171677579

RMAN> exit


Recovery Manager complete.
[oracle@rac1 dbs]$ sqlplus "/ as sysdba"

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jun 15 14:00:57 2024
Version 19.20.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MOUNTED
SQL> alter database open resetlogs;

Database altered.

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
[oracle@rac1 dbs]$ ps -ef|grep pmon
oracle    4714     1  0 14:00 ?        00:00:00 ora_pmon_testcdb1
oracle    6270 27940  0 14:02 pts/2    00:00:00 grep --color=auto pmon
oracle   17947     1  0 13:37 ?        00:00:00 ora_pmon_cdb1
grid     31754     1  0 13:30 ?        00:00:00 asm_pmon_+ASM1
[oracle@rac1 dbs]$ s

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jun 15 14:03:18 2024
Version 19.20.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0

SQL> shutdown abort
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
[oracle@rac1 dbs]$ ps -ef|grep pmon
oracle    8434 27940  0 14:03 pts/2    00:00:00 grep --color=auto pmon
oracle   17947     1  0 13:37 ?        00:00:00 ora_pmon_cdb1
grid     31754     1  0 13:30 ?        00:00:00 asm_pmon_+ASM1
 
[oracle@rac1 dbs]$  rman auxiliary sys/A#qwert#12
 

RMAN> startup nomount;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 06/15/2024 14:06:04
RMAN-06171: not connected to target database

RMAN> startup  nomount pfile=inittestcdb1.ora  force

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 06/15/2024 18:28:40
RMAN-06171: not connected to target database

RMAN> 

----------------------带PDB的恢复----------------------------


Recovery Manager complete.
[oracle@rac1 dbs]$ s

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jun 15 14:06:13 2024
Version 19.20.0.0.0

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

Connected to an idle instance.

SQL>  startup nomount pfile=inittestcdb1.ora
ORACLE instance started.

Total System Global Area  390067064 bytes
Fixed Size                  9163640 bytes
Variable Size             339738624 bytes
Database Buffers           33554432 bytes
Redo Buffers                7610368 bytes
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
[oracle@rac1 dbs]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Sat Jun 15 14:06:29 2024
Version 19.20.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: TESTCDB1 (not mounted)

RMAN>  Duplicate database to 'testcdb1' noopen backup location '+data1';

Starting Duplicate Db at 15-JUN-24
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/15/2024 14:06:35
RMAN-05501: aborting duplication of target database
RMAN-06174: not connected to auxiliary database

RMAN> exit
  

Recovery Manager complete.
[oracle@rac1 dbs]$ s

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jun 15 14:07:24 2024
Version 19.20.0.0.0

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

Connected to an idle instance.

SQL>  startup nomount pfile=inittestcdb1.ora
ORACLE instance started.

Total System Global Area  390067064 bytes
Fixed Size                  9163640 bytes
Variable Size             339738624 bytes
Database Buffers           33554432 bytes
Redo Buffers                7610368 bytes
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
[oracle@rac1 dbs]$  rman auxiliary sys/A#qwert#12

Recovery Manager: Release 19.0.0.0.0 - Production on Sat Jun 15 14:07:41 2024
Version 19.20.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to auxiliary database: TESTCDB1 (not mounted)

RMAN>  Duplicate database to 'testcdb1' noopen backup location '+data1';

Starting Duplicate Db at 15-JUN-24
searching for database ID
found backup of database ID 2265125454

contents of Memory Script:
{
   sql clone "create spfile from memory";
}
executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:
{
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     390067064 bytes

Fixed Size                     9163640 bytes
Variable Size                339738624 bytes
Database Buffers              33554432 bytes
Redo Buffers                   7610368 bytes

contents of Memory Script:
{
   sql clone "alter system set  db_name = 
 ''CDB'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name = 
 ''testcdb1'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   restore clone primary controlfile from  '+DATA1/CDB/AUTOBACKUP/2024_06_15/s_1171721115.429.1171677915';
   alter clone database mount;
}
executing Memory Script

sql statement: alter system set  db_name =  ''CDB'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''testcdb1'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area     390067064 bytes

Fixed Size                     9163640 bytes
Variable Size                339738624 bytes
Database Buffers              33554432 bytes
Redo Buffers                   7610368 bytes

Starting restore at 15-JUN-24
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=23 device type=DISK

channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:05
output file name=+DATA1/TESTCDB1/controlfile/o1_mf_bfsn3k7o_.ctl
Finished restore at 15-JUN-24

database mounted
released channel: ORA_AUX_DISK_1
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=23 device type=DISK
duplicating Online logs to Oracle Managed File (OMF) location
duplicating Datafiles to Oracle Managed File (OMF) location
datafile 60 not processed because file is offline
datafile 61 not processed because file is offline

contents of Memory Script:
{
   set until scn  9569022;
   set newname for clone datafile  1 to new;
   set newname for clone datafile  3 to new;
   set newname for clone datafile  4 to new;
   set newname for clone datafile  5 to new;
   set newname for clone datafile  6 to new;
   set newname for clone datafile  7 to new;
   set newname for clone datafile  8 to new;
   set newname for clone datafile  9 to new;
   set newname for clone datafile  10 to new;
   set newname for clone datafile  59 to new;
   restore
   clone database
   skip forever tablespace  "TESTPDB":"UNDOTBS1",
 "TESTPDB":"SYSAUX"   ;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 15-JUN-24
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to +data1
channel ORA_AUX_DISK_1: restoring datafile 00003 to +data1
channel ORA_AUX_DISK_1: restoring datafile 00004 to +data1
channel ORA_AUX_DISK_1: restoring datafile 00007 to +data1
channel ORA_AUX_DISK_1: restoring datafile 00009 to +data1
channel ORA_AUX_DISK_1: restoring datafile 00010 to +data1
channel ORA_AUX_DISK_1: reading from backup piece +DATA1/CDB/BACKUPSET/2024_06_15/nnndf0_tag20240615t140505_0.424.1171677905
channel ORA_AUX_DISK_1: piece handle=+DATA1/CDB/BACKUPSET/2024_06_15/nnndf0_tag20240615t140505_0.424.1171677905 tag=TAG20240615T140505
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to +data1
channel ORA_AUX_DISK_1: restoring datafile 00006 to +data1
channel ORA_AUX_DISK_1: restoring datafile 00008 to +data1
channel ORA_AUX_DISK_1: reading from backup piece +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_15/nnndf0_tag20240615t140505_0.492.1171677909
channel ORA_AUX_DISK_1: piece handle=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_15/nnndf0_tag20240615t140505_0.492.1171677909 tag=TAG20240615T140505
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00059 to +data1
channel ORA_AUX_DISK_1: reading from backup piece +DATA1/CDB/1AE8818E8B712414E0636401A8C00D9E/BACKUPSET/2024_06_15/nnndf0_tag20240615t140505_0.753.1171677911
channel ORA_AUX_DISK_1: piece handle=+DATA1/CDB/1AE8818E8B712414E0636401A8C00D9E/BACKUPSET/2024_06_15/nnndf0_tag20240615t140505_0.753.1171677911 tag=TAG20240615T140505
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 15-JUN-24

contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafile copy RECID=15 STAMP=1171721336 file name=+DATA1/TESTCDB1/DATAFILE/system.437.1171678125
datafile 3 switched to datafile copy
input datafile copy RECID=16 STAMP=1171721336 file name=+DATA1/TESTCDB1/DATAFILE/sysaux.539.1171678125
datafile 4 switched to datafile copy
input datafile copy RECID=17 STAMP=1171721336 file name=+DATA1/TESTCDB1/DATAFILE/undotbs1.367.1171678125
datafile 5 switched to datafile copy
input datafile copy RECID=18 STAMP=1171721336 file name=+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.446.1171678133
datafile 6 switched to datafile copy
input datafile copy RECID=19 STAMP=1171721336 file name=+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.449.1171678133
datafile 7 switched to datafile copy
input datafile copy RECID=20 STAMP=1171721336 file name=+DATA1/TESTCDB1/DATAFILE/users.391.1171678125
datafile 8 switched to datafile copy
input datafile copy RECID=21 STAMP=1171721336 file name=+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.456.1171678133
datafile 9 switched to datafile copy
input datafile copy RECID=22 STAMP=1171721336 file name=+DATA1/TESTCDB1/DATAFILE/undotbs2.439.1171678125
datafile 10 switched to datafile copy
input datafile copy RECID=23 STAMP=1171721336 file name=+DATA1/TESTCDB1/DATAFILE/undotbs3.497.1171678125
datafile 59 switched to datafile copy
input datafile copy RECID=24 STAMP=1171721336 file name=+DATA1/TESTCDB1/1AE8818E8B712414E0636401A8C00D9E/DATAFILE/system.457.1171678135

contents of Memory Script:
{
   set until scn  9569022;
   recover
   clone database
   skip forever tablespace  "TESTPDB":"UNDOTBS1",
 "TESTPDB":"SYSAUX"    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 15-JUN-24
using channel ORA_AUX_DISK_1

Executing: alter database datafile 60, 61 offline drop
starting media recovery

archived log for thread 1 with sequence 47 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_47.275.1171677915
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_15/thread_1_seq_47.275.1171677915 thread=1 sequence=47
media recovery complete, elapsed time: 00:00:00
Finished recover at 15-JUN-24
Oracle instance started

Total System Global Area     390067064 bytes

Fixed Size                     9163640 bytes
Variable Size                339738624 bytes
Database Buffers              33554432 bytes
Redo Buffers                   7610368 bytes

contents of Memory Script:
{
   sql clone "alter system set  db_name = 
 ''TESTCDB1'' comment=
 ''Reset to original value by RMAN'' scope=spfile";
   sql clone "alter system reset  db_unique_name scope=spfile";
}
executing Memory Script

sql statement: alter system set  db_name =  ''TESTCDB1'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset  db_unique_name scope=spfile
Oracle instance started

Total System Global Area     390067064 bytes

Fixed Size                     9163640 bytes
Variable Size                339738624 bytes
Database Buffers              33554432 bytes
Redo Buffers                   7610368 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "TESTCDB1" RESETLOGS ARCHIVELOG 
  MAXLOGFILES    192
  MAXLOGMEMBERS      3
  MAXDATAFILES     1024
  MAXINSTANCES    32
  MAXLOGHISTORY      292
 LOGFILE
  GROUP     1  SIZE 50 M ,
  GROUP     2  SIZE 50 M ,
  GROUP     3  SIZE 50 M ,
  GROUP     4  SIZE 50 M ,
  GROUP     5  SIZE 50 M ,
  GROUP     6  SIZE 50 M 
 DATAFILE
  '+DATA1/TESTCDB1/DATAFILE/system.437.1171678125',
  '+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.446.1171678133',
  '+DATA1/TESTCDB1/1AE8818E8B712414E0636401A8C00D9E/DATAFILE/system.457.1171678135'
 CHARACTER SET AL32UTF8

sql statement: ALTER DATABASE ADD LOGFILE 
  
  
  
  
  
  INSTANCE 'i2' 
  GROUP     7  SIZE 100 M ,
  GROUP     8  SIZE 100 M 
sql statement: ALTER DATABASE ADD LOGFILE 
  
  
  
  
  
  
  INSTANCE 'i3' 
  GROUP     9  SIZE 100 M ,
  GROUP    10  SIZE 100 M 

contents of Memory Script:
{
   catalog clone datafilecopy  "+DATA1/TESTCDB1/DATAFILE/sysaux.539.1171678125", 
 "+DATA1/TESTCDB1/DATAFILE/undotbs1.367.1171678125", 
 "+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.449.1171678133", 
 "+DATA1/TESTCDB1/DATAFILE/users.391.1171678125", 
 "+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.456.1171678133", 
 "+DATA1/TESTCDB1/DATAFILE/undotbs2.439.1171678125", 
 "+DATA1/TESTCDB1/DATAFILE/undotbs3.497.1171678125";
   switch clone datafile all;
}
executing Memory Script

cataloged datafile copy
datafile copy file name=+DATA1/TESTCDB1/DATAFILE/sysaux.539.1171678125 RECID=1 STAMP=1171721357
cataloged datafile copy
datafile copy file name=+DATA1/TESTCDB1/DATAFILE/undotbs1.367.1171678125 RECID=2 STAMP=1171721357
cataloged datafile copy
datafile copy file name=+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.449.1171678133 RECID=3 STAMP=1171721357
cataloged datafile copy
datafile copy file name=+DATA1/TESTCDB1/DATAFILE/users.391.1171678125 RECID=4 STAMP=1171721357
cataloged datafile copy
datafile copy file name=+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.456.1171678133 RECID=5 STAMP=1171721357
cataloged datafile copy
datafile copy file name=+DATA1/TESTCDB1/DATAFILE/undotbs2.439.1171678125 RECID=6 STAMP=1171721357
cataloged datafile copy
datafile copy file name=+DATA1/TESTCDB1/DATAFILE/undotbs3.497.1171678125 RECID=7 STAMP=1171721357

datafile 3 switched to datafile copy
input datafile copy RECID=1 STAMP=1171721357 file name=+DATA1/TESTCDB1/DATAFILE/sysaux.539.1171678125
datafile 4 switched to datafile copy
input datafile copy RECID=2 STAMP=1171721357 file name=+DATA1/TESTCDB1/DATAFILE/undotbs1.367.1171678125
datafile 6 switched to datafile copy
input datafile copy RECID=3 STAMP=1171721357 file name=+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.449.1171678133
datafile 7 switched to datafile copy
input datafile copy RECID=4 STAMP=1171721357 file name=+DATA1/TESTCDB1/DATAFILE/users.391.1171678125
datafile 8 switched to datafile copy
input datafile copy RECID=5 STAMP=1171721357 file name=+DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.456.1171678133
datafile 9 switched to datafile copy
input datafile copy RECID=6 STAMP=1171721357 file name=+DATA1/TESTCDB1/DATAFILE/undotbs2.439.1171678125
datafile 10 switched to datafile copy
input datafile copy RECID=7 STAMP=1171721357 file name=+DATA1/TESTCDB1/DATAFILE/undotbs3.497.1171678125
Leaving database unopened, as requested
Cannot remove created server parameter file
Finished Duplicate Db at 15-JUN-24

RMAN> report schema;

RMAN-06139: warning: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name TESTCDB1

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    1180     SYSTEM               ***     +DATA1/TESTCDB1/DATAFILE/system.437.1171678125
3    1010     SYSAUX               ***     +DATA1/TESTCDB1/DATAFILE/sysaux.539.1171678125
4    615      UNDOTBS1             ***     +DATA1/TESTCDB1/DATAFILE/undotbs1.367.1171678125
5    510      PDB$SEED:SYSTEM      ***     +DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.446.1171678133
6    480      PDB$SEED:SYSAUX      ***     +DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.449.1171678133
7    5        USERS                ***     +DATA1/TESTCDB1/DATAFILE/users.391.1171678125
8    215      PDB$SEED:UNDOTBS1    ***     +DATA1/TESTCDB1/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.456.1171678133
9    250      UNDOTBS2             ***     +DATA1/TESTCDB1/DATAFILE/undotbs2.439.1171678125
10   25       UNDOTBS3             ***     +DATA1/TESTCDB1/DATAFILE/undotbs3.497.1171678125
59   510      _###_UNKNOWN_PDB_#_3:SYSTEM ***     +DATA1/TESTCDB1/1AE8818E8B712414E0636401A8C00D9E/DATAFILE/system.457.1171678135

RMAN> exit


Recovery Manager complete.
[oracle@rac1 dbs]$ s

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jun 15 14:09:43 2024
Version 19.20.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       MOUNTED
         3 _###_UNKNOWN_PDB_#_3           MOUNTED

----没有resetlogs前名字不对
SQL> alter database open resetlogs;

Database altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 TESTPDB                        MOUNTED
SQL> alter pluggable database testpdb open;
alter pluggable database testpdb open
*
ERROR at line 1:
ORA-65104: operation not allowed on an inactive pluggable database


SQL>  alter pluggable database testpdb unplug into '/tmp/testpdb.xml';
 alter pluggable database testpdb unplug into '/tmp/testpdb.xml'
*
ERROR at line 1:
ORA-65104: operation not allowed on an inactive pluggable database


SQL> 

相关文章：

19C之前恢复drop 掉的PDB 创建另一个实例

--------恢复PDB------------------ create pluggable database testpdb admin user test identified by test; backup database plus archivelog tag full db backup; RMAN> backup database plus archivelog tag full db backup; ORA-15012: ASM file DATA1/CDB/ARC…...

编程日记 2024/6/16 5:41:17

实用软件下载:BetterZip 5最新安装包及详细安装教程

BetterZip是一款功能强大的Mac解/压缩软件，可以满足用户对文件压缩、解压、加密和保护等方面的需求。以下是关于BetterZip软件的主要功能、特点和使用方法的详细介绍，以及对其用户友好度、稳定性和安全性的评价。 安 装 包 获 取 地 址: BetterZip 5-安…...

编程日记 2024/6/16 5:40:15

实拆一个风扇

fr:徐海涛(hunkxu)...

编程日记 2024/6/16 5:38:13

Android 蓝牙配对Settings应用里面的简要流程记录

Android 蓝牙配对Settings应用里面的简要流程记录 文章目录 Android 蓝牙配对Settings应用里面的简要流程记录一、前言二、Settings蓝牙配对的关键代码1、接收蓝牙请求的地方 AndroidManifest.xml2、BluetoothPairingRequest3、BluetoothPairingService4、BluetoothPairingDial…...

编程日记 2024/6/16 5:37:11

shell编程基础（第18篇：更多的文件操作命令介绍）

前言 对于文件来说，除了它的文件内容之外，就是对其文件本身的操作，比如我们想要重命名文件、移动文件、复制文件、已经获取文件所在目录，文件名等操作，今天一起学习更多的文件操作相关的命令 basename 用于获取文件名…...

编程日记 2024/6/16 5:36:10

java如何提取字符串的每一个字符

java如何提取字符串每一个字符并转换为一个字符数组 这里需要用到toCharArray()语句 语法格式是 str.toCharArray(); 其中 str是字符串 示例代码如下 public class StringToArray {public static void main(String[] args) {String str"这是一个字符串";char[…...

编程日记 2024/6/16 5:34:08

LVS负载均衡：理解IPVS和IPVSADM的内部工作原理

LVS 负载均衡工作模式 LVS（Linux Virtual Server） 共有三种工作模式：DR、Tunnel、NAT。 DR（Direct Routing）： 技术原理：DR模式下，LVS调度器接收到请求后，直接通过MAC地址…...

编程日记 2024/6/16 5:33:01

c语言回顾-结构体

前言 在前面的学习中，我们知道C语言提供了许多内置类型，如：char、short、int、long、float、double等，但是只有这些内置类型还是不够的。当我们想描述学生，描述一本书，这时单一的内置类型是不行的。描述一个…...

编程日记 2024/6/16 5:32:00

stable diffusion最全插件大全，新手必备指南

Stable diffusion30个必备插件推荐，给我点个赞吧，兄弟们 1，ComfyUI，SD扩展里面直接搜索就行， ComfyUI 是一个基于节点操作的UI界面，玩过建模的更容易学 安装后大概是这样的 评价：comfyui,更适…...

编程日记 2024/6/16 5:28:55

大模型开发LangChain简介

LangChain 是一个用于构建大型语言模型 (LLM) 驱动应用程序的开发框架。它提供了强大的工具和功能，帮助开发者更高效地使用语言模型来构建复杂的应用程序。 LangChain 的主要功能和特点 1、模块化设计： LangChain 采用模块化设计，分为多个…...

编程日记 2024/6/16 5:27:53

Camtasia Studio 2024软件最新版下载【安装详细图文教程】

​Camtasia是美国TechSmith公司出品的一款集电脑屏幕录制、视频剪辑为一体的软件套装。同时包含Camtasia 录制器、Camtasia Studio（编辑器）、Camtasia 菜单制作器、Camtasia 剧场、Camtasia 播放器和Screencast的内置功能。 安 装 包 获 取 地 址&#x…...

编程日记 2024/6/16 5:26:52

抖音视频素材在哪找无版权？免版权可以剪辑视频素材网站分享

在抖音视频制作中，素材的选择至关重要。今天，我就为大家推荐几个宝藏网站，帮你找到既好用又无版权纠纷的视频素材。无论你是新手还是老手，这些网站都能满足你的需求。 蛙学府 首先推荐的是蛙学府。这个网站提供丰富的视频素材&am…...

编程日记 2024/6/16 5:25:51

Dubbo-使用zookeeper作为注册中心时节点的概述

本文内容很容易理解，会阐述当dubbo使用zookeeper作为注册中心时候，zookeeper节点是什么样子的 本文的代码使用的dubbo版本是2.7.x，几年前的版本了，但是不影响探究 首先我们创建一个简单的maven项目，然后写出一段dubb…...

编程日记 2024/6/16 5:24:49

秋招突击——第四弹——Java的SSN框架快速入门——Maven

文章目录 引言Maven分模块开发与设计分模块开发的过程 依赖管理可选依赖与排除依赖 继承与聚合聚合继承 属性和版本管理属性扩大集中管理的范围版本管理 多环境开发多环境开发 私服简介安装私服资源操作流程分析上传和下载 总结 引言 前一个部分花了太多时间，后续得…...

编程日记 2024/6/16 5:22:47

【Python】数据处理：CSV文件操作

CSV 文件（Comma-Separated Values，逗号分隔值文件）是一种常见的文本文件格式，用于存储表格数据。它的特点是用逗号或其他特定字符（如分号、制表符等）来分隔不同的字段，每行代表表格中的一条记录…...

编程日记 2024/6/16 5:21:46

SpringBoot集成Elasticsearch实例

SpringBoot项目集成Elasticsearch实例 导包 <dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-data-elasticsearch</artifactId> </dependency>配置es连接 spring:data:elasticsearch:cluster…...

编程日记 2024/6/16 5:18:43

2024.ZCPC.M题 计算三角形个数

题目描述&#xff1a; 小蔡有一张三角形的格子纸&#xff0c;上面有一个大三角形。这个边长为 的大三角形&#xff0c; 被分成 个边长为 1 的小三角形(如图一所示)。现在&#xff0c;小蔡选择了一条水平边 删除&#xff08;如图二所示&#xff09;&#xff0c;请你找出图上剩余…...

编程日记 2024/6/16 5:16:39

Java常见设计模式入门与实践

设计模式是软件开发中被反复应用的、为解决特定问题而总结出的最佳实践。它们提供了开发可重用、灵活和高效软件系统的方法。在Java中&#xff0c;设计模式可以帮助开发者编写更高质量的代码。以下是Java中一些常用设计模式的入门介绍及其实践示例。 1. 单例模式 (Singleton P…...

编程日记 2024/6/16 5:15:39

110.平衡二叉树

给定一个二叉树&#xff0c;判断它是否是 平衡二叉树 题解&#xff1a;平衡二叉树 是指该树所有节点的左右子树的深度相差不超过 1。可以采用递归遍历每一个节点&#xff0c;得到其高度&#xff0c;在判断高度时不可避免的要用到其左右子树的高度&#xff0c;所以可以顺便判断出…...

编程日记 2024/6/16 5:14:37

字符串数组——传递文本的不同方法实例

一、实例化一个文本并在文本上直接显示接收的信息 1、制作一个预制体 (1) UI-Text (TMP)&#xff0c;TitleText (2) 给Text (TMP)添加Recipients.cs组件 using System.Collections; using System.Collections.Generic; using TMPro; using UnityEngine;public class Recipi…...

编程日记 2024/6/16 5:13:36

Cilium动手实验室: 精通之旅---20.Isovalent Enterprise for Cilium: Zero Trust Visibility

Cilium动手实验室: 精通之旅---20.Isovalent Enterprise for Cilium: Zero Trust Visibility 1. 实验室环境1.1 实验室环境1.2 小测试 2. The Endor System2.1 部署应用2.2 检查现有策略 3. Cilium 策略实体3.1 创建 allow-all 网络策略3.2 在 Hubble CLI 中验证网络策略源3.3 …...

编程新知 2025/7/9 22:23:37

C#学习第29天：表达式树（Expression Trees）

目录 什么是表达式树&#xff1f; 核心概念 1.表达式树的构建 2. 表达式树与Lambda表达式 3.解析和访问表达式树 4.动态条件查询 表达式树的优势 1.动态构建查询 2.LINQ 提供程序支持&#xff1a; 3.性能优化 4.元数据处理 5.代码转换和重写 适用场景 代码复杂性…...

编程新知 2025/7/9 13:55:24

【JVM】Java虚拟机（二）——垃圾回收

目录 一、如何判断对象可以回收 &#xff08;一&#xff09;引用计数法 &#xff08;二&#xff09;可达性分析算法 二、垃圾回收算法 &#xff08;一&#xff09;标记清除 &#xff08;二&#xff09;标记整理 &#xff08;三&#xff09;复制 &#xff08;四&#xff…...

编程新知 2025/7/11 19:32:40

【网络安全】开源系统getshell漏洞挖掘

审计过程&#xff1a; 在入口文件admin/index.php中&#xff1a; 用户可以通过m,c,a等参数控制加载的文件和方法&#xff0c;在app/system/entrance.php中存在重点代码&#xff1a; 当M_TYPE system并且M_MODULE include时&#xff0c;会设置常量PATH_OWN_FILE为PATH_APP.M_T…...

编程新知 2025/7/6 20:49:39

R 语言科研绘图第 55 期 --- 网络图-聚类

在发表科研论文的过程中&#xff0c;科研绘图是必不可少的&#xff0c;一张好看的图形会是文章很大的加分项。 为了便于使用&#xff0c;本系列文章介绍的所有绘图都已收录到了 sciRplot 项目中&#xff0c;获取方式&#xff1a; R 语言科研绘图模板 --- sciRplothttps://mp.…...

编程新知 2025/7/12 14:00:29

【把数组变成一棵树】有序数组秒变平衡BST，原来可以这么优雅！

【把数组变成一棵树】有序数组秒变平衡BST，原来可以这么优雅！ 🌱 前言：一棵树的浪漫，从数组开始说起 程序员的世界里，数组是最常见的基本结构之一，几乎每种语言、每种算法都少不了它。可你有没有想过，一组看似“线性排列”的有序数组，竟然可以**“长”成一棵平衡的二…...

编程新知 2025/7/6 18:31:36

负载均衡器》》LVS、Nginx、HAproxy 区别

虚拟主机 先4&#xff0c;后7...

编程新知 2025/7/7 20:47:35

算法250609 高精度

加法 #include<stdio.h> #include<iostream> #include<string.h> #include<math.h> #include<algorithm> using namespace std; char input1[205]; char input2[205]; int main(){while(scanf("%s%s",input1,input2)!EOF){int a[205]…...

编程新知 2025/7/10 20:37:34

初级程序员入门指南

初级程序员入门指南 在数字化浪潮中&#xff0c;编程已然成为极具价值的技能。对于渴望踏入程序员行列的新手而言&#xff0c;明晰入门路径与必备知识是开启征程的关键。本文将为初级程序员提供全面的入门指引。 一、明确学习方向 &#xff08;一&#xff09;编程语言抉择 编…...

编程新知 2025/7/8 19:51:32

JS设计模式(5): 发布订阅模式

解锁JavaScript发布订阅模式&#xff1a;让代码沟通更优雅 在JavaScript的世界里&#xff0c;我们常常会遇到这样的场景&#xff1a;多个模块之间需要相互通信&#xff0c;但是又不想让它们产生过于紧密的耦合。这时候&#xff0c;发布订阅模式就像一位优雅的信使&#xff0c;…...

编程新知 2025/7/6 14:45:17