RMAN

RMAN: Basic RMAN Commands Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, manageable backup and recovery, for all Oracle data formats. RMAN  provides a common interface, via command line and Enterprise Manager, for backup tasks...

FLASHBACK DATABASE

Please keep in mind till the Transactions are in Undo until then the DB can be restored .. To take Restore Point .. SQL> select flashback_on from v$database; FLASHBACK_ON —————— NO SQL> Alter database flashback on; CREATE...

FLASHBACK SESSION

Changing the session time in back –step 1 select * from REGION_ANI; begin dbms_flashback.enable_at_time(to_timestamp(’12-03-14 17:26:06′,’dd-mm-yy hh24:mi:ss’)); end; –step 2 select * from REGION_ANI; –step 3 begin...

FLASHBACK TABLE

Only FLASHBACK DATABASE requires flashback to be ‘ON’ since only FLASHBACK DATABASE uses flashback logs in the flash_recovery_area. All other forms of FLASHBACK use the recycle bin and undo_tablespace. Important info: You cannot ‘flashback table to before drop’ a...

Oracle DBA day to day activity

Tablespace size and uses set linesize 230 SELECT Total.name “TABLESPACE_NAME”, nvl(Free_space, 0) FREE_SPACE, nvl(total_space-Free_space, 0) USED_SPACE, total_space,round((nvl(free_space,0)/nvl(total_space,0)*100),2) “PCTFREE”...