Questions tagged [oracle]
All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.
7,789
questions
0
votes
1
answer
19
views
Oracle - manual replication and force logging
When we configure Data Guard, we enable force logging. If we set up manual replication (via rsync and cataloging the archives at the destination + database recovery), do we need to enable force ...
0
votes
0
answers
33
views
Is there a way to know until what time a point-in-time recovery of an Oracle database was performed?
Is there a way to know until what time a point-in-time recovery of an Oracle database was performed?
I only found references to the columns RESETLOGS_CHANGE# and RESETLOGS_TIME in V$DATABASE, but ...
0
votes
0
answers
17
views
oracle 19c user getting EXPIRED & LOCKED within several minutes when all password related settings in its profile are set to unlimited
I cannot understand why the account in Oracle 19c NON-CDB database getting locked few minutes later after creation. Audit trail is not configured.
I'm running the database in container, it's Oracle ...
0
votes
1
answer
28
views
Select hierarchical rows in proper order
How do I fix this query in Oracle?
SELECT t.id, t.code, t.text
FROM our_table t
WHERE EXISTS (
SELECT 1
FROM our_table root
WHERE root.id = t.root_id
AND root.code IN ('1', '2')
)
...
0
votes
1
answer
24
views
Oracle - Completly audit of normal users and DBA's
Which is the option to enable user audit and DBA actions?
I mean, let's say we audit a table called salary. No normal user can update the table without being audited.
But a DBA (which has full access ...
0
votes
0
answers
16
views
Select, Filter and Sort ist not working with Oracle SQL Developer
I am using SAP ADBC to UPDATE some Oracle database entries.
It's working and the data appearance in the SQL Developer between "normal" and UPDATED entries look same.
But when I use a,
SELECT ...
0
votes
0
answers
19
views
Rotate encryption key for asm tde wallet oracle 19c
I have 1 database that has the tde encryption wallet located in ASM rather than o/s
I now need to rotate the encryption key. I normally do this by changing the key ob one node then copying to the ...
0
votes
1
answer
23
views
Oracle 19 recover table with remap and constraints issue
I have a Oracle 19 DB that I am testing table restores from RMAN backups. I am using this code.
recover table "HR".REGIONS OF PLUGGABLE DATABASE 'pdb'
until ...
0
votes
0
answers
47
views
ORA-65139: Mismatch Between XML Metadata File And Data File
I have two systems - SYS1, SYS2(stand alone). On both is running an oracle 19c database. I want to create a plugable database from SYS1 and want to plug in the SYS2 database.
I created the pluggable ...
0
votes
2
answers
63
views
How to Restore RMAN Backup at Specific Date
I have daily backups of my test system which is taken daily full backups and also hourly arch backups. I need to restore one of these backups to another linux server. I've completed all steps until ...
1
vote
2
answers
79
views
RMAN - keep until and control_file_record_keep_time
Should I adjust control_file_record_keep_time to match the KEEP UNTIL value in my RMAN script?
Here's my monthly backup script:
RUN
{
BACKUP AS COMPRESSED BACKUPSET FULL
FORMAT 'FULL_MONTHLY_%...
0
votes
0
answers
26
views
What are the implications of PLSQL_OPTIMIZE_LEVEL=2 and PLSQL_DEBUG=TRUE?
I have an Oracle database (19c EE) where several users develop PL/SQL Code. When I query the view USER_PLSQL_OBJECT_SETTINGS it shows me 700 entries with PLSQL_OPTIMIZE_LEVEL=2 and PLSQL_DEBUG=TRUE. I ...
0
votes
1
answer
48
views
Oracle database backup recovery
Just startet to study Oracle, i need to restore database backup. Log file said it was made in Oracle Database 10g Enterprise. I have Oracle XE 18, is it even possible to make it for XE version usind ...
2
votes
1
answer
37
views
Oracle optimizer does not use column group information from multiple tables and misses correlation
I have a problem where the execution of a query is too slow in oracle 12c standard edition.
I figured out, the optimizer estimates wrong cardinalities because it misses the correlation between two ...
3
votes
0
answers
25
views
How to check if Oracle Database is using EBR ( EDITION-BASED REDEFINITION) or not
As per Oracle's documentation, since version 11g, Edition Based Redefinition (EBR) is initialized with a default edition named ORA$BASE. Any future EBRs are children of this so-called "edition&...