How to Start a Standby Database

SQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 28 07:13:19 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 2.1780E+10 bytes
Fixed Size                  2262896 bytes
Variable Size            5637146768 bytes
Database Buffers         1.6106E+10 bytes
Redo Buffers               34275328 bytes
SQL> alter database mount  standby database;

Database altered.

SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> select max(sequence#) from v$archived_log where applied='YES';

MAX(SEQUENCE#)
--------------
        174792

SQL>