rman and nls date format – until time

on June 17, 2008 at 8:16 am
Posted In: Oracle Rman Notes (Cat)

— Before invoking RMAN, set the NLS_DATE_FORMAT and NLS_LANG environment variables.

— These variables determine the format used for the time parameters in RMAN commands such as RESTORE, RECOVER, and REPORT.

— The following example shows typical language and date format settings:

export NLS_LANG=english.WE8MSWIN1252
export NLS_DATE_FORMAT=’Mon DD YYYY HH24:MI:SS’

set NLS_LANG=english.WE8MSWIN1252
set NLS_DATE_FORMAT=Mon DD YYYY HH24:MI:SS

— To perform an incomplete recovery, shutdown the databases, startup mount

Shutdown immediate;
startup mount;
RUN
{
  SET UNTIL TIME ‘Oct 28 2005 11:00:00’;
  # SET UNTIL SCN 1000;       # alternatively, you can specify SCN
  # SET UNTIL SEQUENCE 9923;  # alternatively, you can specify log sequence number
  RESTORE DATABASE;
  RECOVER DATABASE;
}
ALTER DATABASE OPEN RESETLOGS;

– Shutdown the database and perform a full backup