Showing posts with label Redo Log files. Show all posts
Showing posts with label Redo Log files. Show all posts
Friday, January 12, 2024

Syntax for dropping standby redo logs

›
In one of my primary databases, I had several old standby redo log files that were forgotten from a previous relocation using Data Guard. T...
Monday, December 5, 2022

How to avoid redo logs and standby redo logs being created as OMF files during a DUPLICATE ... FOR STANDBY operation

›
Recently I had to create a Data Guard physical standby database, and I used RMAN active database duplication ( "duplicate target datab...
Wednesday, May 12, 2021

How to clear a standby redo logfile and then dropping it

›
During set up of a physical standby database, one of the standby redo logfiles was marked as "ACTIVE" when querying the v$standb...
Tuesday, January 29, 2019

The difference between REDO and UNDO

›
UNDO REDO Used during normal database operations Used during instance and media recovery only Contains changed column values Conta...
Wednesday, November 18, 2015

How to drop a redo logfile group and redo logfile group members - syntax

›
alter database drop logfile group 4; The drop statement will be confirmed by an entry in the database's alert log. Don't forget t...

Query to find basic redo log information

›
COL MEMBER FORMAT A50 SET LINES 200 SELECT A.GROUP#,A.MEMBER, B.BYTES/1024/1024 "MB", B.ARCHIVED,B.STATUS,B.SEQUENCE# FROM V$LOGFI...
Thursday, May 7, 2015

How to add a logfile group and a logfile member - syntax

›
alter database add logfile group 2 ( '/u01/app/oracle/flash_recovery_area/mydb/onlinelog/redo02a.log', '/u01/app/oracle/oradata...