Recover Data Block Using Flashback | dailyDBA 43

Подписаться 37 тыс.

Просмотров 3 тыс.

50% 1

00:00 DBA challenge question
1:12 Can I use flashback to recover a data block?
4:52 How can we significantly reduce the backup size?
10:23 Can a user change their own password in Oracle?
11:40 If we rollback to a savepoint, are the UNDO blocks generated after the savepoint released right away?
13:18 Does the RESOURCE Role already have UNLIMITED TABLESPACE privilege or I have to grant it separately?
Website: www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis

Наука

Опубликовано:

30 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 13

@Kumbutranjaami 4 года назад

Your dba challenge question includes lot of different concepts like row migration, automatic segment space management (opposed to free list kind of segments space management), PCTFREE value of that table, HWM of the table. So depends on on the situation and value of these parameters, oracle will take different paths for inserting the rows whether in a new block or in a existing block where space is available.

@vineet2802 4 года назад

You are right Arun. When we perform data purge activity in my environment, oracle gives us surprises during import.

@rajagrandhi7547 3 года назад

Hi arun, Nice 👍👍👍 explanations. Finally I found ryt channel for dba

@mahmudurkhan5754 4 года назад

God bless you Sir

@bharathkumar-ds8cd 4 года назад

As a rac dba most of the times we miss sla in patching time, every quarter we facing minimum two to three times slas breached in production environments. That's why we choose out of place patching to reduce minimal down time.

@sandeepsindhu346 4 года назад

Great

@tamahesh Год назад

How to remove the flashback logs when fra is full? Flashback logs is in ASM. How to backup the flashback logs?

@shineshvv 4 года назад

Hi Arun, Can't we use the Rman block recovery option instead of restoring the entire DF and recover ?

@Tinkuuuuuuu Год назад

Hello sir can i move sysaux datafiles to another file system with alter database move command without any downtime ? I know that this his works for both archivelog and nonarchivelogmode. Please suggest

@dbagenesis Год назад

Moving the SYSaux datafiles to another file system using the ALTER DATABASE MOVE command without any downtime is not recommended. The SYSaux tablespace contains critical metadata for Oracle Database features, and moving it requires additional steps and caution. It is best to consult the Oracle documentation or seek assistance from a database administrator for this operation.