[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