Learn Database Concepts

SQL> select protection_mode from v$database; PROTECTION_MODE -------------------- MAXIMUM PERFORMANCE SQL> show parameter log_archive_dest_2 NAME                     TYPE     VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_2             string     SERVICE=ORCLSTB1 NOAFFIRM ASYN                          C VALID_FOR=(ONLINE_LOGFILES,P                          RIMARY_ROLE) DB_UNIQUE_NAME=OR                          CLSTB1 log_archive_dest_20        ...

*********************************************************************     REAL TIME APPLY OF ARCHIVE LOG FILES IN READ ONLY MODE: ********************************************************************* SQL> select PROTECTION_MODE,PROTECTION_LEVEL FROM V$DATABASE; PROTECTION_MODE      PROTECTION_LEVEL -------------------- -------------------- MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE SQL> archive log list; Database log mode           Archive Mode Automatic archival           Enabled Archive destination           /u01/app/oracle/oraarch/ Oldest online log sequence     250 Next log sequence to archive   0 Current log sequence           252 SQL> recover managed standby database using current logfile disconnect from session; Media reco...

dbms_service.create_service :   We can call dbms_service.create_service procedure to create new service names , then start these service names for user connections. The procedure dbms_service.create_service requires the service name and service network name, use the service name to manage the service name. oracle@LINUX201:[~] $ sqlplus /"As sysdba" SQL*Plus: Release 11.2.0.4.0 Production on Tue Apr 5 13:17:50 2016 Copyright (c) 1982, 2013, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select SERVICE_ID,name from V$SERVICES; SERVICE_ID NAME ---------- ----------------------------------------------------------------          4 ORCL          1 SYS$BACKGROUND          2 SYS$USERS ****************************** ****************************** LEST CRE...