Simple configuration of Oracle elastic uard

Oracle login uard is so disgusting that it took so long ~ Next I will introduce the simplest installation method ~

1. First, install two oracle databases with the same directory (you can select different directories). Because I use a VM, it is installed under c: \ app by default.

2. Configure the client parameters in the primary database, tnsnames. ora and listener. ora. The same is true for standby ~

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C: \ app \ product \ 11.2.0 \ dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS = ONLY: C: \ app \ product \ 11.2.0 \ dbhome_1 \ bin \ lrlr11.dll ")
)
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = C: \ app \ product \ 11.2.0 \ dbhome_1)
)

)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521 ))
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.70.254) (PORT = 1521 ))
)
)

ORCL254 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.70.254) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

ORCL253 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.70.253) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

3, enable logging:

Go to sqlplus and execute alter database force logging;

4. Check whether logs are archived.

Archive log list;

If not, run the command,

SQL> STARTUP MOUNT;
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ALTER DATABASE OPEN;

5. Redefine the pfile file.

Create pfile = 'C: \ pfile. ora 'from spfile

Modify the corresponding pfile file (other documents say backup is required, so don't bother them ~), Add the following content

DB_UNIQUE_NAME = orcl254
LOG_ARCHIVE_CONFIG = 'dg _ CONFIG = (orcl254, orcl253 )'
LOG_ARCHIVE_DEST_1 = 'location = c: \ app \ oradata \ orcl \ VALID_FOR = (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME = orcl254'
LOG_ARCHIVE_DEST_2 = 'service = orcl253 lgwr async VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = orcl253'
LOG_ARCHIVE_DEST_STATE_1 = ENABLE
LOG_ARCHIVE_DEST_STATE_2 = ENABLE
REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE
FAL_SERVER = orcl
FAL_CLIENT = orcl
DB_FILE_NAME_CONVERT = 'oradata \ orcl253 ', 'oradata \ orcl254'
LOG_FILE_NAME_CONVERT = 'oradata \ orcl253 ', 'oradata \ orcl254'
STANDBY_FILE_MANAGEMENT = AUTO

Run:

Create spfile from pfile = 'C: \ pfile. ora'

1 2 Next Page