ORA-60019 on installation

OTN Discussion Forums : ORA-60019 on installation ...

 

"ORA-60019: creating initial extent of size 8 in tablespace of extent size 14"

In my case , the tablespace was created with uniform size 8k*8=64k, which is too small.

Given that the block size is 8192, the extent size of the tablespace should be at least  (8192*14) + 1 = 114689.

So after clean out object inside the tablespace by vendor, I re-create the tablespace with system-managed extent size.

See rainbow while walking home

Test post with picture from iphone.

Rename datafile on-the-flying

Imaging you accidentally append a space to the datafile...
Luckily, you have the database in archivelog mode.

Examples
1. Resize datafile if possible (for backup before rename: save space and faster copy)

SQL> ALTER DATABASE DATAFILE 'F:\oradata\live\Mydb02.ora ' RESIZE 50m; 

2. Take datafile offline:

SQL> ALTER DATABASE DATAFILE 'F:\oradata\live\Mydb02.ora ' OFFLINE;

Database altered.

3. at OS level, copy (preferable) or rename the file

cd  F:\oradata\live\

copy 'Mydb02.ora ' 'Mydb02.ora'
#cp -p 'Mydb02.ora ' 'Mydb02.ora'  (for unix like platform)

or move 'Mydb02.ora ' 'Mydb02.ora'
 

4. Rename the datafile in database to update control file 

ALTER DATABASE RENAME FILE 'F:\oradata\live\Mydb02.ora ' TO 'F:\oradata\live\Mydb02.ora
';

5. Take datafile online, when doing this, file recovery is needed to update the timestamp in the offline datafile header.:

SQL> ALTER DATABASE DATAFILE 'F:\oradata\live\Mydb02.ora' ONLINE;

ALTER DATABASE DATAFILE 'F:\oradata\live\Mydb02.ora' ONLINE
* ERROR at line 1: ORA-01113: file 16 needs media recovery
ORA-01110: data file 16: 'F:\ORADATA\LIVE\Mydb02.ORA'

SQL> RECOVER DATAFILE 'F:\oradata\live\Mydb02.ora';
 Media recovery complete.

SQL> ALTER DATABASE DATAFILE 'F:\oradata\live\Mydb02.ora' ONLINE;

Database altered

Ref:

1. ALTER DATABASE

2. Renaming or Moving Oracle Files

3. Move/rename datafiles in Oracle

alter system register to speed up dynamic registration

【LISTENER】使用“alter system register;”解决动态监听注册缓慢问题 - secooler 快乐的DBA - ITPUB个人空间 - powered by X-Space

7 Linux Grep OR, Grep AND, Grep NOT Operator Examples

7 Linux Grep OR, Grep AND, Grep NOT Operator Examples

db_block_checking overhead.

11g中的db_block_checking参数 | Oracle Clinic – 提供专业Oracle技术支持,性能调整及数据恢复服务

Furthermore, if there are few indexes, I believe more overhead needed.

I do have data loading performance issues in data warehouse, after enable  DB_ULTRA_SAFE = DATA_AND_INDEX

more redo size generated when undo tablespace is insufficient and rollback as result

oracle新人关于redo和undo的疑惑 - Oracle专题深入讨论 - ITPUB论坛 - it168旗下专业技术社区