Oracle11gR2ActiveDataGuard adjustment case [1]

The customer's environment is OracleRACDatabase11.2.0.3forLinuxx86 _ 64bit + OracleDatabase11.2.0.3forLinuxx86 _ 64bit (ADG standby database), RA

The customer's environment is Oracle RAC Database 11.2.0.3 for Linux x86_64bit + Oracle Database 11.2.0.3 for Linux x86_64bit (ADG slave Database), RA

The customer's environment is Oracle RAC Database 11.2.0.3 for Linux x86_64bit + Oracle Database 11.2.0.3 for Linux x86_64bit (ADG slave Database). RAC uses ASM and the slave Database uses the file system. The customer added a data file to the SYSTEM tablespace in the main database of RAC. Due to script problems, the data file is stored in the local file SYSTEM of node 1 ,, as a result, the database instance of node 2 is down. This process is successfully synchronized to the slave database. The file system space corresponding to the file synchronized by the slave database is insufficient. You also need to adjust the location of the file, use the following steps to simulate the problem and solve the problem.

1. Simulate misoperation.

1. master database operations:
SQL> show parameter db_create

NAME TYPE VALUE
-----------------------------------------------------------------------------
Db_create_file_dest string + DBFILE1
Db_create_online_log_dest_1 string
Db_create_online_log_dest_2 string
Db_create_online_log_dest_3 string
Db_create_online_log_dest_4 string
Db_create_online_log_dest_5 string
SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
+ DBFILE1/ractest/datafile/users.259.754173059
+ DBFILE1/ractest/datafile/undotbs1.258.754173059
+ DBFILE1/ractest/datafile/sysaux.257.754173057
+ DBFILE1/ractest/datafile/system.256.754173057
+ DBFILE1/ractest/datafile/undotbs2.264.754173315
+ DBFILE1/ractest/datafile/soe.274.686330585
+ DBFILE1/ractest/datafile/liubinglin.276.786500233
+ DBFILE1/ractest/datafile/liubinglin.268.805074155

8 rows selected.

All data files of the current RAC are stored in the ASM disk group.

1) Add a data file for the SYSTEM tablespace.
SQL> alter tablespace system add datafile 'system02. dbf' size 5 m;

Tablespace altered.

When you add a system02.dbf data file to the SYSETM tablespace, the name of the ASM disk group is not specified.

/Xxx ×××××/
Note:
Because the db_create_file_dest parameter is specified, datafile can be followed by any parameter to create a file at the location specified by the db_create_file_dest parameter. For example:
SQL> create tablespace t1 datafile size 5 m;

Tablespace created.

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
+ DBFILE1/ractest/datafile/users.259.754173059
+ DBFILE1/ractest/datafile/undotbs1.258.754173059
+ DBFILE1/ractest/datafile/sysaux.257.754173057
+ DBFILE1/ractest/datafile/system.256.754173057
+ DBFILE1/ractest/datafile/undotbs2.264.754173315
+ DBFILE1/ractest/datafile/soe.274.686330585
+ DBFILE1/ractest/datafile/liubinglin.276.786500233
+ DBFILE1/ractest/datafile/liubinglin.268.805074155
+ DBFILE1/ractest/datafile/t1.279.814356763

10 rows selected.
/Xxx ×××××/

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
+ DBFILE1/ractest/datafile/users.259.754173059
+ DBFILE1/ractest/datafile/undotbs1.258.754173059
+ DBFILE1/ractest/datafile/sysaux.257.754173057
+ DBFILE1/ractest/datafile/system.256.754173057
+ DBFILE1/ractest/datafile/undotbs2.264.754173315
+ DBFILE1/ractest/datafile/soe.274.686330585
+ DBFILE1/ractest/datafile/liubinglin.276.786500233
+ DBFILE1/ractest/datafile/liubinglin.268.805074155
/U01/app/oracle/product/11.2.0/db_1/dbs/system02.dbf

9 rows selected.
Because the disk group name is not specified, the file is created in the $ ORACLE_HOME/dbs default directory of the local file system.

Slave database operations:
SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
/U01/app/oracle/oradata/ractestusers.259.754173059
/U01/app/oracle/oradata/ractestundotbs1.258.754173059
/U01/app/oracle/oradata/ractestsysaux.257.754173057
/U01/app/oracle/oradata/ractestsystem.256.754173057
/U01/app/oracle/oradata/ractestundotbs2.264.754173315
/U01/app/oracle/oradata/ractestsoe.274.686330585
/U01/app/oracle/oradata/ractestliubinglin.276.786500233
/U01/app/oracle/oradata/ractestliubinglin.268.805074155
/U01/app/oracle/product/11.2.0/db_1/dbs/system02.dbf

9 rows selected.
Operations on the master database are successfully synchronized to the slave database.

Ii. troubleshooting process.