Search This Blog

Total Pageviews

Monday 14 February 2011

Oracle RMAN Configuring Tablespaces for Exclusion/exclude

RMAN exclude Tablespace

The exclusion condition applies to any datafiles that you add to this tablespace in the future.

RMAN> CONFIGURE EXCLUDE FOR TABLESPACE XXXX;

XXXX <<<<<<<--- tablespace name

RMAN will not take backup of XXXX tablespace


To Clear exclusion .....

RMAN> CONFIGURE EXCLUDE FOR TABLESPACE XXXX CLEAR ;

RMAN> SHOW EXCLUDE;

Oracle Date Time - How to add second Minute hour

Example using NUMTODSINTERVAL with SYSDATE:



Example-- Add 20 second in system time

select to_char(sysdate,'dd/mm/yyyy hh:mi:ss'),to_char (SYSDATE + NUMTODSINTERVAL(20,'SECOND'),'dd/mm/yyyy hh:mi:ss') from dual;


One of the string constants: 'DAY', 'HOUR', 'MINUTE', or 'SECOND'.

Oracle DBA

anuj blog Archive