Oracle Standby

На основной базе последние сгенерированные арх.логи:

SQL> alter session set nls_date_format = 'dd-mm-rr hh24:mi:ss';
SQL> SELECT * FROM (SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE# DESC) WHERE ROWNUM < 10 ORDER BY SEQUENCE#;


На standby-базе последние арх.логи:

SQL> alter session set nls_date_format = 'rrrr-mm-dd hh24:mi:ss';
SQL> SELECT * FROM (SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE# DESC) WHERE ROWNUM < 10 ORDER BY SEQUENCE#;



Информация о состоянии процессов на стендбай-базе:

SQL> alter session set nls_date_format = 'rrrr-mm-dd hh24:mi:ss';
SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;


После добавления файла данных на production
alter database create datafile 'UNNAMED00012' as '/oradata/users02.dbf';