Questions tagged [redo-logs]
13 questions
3
votes
2 answers
What are the effects of disabling the redo logs in Oracle on Hibernate transactions?
If we disable the 'redo logs' of a tablespace in Oracle, will they impact Hibernate's transactions?
These are the options present in the Oracle EM on a tablespace level:
Enable logging
Yes
Generate redo logs for creation of tables, indexes and…
Monis Iqbal
- 1,987
- 7
- 26
- 42
2
votes
0 answers
SQL Server 2016 secondary often issued error 3456, how to prevent SQL database error 3456?
Could not redo log record (410417:192254:28), for transaction ID (0:1838907632), on page (1:761914), allocation unit 72057594280869888, database '****' (database ID 5). Page: LSN = (410417:191949:3), allocation unit = 72057594280869888, type = 10.…
JoyceLuo
- 21
- 2
2
votes
3 answers
How does Oracle manage Redo logs?
Can any body give me an idea about Redo logs? An example would be most appreciated.
P Sharma
- 2,638
- 11
- 31
- 35
1
vote
2 answers
Oracle Logminer can't find redo entries
I updated several rows in "HR"."AAA" table. Now I want to return HR.AAA table to its previous state using LogMiner.
I do the following:
begin
dbms_logmnr_d.build('dictionary.ora','C:\oracle\product\10.2.0\oradata\ORCL\UTL');
end;
I checked and…
kupa
- 1,861
- 5
- 25
- 41
1
vote
2 answers
RMAN backup restore in a different node with datafiles and redolog files to a different directory
I can't restore the datafiles and redolog files from backup.
In RMAN I wrote,
run{
set newname for datafile 1 to '/u02/data_redo/system01.dbf';
set newname for datafile 2 to '/u02/data_redo/sysaux01.dbf';
set newname for datafile 3 to…
Somadder Abhijit
- 85
- 1
- 3
- 9
1
vote
1 answer
Reading oracle logs giving duplicate records
enter code hereI am facing an issue when reading the oracle logs through time interval.
Issue:
In oracle , while data is getting inserted through some external application, If I am using log miner to read the oracle logs, It gives me duplicate…
Abinash
- 103
- 11
0
votes
0 answers
Redo logfiles for mySQL database
I want to have my database safer by using redo logfiles.
I read some articles about it online, but I have no idea where to start using this.
Where and how can I configure this?
Webdeveloper_Jelle
- 2,868
- 4
- 29
- 55
0
votes
1 answer
Why doesn't MySQL InnoDB redo log block writing need double write?
MySQL InnoDB redo log block size is 512 bytes (maybe a sector in the disk). I read Are disk sector writes atomic?. It looks like it depends on the underlying hardware to decide if a sector writing is atomic. So if it's not atomic, how can InnoDB…
xnervwang
- 125
- 1
- 8
0
votes
1 answer
Would Insert statement perform better than a merge statement in Oracle
May I ask would Insert statement perform better than a merge statement in Oracle if we don't need to do any update?
I understand that a single merge statement will usually a preferred option if we need to run both insert and update statement at the…
E. L.
- 502
- 3
- 16
0
votes
1 answer
Trouble with Oracle 11.2.0.3 redo logs
I have a table in oracle 11.2.0.3 that I want to capture in the redo logs. The issue is that it has an sdo_geometry field. This is a legacy table that I can not change. But the good news is I do not need that sdo_geometry field.
So I have created a…
Patrick O'Brien
- 3
- 2
0
votes
1 answer
Oracle RAC standby - standby redo log configuration
With an Oracle RAC standby DB where the primary has 2 threads of 4 groups of online redo logs, should the standby DB have 2 threads of 5 groups each? Or is just one additional group in one of the threads enough? Oracle recommends an extra group for…
Franco
- 23
- 1
- 8
0
votes
1 answer
Oracle redologs files
Assuming regular basis workload of the database
generates 1GB of data in redologs files every hour.
What number and size of the redologs files might be appropriate for a
good performance?
Snochacz
- 685
- 1
- 8
- 23
0
votes
0 answers
how to raise event when there is change in oracle current redo log?
I have a requirement to read redo log files using logminer constantly and update the logminer results into a table.. Instead of scheduling a job for to reoccur at particular interval I am exploring ways to execute the job whenever new records are…
Ahmad Osama
- 91
- 1
- 11