OEM 13cR1 to 13cR2 - Upgrade Testing
Please Use Below Link: http://www.slideshare.net/monowar94ru/oem-13cr113cr2-upgrade
Posts
Showing posts from October, 2016
Oracle DataGuard – How to resize Redo Log and Standby Redo Log
- Get link
- X
- Other Apps
Oracle DataGuard – How to resize Redo Log and Standby Redo Log set linesize 200 col dest_name for a30 select DEST_NAME,STATUS,PROTECTION_MODE,ARCHIVED_SEQ#,APPLIED_SEQ# from v$archive_dest_status; On Standby server - make file management parameter to manual if not: show parameter standby; alter system set standby_file_management=manual; ================== + On Primary + ================== SQL> select group#,thread#,status from v$log; col member for a60 set linesize 200 select member,group#,status from v$logfile; SQL> select group#,thread#,status from v$log; GROUP# THREAD# STATUS ---------- ---------- ---------------- 1 1 ACTIVE 2 ...
Oracle DataGuard – How to resize Redo Log and Standby Redo Log
- Get link
- X
- Other Apps
Oracle DataGuard – How to resize Redo Log and Standby Redo Log set linesize 200 col dest_name for a30 select DEST_NAME,STATUS,PROTECTION_MODE,ARCHIVED_SEQ#,APPLIED_SEQ# from v$archive_dest_status; On Standby server - make file management parameter to manual if not: show parameter standby; alter system set standby_file_management=manual; ================== + On Primary + ================== SQL> select group#,thread#,status from v$log; col member for a60 set linesize 200 select member,group#,status from v$logfile; SQL> select group#,thread#,status from v$log; GROUP# THREAD# STATUS ---------- ---------- ---------------- 1 1 ACTIVE 2 ...