Tag Archives: 12c

Oracle database 12c：DataGuard 主备切换

By Adamhuan | 2018年4月10日

Info。
——————
主库：oracleme
unique: orcl
sid: orcl
——————
从库：oracleyou
unique: stdbyme
sid: orcl

一、切换前

主：

[oracle@oracleme ~]$ id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba)
[oracle@oracleme ~]$ 
[oracle@oracleme ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Apr 10 16:32:03 2018

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> 
SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
----------------------------------------
TO STANDBY

SQL> 
SQL> select database_role from v$database;

DATABASE_ROLE
--------------------------------
PRIMARY

SQL>    
SQL> show parameter unique

NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
db_unique_name                       string
orcl
SQL> 
SQL> select instance_name,status from v$instance;

INSTANCE_NAME                    STATUS
-------------------------------- ------------------------
orcl                             OPEN

SQL> 
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@oracleme ~]$

[oracle@oracleme ~]$ id oracle

uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba)

[oracle@oracleme ~]$

[oracle@oracleme ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Apr 10 16:32:03 2018

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS

----------------------------------------

TO STANDBY

SQL>

SQL> select database_role from v$database;

DATABASE_ROLE

--------------------------------

PRIMARY

SQL>

SQL> show parameter unique

NAME TYPE

------------------------------------ ----------------------

VALUE

------------------------------

db_unique_name string

orcl

SQL>

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS

-------------------------------- ------------------------

orcl OPEN

SQL>

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

[oracle@oracleme ~]$

[……]

Oracle Database 12c：Data Guard in CentOS 7.4.1708

By Adamhuan | 2018年4月10日

0 Comment

开始本文的前提：
1. CentOS Linux 7.4.1708:2台
2. 都安装了Oracle 12c database
3. 主节点已经建好了库

在我的环境里：
Primary – 10.158.1.97
Standby – 10.158.1.161

文件：/etc/h[……]

ORA-12705: Cannot access NLS data files or invalid environment specified

By Adamhuan | 2018年4月4日

0 Comment

如题所示，在启动SQLPLUS的时候，你可能遇到上面的错误。
具体如下：

[oracle@oracleme ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 4 14:21:08 2018

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

ERROR:
ORA-12705: Cannot access NLS data files or invalid environment specified


Enter user-name: ^C
[oracle@oracleme ~]$

[oracle@oracleme ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 4 14:21:08 2018

ERROR:

ORA-12705: Cannot access NLS data files or invalid environment specified

Enter user-name: ^C

[oracle@oracleme ~]$

造成这个问题的原因是两个环境变量的配置：
1. NLS_LANG
2. ORA_NLS10

正确的配置：
[crayon-5b4ec[……]

Oracle Database：还原点（Restore Point）名称乱码的处理

By Adamhuan | 2017年11月4日

0 Comment

今天，在我的实验环境中遇到了这么一个问题：

[oracle@dg12c1 ~]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Sat Nov 4 00:34:50 2017

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

connected to target database: LENKA (DBID=2000990868)

RMAN> list restore point all;

using target database control file instead of recovery catalog
SCN              RSP Time  Type       Time      Name
---------------- --------- ---------- --------- ----
5555959                    GUARANTEED 02-NOV-17 BEFORE_SWITCH???H_OVER
6050990                               04-NOV-17 helloworld_??????
6051159                               04-NOV-17 ??????

RMAN> 

[oracle@dg12c1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Nov 3 23:46:47 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>          
SQL> col name for a24
SQL>        
SQL> select scn,name,storage_size,database_incarnation# from v$restore_point;

       SCN NAME                     STORAGE_SIZE DATABASE_INCARNATION#
---------- ------------------------ ------------ ---------------------
   5555959 BEFORE_SWITCH???H_OVER      419430400                     2
   6050990 helloworld_??????                   0                     3
   6051159 ??????                              0                     3

SQL>

[oracle@dg12c1 ~]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Sat Nov 4 00:34:50 2017

connected to target database: LENKA (DBID=2000990868)

RMAN> list restore point all;

using target database control file instead of recovery catalog

SCN RSP Time Type Time Name

---------------- --------- ---------- --------- ----

5555959 GUARANTEED 02-NOV-17 BEFORE_SWITCH???H_OVER

6050990 04-NOV-17 helloworld_??????

6051159 04-NOV-17 ??????

RMAN>

[oracle@dg12c1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Nov 3 23:46:47 2017

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>

SQL> col name for a24

SQL>

SQL> select scn,name,storage_size,database_incarnation# from v$restore_point;

SCN NAME STORAGE_SIZE DATABASE_INCARNATION#

---------- ------------------------ ------------ ---------------------

5555959 BEFORE_SWITCH???H_OVER 419430400 2

6050990 helloworld_?????? 0 3

6051159 ?????? 0 3

SQL>

可以看到还原点（Restore point）的名字包含乱码。

而在Oracle中，对还原点的操作，目前都是需要【NAME】作为唯一选择的方法。
但现在，这个【NAME】有乱码了[……]

Oracle：重建控制文件

By Adamhuan | 2017年11月4日

1 Comment

备份控制文件的脚本到TRACE：

[oracle@dg12c1 lenka]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sat Nov 4 00:45:17 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> 
SQL> alter database backup controlfile to trace;

Database altered.

SQL>

[oracle@dg12c1 lenka]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sat Nov 4 00:45:17 2017

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>

SQL> alter database backup controlfile to trace;

Database altered.

SQL>

后台ALERT日志

2017-11-04T00:45:41.058203+08:00
alter database backup controlfile to trace
2017-11-04T00:45:41.061303+08:00
Backup controlfile written to trace file /u01/app/oracle/diag/rdbms/lenka_primary/lenka/trace/lenka_ora_14627.trc
Completed: alter database backup controlfile to trace

2017-11-04T00:45:41.058203+08:00

alter database backup controlfile to trace

2017-11-04T00:45:41.061303+08:00

Backup controlfile written to trace file /u01/app/oracle/diag/rdbms/lenka_primary/lenka/trace/lenka_ora_14627.trc

Completed: alter database backup controlfile to trace

可以看到，生成的TRACE文件是：/u01/app/oracle/diag/rdbms/len[……]