cdb级flashback 将pdb restore 回来后还可以做pdb flashback? 最后一步未完成
SQL> select *from abcd;
D
–
X
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 nfs]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 11:36:54 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454)
RMAN> backup as compressed backupset database tag ‘fulldbbackup0617’ plus archivelog tag ‘fulldbbackup0617’;
Starting backup at 2024/06/16 11:37:26
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=65 instance=cdb3 device type=DISK
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=3 sequence=1 RECID=321 STAMP=1171798647
channel ORA_DISK_1: starting piece 1 at 2024/06/16 11:37:27
channel ORA_DISK_1: finished piece 1 at 2024/06/16 11:37:28
piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup0617_0.384.1171798647 tag=FULLDBBACKUP0617 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2024/06/16 11:37:28
Starting backup at 2024/06/16 11:37:28
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/CDB/DATAFILE/system.258.1171797291
input datafile file number=00003 name=+DATA/CDB/DATAFILE/sysaux.287.1171797291
input datafile file number=00004 name=+DATA/CDB/DATAFILE/undotbs1.302.1171797291
input datafile file number=00009 name=+DATA/CDB/DATAFILE/undotbs2.290.1171797291
input datafile file number=00010 name=+DATA/CDB/DATAFILE/undotbs3.276.1171797291
input datafile file number=00007 name=+DATA/CDB/DATAFILE/users.259.1171797291
channel ORA_DISK_1: starting piece 1 at 2024/06/16 11:37:28
channel ORA_DISK_1: finished piece 1 at 2024/06/16 11:38:03
piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.383.1171798649 tag=FULLDBBACKUP0617 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00011 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.301.1171797307
input datafile file number=00012 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.266.1171797307
input datafile file number=00013 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.274.1171797307
input datafile file number=00014 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.270.1171797307
input datafile file number=00015 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.261.1171797307
input datafile file number=00016 name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.260.1171797307
channel ORA_DISK_1: starting piece 1 at 2024/06/16 11:38:03
channel ORA_DISK_1: finished piece 1 at 2024/06/16 11:38:28
piece handle=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.382.1171798683 tag=FULLDBBACKUP0617 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.280.1171797313
input datafile file number=00006 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.285.1171797313
input datafile file number=00008 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.293.1171797313
channel ORA_DISK_1: starting piece 1 at 2024/06/16 11:38:29
channel ORA_DISK_1: finished piece 1 at 2024/06/16 11:38:54
piece handle=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.381.1171798709 tag=FULLDBBACKUP0617 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 2024/06/16 11:38:54
Starting backup at 2024/06/16 11:38:54
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=3 sequence=2 RECID=322 STAMP=1171798734
channel ORA_DISK_1: starting piece 1 at 2024/06/16 11:38:54
channel ORA_DISK_1: finished piece 1 at 2024/06/16 11:38:55
piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup0617_0.377.1171798735 tag=FULLDBBACKUP0617 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2024/06/16 11:38:55
Starting Control File and SPFILE Autobackup at 2024/06/16 11:38:55
piece handle=+DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171798735.315.1171798735 comment=NONE
Finished Control File and SPFILE Autobackup at 2024/06/16 11:38:56
RMAN> exit
Recovery Manager complete.
[oracle@rac3 nfs]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 11:39:05 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 READ ONLY NO
3 PDB READ WRITE YES
SQL> create table abc1 as select *from dual;
Table created.
SQL>
SQL>
SQL> alter pluggable database pdb close;
Pluggable database altered.
SQL> drop pluggable database pdb including datafiles;
Pluggable database dropped.
SQL> startup mount force;
ORACLE instance started.
Total System Global Area 2382361320 bytes
Fixed Size 9167592 bytes
Variable Size 922746880 bytes
Database Buffers 1442840576 bytes
Redo Buffers 7606272 bytes
Database mounted.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED MOUNTED
SQL> flashback database to timestamp to_timestamp(’06/16/2024 11:39:05′, ‘mm/dd/yyyy hh24:mi:ss’);
Flashback complete.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED MOUNTED
3 PDB MOUNTED
SQL> alter database open resetlogs;
Database altered.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
3 PDB MOUNTED
SQL> alter pluggable database pdb open;
alter pluggable database pdb open
*
ERROR at line 1:
ORA-01147: SYSTEM tablespace file 11 is offline
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 nfs]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 11:47:33 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454)
RMAN> run {
2> set newname for pluggable database pdb to ‘+data1’;
3> restore pluggable database pdb ;
4> recover pluggable database pdb ;
5> }
executing command: SET NEWNAME
Starting restore at 2024/06/16 11:48:22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=822 instance=cdb3 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00011 to +data1
channel ORA_DISK_1: restoring datafile 00012 to +data1
channel ORA_DISK_1: restoring datafile 00013 to +data1
channel ORA_DISK_1: restoring datafile 00014 to +data1
channel ORA_DISK_1: restoring datafile 00015 to +data1
channel ORA_DISK_1: restoring datafile 00016 to +data1
channel ORA_DISK_1: reading from backup piece +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.382.1171798683
channel ORA_DISK_1: piece handle=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.382.1171798683 tag=FULLDBBACKUP0617
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
Finished restore at 2024/06/16 11:48:48
Starting recover at 2024/06/16 11:48:48
using channel ORA_DISK_1
starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 11:48:48
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover
if needed datafile 11 , 12 , 13 , 14 , 15 , 16
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 11: ‘/u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00011’
ORA-01157: cannot identify/lock data file 11 – see DBWR trace file
ORA-01110: data file 11: ‘/u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00011’
RMAN> report schema;
Report of database schema for database with db_unique_name CDB
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
—- ——– ——————– ——- ————————
1 1170 SYSTEM YES +DATA/CDB/DATAFILE/system.258.1171797291
3 910 SYSAUX NO +DATA/CDB/DATAFILE/sysaux.287.1171797291
4 615 UNDOTBS1 YES +DATA/CDB/DATAFILE/undotbs1.302.1171797291
5 510 PDB$SEED:SYSTEM NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.280.1171797313
6 480 PDB$SEED:SYSAUX NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.285.1171797313
7 5 USERS NO +DATA/CDB/DATAFILE/users.259.1171797291
8 215 PDB$SEED:UNDOTBS1 NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.293.1171797313
9 250 UNDOTBS2 YES +DATA/CDB/DATAFILE/undotbs2.290.1171797291
10 75 UNDOTBS3 YES +DATA/CDB/DATAFILE/undotbs3.276.1171797291
11 0 PDB:SYSTEM NO /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00011
12 0 PDB:SYSAUX NO /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00012
13 0 PDB:UNDOTBS1 NO /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00013
14 0 PDB:UNDO_3 NO /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00014
15 0 PDB:UNDO_4 NO /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00015
16 0 PDB:USERS NO /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00016
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
—- ——– ——————– ———– ——————–
1 24 TEMP 32767 +DATA/CDB/TEMPFILE/temp.347.1171775247
2 36 PDB$SEED:TEMP 32767 +DATA/CDB/0633F844101D69CBE0636401A8C09D55/TEMPFILE/temp.279.1171775251
RMAN> exit
Recovery Manager complete.
[oracle@rac3 nfs]$ ls /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00011
ls: cannot access /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00011: No such file or directory
[oracle@rac3 nfs]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 11:49:07 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454)
RMAN> switch database to copy;
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch to copy command at 06/16/2024 11:49:39
RMAN-06572: database is open and datafile 1 is not offline
RMAN> alter pluggable database pdb switch datafile to copy;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 11:50:10
ORA-00922: missing or invalid option
RMAN> swtich datafile 11 to copy;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found “identifier”: expecting one of: “advise, allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create or replace global, create or replace script, create script, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, register, release”
RMAN-01008: the bad identifier was: swtich
RMAN-01007: at line 1 column 1 file: standard input
RMAN> switch datafile 11 to copy;—-老老实实一个一个来
datafile 11 switched to datafile copy “+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.291.1171799303”
RMAN> switch datafile 12 to copy;
datafile 12 switched to datafile copy “+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.290.1171799303”
RMAN> switch datafile 13 to copy;
datafile 13 switched to datafile copy “+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.258.1171799303”
RMAN> switch datafile 14 to copy;
datafile 14 switched to datafile copy “+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.296.1171799303”
RMAN> switch datafile 15 to copy;
datafile 15 switched to datafile copy “+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.289.1171799303”
RMAN> switch datafile 16 to copy;
datafile 16 switched to datafile copy “+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.259.1171799303”
RMAN> report schema;
Report of database schema for database with db_unique_name CDB
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
—- ——– ——————– ——- ————————
1 1170 SYSTEM YES +DATA/CDB/DATAFILE/system.258.1171797291
3 910 SYSAUX NO +DATA/CDB/DATAFILE/sysaux.287.1171797291
4 615 UNDOTBS1 YES +DATA/CDB/DATAFILE/undotbs1.302.1171797291
5 510 PDB$SEED:SYSTEM NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.280.1171797313
6 480 PDB$SEED:SYSAUX NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.285.1171797313
7 5 USERS NO +DATA/CDB/DATAFILE/users.259.1171797291
8 215 PDB$SEED:UNDOTBS1 NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.293.1171797313
9 250 UNDOTBS2 YES +DATA/CDB/DATAFILE/undotbs2.290.1171797291
10 75 UNDOTBS3 YES +DATA/CDB/DATAFILE/undotbs3.276.1171797291
11 510 PDB:SYSTEM NO +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.291.1171799303
12 490 PDB:SYSAUX NO +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.290.1171799303
13 215 PDB:UNDOTBS1 NO +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.258.1171799303
14 215 PDB:UNDO_3 NO +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.296.1171799303
15 215 PDB:UNDO_4 NO +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.289.1171799303
16 5 PDB:USERS NO +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.259.1171799303
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
—- ——– ——————– ———– ——————–
1 24 TEMP 32767 +DATA/CDB/TEMPFILE/temp.347.1171775247
2 36 PDB$SEED:TEMP 32767 +DATA/CDB/0633F844101D69CBE0636401A8C09D55/TEMPFILE/temp.279.1171775251
RMAN> recover pluggable database pdb ;
Starting recover at 2024/06/16 11:52:14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=792 instance=cdb3 device type=DISK
starting media recovery
archived log for thread 3 with sequence 2 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.313.1171799187
archived log for thread 3 with sequence 3 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.314.1171799187
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.313.1171799187 thread=3 sequence=2
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.314.1171799187 thread=3 sequence=3
media recovery complete, elapsed time: 00:00:00
Finished recover at 2024/06/16 11:52:15
RMAN> show pdbs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found “identifier”: expecting one of: “all, archivelog, auxiliary, auxname, backup, channel, compression, controlfile, datafile, db_unique_name, default, device, encryption, exclude, incremental, maxsetsize, retention, snapshot, “
RMAN-01008: the bad identifier was: pdbs
RMAN-01007: at line 1 column 6 file: standard input
RMAN> report schema;
Report of database schema for database with db_unique_name CDB
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
—- ——– ——————– ——- ————————
1 1170 SYSTEM YES +DATA/CDB/DATAFILE/system.258.1171797291
3 910 SYSAUX NO +DATA/CDB/DATAFILE/sysaux.287.1171797291
4 615 UNDOTBS1 YES +DATA/CDB/DATAFILE/undotbs1.302.1171797291
5 510 PDB$SEED:SYSTEM NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.280.1171797313
6 480 PDB$SEED:SYSAUX NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.285.1171797313
7 5 USERS NO +DATA/CDB/DATAFILE/users.259.1171797291
8 215 PDB$SEED:UNDOTBS1 NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.293.1171797313
9 250 UNDOTBS2 YES +DATA/CDB/DATAFILE/undotbs2.290.1171797291
10 75 UNDOTBS3 YES +DATA/CDB/DATAFILE/undotbs3.276.1171797291
11 510 PDB:SYSTEM NO +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.291.1171799303
12 490 PDB:SYSAUX NO +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.290.1171799303
13 215 PDB:UNDOTBS1 NO +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.258.1171799303
14 215 PDB:UNDO_3 NO +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.296.1171799303
15 215 PDB:UNDO_4 NO +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.289.1171799303
16 5 PDB:USERS NO +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.259.1171799303
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
—- ——– ——————– ———– ——————–
1 24 TEMP 32767 +DATA/CDB/TEMPFILE/temp.347.1171775247
2 36 PDB$SEED:TEMP 32767 +DATA/CDB/0633F844101D69CBE0636401A8C09D55/TEMPFILE/temp.279.1171775251
RMAN> exit
Recovery Manager complete.
[oracle@rac3 nfs]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 11:52:41 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 READ ONLY NO
3 PDB MOUNTED
SQL> flashback pluggable database pdb to timestamp to_date(’16-JUN-2024 07:00:00′,’DD-MON-YYYY HH24:MI:SS’);
flashback pluggable database pdb to timestamp to_date(’16-JUN-2024 07:00:00′,’DD-MON-YYYY HH24:MI:SS’)
*
ERROR at line 1:
ORA-00264: no recovery required
———————–再朝前flashback不成。—————-如果要到再早怎么办呢,只能从上次恢复
SQL> flashback pluggable database pdb to timestamp to_date(’16-JUN-2024 06:00:00′,’DD-MON-YYYY HH24:MI:SS’);
flashback pluggable database pdb to timestamp to_date(’16-JUN-2024 06:00:00′,’DD-MON-YYYY HH24:MI:SS’)
*
ERROR at line 1:
ORA-00264: no recovery required
SQL> alter pluggable database pdb open resetlogs;
alter pluggable database pdb open resetlogs
*
ERROR at line 1:
ORA-39862: RESETLOGS option only valid after a Pluggable Database incomplete
recovery
SQL> alter pluggable database pdb open;
alter pluggable database pdb open
*
ERROR at line 1:
ORA-01147: SYSTEM tablespace file 11 is offline
SQL> alter session set container=pdb;
Session altered.
SQL> alter database datafile 11 online;
Database altered.
SQL> alter database datafile 12 online;
Database altered.
SQL> alter database datafile 13 online;
Database altered.
SQL> alter database datafile 14 online;
Database altered.
SQL> alter database datafile 15 online;
Database altered.
SQL> alter database datafile 16 online;
Database altered.
SQL> alter pluggable database pdb open;
Pluggable database altered.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
3 PDB READ WRITE NO
SQL> select *from abc;
D
–
X
SQL> select *from abc1;
select *from abc1
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select *from abc1;
select *from abc1
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select *from abcd;
D
–
X
SQL>
———-再朝前flashback,可用带库的恢复, 但是这个CDB做测试时从带库恢复后做过resetlogs,所以带库和本地之间有个resetlogs,不符合正常的DB情况,———–
Last login: Sun Jun 16 12:02:26 2024 from 192.168.1.1
[root@rac3 ~]# su – oracle
Last login: Sun Jun 16 11:45:22 EDT 2024
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:02:46 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 READ ONLY NO
3 PDB READ WRITE NO
SQL> create table abc1 as select *from dual;
Table created.
SQL> alter pluggable database pdb close;
Pluggable database altered.
SQL> drop pluggable database pdb including datafiles;
Pluggable database dropped.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
SQL> startup mount force;
ORACLE instance started.
Total System Global Area 2382361320 bytes
Fixed Size 9167592 bytes
Variable Size 922746880 bytes
Database Buffers 1442840576 bytes
Redo Buffers 7606272 bytes
Database mounted.
SQL> flashback database to timestamp to_timestamp(’06/16/2024 11:39:05′, ‘mm/dd/yyyy hh24:mi:ss’);
Flashback complete.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED MOUNTED
3 PDB MOUNTED
SQL> alter database open resetlogs;
Database altered.
SQL> SQL> alter pluggable database pdb open;
alter pluggable database pdb open
*
ERROR at line 1:
ORA-01147: SYSTEM tablespace file 11 is offline
SQL> run {
1* alter pluggable database pdb open
set until time “(to_date(’06/16/2024 07:00:00′, ‘mm/dd/yyyy hh24:mi:ss’))”;
set newname for pluggable database pdb to ‘+data1’;
restore pluggable database pdb ;
recover pluggable database pdb ;
}
alter pluggable database pdb open
*
ERROR at line 1:
ORA-01147: SYSTEM tablespace file 11 is offline
SQL> SP2-0158: unknown SET option “until”
SQL> SP2-0158: unknown SET option “newname”
SQL> SP2-0734: unknown command beginning “restore p…” – rest of line ignored.
SQL> ORA-00905: missing keyword
[oracle@rac3 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 12:06:20 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454)
RMAN> run {
2> set until time “(to_date(’06/16/2024 07:00:00′, ‘mm/dd/yyyy hh24:mi:ss’))”;
3> set newname for pluggable database pdb to ‘+data1’;
4> restore pluggable database pdb ;
5> recover pluggable database pdb ;
6> }
executing command: SET until clause
executing command: SET NEWNAME
Starting restore at 16-JUN-24
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=821 instance=cdb3 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/16/2024 12:06:23
RMAN-06026: some targets not found – aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 16
RMAN-06100: no channel to restore a backup or copy of datafile 15
RMAN-06100: no channel to restore a backup or copy of datafile 14
RMAN-06100: no channel to restore a backup or copy of datafile 13
RMAN-06100: no channel to restore a backup or copy of datafile 12
RMAN-06100: no channel to restore a backup or copy of datafile 11
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN> run {
2> allocate channel ch00 device type ‘SBT_TAPE’
3> PARMS=”SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)”;
5> set until time “(to_date(’06/16/2024 07:00:00′, ‘mm/dd/yyyy hh24:mi:ss’))”;
6> set newname for pluggable database pdb to ‘+data1’;
7> restore pluggable database pdb ;
8> recover pluggable database pdb ;
9> }
released channel: ORA_DISK_1
allocated channel: ch00
channel ch00: SID=821 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API
executing command: SET until clause
executing command: SET NEWNAME
Starting restore at 16-JUN-24
channel ch00: starting datafile backup set restore
channel ch00: specifying datafile(s) to restore from backup set
channel ch00: restoring datafile 00011 to +data1
channel ch00: restoring datafile 00012 to +data1
channel ch00: restoring datafile 00013 to +data1
channel ch00: restoring datafile 00014 to +data1
channel ch00: restoring datafile 00015 to +data1
channel ch00: restoring datafile 00016 to +data1
channel ch00: reading from backup piece 542tfrvm_164_1_1
channel ch00: piece handle=542tfrvm_164_1_1 tag=FULLDBBACKUP
channel ch00: restored backup piece 1
channel ch00: restore complete, elapsed time: 00:00:03
Finished restore at 16-JUN-24
Starting recover at 16-JUN-24
current log archived
starting media recovery
media recovery failed
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 12:07:05
ORA-38770: FLASHBACK DATABASE failed during recovery.
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 11: ‘/u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00011’
ORA-01157: cannot identify/lock data file 11 – see DBWR trace file
ORA-01110: data file 11: ‘/u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00011’
Recovery Manager complete.
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:07:31 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 pbs;
SP2-0158: unknown SHOW option “pbs”
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
3 PDB MOUNTED
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 12:07:47 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454)
RMAN> report schema;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name CDB
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
—- ——– ——————– ——- ————————
1 1170 SYSTEM YES +DATA/CDB/DATAFILE/system.258.1171797291
3 910 SYSAUX NO +DATA/CDB/DATAFILE/sysaux.287.1171797291
4 615 UNDOTBS1 YES +DATA/CDB/DATAFILE/undotbs1.302.1171797291
5 510 PDB$SEED:SYSTEM NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.280.1171797313
6 480 PDB$SEED:SYSAUX NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.285.1171797313
7 5 USERS NO +DATA/CDB/DATAFILE/users.259.1171797291
8 215 PDB$SEED:UNDOTBS1 NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.293.1171797313
9 250 UNDOTBS2 YES +DATA/CDB/DATAFILE/undotbs2.290.1171797291
10 75 UNDOTBS3 YES +DATA/CDB/DATAFILE/undotbs3.276.1171797291
11 0 PDB:SYSTEM NO /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00011
12 0 PDB:SYSAUX NO /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00012
13 0 PDB:UNDOTBS1 NO /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00013
14 0 PDB:UNDO_3 NO /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00014
15 0 PDB:UNDO_4 NO /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00015
16 0 PDB:USERS NO /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00016
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
—- ——– ——————– ———– ——————–
1 24 TEMP 32767 +DATA/CDB/TEMPFILE/temp.347.1171775247
2 36 PDB$SEED:TEMP 32767 +DATA/CDB/0633F844101D69CBE0636401A8C09D55/TEMPFILE/temp.279.1171775251
RMAN> switch datafile 11 to copy;
datafile 11 switched to datafile copy “+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.296.1171800421”
RMAN> switch datafile 12 to copy;
datafile 12 switched to datafile copy “+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.289.1171800421”
RMAN> switch datafile 13 to copy;
datafile 13 switched to datafile copy “+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.259.1171800421”
RMAN> switch datafile 14 to copy;
datafile 14 switched to datafile copy “+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.338.1171800421”
RMAN> switch datafile 15 to copy;
datafile 15 switched to datafile copy “+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.345.1171800421”
RMAN> switch datafile 16 to copy;
datafile 16 switched to datafile copy “+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.347.1171800421”
RMAN> run {
2> allocate channel ch00 device type ‘SBT_TAPE’
3> PARMS=”SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)”;
5> set until time “(to_date(’06/16/2024 07:00:00′, ‘mm/dd/yyyy hh24:mi:ss’))”;
6> recover pluggable database pdb ;
7> }
allocated channel: ch00
channel ch00: SID=810 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API
executing command: SET until clause
Starting recover at 16-JUN-24
starting media recovery
channel ch00: starting archived log restore to default destination
channel ch00: restoring archived log
archived log thread=3 sequence=17
channel ch00: reading from backup piece 562tfrvt_166_1_1
channel ch00: piece handle=562tfrvt_166_1_1 tag=FULLDBBACKUP
channel ch00: restored backup piece 1
channel ch00: restore complete, elapsed time: 00:00:01
channel default: deleting archived log(s)
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_17.270.1171800551 RECID=330 STAMP=1171800551
media recovery complete, elapsed time: 00:00:00
Finished recover at 16-JUN-24
released channel: ch00
Recovery Manager complete.
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:09:28 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> alter session set container=pdb;
Session altered.
SQL> alter database datafile 11 online;
Database altered.
SQL> alter database datafile 12 online;
Database altered.
SQL> alter database datafile 13 online;
Database altered.
SQL> alter database datafile 14 online;
Database altered.
SQL> alter database datafile 15 online;
Database altered.
SQL> alter database datafile 16 online;
Database altered.
SQL> alter pluggable database pdb open;
alter pluggable database pdb open
*
ERROR at line 1:
ORA-01190: control file or data file 16 is from before the last RESETLOGS
ORA-01110: data file 16:
‘+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.347.1171800421’
SQL> alter pluggable database pdb open resetlogs;
alter pluggable database pdb open resetlogs
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcp_begin_df_resetlogs_5], [16],
[], [], [], [], [], [], [], [], [], []
ORA-01122: database file 16 failed verification check
ORA-01110: data file 16:
‘+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.347.1171800421’
ORA-01207: file is more recent than control file – old control file
SQL> alter pluggable database pdb open ;
alter pluggable database pdb open
*
ERROR at line 1:
ORA-65137: Pluggable database PDB is in the middle of Pluggable Database
RESETLOGS operation.
[oracle@rac3 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 12:11:18 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454)
RMAN> run {
2> allocate channel ch00 device type ‘SBT_TAPE’
3> PARMS=”SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)”;
5> set until time “(to_date(’06/16/2024 07:00:00′, ‘mm/dd/yyyy hh24:mi:ss’))”;
6> recover pluggable database pdb ;
7> }
using target database control file instead of recovery catalog
allocated channel: ch00
channel ch00: SID=30 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API
executing command: SET until clause
Starting recover at 16-JUN-24
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 16-JUN-24
released channel: ch00
RMAN> alter pluggable database pdb open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:11:29
ORA-65137: Pluggable database PDB is in the middle of Pluggable Database RESETLOGS operation.
RMAN> alter pluggable database pdb open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:11:37
ORA-00600: internal error code, arguments: [kcp_begin_df_resetlogs_5], [16], [], [], [], [], [], [], [], [], [], []
ORA-01122: database file 16 failed verification check
ORA-01110: data file 16: ‘+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.347.1171800421’
ORA-01207: file is more recent than control file – old control file
RMAN> recover pluggable database pdb until time “to_date(’16-JUN-2024 07:01:00′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
Starting recover at 16-JUN-24
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=30 instance=cdb3 device type=DISK
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 16-JUN-24
RMAN> alter pluggable database pdb open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:12:40
ORA-00600: internal error code, arguments: [kcp_begin_df_resetlogs_5], [16], [], [], [], [], [], [], [], [], [], []
ORA-01122: database file 16 failed verification check
ORA-01110: data file 16: ‘+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.347.1171800421’
ORA-01207: file is more recent than control file – old control file
RMAN> recover pluggable database pdb until time “to_date(’16-JUN-2024 07:11:00′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
Starting recover at 16-JUN-24
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 16-JUN-24
RMAN> alter pluggable database pdb open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:13:07
ORA-00600: internal error code, arguments: [kcp_begin_df_resetlogs_5], [16], [], [], [], [], [], [], [], [], [], []
ORA-01122: database file 16 failed verification check
ORA-01110: data file 16: ‘+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.347.1171800421’
ORA-01207: file is more recent than control file – old control file
RMAN> recover pluggable database pdb;
Starting recover at 16-JUN-24
using channel ORA_DISK_1
starting media recovery
archived log for thread 3 with sequence 1 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.300.1171798647
archived log for thread 3 with sequence 2 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.313.1171799187
archived log for thread 3 with sequence 3 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.314.1171799187
archived log for thread 3 with sequence 1 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.257.1171800425
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.300.1171798647 thread=3 sequence=1
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.313.1171799187 thread=3 sequence=2
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.314.1171799187 thread=3 sequence=3
media recovery complete, elapsed time: 00:00:00
Finished recover at 16-JUN-24
RMAN> alter pluggable database pdb open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:13:16
ORA-39862: RESETLOGS option only valid after a Pluggable Database incomplete recovery
RMAN> alter pluggable database pdb open
2> ;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:13:26
ORA-65137: Pluggable database PDB is in the middle of Pluggable Database RESETLOGS operation.
RMAN> alter pluggable database pdb open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:13:35
ORA-39862: RESETLOGS option only valid after a Pluggable Database incomplete recovery
RMAN> alter pluggable database pdb open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:13:44
ORA-65137: Pluggable database PDB is in the middle of Pluggable Database RESETLOGS operation.
RMAN> startup force;
Oracle instance started
database mounted
database opened
Total System Global Area 2382361320 bytes
Fixed Size 9167592 bytes
Variable Size 922746880 bytes
Database Buffers 1442840576 bytes
Redo Buffers 7606272 bytes
RMAN> alter pluggable database pdb open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:14:13
ORA-65137: Pluggable database PDB is in the middle of Pluggable Database RESETLOGS operation.
RMAN> alter pluggable database pdb open RESETLOGS;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:14:20
ORA-39862: RESETLOGS option only valid after a Pluggable Database incomplete recovery
RMAN> recover pluggable database pdb until cancel;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found “cancel”: expecting one of: “available, scn, sequence, time”
RMAN-01007: at line 1 column 39 file: standard input
RMAN> recover pluggable database pdb;
Starting recover at 16-JUN-24
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=61 instance=cdb3 device type=DISK
starting media recovery
archived log for thread 3 with sequence 1 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.300.1171798647
archived log for thread 3 with sequence 2 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.313.1171799187
archived log for thread 3 with sequence 3 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.314.1171799187
archived log for thread 3 with sequence 1 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.257.1171800425
archived log for thread 3 with sequence 2 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.270.1171800847
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.300.1171798647 thread=3 sequence=1
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.313.1171799187 thread=3 sequence=2
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.314.1171799187 thread=3 sequence=3
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.257.1171800425 thread=3 sequence=1
media recovery complete, elapsed time: 00:00:00
Finished recover at 16-JUN-24
RMAN> alter pluggable database pdb open RESETLOGS;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:14:57
ORA-39862: RESETLOGS option only valid after a Pluggable Database incomplete recovery
RMAN> alter pluggable database pdb open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:15:02
ORA-65137: Pluggable database PDB is in the middle of Pluggable Database RESETLOGS operation.
RMAN> recover pluggable database pdb until time “to_date(’16-JUN-2024 11:01:00′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
Starting recover at 16-JUN-24
using channel ORA_DISK_1
——-CDB resetlogs后的时间————————–
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 16-JUN-24
RMAN> alter pluggable database pdb open RESETLOGS;
Statement processed
RMAN> exit
Recovery Manager complete.
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:15:47 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> alter session set container=pdb;
Session altered.
SQL> select *from abc;
D
–
X
SQL> select *from abc1;
select *from abc1
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select *from abcd;
select *from abcd
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL>
————————————————–做一个正常的,磁带和磁盘之间没有resetlogs的—————
Last login: Sun Jun 16 12:02:26 2024 from 192.168.1.1
[root@rac3 ~]# su – oracle
Last login: Sun Jun 16 11:45:22 EDT 2024
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:02:46 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 READ ONLY NO
3 PDB READ WRITE NO
SQL> create table abc1 as select *from dual;
Table created.
SQL> alter pluggable database pdb close;
Pluggable database altered.
SQL> drop pluggable database pdb including datafiles;
Pluggable database dropped.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
SQL> flashback database to timestamp to_timestamp(’06/16/2024 11:39:05′, ‘mm/dd/yyyy hh24:mi:ss’);
flashback database to timestamp to_timestamp(’06/16/2024 11:39:05′, ‘mm/dd/yyyy hh24:mi:ss’)
*
ERROR at line 1:
ORA-38757: Database must be mounted and not open to FLASHBACK.
SQL> startup mount force;
ORACLE instance started.
Total System Global Area 2382361320 bytes
Fixed Size 9167592 bytes
Variable Size 922746880 bytes
Database Buffers 1442840576 bytes
Redo Buffers 7606272 bytes
Database mounted.
SQL> flashback database to timestamp to_timestamp(’06/16/2024 11:39:05′, ‘mm/dd/yyyy hh24:mi:ss’);
Flashback complete.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED MOUNTED
3 PDB MOUNTED
SQL> alter database open resetlogs;
Database altered.
SQL> SQL> alter pluggable database pdb open;
alter pluggable database pdb open
*
ERROR at line 1:
ORA-01147: SYSTEM tablespace file 11 is offline
SQL> run {
1* alter pluggable database pdb open
set until time “(to_date(’06/16/2024 07:00:00′, ‘mm/dd/yyyy hh24:mi:ss’))”;
set newname for pluggable database pdb to ‘+data1’;
restore pluggable database pdb ;
recover pluggable database pdb ;
}
alter pluggable database pdb open
*
ERROR at line 1:
ORA-01147: SYSTEM tablespace file 11 is offline
SQL> SP2-0158: unknown SET option “until”
SQL> SP2-0158: unknown SET option “newname”
SQL> SP2-0734: unknown command beginning “restore p…” – rest of line ignored.
SQL> ORA-00905: missing keyword
SQL> SP2-0042: unknown command “}” – rest of line ignored.
SQL>
SQL>
SQL> run {
1* alter pluggable database pdb open
set until time “(to_date(’06/16/2024 07:00:00′, ‘mm/dd/yyyy hh24:mi:ss’))”;
set newname for pluggable database pdb to ‘+data1’;
restore pluggable database pdb ;
recover pluggable database pdb ;
}
alter pluggable database pdb open
*
ERROR at line 1:
ORA-01147: SYSTEM tablespace file 11 is offline
SQL> SP2-0158: unknown SET option “until”
SQL> SP2-0158: unknown SET option “newname”
SQL> SP2-0734: unknown command beginning “restore p…” – rest of line ignored.
SQL> ORA-00905: missing keyword
SQL> SP2-0042: unknown command “}” – rest of line ignored.
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 12:06:20 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454)
RMAN> run {
2> set until time “(to_date(’06/16/2024 07:00:00′, ‘mm/dd/yyyy hh24:mi:ss’))”;
3> set newname for pluggable database pdb to ‘+data1’;
4> restore pluggable database pdb ;
5> recover pluggable database pdb ;
6> }
executing command: SET until clause
executing command: SET NEWNAME
Starting restore at 16-JUN-24
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=821 instance=cdb3 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/16/2024 12:06:23
RMAN-06026: some targets not found – aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 16
RMAN-06100: no channel to restore a backup or copy of datafile 15
RMAN-06100: no channel to restore a backup or copy of datafile 14
RMAN-06100: no channel to restore a backup or copy of datafile 13
RMAN-06100: no channel to restore a backup or copy of datafile 12
RMAN-06100: no channel to restore a backup or copy of datafile 11
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN>
RMAN> run {
2> allocate channel ch00 device type ‘SBT_TAPE’
3> PARMS=”SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)”;
5> set until time “(to_date(’06/16/2024 07:00:00′, ‘mm/dd/yyyy hh24:mi:ss’))”;
6> set newname for pluggable database pdb to ‘+data1’;
7> restore pluggable database pdb ;
8> recover pluggable database pdb ;
9> }
released channel: ORA_DISK_1
allocated channel: ch00
channel ch00: SID=821 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API
executing command: SET until clause
executing command: SET NEWNAME
Starting restore at 16-JUN-24
channel ch00: starting datafile backup set restore
channel ch00: specifying datafile(s) to restore from backup set
channel ch00: restoring datafile 00011 to +data1
channel ch00: restoring datafile 00012 to +data1
channel ch00: restoring datafile 00013 to +data1
channel ch00: restoring datafile 00014 to +data1
channel ch00: restoring datafile 00015 to +data1
channel ch00: restoring datafile 00016 to +data1
channel ch00: reading from backup piece 542tfrvm_164_1_1
channel ch00: piece handle=542tfrvm_164_1_1 tag=FULLDBBACKUP
channel ch00: restored backup piece 1
channel ch00: restore complete, elapsed time: 00:00:03
Finished restore at 16-JUN-24
Starting recover at 16-JUN-24
current log archived
starting media recovery
media recovery failed
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 12:07:05
ORA-38770: FLASHBACK DATABASE failed during recovery.
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 11: ‘/u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00011’
ORA-01157: cannot identify/lock data file 11 – see DBWR trace file
ORA-01110: data file 11: ‘/u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00011’
RMAN> show pdbs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found “identifier”: expecting one of: “all, archivelog, auxiliary, auxname, backup, channel, compression, controlfile, datafile, db_unique_name, default, device, encryption, exclude, incremental, maxsetsize, retention, snapshot, “
RMAN-01008: the bad identifier was: pdbs
RMAN-01007: at line 1 column 6 file: standard input
RMAN> exit
Recovery Manager complete.
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:07:31 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 pbs;
SP2-0158: unknown SHOW option “pbs”
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
3 PDB MOUNTED
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 12:07:47 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454)
RMAN> report schema;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name CDB
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
—- ——– ——————– ——- ————————
1 1170 SYSTEM YES +DATA/CDB/DATAFILE/system.258.1171797291
3 910 SYSAUX NO +DATA/CDB/DATAFILE/sysaux.287.1171797291
4 615 UNDOTBS1 YES +DATA/CDB/DATAFILE/undotbs1.302.1171797291
5 510 PDB$SEED:SYSTEM NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.280.1171797313
6 480 PDB$SEED:SYSAUX NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.285.1171797313
7 5 USERS NO +DATA/CDB/DATAFILE/users.259.1171797291
8 215 PDB$SEED:UNDOTBS1 NO +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.293.1171797313
9 250 UNDOTBS2 YES +DATA/CDB/DATAFILE/undotbs2.290.1171797291
10 75 UNDOTBS3 YES +DATA/CDB/DATAFILE/undotbs3.276.1171797291
11 0 PDB:SYSTEM NO /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00011
12 0 PDB:SYSAUX NO /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00012
13 0 PDB:UNDOTBS1 NO /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00013
14 0 PDB:UNDO_3 NO /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00014
15 0 PDB:UNDO_4 NO /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00015
16 0 PDB:USERS NO /u01/app/oracle/product/19.0.0/db_1/dbs/UNNAMED00016
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
—- ——– ——————– ———– ——————–
1 24 TEMP 32767 +DATA/CDB/TEMPFILE/temp.347.1171775247
2 36 PDB$SEED:TEMP 32767 +DATA/CDB/0633F844101D69CBE0636401A8C09D55/TEMPFILE/temp.279.1171775251
RMAN> switch datafile 11 to copy;
datafile 11 switched to datafile copy “+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.296.1171800421”
RMAN> switch datafile 12 to copy;
datafile 12 switched to datafile copy “+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.289.1171800421”
RMAN> switch datafile 13 to copy;
datafile 13 switched to datafile copy “+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.259.1171800421”
RMAN> switch datafile 14 to copy;
datafile 14 switched to datafile copy “+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.338.1171800421”
RMAN> switch datafile 15 to copy;
datafile 15 switched to datafile copy “+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.345.1171800421”
RMAN> switch datafile 16 to copy;
datafile 16 switched to datafile copy “+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.347.1171800421”
RMAN> run {
2> allocate channel ch00 device type ‘SBT_TAPE’
3> PARMS=”SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)”;
5> set until time “(to_date(’06/16/2024 07:00:00′, ‘mm/dd/yyyy hh24:mi:ss’))”;
6> recover pluggable database pdb ;
7> }
allocated channel: ch00
channel ch00: SID=810 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API
executing command: SET until clause
Starting recover at 16-JUN-24
starting media recovery
channel ch00: starting archived log restore to default destination
channel ch00: restoring archived log
archived log thread=3 sequence=17
channel ch00: reading from backup piece 562tfrvt_166_1_1
channel ch00: piece handle=562tfrvt_166_1_1 tag=FULLDBBACKUP
channel ch00: restored backup piece 1
channel ch00: restore complete, elapsed time: 00:00:01
channel default: deleting archived log(s)
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_17.270.1171800551 RECID=330 STAMP=1171800551
media recovery complete, elapsed time: 00:00:00
Finished recover at 16-JUN-24
released channel: ch00
RMAN> alter pluggable database pdb open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:09:24
ORA-01147: SYSTEM tablespace file 11 is offline
RMAN> exit
Recovery Manager complete.
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:09:28 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> alter session set container=pdb;
Session altered.
SQL> alter database datafile 11 online;
Database altered.
SQL> alter database datafile 12 online;
Database altered.
SQL> alter database datafile 13 online;
Database altered.
SQL> alter database datafile 14 online;
Database altered.
SQL> alter database datafile 15 online;
Database altered.
SQL> alter database datafile 16 online;
Database altered.
SQL> alter pluggable database pdb open;
alter pluggable database pdb open
*
ERROR at line 1:
ORA-01190: control file or data file 16 is from before the last RESETLOGS
ORA-01110: data file 16:
‘+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.347.1171800421’
SQL> alter pluggable database pdb open resetlogs;
alter pluggable database pdb open resetlogs
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcp_begin_df_resetlogs_5], [16],
[], [], [], [], [], [], [], [], [], []
ORA-01122: database file 16 failed verification check
ORA-01110: data file 16:
‘+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.347.1171800421’
ORA-01207: file is more recent than control file – old control file
SQL> alter pluggable database pdb open ;
alter pluggable database pdb open
*
ERROR at line 1:
ORA-65137: Pluggable database PDB is in the middle of Pluggable Database
RESETLOGS operation.
SQL> run {
1* alter pluggable database pdb open
allocate channel ch00 device type ‘SBT_TAPE’
PARMS=”SBT_LIBRARY=oracle.disksbt,
ENV=(BACKUP_DIR=/nfs)”;
set until time “(to_date(’06/16/2024 07:00:00′, ‘mm/dd/yyyy hh24:mi:ss’))”;
recover pluggable database pdb ;
} alter pluggable database pdb open
*
ERROR at line 1:
ORA-65137: Pluggable database PDB is in the middle of Pluggable Database
RESETLOGS operation.
SQL> SP2-0734: unknown command beginning “allocate c…” – rest of line ignored.
SQL> SP2-0734: unknown command beginning “PARMS=”SBT…” – rest of line ignored.
SQL> SP2-0734: unknown command beginning “ENV=(BACKU…” – rest of line ignored.
SQL> SP2-0158: unknown SET option “until”
SQL> ORA-00905: missing keyword
SQL>
SP2-0042: unknown command “}” – rest of line ignored.
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 12:11:18 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454)
RMAN> run {
2> allocate channel ch00 device type ‘SBT_TAPE’
3> PARMS=”SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)”;
5> set until time “(to_date(’06/16/2024 07:00:00′, ‘mm/dd/yyyy hh24:mi:ss’))”;
6> recover pluggable database pdb ;
7> }
using target database control file instead of recovery catalog
allocated channel: ch00
channel ch00: SID=30 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API
executing command: SET until clause
Starting recover at 16-JUN-24
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 16-JUN-24
released channel: ch00
RMAN> alter pluggable database pdb open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:11:29
ORA-65137: Pluggable database PDB is in the middle of Pluggable Database RESETLOGS operation.
RMAN> alter pluggable database pdb open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:11:37
ORA-00600: internal error code, arguments: [kcp_begin_df_resetlogs_5], [16], [], [], [], [], [], [], [], [], [], []
ORA-01122: database file 16 failed verification check
ORA-01110: data file 16: ‘+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.347.1171800421’
ORA-01207: file is more recent than control file – old control file
RMAN> recover pluggable database pdb until time “to_date(’16-JUN-2024 07:01:00′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
Starting recover at 16-JUN-24
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=30 instance=cdb3 device type=DISK
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 16-JUN-24
RMAN> alter pluggable database pdb open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:12:40
ORA-00600: internal error code, arguments: [kcp_begin_df_resetlogs_5], [16], [], [], [], [], [], [], [], [], [], []
ORA-01122: database file 16 failed verification check
ORA-01110: data file 16: ‘+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.347.1171800421’
ORA-01207: file is more recent than control file – old control file
RMAN> recover pluggable database pdb until time “to_date(’16-JUN-2024 07:11:00′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
Starting recover at 16-JUN-24
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 16-JUN-24
RMAN> alter pluggable database pdb open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:13:07
ORA-00600: internal error code, arguments: [kcp_begin_df_resetlogs_5], [16], [], [], [], [], [], [], [], [], [], []
ORA-01122: database file 16 failed verification check
ORA-01110: data file 16: ‘+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.347.1171800421’
ORA-01207: file is more recent than control file – old control file
RMAN> recover pluggable database pdb;
Starting recover at 16-JUN-24
using channel ORA_DISK_1
starting media recovery
archived log for thread 3 with sequence 1 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.300.1171798647
archived log for thread 3 with sequence 2 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.313.1171799187
archived log for thread 3 with sequence 3 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.314.1171799187
archived log for thread 3 with sequence 1 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.257.1171800425
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.300.1171798647 thread=3 sequence=1
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.313.1171799187 thread=3 sequence=2
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.314.1171799187 thread=3 sequence=3
media recovery complete, elapsed time: 00:00:00
Finished recover at 16-JUN-24
RMAN> alter pluggable database pdb open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:13:16
ORA-39862: RESETLOGS option only valid after a Pluggable Database incomplete recovery
RMAN> alter pluggable database pdb open
2> ;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:13:26
ORA-65137: Pluggable database PDB is in the middle of Pluggable Database RESETLOGS operation.
RMAN> alter pluggable database pdb open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:13:35
ORA-39862: RESETLOGS option only valid after a Pluggable Database incomplete recovery
RMAN> alter pluggable database pdb open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:13:44
ORA-65137: Pluggable database PDB is in the middle of Pluggable Database RESETLOGS operation.
RMAN> startup force;
Oracle instance started
database mounted
database opened
Total System Global Area 2382361320 bytes
Fixed Size 9167592 bytes
Variable Size 922746880 bytes
Database Buffers 1442840576 bytes
Redo Buffers 7606272 bytes
RMAN> alter pluggable database pdb open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:14:13
ORA-65137: Pluggable database PDB is in the middle of Pluggable Database RESETLOGS operation.
RMAN> alter pluggable database pdb open RESETLOGS;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:14:20
ORA-39862: RESETLOGS option only valid after a Pluggable Database incomplete recovery
RMAN> recover pluggable database pdb until cancel;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found “cancel”: expecting one of: “available, scn, sequence, time”
RMAN-01007: at line 1 column 39 file: standard input
RMAN> recover pluggable database pdb;
Starting recover at 16-JUN-24
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=61 instance=cdb3 device type=DISK
starting media recovery
archived log for thread 3 with sequence 1 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.300.1171798647
archived log for thread 3 with sequence 2 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.313.1171799187
archived log for thread 3 with sequence 3 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.314.1171799187
archived log for thread 3 with sequence 1 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.257.1171800425
archived log for thread 3 with sequence 2 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.270.1171800847
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.300.1171798647 thread=3 sequence=1
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.313.1171799187 thread=3 sequence=2
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.314.1171799187 thread=3 sequence=3
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.257.1171800425 thread=3 sequence=1
media recovery complete, elapsed time: 00:00:00
Finished recover at 16-JUN-24
RMAN> alter pluggable database pdb open RESETLOGS;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:14:57
ORA-39862: RESETLOGS option only valid after a Pluggable Database incomplete recovery
RMAN> alter pluggable database pdb open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/16/2024 12:15:02
ORA-65137: Pluggable database PDB is in the middle of Pluggable Database RESETLOGS operation.
RMAN> recover pluggable database pdb until time “to_date(’16-JUN-2024 11:01:00′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
Starting recover at 16-JUN-24
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 16-JUN-24
RMAN> alter pluggable database pdb open RESETLOGS;
Statement processed
RMAN> exit
Recovery Manager complete.
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:15:47 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> alter session set container=pdb;
Session altered.
SQL> select *from abc;
D
–
X
SQL> select *from abc1;
select *from abc1
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select *from abcd;
select *from abcd
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 12:25:02 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454)
RMAN> exit
Recovery Manager complete.
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:25:05 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 pbs;
SP2-0158: unknown SHOW option “pbs”
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
3 PDB READ WRITE NO
SQL> exigt
SP2-0042: unknown command “exigt” – rest of line ignored.
SQL> rman
SP2-0042: unknown command “rman” – rest of line ignored.
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 12:25:16 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454)
RMAN> delete archivedlog all;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found “identifier”: expecting one of: “archivelog, backuppiece, backupset, backup, controlfilecopy, copy, datafilecopy, expired, force, foreign, global, noprompt, obsolete, proxy, preplugin, script”
RMAN-01008: the bad identifier was: archivedlog
RMAN-01007: at line 1 column 8 file: standard input
RMAN> delte archivelog all;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found “identifier”: expecting one of: “advise, allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create or replace global, create or replace script, create script, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, register, release”
RMAN-01008: the bad identifier was: delte
RMAN-01007: at line 1 column 1 file: standard input
RMAN> delete archivelog all;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=812 instance=cdb3 device type=DISK
YList of Archived Log Copies for database with db_unique_name CDB
=====================================================================
Key Thrd Seq S Low Time
——- —- ——- – ———
331 3 1 A 16-JUN-24
Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.300.1171798647
324 3 2 A 16-JUN-24
Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.313.1171799187
322 3 2 A 16-JUN-24
Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.378.1171798735
323 3 3 A 16-JUN-24
Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.314.1171799187
325 3 1 A 16-JUN-24
Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.288.1171799739
328 3 2 A 16-JUN-24
Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.290.1171800297
326 3 2 A 16-JUN-24
Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.264.1171799759
327 3 3 A 16-JUN-24
Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.291.1171800297
329 3 1 A 16-JUN-24
Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.257.1171800425
332 3 2 A 16-JUN-24
Name: +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.270.1171800847
Do you really want to delete the above objects (enter YES or NO)? ES
deleted archived log
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.300.1171798647 RECID=331 STAMP=1171800552
deleted archived log
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.313.1171799187 RECID=324 STAMP=1171799187
deleted archived log
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.378.1171798735 RECID=322 STAMP=1171798734
deleted archived log
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.314.1171799187 RECID=323 STAMP=1171799187
deleted archived log
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.288.1171799739 RECID=325 STAMP=1171799738
deleted archived log
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.290.1171800297 RECID=328 STAMP=1171800297
deleted archived log
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.264.1171799759 RECID=326 STAMP=1171799759
deleted archived log
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_3.291.1171800297 RECID=327 STAMP=1171800296
deleted archived log
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_1.257.1171800425 RECID=329 STAMP=1171800425
deleted archived log
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_2.270.1171800847 RECID=332 STAMP=1171800846
Deleted 10 objects
RMAN> delte backup;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found “identifier”: expecting one of: “advise, allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create or replace global, create or replace script, create script, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, register, release”
RMAN-01008: the bad identifier was: delte
RMAN-01007: at line 1 column 1 file: standard input
RMAN> delete backup;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
——- ——- — — ———– ———– ———-
172 131 1 1 AVAILABLE DISK +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171797368.388.1171797369
173 132 1 1 AVAILABLE DISK +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup0617_0.384.1171798647
174 133 1 1 AVAILABLE DISK +DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.383.1171798649
175 134 1 1 AVAILABLE DISK +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.382.1171798683
176 135 1 1 AVAILABLE DISK +DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.381.1171798709
177 136 1 1 AVAILABLE DISK +DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup0617_0.377.1171798735
178 137 1 1 AVAILABLE DISK +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171798735.315.1171798735
179 138 1 1 AVAILABLE DISK +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171799194.302.1171799195
180 139 1 1 AVAILABLE DISK +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171800303.258.1171800303
181 140 1 1 AVAILABLE DISK +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171800943.318.1171800943
Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=+DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171797368.388.1171797369 RECID=172 STAMP=1171797369
deleted backup piece
backup piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup0617_0.384.1171798647 RECID=173 STAMP=1171798647
deleted backup piece
backup piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.383.1171798649 RECID=174 STAMP=1171798648
deleted backup piece
backup piece handle=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.382.1171798683 RECID=175 STAMP=1171798683
deleted backup piece
backup piece handle=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.381.1171798709 RECID=176 STAMP=1171798709
deleted backup piece
backup piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup0617_0.377.1171798735 RECID=177 STAMP=1171798734
deleted backup piece
backup piece handle=+DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171798735.315.1171798735 RECID=178 STAMP=1171798735
deleted backup piece
backup piece handle=+DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171799194.302.1171799195 RECID=179 STAMP=1171799194
deleted backup piece
backup piece handle=+DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171800303.258.1171800303 RECID=180 STAMP=1171800303
deleted backup piece
backup piece handle=+DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171800943.318.1171800943 RECID=181 STAMP=1171800943
Deleted 10 objects
RMAN> run {
2> allocate channel ch00 device type ‘SBT_TAPE’
3> PARMS=”SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)”;
5> delete backup device type sbt;
6> }
released channel: ORA_DISK_1
allocated channel: ch00
channel ch00: SID=812 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
——- ——- — — ———– ———– ———-
161 120 1 1 AVAILABLE SBT_TAPE 4s2tfrpm_156_1_1
162 121 1 1 AVAILABLE SBT_TAPE 4t2tfrpn_157_1_1
163 122 1 1 AVAILABLE SBT_TAPE 4u2tfrqq_158_1_1
164 123 1 1 AVAILABLE SBT_TAPE 4v2tfrrj_159_1_1
165 124 1 1 AVAILABLE SBT_TAPE 502tfrsc_160_1_1
166 125 1 1 AVAILABLE SBT_TAPE c-2265125454-20240616-07
167 126 1 1 AVAILABLE SBT_TAPE 522tfrve_162_1_1
168 127 1 1 AVAILABLE SBT_TAPE 532tfrvf_163_1_1
169 128 1 1 AVAILABLE SBT_TAPE 542tfrvm_164_1_1
170 129 1 1 AVAILABLE SBT_TAPE 552tfrvp_165_1_1
171 130 1 1 AVAILABLE SBT_TAPE 562tfrvt_166_1_1
Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=4s2tfrpm_156_1_1 RECID=161 STAMP=1171779382
deleted backup piece
backup piece handle=4t2tfrpn_157_1_1 RECID=162 STAMP=1171779383
deleted backup piece
backup piece handle=4u2tfrqq_158_1_1 RECID=163 STAMP=1171779418
deleted backup piece
backup piece handle=4v2tfrrj_159_1_1 RECID=164 STAMP=1171779443
deleted backup piece
backup piece handle=502tfrsc_160_1_1 RECID=165 STAMP=1171779468
deleted backup piece
backup piece handle=c-2265125454-20240616-07 RECID=166 STAMP=1171779469
deleted backup piece
backup piece handle=522tfrve_162_1_1 RECID=167 STAMP=1171779566
deleted backup piece
backup piece handle=532tfrvf_163_1_1 RECID=168 STAMP=1171779567
deleted backup piece
backup piece handle=542tfrvm_164_1_1 RECID=169 STAMP=1171779574
deleted backup piece
backup piece handle=552tfrvp_165_1_1 RECID=170 STAMP=1171779577
deleted backup piece
backup piece handle=562tfrvt_166_1_1 RECID=171 STAMP=1171779581
Deleted 11 objects
released channel: ch00
RMAN> delete backup;
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=812 instance=cdb3 device type=DISK
specification does not match any backup in the repository
RMAN> delete backup of controlfile;
using channel ORA_DISK_1
specification does not match any backup in the repository
RMAN> run {
2> allocate channel ch00 device type ‘SBT_TAPE’
3> PARMS=”SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)”;
5> delete backup device type sbt;
6> delete backup of controlfile device type sbt;
7> }
released channel: ORA_DISK_1
allocated channel: ch00
channel ch00: SID=812 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API
specification does not match any backup in the repository
specification does not match any backup in the repository
released channel: ch00
RMAN> run {
2> allocate channel ch00 device type ‘SBT_TAPE’
3> PARMS=”SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)”;
5> backup as compressed backupset database tag ‘fulldbbackup0617’ plus archivelog tag ‘fulldbbackup0617’;}
allocated channel: ch00
channel ch00: SID=812 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API
Starting backup at 16-JUN-24
current log archived
channel ch00: starting compressed archived log backup set
channel ch00: specifying archived log(s) in backup set
input archived log thread=3 sequence=3 RECID=333 STAMP=1171801697
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: finished piece 1 at 16-JUN-24
piece handle=5j2tghj1_179_1_1 tag=FULLDBBACKUP0617 comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:01
Finished backup at 16-JUN-24
Starting backup at 16-JUN-24
channel ch00: starting compressed full datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/CDB/DATAFILE/system.258.1171797291
input datafile file number=00003 name=+DATA/CDB/DATAFILE/sysaux.287.1171797291
input datafile file number=00004 name=+DATA/CDB/DATAFILE/undotbs1.302.1171797291
input datafile file number=00009 name=+DATA/CDB/DATAFILE/undotbs2.290.1171797291
input datafile file number=00010 name=+DATA/CDB/DATAFILE/undotbs3.276.1171797291
input datafile file number=00007 name=+DATA/CDB/DATAFILE/users.259.1171797291
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: finished piece 1 at 16-JUN-24
piece handle=5k2tghj2_180_1_1 tag=FULLDBBACKUP0617 comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:36
channel ch00: starting compressed full datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00011 name=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.296.1171800421
input datafile file number=00012 name=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.289.1171800421
input datafile file number=00013 name=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.259.1171800421
input datafile file number=00014 name=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.338.1171800421
input datafile file number=00015 name=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.345.1171800421
input datafile file number=00016 name=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.347.1171800421
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: finished piece 1 at 16-JUN-24
piece handle=5l2tghk6_181_1_1 tag=FULLDBBACKUP0617 comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:25
channel ch00: starting compressed full datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.280.1171797313
input datafile file number=00006 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.285.1171797313
input datafile file number=00008 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.293.1171797313
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: finished piece 1 at 16-JUN-24
piece handle=5m2tghkv_182_1_1 tag=FULLDBBACKUP0617 comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:25
Finished backup at 16-JUN-24
Starting backup at 16-JUN-24
current log archived
channel ch00: starting compressed archived log backup set
channel ch00: specifying archived log(s) in backup set
input archived log thread=3 sequence=4 RECID=334 STAMP=1171801784
channel ch00: starting piece 1 at 16-JUN-24
channel ch00: finished piece 1 at 16-JUN-24
piece handle=5n2tghlo_183_1_1 tag=FULLDBBACKUP0617 comment=API Version 2.0,MMS Version 8.1.3.0
channel ch00: backup set complete, elapsed time: 00:00:01
Finished backup at 16-JUN-24
Starting Control File and SPFILE Autobackup at 16-JUN-24
piece handle=c-2265125454-20240616-0e comment=API Version 2.0,MMS Version 8.1.3.0
Finished Control File and SPFILE Autobackup at 16-JUN-24
released channel: ch00
RMAN> exit
Recovery Manager complete.
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:30:02 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 READ ONLY NO
3 PDB READ WRITE NO
SQL> alter session set container=pdb;
Session altered.
SQL> drop table abc;
Table dropped.
SQL> create table abc as select sysdate from dual;
create table abc as select sysdate from dual
*
ERROR at line 1:
ORA-00998: must name this expression with a column alias
SQL> create table abc as select sysdate date from dual;
create table abc as select sysdate date from dual
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
SQL> create table abc as select sysdate dt from dual;
Table created.
SQL> select *from abc;
DT
———
16-JUN-24
SQL> alter session set nls_date_format = ‘yyyy-mm-dd hh24:mi:ss’;
Session altered.
SQL> select *from abc;
DT
——————-
2024-06-16 12:30:46
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 12:32:56 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454)
RMAN> backup as compressed backupset database tag ‘fulldbbackup0617’ plus archivelog tag ‘fulldbbackup0617’;
Starting backup at 16-JUN-24
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=67 instance=cdb3 device type=DISK
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=3 sequence=3 RECID=333 STAMP=1171801697
input archived log thread=3 sequence=4 RECID=334 STAMP=1171801784
input archived log thread=3 sequence=5 RECID=335 STAMP=1171802004
channel ORA_DISK_1: starting piece 1 at 16-JUN-24
channel ORA_DISK_1: finished piece 1 at 16-JUN-24
piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup0617_0.315.1171802005 tag=FULLDBBACKUP0617 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 16-JUN-24
Starting backup at 16-JUN-24
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/CDB/DATAFILE/system.258.1171797291
input datafile file number=00003 name=+DATA/CDB/DATAFILE/sysaux.287.1171797291
input datafile file number=00004 name=+DATA/CDB/DATAFILE/undotbs1.302.1171797291
input datafile file number=00009 name=+DATA/CDB/DATAFILE/undotbs2.290.1171797291
input datafile file number=00010 name=+DATA/CDB/DATAFILE/undotbs3.276.1171797291
input datafile file number=00007 name=+DATA/CDB/DATAFILE/users.259.1171797291
channel ORA_DISK_1: starting piece 1 at 16-JUN-24
channel ORA_DISK_1: finished piece 1 at 16-JUN-24
piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.377.1171802007 tag=FULLDBBACKUP0617 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00011 name=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.296.1171800421
input datafile file number=00012 name=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.289.1171800421
input datafile file number=00013 name=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.259.1171800421
input datafile file number=00014 name=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.338.1171800421
input datafile file number=00015 name=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.345.1171800421
input datafile file number=00016 name=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.347.1171800421
channel ORA_DISK_1: starting piece 1 at 16-JUN-24
channel ORA_DISK_1: finished piece 1 at 16-JUN-24
piece handle=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.381.1171802041 tag=FULLDBBACKUP0617 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.280.1171797313
input datafile file number=00006 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.285.1171797313
input datafile file number=00008 name=+DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.293.1171797313
channel ORA_DISK_1: starting piece 1 at 16-JUN-24
channel ORA_DISK_1: finished piece 1 at 16-JUN-24
piece handle=+DATA1/CDB/0633F844101D69CBE0636401A8C09D55/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.382.1171802067 tag=FULLDBBACKUP0617 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 16-JUN-24
Starting backup at 16-JUN-24
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=3 sequence=6 RECID=336 STAMP=1171802091
channel ORA_DISK_1: starting piece 1 at 16-JUN-24
channel ORA_DISK_1: finished piece 1 at 16-JUN-24
piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/annnf0_fulldbbackup0617_0.384.1171802091 tag=FULLDBBACKUP0617 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 16-JUN-24
Starting Control File and SPFILE Autobackup at 16-JUN-24
piece handle=+DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171802092.388.1171802093 comment=NONE
Finished Control File and SPFILE Autobackup at 16-JUN-24
RMAN> exit
Recovery Manager complete.
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:34:58 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> select *from abc;
select *from abc
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> alter session set container=pdb;
Session altered.
SQL> select *from abc;
DT
———
16-JUN-24
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ export NLS_DATE_FORMAT= ‘yyyy-mm-dd hh24:mi:ss’
-bash: export: `yyyy-mm-dd hh24:mi:ss’: not a valid identifier
[oracle@rac3 ~]$ export NLS_DATE_FORMAT=’yyyy-mm-dd hh24:mi:ss’
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:36:49 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> alter session set container=pdb;
Session altered.
SQL> select *from abc;
DT
———
16-JUN-24
SQL> alter session set nls_date_format = ‘yyyy-mm-dd hh24:mi:ss’;
Session altered.
SQL> select *from abc;
DT
——————-
2024-06-16 12:30:46
SQL> insert into abc select sysdate from dual;
1 row created.
SQL> select *from abc;
DT
——————-
2024-06-16 12:30:46
2024-06-16 12:37:15
SQL> commit;
Commit complete.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:37:47 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> alter pluggable database pdb close abort;
Pluggable database altered.
SQL> drop pluggable datatabase pdb including database;
drop pluggable datatabase pdb including database
*
ERROR at line 1:
ORA-02000: missing DATABASE keyword
SQL> drop pluggable database pdb including database;
drop pluggable database pdb including database
*
ERROR at line 1:
ORA-02000: missing DATAFILES keyword
SQL> drop pluggable database pdb including datafiles;
Pluggable database dropped.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 12:38:49 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454)
RMAN> startup mount force;
Oracle instance started
database mounted
Total System Global Area 2382361320 bytes
Fixed Size 9167592 bytes
Variable Size 922746880 bytes
Database Buffers 1442840576 bytes
Redo Buffers 7606272 bytes
RMAN> show pdbs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found “identifier”: expecting one of: “all, archivelog, auxiliary, auxname, backup, channel, compression, controlfile, datafile, db_unique_name, default, device, encryption, exclude, incremental, maxsetsize, retention, snapshot, “
RMAN-01008: the bad identifier was: pdbs
RMAN-01007: at line 1 column 6 file: standard input
RMAN> exit
Recovery Manager complete.
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:39:45 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> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 12:39:51 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454, not open)
RMAN> flashback database to timestamp to_timestamp(’06/16/2024 12:37:05′, ‘mm/dd/yyyy hh24:mi:ss’);
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found “identifier”: expecting one of: “before, scn, sequence, time”
RMAN-01008: the bad identifier was: timestamp
RMAN-01007: at line 1 column 23 file: standard input
RMAN> exit
Recovery Manager complete.
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:39: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> flashback database to timestamp to_timestamp(’06/16/2024 12:37:05′, ‘mm/dd/yyyy hh24:mi:ss’);
flashback database to timestamp to_timestamp(’06/16/2024 12:37:05′, ‘mm/dd/yyyy hh24:mi:ss’)
*
ERROR at line 1:
ORA-38729: Not enough flashback database log data to do FLASHBACK.
SQL> flashback database to timestamp to_timestamp(’06/16/2024 12:37:00′, ‘mm/dd/yyyy hh24:mi:ss’);
flashback database to timestamp to_timestamp(’06/16/2024 12:37:00′, ‘mm/dd/yyyy hh24:mi:ss’)
*
ERROR at line 1:
ORA-38729: Not enough flashback database log data to do FLASHBACK.
SQL> flashback database to timestamp to_timestamp(’06/16/2024 12:30:00′, ‘mm/dd/yyyy hh24:mi:ss’);
flashback database to timestamp to_timestamp(’06/16/2024 12:30:00′, ‘mm/dd/yyyy hh24:mi:ss’)
*
ERROR at line 1:
ORA-38729: Not enough flashback database log data to do FLASHBACK.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:42:41 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> startup mount force;
ORACLE instance started.
Total System Global Area 2382361320 bytes
Fixed Size 9167592 bytes
Variable Size 922746880 bytes
Database Buffers 1442840576 bytes
Redo Buffers 7606272 bytes
Database mounted.
SQL> alter session set nls_date_format = ‘yyyy-mm-dd hh24:mi:ss’;
Session altered.
SQL> select sysdate from dual;
SYSDATE
——————-
2024-06-16 12:43:14
SQL> flashback database to timestamp to_date(’06/16/2024 12:37:05′, ‘mm/dd/yyyy hh24:mi:ss’);
flashback database to timestamp to_date(’06/16/2024 12:37:05′, ‘mm/dd/yyyy hh24:mi:ss’)
*
ERROR at line 1:
ORA-38729: Not enough flashback database log data to do FLASHBACK.
SQL> flashback database to timestamp “to_date(’16-JUN-2024 12:37:00′,’DD-MON-YYYY HH24:MI:SS’)”;
flashback database to timestamp “to_date(’16-JUN-2024 12:37:00′,’DD-MON-YYYY HH24:MI:SS’)”
*
ERROR at line 1:
ORA-38730: Invalid SCN/TIMESTAMP expression.
SQL> flashback database to timestamp “to_date(’16-JUN-2024 12:37:00′,’DD-MON-YYYY HH24:MI:SS’)”;
flashback database to timestamp “to_date(’16-JUN-2024 12:37:00′,’DD-MON-YYYY HH24:MI:SS’)”
*
ERROR at line 1:
ORA-38730: Invalid SCN/TIMESTAMP expression.
SQL> flashback database to timestamp to_date(’16-JUN-2024 12:37:00′,’DD-MON-YYYY HH24:MI:SS’);
flashback database to timestamp to_date(’16-JUN-2024 12:37:00′,’DD-MON-YYYY HH24:MI:SS’)
*
ERROR at line 1:
ORA-38729: Not enough flashback database log data to do FLASHBACK.
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> SELECT FLASHBACK_ON FROM V$DATABASE;
FLASHBACK_ON
——————
YES
SQL> flashback database to timestamp sysdate -0.1;
flashback database to timestamp sysdate -0.1
*
ERROR at line 1:
ORA-38796: Not enough flashback database log data to undo FLASHBACK.
SQL> flashback database to timestamp sysdate -0.01;
flashback database to timestamp sysdate -0.01
*
ERROR at line 1:
ORA-38729: Not enough flashback database log data to do FLASHBACK.
SQL> flashback database to timestamp sysdate -0.0001;
flashback database to timestamp sysdate -0.0001
*
ERROR at line 1:
ORA-38729: Not enough flashback database log data to do FLASHBACK.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$
[oracle@rac3 ~]$
[oracle@rac3 ~]$
[oracle@rac3 ~]$
[oracle@rac3 ~]$
[oracle@rac3 ~]$
[oracle@rac3 ~]$
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:46:03 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> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:46:34 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>
SQL> recover pluggable database pdb until time “to_date(’16-JUN-2024 12:35:46′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
ORA-00905: missing keyword
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 12:47:33 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454, not open)
RMAN> recover pluggable database pdb until time “to_date(’16-JUN-2024 12:35:46′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
Starting recover at 2024-06-16 12:47:34
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 12:47:35
RMAN-06617: UNTIL TIME (2024-06-16 12:35:46) is ahead of last NEXT TIME in archived logs (2024-06-16 12:34:51)
RMAN> recover pluggable database pdb ;
Starting recover at 2024-06-16 12:47:50
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=796 instance=cdb3 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 12:47:50
RMAN-06813: could not translate pluggable database PDB
RMAN> recover pluggable database pdb auxiliary destination ‘+data1’;
Starting recover at 2024-06-16 12:48:04
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 12:48:04
RMAN-05020: cannot specify AUXILIARY DESTINATION option for normal recovery
RMAN> recover pluggable database pdb until time “to_date(’16-JUN-2024 12:37:46′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
Starting recover at 2024-06-16 12:48:27
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 12:48:27
RMAN-06617: UNTIL TIME (2024-06-16 12:37:46) is ahead of last NEXT TIME in archived logs (2024-06-16 12:34:51)
RMAN> recover pluggable database pdb until time “to_date(’16-JUN-2024 12:30:46′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
Starting recover at 2024-06-16 12:48:45
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 12:48:45
RMAN-05101: Point-in-Time Recovery without CATALOG and TARGET not open requires that UNDO TABLESPACE is specified
RMAN> report schema;
Report of database schema for database with db_unique_name CDB
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
—- ——– ——————– ——- ————————
1 1170 SYSTEM *** +DATA/CDB/DATAFILE/system.258.1171797291
3 910 SYSAUX *** +DATA/CDB/DATAFILE/sysaux.287.1171797291
4 615 UNDOTBS1 *** +DATA/CDB/DATAFILE/undotbs1.302.1171797291
5 510 PDB$SEED:SYSTEM *** +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/system.280.1171797313
6 480 PDB$SEED:SYSAUX *** +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/sysaux.285.1171797313
7 5 USERS *** +DATA/CDB/DATAFILE/users.259.1171797291
8 215 PDB$SEED:UNDOTBS1 *** +DATA/CDB/0633F844101D69CBE0636401A8C09D55/DATAFILE/undotbs1.293.1171797313
9 250 UNDOTBS2 *** +DATA/CDB/DATAFILE/undotbs2.290.1171797291
10 75 UNDOTBS3 *** +DATA/CDB/DATAFILE/undotbs3.276.1171797291
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
—- ——– ——————– ———– ——————–
1 24 TEMP 32767 +DATA/CDB/TEMPFILE/temp.347.1171775247
2 36 PDB$SEED:TEMP 32767 +DATA/CDB/0633F844101D69CBE0636401A8C09D55/TEMPFILE/temp.279.1171775251
RMAN> recover pluggable database pdb until time “to_date(’16-JUN-2024 12:00:46′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
Starting recover at 2024-06-16 12:49:41
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 12:49:41
RMAN-05101: Point-in-Time Recovery without CATALOG and TARGET not open requires that UNDO TABLESPACE is specified
RMAN> recover pluggable database pdb until time “to_date(’16-JUN-2024 11:00:46′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
Starting recover at 2024-06-16 12:49:52
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 12:49:52
RMAN-05101: Point-in-Time Recovery without CATALOG and TARGET not open requires that UNDO TABLESPACE is specified
RMAN> exit
Recovery Manager complete.
[oracle@rac3 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 12:50:07 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454, not open)
RMAN> exit
Recovery Manager complete.
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:50:12 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;
Database altered.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 12:50:42 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454)
RMAN> exit
Recovery Manager complete.
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:51:01 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> flashback database to timestamp to_date(’06/16/2024 12:37:05′, ‘mm/dd/yyyy hh24:mi:ss’);
flashback database to timestamp to_date(’06/16/2024 12:37:05′, ‘mm/dd/yyyy hh24:mi:ss’)
*
ERROR at line 1:
ORA-38757: Database must be mounted and not open to FLASHBACK.
SQL> startup mount force;
ORACLE instance started.
Total System Global Area 2382361320 bytes
Fixed Size 9167592 bytes
Variable Size 922746880 bytes
Database Buffers 1442840576 bytes
Redo Buffers 7606272 bytes
Database mounted.
SQL> flashback database to timestamp to_date(’06/16/2024 12:37:05′, ‘mm/dd/yyyy hh24:mi:ss’);
flashback database to timestamp to_date(’06/16/2024 12:37:05′, ‘mm/dd/yyyy hh24:mi:ss’)
*
ERROR at line 1:
ORA-38729: Not enough flashback database log data to do FLASHBACK.
SQL> startup force;
ORACLE instance started.
Total System Global Area 2382361320 bytes
Fixed Size 9167592 bytes
Variable Size 922746880 bytes
Database Buffers 1442840576 bytes
Redo Buffers 7606272 bytes
exit
rman target /
Database mounted.
Database opened.
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 12:51:52 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454)
RMAN> recover pluggable database pdb until time “to_date(’16-JUN-2024 12:00:46′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
Starting recover at 2024-06-16 12:51:59
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=57 instance=cdb3 device type=DISK
RMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time
List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace UNDOTBS1
Tablespace UNDOTBS2
Tablespace UNDOTBS3
Creating automatic instance, with SID=’skFo’
initialization parameters used for automatic instance:
db_name=CDB
db_unique_name=skFo_pitr_pdb_CDB
compatible=19.0.0
db_block_size=8192
db_files=200
diagnostic_dest=/u01/app/oracle
_pdb_name_case_sensitive=false
_system_trig_enabled=FALSE
db_domain=cj.com
sga_target=2272M
processes=200
db_create_file_dest=+data1
log_archive_dest_1=’location=+data1′
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used
starting up automatic instance CDB
Oracle instance started
Total System Global Area 2382363816 bytes
Fixed Size 9165992 bytes
Variable Size 520093696 bytes
Database Buffers 1845493760 bytes
Redo Buffers 7610368 bytes
Automatic instance created
contents of Memory Script:
{
# set requested point in time
set until time “to_date(’16-JUN-2024 12:00:46′,’DD-MON-YYYY HH24:MI:SS’)”;
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone ‘alter database mount clone database’;
}
executing Memory Script
executing command: SET until clause
Starting restore at 2024-06-16 12:52:09
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=184 device type=DISK
Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 12:52:10
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found – aborting restore
RMAN-06024: no backup or copy of the control file found to restore
RMAN> recover pluggable database pdb until time “to_date(’16-JUN-2024 12:37:46′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
Starting recover at 2024-06-16 12:52:25
using channel ORA_DISK_1
RMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time
List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace UNDOTBS1
Tablespace UNDOTBS2
Tablespace UNDOTBS3
Creating automatic instance, with SID=’blbv’
initialization parameters used for automatic instance:
db_name=CDB
db_unique_name=blbv_pitr_pdb_CDB
compatible=19.0.0
db_block_size=8192
db_files=200
diagnostic_dest=/u01/app/oracle
_pdb_name_case_sensitive=false
_system_trig_enabled=FALSE
db_domain=cj.com
sga_target=2272M
processes=200
db_create_file_dest=+data1
log_archive_dest_1=’location=+data1′
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used
starting up automatic instance CDB
Oracle instance started
Total System Global Area 2382363816 bytes
Fixed Size 9165992 bytes
Variable Size 520093696 bytes
Database Buffers 1845493760 bytes
Redo Buffers 7610368 bytes
Automatic instance created
contents of Memory Script:
{
# set requested point in time
set until time “to_date(’16-JUN-2024 12:37:46′,’DD-MON-YYYY HH24:MI:SS’)”;
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone ‘alter database mount clone database’;
}
executing Memory Script
executing command: SET until clause
Starting restore at 2024-06-16 12:52:33
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=25 device type=DISK
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171802092.388.1171802093
channel ORA_AUX_DISK_1: piece handle=+DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171802092.388.1171802093 tag=TAG20240616T123452
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
output file name=+DATA1/CDB/CONTROLFILE/current.338.1171803157
Finished restore at 2024-06-16 12:52:37
sql statement: alter database mount clone database
contents of Memory Script:
{
# set requested point in time
set until time “to_date(’16-JUN-2024 12:37:46′,’DD-MON-YYYY HH24:MI:SS’)”;
# set destinations for recovery set and auxiliary set datafiles
set newname for clone datafile 1 to new;
set newname for clone datafile 4 to new;
set newname for clone datafile 9 to new;
set newname for clone datafile 10 to new;
set newname for clone datafile 3 to new;
set newname for clone datafile 7 to new;
set newname for datafile 11 to new;
set newname for datafile 12 to new;
set newname for datafile 13 to new;
set newname for datafile 14 to new;
set newname for datafile 15 to new;
set newname for datafile 16 to new;
# restore the tablespaces in the recovery set and the auxiliary set
restore clone datafile 1, 4, 9, 10, 3, 7, 11, 12, 13, 14, 15, 16;
switch clone datafile all;
}
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
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 2024-06-16 12:52:41
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 00004 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: restoring datafile 00003 to +data1
channel ORA_AUX_DISK_1: restoring datafile 00007 to +data1
channel ORA_AUX_DISK_1: reading from backup piece +DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.377.1171802007
channel ORA_AUX_DISK_1: piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.377.1171802007 tag=FULLDBBACKUP0617
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 00011 to +DATA
channel ORA_AUX_DISK_1: restoring datafile 00012 to +DATA
channel ORA_AUX_DISK_1: restoring datafile 00013 to +DATA
channel ORA_AUX_DISK_1: restoring datafile 00014 to +DATA
channel ORA_AUX_DISK_1: restoring datafile 00015 to +DATA
channel ORA_AUX_DISK_1: restoring datafile 00016 to +DATA
channel ORA_AUX_DISK_1: reading from backup piece +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.381.1171802041
channel ORA_AUX_DISK_1: piece handle=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.381.1171802041 tag=FULLDBBACKUP0617
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25
Finished restore at 2024-06-16 12:53:52
datafile 11 switched to datafile copy
input datafile copy RECID=37 STAMP=1171803232 file name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.301.1171803207
datafile 12 switched to datafile copy
input datafile copy RECID=38 STAMP=1171803232 file name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.266.1171803207
datafile 13 switched to datafile copy
input datafile copy RECID=39 STAMP=1171803232 file name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.274.1171803207
datafile 14 switched to datafile copy
input datafile copy RECID=40 STAMP=1171803232 file name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.286.1171803207
datafile 15 switched to datafile copy
input datafile copy RECID=41 STAMP=1171803232 file name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.270.1171803207
datafile 16 switched to datafile copy
input datafile copy RECID=42 STAMP=1171803232 file name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.261.1171803207
datafile 1 switched to datafile copy
input datafile copy RECID=43 STAMP=1171803232 file name=+DATA1/CDB/DATAFILE/system.345.1171803163
datafile 4 switched to datafile copy
input datafile copy RECID=44 STAMP=1171803232 file name=+DATA1/CDB/DATAFILE/undotbs1.270.1171803163
datafile 9 switched to datafile copy
input datafile copy RECID=45 STAMP=1171803232 file name=+DATA1/CDB/DATAFILE/undotbs2.257.1171803163
datafile 10 switched to datafile copy
input datafile copy RECID=46 STAMP=1171803232 file name=+DATA1/CDB/DATAFILE/undotbs3.291.1171803163
datafile 3 switched to datafile copy
input datafile copy RECID=47 STAMP=1171803232 file name=+DATA1/CDB/DATAFILE/sysaux.347.1171803163
datafile 7 switched to datafile copy
input datafile copy RECID=48 STAMP=1171803232 file name=+DATA1/CDB/DATAFILE/users.264.1171803163
contents of Memory Script:
{
# set requested point in time
set until time “to_date(’16-JUN-2024 12:37:46′,’DD-MON-YYYY HH24:MI:SS’)”;
# online the datafiles restored or switched
sql clone “alter database datafile 1 online”;
sql clone “alter database datafile 4 online”;
sql clone “alter database datafile 9 online”;
sql clone “alter database datafile 10 online”;
sql clone “alter database datafile 3 online”;
sql clone “alter database datafile 7 online”;
sql clone ‘PDB’ “alter database datafile
11 online”;
sql clone ‘PDB’ “alter database datafile
12 online”;
sql clone ‘PDB’ “alter database datafile
13 online”;
sql clone ‘PDB’ “alter database datafile
14 online”;
sql clone ‘PDB’ “alter database datafile
15 online”;
sql clone ‘PDB’ “alter database datafile
16 online”;
#recover pdb
recover clone database tablespace “SYSTEM”, “UNDOTBS1”, “UNDOTBS2”, “UNDOTBS3”, “SYSAUX”, “USERS” pluggable database
‘PDB’ delete archivelog;
#open in read write mode
sql clone ‘alter database open resetlogs’;
#unplug dropped pdb into temp file
sql clone “alter pluggable database PDB unplug into ”
/u01/app/oracle/product/19.0.0/db_1/dbs/_rm_pdb_pitr_8_blbv.xml””;
#create pdb using temp file of recovered pdb
sql “create pluggable database PDB using ”
/u01/app/oracle/product/19.0.0/db_1/dbs/_rm_pdb_pitr_8_blbv.xml” nocopy tempfile reuse”;
alter pluggable database PDB open;
}
executing Memory Script
executing command: SET until clause
sql statement: alter database datafile 1 online
sql statement: alter database datafile 4 online
sql statement: alter database datafile 9 online
sql statement: alter database datafile 10 online
sql statement: alter database datafile 3 online
sql statement: alter database datafile 7 online
sql statement: alter database datafile 11 online
sql statement: alter database datafile 12 online
sql statement: alter database datafile 13 online
sql statement: alter database datafile 14 online
sql statement: alter database datafile 15 online
sql statement: alter database datafile 16 online
Starting recover at 2024-06-16 12:53:53
using channel ORA_AUX_DISK_1
Executing: alter database datafile 5, 6, 8 offline
starting media recovery
archived log for thread 3 with sequence 6 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_6.383.1171802091
archived log for thread 3 with sequence 7 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_7.296.1171803027
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_6.383.1171802091 thread=3 sequence=6
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_7.296.1171803027 thread=3 sequence=7
media recovery complete, elapsed time: 00:00:01
Finished recover at 2024-06-16 12:53:55
sql statement: alter database open resetlogs
sql statement: alter pluggable database PDB unplug into ”/u01/app/oracle/product/19.0.0/db_1/dbs/_rm_pdb_pitr_8_blbv.xml”
sql statement: create pluggable database PDB using ”/u01/app/oracle/product/19.0.0/db_1/dbs/_rm_pdb_pitr_8_blbv.xml” nocopy tempfile reuse
Statement processed
Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
auxiliary instance file /u01/app/oracle/product/19.0.0/db_1/dbs/_rm_pdb_pitr_8_blbv.xml deleted
auxiliary instance file +DATA1/CDB/DATAFILE/sysaux.347.1171803163 deleted
auxiliary instance file +DATA1/CDB/CONTROLFILE/current.338.1171803157 deleted
Finished recover at 2024-06-16 12:54:24
RMAN> exit
Recovery Manager complete.
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:54:27 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 READ ONLY NO
3 PDB READ WRITE NO
SQL> alter session set container=pdb;
Session altered.
SQL> select *from abc;
DT
———
16-JUN-24
16-JUN-24
SQL> alter session set nls_date_format = ‘yyyy-mm-dd hh24:mi:ss’;
Session altered.
SQL> select *from abc;
DT
——————-
2024-06-16 12:30:46
2024-06-16 12:37:15
SQL> alter pluggable database pdb close abort;
Pluggable database altered.
SQL> drop pluggable databsae pdb including datafiles;
drop pluggable databsae pdb including datafiles
*
ERROR at line 1:
ORA-02000: missing DATABASE keyword
SQL> drop pluggable database pdb including datafiles
2 ;
drop pluggable database pdb including datafiles
*
ERROR at line 1:
ORA-01109: database not open
SQL> drop pluggable database pdb including datafiles;
drop pluggable database pdb including datafiles
*
ERROR at line 1:
ORA-01109: database not open
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
3 PDB MOUNTED
SQL> drop pluggable database pdb including datafiles;
drop pluggable database pdb including datafiles
*
ERROR at line 1:
ORA-01109: database not open
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:57:02 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> drop pluggable database pdb including datafiles;
Pluggable database dropped.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 12:57:11 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454)
RMAN> recover pluggable database pdb until time “to_date(’16-JUN-2024 12:37:00′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
Starting recover at 2024-06-16 12:57:38
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=69 instance=cdb3 device type=DISK
RMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time
List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace UNDOTBS1
Tablespace UNDOTBS2
Tablespace UNDOTBS3
Creating automatic instance, with SID=’brxB’
initialization parameters used for automatic instance:
db_name=CDB
db_unique_name=brxB_pitr_pdb_CDB
compatible=19.0.0
db_block_size=8192
db_files=200
diagnostic_dest=/u01/app/oracle
_pdb_name_case_sensitive=false
_system_trig_enabled=FALSE
db_domain=cj.com
sga_target=2272M
processes=200
db_create_file_dest=+data1
log_archive_dest_1=’location=+data1′
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used
starting up automatic instance CDB
Oracle instance started
Total System Global Area 2382363816 bytes
Fixed Size 9165992 bytes
Variable Size 520093696 bytes
Database Buffers 1845493760 bytes
Redo Buffers 7610368 bytes
Automatic instance created
contents of Memory Script:
{
# set requested point in time
set until time “to_date(’16-JUN-2024 12:37:00′,’DD-MON-YYYY HH24:MI:SS’)”;
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone ‘alter database mount clone database’;
}
executing Memory Script
executing command: SET until clause
Starting restore at 2024-06-16 12:57:47
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=25 device type=DISK
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece +DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171802092.388.1171802093
channel ORA_AUX_DISK_1: piece handle=+DATA1/CDB/AUTOBACKUP/2024_06_16/s_1171802092.388.1171802093 tag=TAG20240616T123452
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
output file name=+DATA1/CDB/CONTROLFILE/current.338.1171803469
Finished restore at 2024-06-16 12:57:50
sql statement: alter database mount clone database
contents of Memory Script:
{
# set requested point in time
set until time “to_date(’16-JUN-2024 12:37:00′,’DD-MON-YYYY HH24:MI:SS’)”;
# set destinations for recovery set and auxiliary set datafiles
set newname for clone datafile 1 to new;
set newname for clone datafile 4 to new;
set newname for clone datafile 9 to new;
set newname for clone datafile 10 to new;
set newname for clone datafile 3 to new;
set newname for clone datafile 7 to new;
set newname for datafile 11 to new;
set newname for datafile 12 to new;
set newname for datafile 13 to new;
set newname for datafile 14 to new;
set newname for datafile 15 to new;
set newname for datafile 16 to new;
# restore the tablespaces in the recovery set and the auxiliary set
restore clone datafile 1, 4, 9, 10, 3, 7, 11, 12, 13, 14, 15, 16;
switch clone datafile all;
}
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
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 2024-06-16 12:57:55
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 00004 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: restoring datafile 00003 to +data1
channel ORA_AUX_DISK_1: restoring datafile 00007 to +data1
channel ORA_AUX_DISK_1: reading from backup piece +DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.377.1171802007
channel ORA_AUX_DISK_1: piece handle=+DATA1/CDB/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.377.1171802007 tag=FULLDBBACKUP0617
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 00011 to +DATA
channel ORA_AUX_DISK_1: restoring datafile 00012 to +DATA
channel ORA_AUX_DISK_1: restoring datafile 00013 to +DATA
channel ORA_AUX_DISK_1: restoring datafile 00014 to +DATA
channel ORA_AUX_DISK_1: restoring datafile 00015 to +DATA
channel ORA_AUX_DISK_1: restoring datafile 00016 to +DATA
channel ORA_AUX_DISK_1: reading from backup piece +DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.381.1171802041
channel ORA_AUX_DISK_1: piece handle=+DATA1/CDB/06344F62B8C65A17E0636401A8C0F073/BACKUPSET/2024_06_16/nnndf0_fulldbbackup0617_0.381.1171802041 tag=FULLDBBACKUP0617
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 2024-06-16 12:59:15
datafile 11 switched to datafile copy
input datafile copy RECID=37 STAMP=1171803556 file name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/system.301.1171803521
datafile 12 switched to datafile copy
input datafile copy RECID=38 STAMP=1171803556 file name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/sysaux.266.1171803521
datafile 13 switched to datafile copy
input datafile copy RECID=39 STAMP=1171803556 file name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undotbs1.274.1171803521
datafile 14 switched to datafile copy
input datafile copy RECID=40 STAMP=1171803556 file name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_3.286.1171803521
datafile 15 switched to datafile copy
input datafile copy RECID=41 STAMP=1171803556 file name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/undo_4.270.1171803521
datafile 16 switched to datafile copy
input datafile copy RECID=42 STAMP=1171803556 file name=+DATA/CDB/06344F62B8C65A17E0636401A8C0F073/DATAFILE/users.261.1171803521
datafile 1 switched to datafile copy
input datafile copy RECID=43 STAMP=1171803556 file name=+DATA1/CDB/DATAFILE/system.347.1171803475
datafile 4 switched to datafile copy
input datafile copy RECID=44 STAMP=1171803556 file name=+DATA1/CDB/DATAFILE/undotbs1.303.1171803475
datafile 9 switched to datafile copy
input datafile copy RECID=45 STAMP=1171803556 file name=+DATA1/CDB/DATAFILE/undotbs2.304.1171803475
datafile 10 switched to datafile copy
input datafile copy RECID=46 STAMP=1171803556 file name=+DATA1/CDB/DATAFILE/undotbs3.392.1171803475
datafile 3 switched to datafile copy
input datafile copy RECID=47 STAMP=1171803556 file name=+DATA1/CDB/DATAFILE/sysaux.317.1171803475
datafile 7 switched to datafile copy
input datafile copy RECID=48 STAMP=1171803556 file name=+DATA1/CDB/DATAFILE/users.276.1171803475
contents of Memory Script:
{
# set requested point in time
set until time “to_date(’16-JUN-2024 12:37:00′,’DD-MON-YYYY HH24:MI:SS’)”;
# online the datafiles restored or switched
sql clone “alter database datafile 1 online”;
sql clone “alter database datafile 4 online”;
sql clone “alter database datafile 9 online”;
sql clone “alter database datafile 10 online”;
sql clone “alter database datafile 3 online”;
sql clone “alter database datafile 7 online”;
sql clone ‘PDB’ “alter database datafile
11 online”;
sql clone ‘PDB’ “alter database datafile
12 online”;
sql clone ‘PDB’ “alter database datafile
13 online”;
sql clone ‘PDB’ “alter database datafile
14 online”;
sql clone ‘PDB’ “alter database datafile
15 online”;
sql clone ‘PDB’ “alter database datafile
16 online”;
#recover pdb
recover clone database tablespace “SYSTEM”, “UNDOTBS1”, “UNDOTBS2”, “UNDOTBS3”, “SYSAUX”, “USERS” pluggable database
‘PDB’ delete archivelog;
#open in read write mode
sql clone ‘alter database open resetlogs’;
#unplug dropped pdb into temp file
sql clone “alter pluggable database PDB unplug into ”
/u01/app/oracle/product/19.0.0/db_1/dbs/_rm_pdb_pitr_1_brxB.xml””;
#create pdb using temp file of recovered pdb
sql “create pluggable database PDB using ”
/u01/app/oracle/product/19.0.0/db_1/dbs/_rm_pdb_pitr_1_brxB.xml” nocopy tempfile reuse”;
alter pluggable database PDB open;
}
executing Memory Script
executing command: SET until clause
sql statement: alter database datafile 1 online
sql statement: alter database datafile 4 online
sql statement: alter database datafile 9 online
sql statement: alter database datafile 10 online
sql statement: alter database datafile 3 online
sql statement: alter database datafile 7 online
sql statement: alter database datafile 11 online
sql statement: alter database datafile 12 online
sql statement: alter database datafile 13 online
sql statement: alter database datafile 14 online
sql statement: alter database datafile 15 online
sql statement: alter database datafile 16 online
Starting recover at 2024-06-16 12:59:16
using channel ORA_AUX_DISK_1
Executing: alter database datafile 5, 6, 8 offline
starting media recovery
archived log for thread 3 with sequence 6 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_6.383.1171802091
archived log for thread 3 with sequence 7 is already on disk as file +DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_7.296.1171803027
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_6.383.1171802091 thread=3 sequence=6
archived log file name=+DATA1/CDB/ARCHIVELOG/2024_06_16/thread_3_seq_7.296.1171803027 thread=3 sequence=7
media recovery complete, elapsed time: 00:00:00
Finished recover at 2024-06-16 12:59:18
sql statement: alter database open resetlogs
sql statement: alter pluggable database PDB unplug into ”/u01/app/oracle/product/19.0.0/db_1/dbs/_rm_pdb_pitr_1_brxB.xml”
sql statement: create pluggable database PDB using ”/u01/app/oracle/product/19.0.0/db_1/dbs/_rm_pdb_pitr_1_brxB.xml” nocopy tempfile reuse
Statement processed
Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
auxiliary instance file /u01/app/oracle/product/19.0.0/db_1/dbs/_rm_pdb_pitr_1_brxB.xml deleted
auxiliary instance file +DATA1/CDB/DATAFILE/sysaux.317.1171803475 deleted
auxiliary instance file +DATA1/CDB/CONTROLFILE/current.338.1171803469 deleted
Finished recover at 2024-06-16 12:59:38
RMAN> exit
Recovery Manager complete.
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 12:59:41 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> alter session set nls_date_format = ‘yyyy-mm-dd hh24:mi:ss’;
Session altered.
SQL> alter session set container=pdb;
Session altered.
SQL> select *from abc;
DT
——————-
2024-06-16 12:30:46
SQL> alter pluggable database pdb close abort;
Pluggable database altered.
SQL> drop pluggable database pdb including datafiles;
drop pluggable database pdb including datafiles
*
ERROR at line 1:
ORA-01109: database not open
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ s
SQL*Plus: Release 19.0.0.0.0 – Production on Sun Jun 16 13:01:15 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> drop pluggable database pdb including datafiles;
Pluggable database dropped.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.20.0.0.0
[oracle@rac3 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 – Production on Sun Jun 16 13:01:27 2024
Version 19.20.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB (DBID=2265125454)
RMAN> show pdbs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found “identifier”: expecting one of: “all, archivelog, auxiliary, auxname, backup, channel, compression, controlfile, datafile, db_unique_name, default, device, encryption, exclude, incremental, maxsetsize, retention, snapshot, “
RMAN-01008: the bad identifier was: pdbs
RMAN-01007: at line 1 column 6 file: standard input
RMAN> recover pluggable database pdb until time “to_date(’16-JUN-2024 12:30:00′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
Starting recover at 2024-06-16 13:02:08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=72 instance=cdb3 device type=DISK
RMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time
List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace UNDOTBS1
Tablespace UNDOTBS2
Tablespace UNDOTBS3
Creating automatic instance, with SID=’ygCB’
initialization parameters used for automatic instance:
db_name=CDB
db_unique_name=ygCB_pitr_pdb_CDB
compatible=19.0.0
db_block_size=8192
db_files=200
diagnostic_dest=/u01/app/oracle
_pdb_name_case_sensitive=false
_system_trig_enabled=FALSE
db_domain=cj.com
sga_target=2272M
processes=200
db_create_file_dest=+data1
log_archive_dest_1=’location=+data1′
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used
starting up automatic instance CDB
Oracle instance started
Total System Global Area 2382363816 bytes
Fixed Size 9165992 bytes
Variable Size 520093696 bytes
Database Buffers 1845493760 bytes
Redo Buffers 7610368 bytes
Automatic instance created
contents of Memory Script:
{
# set requested point in time
set until time “to_date(’16-JUN-2024 12:30:00′,’DD-MON-YYYY HH24:MI:SS’)”;
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone ‘alter database mount clone database’;
}
executing Memory Script
executing command: SET until clause
Starting restore at 2024-06-16 13:02:16
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=23 device type=DISK
Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 13:02:17
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found – aborting restore
RMAN-06101: no channel to restore a backup or copy of the control file
RMAN> recover pluggable database pdb until time “to_date(’16-JUN-2024 12:31:00′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
Starting recover at 2024-06-16 13:02:28
using channel ORA_DISK_1
RMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time
List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace UNDOTBS1
Tablespace UNDOTBS2
Tablespace UNDOTBS3
Creating automatic instance, with SID=’DAlo’
initialization parameters used for automatic instance:
db_name=CDB
db_unique_name=DAlo_pitr_pdb_CDB
compatible=19.0.0
db_block_size=8192
db_files=200
diagnostic_dest=/u01/app/oracle
_pdb_name_case_sensitive=false
_system_trig_enabled=FALSE
db_domain=cj.com
sga_target=2272M
processes=200
db_create_file_dest=+data1
log_archive_dest_1=’location=+data1′
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used
starting up automatic instance CDB
Oracle instance started
Total System Global Area 2382363816 bytes
Fixed Size 9165992 bytes
Variable Size 520093696 bytes
Database Buffers 1845493760 bytes
Redo Buffers 7610368 bytes
Automatic instance created
contents of Memory Script:
{
# set requested point in time
set until time “to_date(’16-JUN-2024 12:31:00′,’DD-MON-YYYY HH24:MI:SS’)”;
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone ‘alter database mount clone database’;
}
executing Memory Script
executing command: SET until clause
Starting restore at 2024-06-16 13:02:36
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=23 device type=DISK
Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 13:02:38
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found – aborting restore
RMAN-06101: no channel to restore a backup or copy of the control file
RMAN> run{
2> allocate channel ch00 device type ‘SBT_TAPE’
3> PARMS=”SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)”;
5> recover pluggable database pdb until time “to_date(’16-JUN-2024 12:31:00′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
6> }
released channel: ORA_DISK_1
allocated channel: ch00
channel ch00: SID=72 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API
Starting recover at 2024-06-16 13:03:18
RMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time
List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace UNDOTBS1
Tablespace UNDOTBS2
Tablespace UNDOTBS3
Creating automatic instance, with SID=’BCpD’
initialization parameters used for automatic instance:
db_name=CDB
db_unique_name=BCpD_pitr_pdb_CDB
compatible=19.0.0
db_block_size=8192
db_files=200
diagnostic_dest=/u01/app/oracle
_pdb_name_case_sensitive=false
_system_trig_enabled=FALSE
db_domain=cj.com
sga_target=2272M
processes=200
db_create_file_dest=+data1
log_archive_dest_1=’location=+data1′
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used
starting up automatic instance CDB
Oracle instance started
Total System Global Area 2382363816 bytes
Fixed Size 9165992 bytes
Variable Size 520093696 bytes
Database Buffers 1845493760 bytes
Redo Buffers 7610368 bytes
Automatic instance created
contents of Memory Script:
{
# set requested point in time
set until time “to_date(’16-JUN-2024 12:31:00′,’DD-MON-YYYY HH24:MI:SS’)”;
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone ‘alter database mount clone database’;
}
executing Memory Script
executing command: SET until clause
Starting restore at 2024-06-16 13:03:26
Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 13:03:27
RMAN-03015: error occurred in stored script Memory Script
RMAN-06034: at least 1 channel must be allocated to execute this command
RMAN> run{
2> allocate channel ch00 device type ‘SBT_TAPE’
3> PARMS=”SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)”;
5> allocate channel ch0 type sbt;
6> recover pluggable database pdb until time “to_date(’16-JUN-2024 12:31:00′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
7> }
allocated channel: ch00
channel ch00: SID=72 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on ch0 channel at 06/16/2024 13:04:10
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 2
RMAN> run{
2> allocate channel ch00 device type ‘SBT_TAPE’
3> PARMS=”SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)”;
5> allocate channel ch0 type tape;
6> recover pluggable database pdb until time “to_date(’16-JUN-2024 12:31:00′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
7> }
allocated channel: ch00
channel ch00: SID=72 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on ch0 channel at 06/16/2024 13:04:32
ORA-19554: error allocating device, device type: TAPE, device name:
ORA-27001: unsupported device type
RMAN> run{
2> allocate channel ch00 device type ‘SBT_TAPE’
3> PARMS=”SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)”;
5> allocate channel ch0 type sbt;
6> allocate channel d0 type sbt;
7> recover pluggable database pdb until time “to_date(’16-JUN-2024 12:31:00′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
8> }
allocated channel: ch00
channel ch00: SID=72 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on ch0 channel at 06/16/2024 13:04:50
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 2
RMAN> run{
2> allocate channel ch00 device type ‘SBT_TAPE’
3> PARMS=”SBT_LIBRARY=oracle.disksbt,
4> ENV=(BACKUP_DIR=/nfs)”;
5> allocate channel d0 device type disk;
6> recover pluggable database pdb until time “to_date(’16-JUN-2024 12:31:00′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
7> }
allocated channel: ch00
channel ch00: SID=72 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API
allocated channel: d0
channel d0: SID=794 instance=cdb3 device type=DISK
Starting recover at 2024-06-16 13:05:21
RMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time
List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace UNDOTBS1
Tablespace UNDOTBS2
Tablespace UNDOTBS3
Creating automatic instance, with SID=’CDtg’
initialization parameters used for automatic instance:
db_name=CDB
db_unique_name=CDtg_pitr_pdb_CDB
compatible=19.0.0
db_block_size=8192
db_files=200
diagnostic_dest=/u01/app/oracle
_pdb_name_case_sensitive=false
_system_trig_enabled=FALSE
db_domain=cj.com
sga_target=2272M
processes=200
db_create_file_dest=+data1
log_archive_dest_1=’location=+data1′
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used
starting up automatic instance CDB
Oracle instance started
Total System Global Area 2382363816 bytes
Fixed Size 9165992 bytes
Variable Size 520093696 bytes
Database Buffers 1845493760 bytes
Redo Buffers 7610368 bytes
Automatic instance created
contents of Memory Script:
{
# set requested point in time
set until time “to_date(’16-JUN-2024 12:31:00′,’DD-MON-YYYY HH24:MI:SS’)”;
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone ‘alter database mount clone database’;
}
executing Memory Script
executing command: SET until clause
Starting restore at 2024-06-16 13:05:28
Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
released channel: ch00
released channel: d0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 13:05:29
RMAN-03015: error occurred in stored script Memory Script
RMAN-06034: at least 1 channel must be allocated to execute this command
RMAN> run{
2> allocate channel d0 device type disk;
3> allocate channel ch00 device type ‘SBT_TAPE’
4> PARMS=”SBT_LIBRARY=oracle.disksbt,
5> ENV=(BACKUP_DIR=/nfs)”;
6> recover pluggable database pdb until time “to_date(’16-JUN-2024 12:31:00′,’DD-MON-YYYY HH24:MI:SS’)” auxiliary destination ‘+data1’;
7> }
allocated channel: d0
channel d0: SID=72 instance=cdb3 device type=DISK
allocated channel: ch00
channel ch00: SID=794 instance=cdb3 device type=SBT_TAPE
channel ch00: WARNING: Oracle Test Disk API
Starting recover at 2024-06-16 13:06:08
RMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time
List of tablespaces expected to have UNDO segments
Tablespace SYSTEM
Tablespace UNDOTBS1
Tablespace UNDOTBS2
Tablespace UNDOTBS3
Creating automatic instance, with SID=’qzpA’
initialization parameters used for automatic instance:
db_name=CDB
db_unique_name=qzpA_pitr_pdb_CDB
compatible=19.0.0
db_block_size=8192
db_files=200
diagnostic_dest=/u01/app/oracle
_pdb_name_case_sensitive=false
_system_trig_enabled=FALSE
db_domain=cj.com
sga_target=2272M
processes=200
db_create_file_dest=+data1
log_archive_dest_1=’location=+data1′
enable_pluggable_database=true
_clone_one_pdb_recovery=true
#No auxiliary parameter file used
starting up automatic instance CDB
Oracle instance started
Total System Global Area 2382363816 bytes
Fixed Size 9165992 bytes
Variable Size 520093696 bytes
Database Buffers 1845493760 bytes
Redo Buffers 7610368 bytes
Automatic instance created
contents of Memory Script:
{
# set requested point in time
set until time “to_date(’16-JUN-2024 12:31:00′,’DD-MON-YYYY HH24:MI:SS’)”;
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone ‘alter database mount clone database’;
}
executing Memory Script
executing command: SET until clause
Starting restore at 2024-06-16 13:06:16
Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
released channel: d0
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/16/2024 13:06:18
RMAN-03015: error occurred in stored script Memory Script
RMAN-06034: at least 1 channel must be allocated to execute this command
RMAN>