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

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

news 2025/12/16 2:45:11

--------恢复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

内存分配函数malloc kmalloc vmalloc

内存分配函数malloc kmalloc vmalloc malloc实现步骤： 1）请求大小调整：首先，malloc 需要调整用户请求的大小，以适应内部数据结构（例如，可能需要存储额外的元数据）。通常，这包括对齐调整，确保分配的内存地址满足特定硬件要求（如对齐到8字节或16字节边界）。 2）空闲…...

编程新知 2025/11/1 5:21:39

盘古信息PCB行业解决方案：以全域场景重构，激活智造新未来

一、破局&#xff1a;PCB行业的时代之问 在数字经济蓬勃发展的浪潮中&#xff0c;PCB&#xff08;印制电路板&#xff09;作为 “电子产品之母”&#xff0c;其重要性愈发凸显。随着 5G、人工智能等新兴技术的加速渗透&#xff0c;PCB行业面临着前所未有的挑战与机遇。产品迭代…...

编程新知 2025/12/10 19:13:55

练习（含atoi的模拟实现,自定义类型等练习）

一、结构体大小的计算及位段 &#xff08;结构体大小计算及位段 详解请看&#xff1a;自定义类型&#xff1a;结构体进阶-CSDN博客&#xff09; 1.在32位系统环境&#xff0c;编译选项为4字节对齐&#xff0c;那么sizeof(A)和sizeof(B)是多少&#xff1f; #pragma pack(4)st…...

编程新知 2025/12/15 11:25:14

使用van-uploader 的UI组件，结合vue2如何实现图片上传组件的封装

以下是基于 vant-ui&#xff08;适配 Vue2 版本 &#xff09;实现截图中照片上传预览、删除功能&#xff0c;并封装成可复用组件的完整代码&#xff0c;包含样式和逻辑实现&#xff0c;可直接在 Vue2 项目中使用&#xff1a; 1. 封装的图片上传组件 ImageUploader.vue <te…...

编程新知 2025/10/1 2:59:48

数据库分批入库

今天在工作中&#xff0c;遇到一个问题&#xff0c;就是分批查询的时候&#xff0c;由于批次过大导致出现了一些问题&#xff0c;一下是问题描述和解决方案&#xff1a; 示例&#xff1a; // 假设已有数据列表 dataList 和 PreparedStatement pstmt int batchSize 1000; // …...

编程新知 2025/7/18 1:50:27

Android 之 kotlin 语言学习笔记三（Kotlin-Java 互操作）

参考官方文档&#xff1a;https://developer.android.google.cn/kotlin/interop?hlzh-cn 一、Java&#xff08;供 Kotlin 使用&#xff09; 1、不得使用硬关键字 不要使用 Kotlin 的任何硬关键字作为方法的名称 或字段。允许使用 Kotlin 的软关键字、修饰符关键字和特殊标识…...

编程新知 2025/12/10 4:05:13

python执行测试用例，allure报乱码且未成功生成报告

allure执行测试用例时显示乱码&#xff1a;‘allure’ &#xfffd;&#xfffd;&#xfffd;&#xfffd;&#xfffd;ڲ&#xfffd;&#xfffd;&#xfffd;&#xfffd;ⲿ&#xfffd;&#xfffd;&#xfffd;Ҳ&#xfffd;&#xfffd;&#xfffd;ǿ&#xfffd;&am…...

编程新知 2025/12/9 4:11:09

MySQL账号权限管理指南：安全创建账户与精细授权技巧

在MySQL数据库管理中&#xff0c;合理创建用户账号并分配精确权限是保障数据安全的核心环节。直接使用root账号进行所有操作不仅危险且难以审计操作行为。今天我们来全面解析MySQL账号创建与权限分配的专业方法。 一、为何需要创建独立账号&#xff1f; 最小权限原则&#xf…...

编程新知 2025/9/5 23:36:27

Aspose.PDF 限制绕过方案：Java 字节码技术实战分享（仅供学习）

Aspose.PDF 限制绕过方案&#xff1a;Java 字节码技术实战分享&#xff08;仅供学习&#xff09; 一、Aspose.PDF 简介二、说明&#xff08;⚠️仅供学习与研究使用&#xff09;三、技术流程总览四、准备工作1. 下载 Jar 包2. Maven 项目依赖配置 五、字节码修改实现代码&#…...

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

NXP S32K146 T-Box 携手 SD NAND（贴片式TF卡）：驱动汽车智能革新的黄金组合

在汽车智能化的汹涌浪潮中&#xff0c;车辆不再仅仅是传统的交通工具&#xff0c;而是逐步演变为高度智能的移动终端。这一转变的核心支撑&#xff0c;来自于车内关键技术的深度融合与协同创新。车载远程信息处理盒&#xff08;T-Box&#xff09;方案&#xff1a;NXP S32K146 与…...

编程新知 2025/12/15 13:11:03