[Oracle DataBase Server 12.1 installation on Windows 2008 Server]: Create a cold backup


sqlplus / as sysdba


SQL> shutdown immediate;
SQL> startup mount;
SQL> quit


$ rman target /


RMAN> backup full database noexclude include current controlfile spfile TAG "FULL_COLD_BACKUP";


****
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 25-AUG-13


RMAN> sql 'alter database open';


RMAN> quit


sqlplus / as sysdba


Get information about FRA usage:


SQL> SELECT
    TO_CHAR(SPACE_USED, '999,999,999,999') AS "Used",
    TO_CHAR(SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE, '999,999,999,999')
       AS "Free",
    ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1)
       AS "Used %"
    FROM V$RECOVERY_FILE_DEST;


Used             Free                 Used %
---------------- ---------------- ----------
     520,380,416   20,974,837,760        2.3


SQL> quit