This discussion is archived
1 Reply Latest reply: Dec 20, 2012 4:09 AM by Niket Kumar RSS

how to find how much space is required for backup.

947771 Newbie
Currently Being Moderated
Hi,

I have 7 gb of space available but on backup it is saying space not avialable,
Please tel me following
1) how to find how much backup space is required.
2) and i think it does not currup the old backup set when backup fails?so i can feel good that my old backup is ok?
3) which folder i should copy, to keep backup of backup on other machine.(C:\ORACLEXE\APP\ORACLE\FAST_RECOVERY_AREA\XE)
4) and also tel me where orignal files of database is present i will backup that also like in MSSQL.
5)please also tel me how to change the backup location to other drive.
yours sincerely

Edited by: 944768 on Dec 19, 2012 9:16 PM

Edited by: 944768 on Dec 19, 2012 10:55 PM
  • 1. Re: how to find how much space is required for backup.
    Niket Kumar Pro
    Currently Being Moderated
    1)this you can check from your old backup size.add a little to it and that is your backup space requirement.
    2)if space is not there then failed backup is corrupt.other old backups remain intect.
    3)you need to shutdown database for copying folder or put data files in backup mode(id archivelogs are enable on database).
    4)you can check original database files dba_data_files,v$controlfile views and as point 3 is valid on them if you using copy paste rather then RMAN.
    5)when taking backup from rman use
    RMAN> RUN {
      ALLOCATE CHANNEL d1 DEVICE TYPE DISK
      FORMAT '/u01/backups/%U';
      BACKUP DATABASE PLUS ARCHIVELOG;
      RELEASE CHANNEL;
    }
    In format clause you can give disk location.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points