自己修改的脚本如下:
在rman命令中可以执行:
nbu还是用这个语句,backup pluggable database 'rznbu1','PDB$SEED';
为啥执行报错了:
结果执行报错了,报错RMAN-06813: could not translate pluggable database PDB
报错日志:
<< EOF
SHOW ALL;
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=nbu32,NB_ORA_CLIENT=rzbbdb2,NB_ORA_POLICY=oracle_pdb_full';
BACKUP
INCREMENTAL LEVEL=0
SKIP INACCESSIBLE
TAG rzbbdb_pdb_full_inc_lvl0
FILESPERSET 5
# recommended format, must end with %t
FORMAT 'rzbbdb_pdb_full_%s_%p_%t'
PLUGGABLE DATABASE
'rznbu1','PDB';
sql 'alter system archive log current';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
# backup the CDB root database
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=nbu32,NB_ORA_CLIENT=rzbbdb2,NB_ORA_POLICY=oracle_pdb_full';
BACKUP
INCREMENTAL LEVEL=0
SKIP INACCESSIBLE
TAG rzbbdb_pdb_full_inc_lvl0
FILESPERSET 5
# recommended format, must end with %t
FORMAT 'rzbbdb_pdb_full_%s_%p_%t'
Database root;
sql 'alter system archive log current';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
# backup all archive logs
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=nbu32,NB_ORA_CLIENT=rzbbdb2,NB_ORA_POLICY=oracle_pdb_full';
BACKUP
filesperset 20
# recommended format, must end with %t
FORMAT 'rzbbdb_pdb_arch_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
#
# Note: During the process of backing up the database, RMAN also backs up the
# control file. That backup of the control file does not contain the
# information about the archive log backup if nocatalog has been specified.
# To include the information about the current backup, the control file should
# be backed up as the last step. This step may not be necessary if using
# a recovery catalog or AUTOBACKUP CONTROLFILE.
#
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=nbu32,NB_ORA_CLIENT=rzbbdb2,NB_ORA_POLICY=oracle_pdb_full';
BACKUP
# recommended format, must end with %t
FORMAT 'rzbbdb_pdb_cntrl_%s_%p_%t'
CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}
EOF
----- STARTING CMDS EXECUTION -----
----- SUBSHELL ENV VARIABLES -----
ORACLE_BASE=/opt/oracle/app/oracle
ORACLE_HOME=/opt/oracle/app/oracle/product/19c/dbhome_1
ORACLE_SID=rzbbdb2
ORACLE_UNQNAME=rzbbdb
----- STARTING RMAN EXECUTION -----
Recovery Manager: Release 19.0.0.0.0 - Production on Mon May 20 22:16:12 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: RZBBDB (DBID=1782323201)
using target database control file instead of recovery catalog
RMAN>
RMAN configuration parameters for database with db_unique_name RZBBDB are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/RZBBDB/snapcf_rzbbdb2.f';
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40>
41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58>
allocated channel: ch00
channel ch00: SID=1567 instance=rzbbdb2 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 8.1.1 (2018020320)
allocated channel: ch01
channel ch01: SID=1577 instance=rzbbdb2 device type=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 8.1.1 (2018020320)
sent command to channel: ch00
sent command to channel: ch01
Starting backup at 2024-05-20 22:16:15
released channel: ch00
released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 05/20/2024 22:16:15
RMAN-06813: could not translate pluggable database PDB
