flashback PDB 不能确保可以打开， CDB 就可以

最新推荐文章于 2024-09-26 15:19:34 发布

jnrjian

最新推荐文章于 2024-09-26 15:19:34 发布

阅读量501

点赞数 9

文章标签： oracle

本文链接：https://blog.csdn.net/jnrjian/article/details/135463148

版权

SYS@> select * from v$restore_point;

SCN DATABASE_INCARNATION# GUA STORAGE_SIZE TIME
---------- --------------------- --- ------------ -----------------
RESTORE_POINT_TIME PRE NAME PDB CLE PDB_INCARNATION# REP
--------------------------------------------------------------------------- --- ------------------------------------ --- --- ---------------- ---
CON_ID
----------

1.0011E+10 3 YES 0 06-JAN-24 01.48.12.000000000 AM
YES CDB_20240106 NO NO 0 NO
0

1.0011E+10 3 YES 1.8098E+11 06-JAN-24 01.49.36.000000000 AM
YES PDB_20240106 YES NO 0 NO
3

SYS@> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 UAT READ WRITE NO
4 UAT READ WRITE NO

SYS@> alter pluggable database UAT close immediate instances=all;
SYS@> alter pluggable database UAT close abort instances=all;
---PDB停不了，重启CDB

SYS@> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
[oracle@ ~]$ srvctl stop database -d XXXXXXXXXX -o abort
[oracle@ ~]$ srvctl start database -d XXXXXXXXXX

SYS@> alter pluggable database UAT close immediate instances=all;

Pluggable database altered.

SYS@> flashback pluggable database UAT to restore point PDB_20240106;

Flashback complete.

SYS@> alter pluggable database UAT open instances=all;
alter pluggable database UAT open instances=all
*
ERROR at line 1:
ORA-65107: Error encountered when processing the current task on instance:1
ORA-01113: file 1478 needs media recovery
ORA-01110: data file 1478: '+DATA01/XXXXXXXXXX/F81661787 /DATAFILE/ '

SYS@> alter pluggable database UAT open;
alter pluggable database UAT open
*
ERROR at line 1:
ORA-01113: file 1478 needs media recovery
ORA-01110: data file 1478: '+DATA01/XXXXXXXXXX/F81661787F7A83F /DATAFILE/ '

SYS@> flashback database to restore point CDB_20240106;
flashback database to restore point CDB_20240106
*
ERROR at line 1:
ORA-38757: Database must be mounted and not open to FLASHBACK.

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 8 15:54:00 2024
Version 19.20.0.0.0

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

SYS@> flashback database to restore point CDB_20240106;

Flashback complete.

SYS@> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
[oracle@ ~]$ srvctl stop database -d XXXXXXXXXX -o abort
[oracle@ ~]$ srvctl start database -d XXXXXXXXXX
PRCR-1079 : Failed to start resource ora.XXXXXXXXXX.db
[oracle@ ~]$ s

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 8 15:58:24 2024
Version 19.20.0.0.0

Connected to an idle instance.

SYS@> startup
ORACLE instance started.

Total System Global Area 1.7180E+10 bytes
Fixed Size 23351176 bytes
Variable Size 1.1979E+10 bytes
Database Buffers 5167382528 bytes
Redo Buffers 10203136 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SYS@> alter database open resetlogs;

Database altered.

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 8 16:02:53 2024
Version 19.20.0.0.0

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

SYS@> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 UAT READ WRITE NO
4 UAT READ WRITE NO
SYS@>