重庆思庄Oracle、Redhat认证学习论坛

标题: ORACLE 12C pdb处于热备模式导致CDB无法正常打开 [打印本页]

作者: 郑全 时间: 2020-1-17 16:43
标题: ORACLE 12C pdb处于热备模式导致CDB无法正常打开
某个PDB处于热备份模式，还没有结束热备，然后，数据被关闭了，这个时候，再去打开CDB，报 ORA-10873 PDB某个数据文件处于热备模式，无发打开。

见下：

SQL> startup mount;
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size                2926472 bytes
Variable Size          1325402232 bytes
Database Buffers       805306368 bytes
Redo Buffers             13848576 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-10873: file 12 needs to be either taken out of backup mode or media
recovered
ORA-01110: data file 12: '/u01/app/oracle/oradata/cdb1/pdb2/system01.dbf'

SQL> show pdbs
CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      MOUNTED
      4 PDB2                         MOUNTED
      5 PDB3APP                      MOUNTED
SQL>
SQL> show pdbs
CON_ID CON_NAME                      OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
      2 PDB$SEED                      MOUNTED
      4 PDB2                         MOUNTED
      5 PDB3APP                      MOUNTED
SQL> alter tablespace pdb2:system offline;
alter tablespace pdb2:system offline
                  *
ERROR at line 1:
ORA-02142: missing or invalid ALTER TABLESPACE option

SQL> alter database datafile 12 offline;
alter database datafile 12 offline
*
ERROR at line 1:
ORA-01516: nonexistent log file, data file, or temporary file "12"

离线，又报文件不存在，怎么办？

一个PDB坏，导致CDB都不能用了，冤哟。

作者: 郑全 时间: 2020-1-17 16:43
这个时候，远程也不能连接。

SQL> conn sys/oracle_4U@192.168.133.120:1521/pdb2 as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

Warning: You are no longer connected to ORACLE.
SQL>

作者: 郑全 时间: 2020-1-17 16:47
在 CDB没有启动的时候，如何能够把这个PDB 关闭呢

答案是，通过alter session set container =pdb2, 即可。

SQL> alter session set container=pdb2;

SQL> alter pluggable database end backup;

Pluggable database altered.

SQL> conn / as sysdba
Connected.
SQL> alter database open;

Database altered.

SQL>
搞定。

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)