Oracle 12c Rac Set Archive Mode

最新推荐文章于 2024-08-19 15:08:43 发布

转载最新推荐文章于 2024-08-19 15:08:43 发布 · 128 阅读

文章标签：

#数据库

本文详细介绍了Oracle RAC环境下配置归档日志、设置恢复文件目的地、调整日志归档格式及实现集群数据库操作的过程，并通过示例展示了如何在不同节点上进行这些配置，最终成功开启所有PDB数据库。

Oracle 12c Rac Set Archive Mode
node1:
SQL> show parameter db_recovery_file_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +CRSFRA
db_recovery_file_dest_size           big integer 4800M

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 7766568960 bytes
Fixed Size                  4665928 bytes
Variable Size            2432699832 bytes
Database Buffers         5318377472 bytes
Redo Buffers               10825728 bytes
Database mounted.
SQL>
SQL>
SQL> alter database archivelog;
Database altered.
show parameter name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name               string
db_file_name_convert                 string
db_name                              string      testdb
db_unique_name                       string      testdb
global_names                         boolean     FALSE
instance_name                        string      testdb_1
lock_name_space                      string
log_file_name_convert                string
pdb_file_name_convert                string
processor_group_name                 string
service_names                        string      testdb
SQL> alter system set db_recovery_file_dest='+CRSFRA' sid='testdb_1';

System altered.

SQL> alter system set db_recovery_file_dest='+CRSFRA' sid='testdb_2';

System altered.

SQL> alter system set log_archive_format ='arch1_%s_%R_%T.arc' scope=spfile sid='testdb_1';

System altered.

SQL> alter system set log_archive_format ='arch1_%s_%R_%T.arc' scope=spfile sid='testdb_2';

System altered.

SQL> alter database open;
SQL> alter system set cluster_database=TRUE scope=spfile sid='*';

System altered.

SQL>
SQL>
SQL> shutdown immediate;
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY NO
         3 TESTCS1                        MOUNTED
         4 PDB_PLUG_NOCOPY                MOUNTED
         5 CRM                            MOUNTED
         6 ESSDB                          MOUNTED
         8 PDB_PLUG_MOVE                  MOUNTED
SQL> select con_id,dbid,NAME,OPEN_MODE from v$pdbs;

    CON_ID       DBID NAME                           OPEN_MODE
---------- ---------- ------------------------------ ----------
         2 4069264041 PDB$SEED                       READ ONLY
         3 4133352937 TESTCS1                        MOUNTED
         4 518394074 PDB_PLUG_NOCOPY                MOUNTED
         5 2880313921 CRM                            MOUNTED
         6 983511936 ESSDB                          MOUNTED
         8 1625017221 PDB_PLUG_MOVE                  MOUNTED

6 rows selected.

SQL> alter PLUGGABLE database all open;

Pluggable database altered.

SQL> select con_id,dbid,NAME,OPEN_MODE from v$pdbs;

    CON_ID       DBID NAME                           OPEN_MODE
---------- ---------- ------------------------------ ----------
         2 4069264041 PDB$SEED                       READ ONLY
         3 4133352937 TESTCS1                        READ WRITE
         4 518394074 PDB_PLUG_NOCOPY                MOUNTED
         5 2880313921 CRM                            READ WRITE
         6 983511936 ESSDB                          READ WRITE
         8 1625017221 PDB_PLUG_MOVE                  READ WRITE

6 rows selected.

node2:

QL> ALTER DATABASE FORCE LOGGING;

Database altered.

SQL> startup force;
ORACLE instance started.

Total System Global Area 7766568960 bytes
Fixed Size                  4665928 bytes
Variable Size            2499808696 bytes
Database Buffers         5251268608 bytes
Redo Buffers               10825728 bytes
select con_id,dbid,NAME,OPEN_MODE from v$pdbs;Database mounted.

Database opened.
SQL>
    CON_ID       DBID NAME                           OPEN_MODE
---------- ---------- ------------------------------ ----------
         2 4069264041 PDB$SEED                       READ ONLY
         3 4133352937 TESTCS1                        MOUNTED
         4 518394074 PDB_PLUG_NOCOPY                MOUNTED
         5 2880313921 CRM                            MOUNTED
         6 983511936 ESSDB                          MOUNTED
         8 1625017221 PDB_PLUG_MOVE                  MOUNTED

6 rows selected.

SQL> alter PLUGGABLE database all open;

Pluggable database altered.

SQL> select con_id,dbid,NAME,OPEN_MODE from v$pdbs;

6 rows selected.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     3672
Next log sequence to archive   3674
Current log sequence           3674
SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13750068/viewspace-1064158/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13750068/viewspace-1064158/