June 2013
Beginner
404 pages
9h 40m
English
Run the following procedures on the primary database to create standby redo logfiles:
SQL> select a.group#, a.status, a.bytes/1024/1024 SizeMB, b.member from v$log a, v$logfile b where a.group#=b.group# order by group#; GROUP# STATUS SizeMB MEMBER ------ -------- ---------- -------------------------------------- 1 INACTIVE 100 /u01/app/oracle/oradata/orcl/redo01.log 2 CURRENT 100 /u01/app/oracle/oradata/orcl/redo02.log 3 INACTIVE 100 /u01/app/oracle/oradata/orcl/redo03.log 4 INACTIVE 100 /u01/app/oracle/oradata/orcl/redo04.log
In this single instance of the primary database, we have four redo log groups, each with one ...
Read now
Unlock full access