[oracle@DCTEST][ALFWEB]$ sqlplus / as sysdba
SQL*Plus: Release [Link].0 Production on Sat Mar 24 [Link] 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 5344731136 bytes
Fixed Size 2262656 bytes
Variable Size 989858176 bytes
Database Buffers 4345298944 bytes
Redo Buffers 7311360 bytes
Database mounted.
SQL> set lines 165 pages 2000;
SQL> col host_name for a25;
alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS';
select INSTANCE_NAME,HOST_NAME,VERSION,STARTUP_TIME,STATUS from gv$instance;
SQL> select
NAME,OPEN_MODE,DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL,FORCE_LOGGING from
v$database;
Session altered.
SQL>
INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME
STATUS
---------------- ------------------------- ----------------- -------------------
------------
ALFWEB DCTEST [Link].0 24-03-2018 [Link]
MOUNTED
SQL>
NAME OPEN_MODE DATABASE_ROLE PROTECTION_MODE
PROTECTION_LEVEL FOR
--------- -------------------- ---------------- --------------------
-------------------- ---
ALFWEB MOUNTED PRIMARY MAXIMUM AVAILABILITY UNPROTECTED
NO
SQL>
SQL>
SQL> select open_mode, DATABASE_ROLE, guard_status, SWITCHOVER_STATUS from
v$database;
OPEN_MODE DATABASE_ROLE GUARD_S SWITCHOVER_STATUS
-------------------- ---------------- ------- --------------------
MOUNTED PRIMARY NONE NOT ALLOWED
SQL> alter database set standby database to maximize performance;
Database altered.
SQL> select open_mode, DATABASE_ROLE, guard_status, SWITCHOVER_STATUS from
v$database;
OPEN_MODE DATABASE_ROLE GUARD_S SWITCHOVER_STATUS
-------------------- ---------------- ------- --------------------
MOUNTED PRIMARY NONE NOT ALLOWED
SQL> select
NAME,OPEN_MODE,DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL,FORCE_LOGGING from
v$database;
NAME OPEN_MODE DATABASE_ROLE PROTECTION_MODE
PROTECTION_LEVEL FOR
--------- -------------------- ---------------- --------------------
-------------------- ---
ALFWEB MOUNTED PRIMARY MAXIMUM PERFORMANCE UNPROTECTED
NO
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 5344731136 bytes
Fixed Size 2262656 bytes
Variable Size 989858176 bytes
Database Buffers 4345298944 bytes
Redo Buffers 7311360 bytes
Database mounted.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL> alter database open;
Database altered.
SQL> set lines 165 pages 2000;
SQL> col host_name for a25;
alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS';
SQL> select INSTANCE_NAME,HOST_NAME,VERSION,STARTUP_TIME,STATUS from gv$instance;
select NAME,OPEN_MODE,DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL,FORCE_LOGGING
from v$database;
Session altered.
SQL>
INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME
STATUS
---------------- ------------------------- ----------------- -------------------
------------
ALFWEB DCTEST [Link].0 24-03-2018 [Link]
OPEN
SQL>
NAME OPEN_MODE DATABASE_ROLE PROTECTION_MODE
PROTECTION_LEVEL FOR
--------- -------------------- ---------------- --------------------
-------------------- ---
ALFWEB READ WRITE PRIMARY MAXIMUM PERFORMANCE MAXIMUM
PERFORMANCE NO
SQL>
