Featured
The Latest
-
|
How to check physical and logical data corruption using RMAN?
If you are not using RMAN to backup data and use technologies like NetApp snapshot which doesn’t check for physical… READ MORE
-
|
Format for RMAN backup piece file name is unique
Using incorrect format when backing up to tape can cause an issue during recovery if the backup pieces have the… READ MORE
-
Script to generate SQLs to terminate rman sessions
Killing the rman main process from the command line doesn’t immediately kill the rman sessions using the script below which… READ MORE
-
Internal parameters
— view oracle internal parameters, note this can be run by SYS user — name, value, default value, session modifiable,… READ MORE
-
|
ORA-19206 when running export (exp)
On Oracle9i if you get the following error when running export (exp) utility, to fix this issue one would need… READ MORE
-
Setting NLS_LANG for Oracle
NLS_LANG=<language>_<territory>.<character set> Example: export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 Setting NLS_LANG tells Oracle what characterset the client is using so Oracle can do conversion… READ MORE
-
French accents character when using SQL*Plus
For SQL*Plus to process french accents characters when using SQL*Plus, you would need to set NLS_LANG On Windows set NLS_LANG=.AL32UTF8… READ MORE
-
How to migrate from single instance to RAC 10gR2
Move from single instance to RAC 1- Install CRS 2- Install new RDBMS binaries rac enable 3- Make sure there… READ MORE
-
How to fix Online redo log corruption?
Today, due to a network issue the host (Solaries) lost contact with the NetApp filer and it corrupted some datafiles… READ MORE
-
How to extract the DB LINKS DDL with the password
Here is a simple script to extract the DB Links DDL with the encripted password. SET LONG 9000 — to… READ MORE
-
|
Creation SQL script for DB Link within a database
The following can be used to create a script for DB Links with work on 8i/9i and will contain the… READ MORE
-
How full is the current redo log file?
SQL> SELECT le.leseq “Current log sequence No”, 100*cp.cpodr_bno/le.lesiz “Percent Full”, cp.cpodr_bno “Current Block No”, le.lesiz “Size of Log in Blocks”… READ MORE
-
|
How to move datafiles in temp tablespace?
One can’t move the temp tablespace during mount stage like other datafiles using “ALTER DATABASE RENAME FILE..” so a workaround… READ MORE
-
|
Enable trace in a running session from PL/SQL or SQL*Plus
Using Oracle SID and SERIAL# can turn trace on/off a Oracle session that has already started. The values of SID… READ MORE
-
TEMP space usage overall and by session
Get current total TEMP tablespace currently allocated, used and free: SELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_size) / 1024… READ MORE
-
Extract all tablespaces DDL
Nice way to extract the DDL for all tablepaces.. This also can be used for other objects as well. SQL>set… READ MORE
-
Clone a database with RMAN
Duplicating a Database using RMAN – (UNIX / Linux) PMMPRD to PMMQA1 Pre-requisites A valid full database backup of the… READ MORE
-
How to create a NetApp FlexClone RAC Database
In the past I used these procedures to create a FlexClone Oracle RAC database. Mainly for refreshing a data-warehouse from… READ MORE
-
|
How to resolve user locking problems
Method 1: Check and remove session locking other from Database Find the USER locking others Select a.serial#, a.sid, a.username, b.id1,… READ MORE
-
Enabling Flashback Database
The following are the requirements for enabling Flashback Database: – Your database must be running in ARCHIVELOG mode, because archived… READ MORE
-
Change from Rollback Segments 8i to UNDO in 9i/10g
Created UNDO tablespace CREATE UNDO TABLESPACE undotbs DATAFILE ‘/ora_data_1/GIST/oradata/undotbs_01.dbf’ SIZE 100M REUSE AUTOEXTEND ON; ALTER DATABASE DATAFILE ‘/ora_data_1/GIST/oradata/undotbs_01.dbf’ RESIZE 3000M;… READ MORE
Recent posts
Quote of the week
“Control what I can control”
~ Alex Lima
Categories
- 18c
- 19c
- AIX
- Archivelog
- Auditing
- AWR
- Backup
- Backup & Recovery
- Batch
- Big Data
- Built-in stored procedures
- Connections
- Control file
- Cursor
- Database
- Dataguard
- Dataguard
- Datatypes
- Date
- Docker
- events
- exp
- Export
- Flashback
- General DBA
- Globalization
- GoldenGate
- Grant
- Initialization
- install
- Internal
- JDBC
- Jobs
- kubernetes
- Leadership
- Linux
- Listener
- LOB
- Lock
- Log Miner
- mac
- Microservices
- Monitor
- Motocycling
- MySQL
- NetApp for Oracle
- networking
- OCI
- OEM – Grid Control
- Open Shift
- OpenWorld 2010
- ORA Errors
- Oracle RAC
- oradebug
- OS
- osql
- Parameters
- partition
- Password
- performance
- PL/SQL
- postgres
- Power Shell
- Primavera
- Product Management
- Profiler
- Project Management
- Python
- REST API
- RMAN
- role
- Scheduler
- Scripts
- Security
- sga
- Shared Pool
- Shell
- snapshot
- SQL – DDL
- SQL Developer
- SQL Server
- SQL*Plus
- SQLcl
- startup
- Statistics
- Statspack
- Table
- tablespace
- trace
- Transaction
- Tuning
- Tuning
- Undo
- Unix
- Upgrade
- vi
- windows
Alex Lima 