Which statement is true regarding the redo log files for the instance?

You are managing a policy-managed Real Application Cluster (RAC) database, RACDB with Oracle Managed Files (OMF) enabled. Examine the following outputs:
(oracleQgr5153 ~]S srvctl config database -d RACDB

Database unique name: RACDB
Database name: RACDB
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/RACDB/spfileRACDB.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: POOL1
Database instances:
Disk Groups: DATA, FRA
Services:

Database is policy managed

SQL> SELECT * FROM v$active instances;

INST NUMBER INST NAME

1 gr5118:RACDB_1
2 gr5l52:RACDB_2
3 gr5l53:RACDB_3

[oracle@gr5153 — ] $ crsctl stat serverpool ora.POOL1 NAME_ora.POOL1

ACTIVE_SERVERS=gr5118 gr5152 gr5153

[oracle@gr5153 — ] $ srvctl config srvpool -g POOL1

Server pool name: POOL1
Importance: 0, Min: 0, Max: 3
Candidate server names:

You added a new server to the server pool using the following command:
[oracle@gr5153 — ] $ srvctl modify srvpool — cf POOL1 -i 0 -1 2 -u 4 -n gr5119

The instance on the newly added node is started by the Oracle Clusterware. Automatic Stem Management (ASM) is used as the storage option.

Which statement is true regarding the redo log files for the instance?

You are managing a policy-managed Real Application Cluster (RAC) database, RACDB with Oracle Managed Files (OMF) enabled. Examine the following outputs:
(oracleQgr5153 ~]S srvctl config database -d RACDB

Database unique name: RACDB
Database name: RACDB
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/RACDB/spfileRACDB.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: POOL1
Database instances:
Disk Groups: DATA, FRA
Services:

Database is policy managed

SQL> SELECT * FROM v$active instances;

INST NUMBER INST NAME

1 gr5118:RACDB_1
2 gr5l52:RACDB_2
3 gr5l53:RACDB_3

[oracle@gr5153 — ] $ crsctl stat serverpool ora.POOL1 NAME_ora.POOL1

ACTIVE_SERVERS=gr5118 gr5152 gr5153

[oracle@gr5153 — ] $ srvctl config srvpool -g POOL1

Server pool name: POOL1
Importance: 0, Min: 0, Max: 3
Candidate server names:

You added a new server to the server pool using the following command:
[oracle@gr5153 — ] $ srvctl modify srvpool — cf POOL1 -i 0 -1 2 -u 4 -n gr5119

The instance on the newly added node is started by the Oracle Clusterware. Automatic Stem Management (ASM) is used as the storage option.

Which statement is true regarding the redo log files for the instance?

A.
Oracle Clusterware automatically creates and enables a new thread of redo

B.
You must create redo log groups for the newly addedservice.

C.
Redo log members will not becreated automatically because storage option used is ASM.

D.
The newly added instance must save full online log groups tracked in the control file.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Sanjay Mevada

Sanjay Mevada

A is correct answer.