Create a physical standby database using RMAN cold copy

1. Configure the master database environment to enable archive SQLgt; altersystemsetlog_archive_dest_1

1. Configure the master database environment to enable archive SQLgt; alter system set log_archive_dest_1 =

1. Configure the master database environment

Enable Archiving

SQL> alter system set log_archive_dest_1 = 'location =/Oracle/archive_log/arch _ % t _ % s _ % r. arc' scope = spfile;

The system has been changed.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_FORMAT = 'arch _ % t _ % s _ % r. arc' scope = spfile;

The system has been changed.

SQL> shutdown immediate
The database has been closed.
The database has been detached.
The ORACLE routine has been disabled.

SQL> startup mount
The ORACLE routine has been started.

Total System Global Area 2538741760 bytes
Fixed Size 2757504 bytes
Variable Size 738200704 bytes
Database Buffers 1778384896 bytes
Redo Buffers 19398656 bytes
The database has been loaded.
SQL> alter database archivelog;

The database has been changed.

SQL> alter database open;

The database has been changed.

SQL> archive log list
Database Log mode archiving Mode
Enable automatic archiving
Archive endpoint/oracle/archive_log
Oldest online log sequence 10
Next archive log sequence 12
Current Log sequence 12

SQL> alter database force logging;

The database has been changed.

SQL> select force_logging from v $ database;

FORCE_LOGGING
--------------------------------------------------------------------------------
YES

2. Configure Oracle Net

Primary Oracle Net

SQL>!
Oracle @ Sol_ORA :~ $ Cd $ ORACLE_HOME/network/admin
Oracle @ Sol_ORA:/oracle/12.1/network/admin $ cat tnsnames. ora
# Tnsnames. ora Network Configuration File:/oracle/12.1/network/admin/tnsnames. ora
# Generated by Oracle configuration tools.

TESTM = # connection string of the master database
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 188.188.1.176) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTM)
)
)

LISTENER_TESTM =
(ADDRESS = (PROTOCOL = TCP) (HOST = 188.188.1.176) (PORT = 1521 ))

TESTS = # connection string of the standby Database
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 188.188.3.20) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTM)
)
)

Oracle @ Sol_ORA:/oracle/12.1/network/admin $ cat listener. ora
# Listener. ora Network Configuration File:/oracle/12.1/network/admin/listener. ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = TESTM) (ORACLE_HOME =/oracle/12.1) # static registration of the master database
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 188.188.1.176) (PORT = 1521 ))
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521 ))
)
)

For more details, please continue to read the highlights on the next page:

Recommended reading:

Use the Duplicate function of RMAN to create a physical partition uard

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

Use RMAN to back up duplicate to create a replica uard

,