Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Oracle cold backup preparation

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    We are planning to do the oracle cold backup tomorrow(11/4/2009) around 4:00pm on production system. One purpose for this backup is free some disk space. I want make sure the steps that we are going to take is correct:

    1.Make sure we have enough space for the cold backup.

    >>df -k
    Filesystem 1K-blocks Used Available Use% Mounted on
    /dev/sdc1 640951500 569960756 38432212 94% /exlibris
    /dev/sdd1 640951500 99331300 509061668 17% /exlibris1
    /dev/sde1 640951500 33254192 575138776 6% /exlibris2

    Do you think we have enough disk space on /exlibris?

    2. shutdown the oracle: util/o/1/2

    3. shutdown aleph:
    cd /exlibris/aleph/u18_1/alephe

    4. Our system Admin will perform the backup process. It may take 4 hours.

    5. After the cold backup is done. restart the aleph and oracle (aleph_startup, util/o/1/1)

    6. Delete the old arch files in /exlibris/oradata/aleph1/arch:
    >>ls -lrt /exlibris/oradata/aleph1/arch|more
    total 289616456
    -rw-r----- 1 oracle dba 120320 Nov 19 2007 arch_aleph1_1_1_639049151.dbf
    -rw-r----- 1 oracle dba 43193856 Nov 19 2007 arch_aleph1_1_2_639049151.dbf
    -rw-r----- 1 oracle dba 43193344 Nov 19 2007 arch_aleph1_1_3_639049151.dbf
    -rw-r----- 1 oracle dba 43193856 Nov 19 2007 arch_aleph1_1_4_639049151.dbf
    -rw-r----- 1 oracle dba 43193856 Nov 19 2007 arch_aleph1_1_5_639049151.dbf
    ..... up to today's date files.

    command :
    su - oracle

    ORACLE>> cd /exlibris/oradata/aleph1/arch

    ORACLE>> rm arch_aleph1_1_1_639049151.dbf

    Please let us know if this correct or not.

    The oradata which you are backing up is on /exlibris , so you do *not* want to write the backup files to /exlibris. (If the disk fails you will lose the /oradata *and* the backup.) You need to write the backup to /exlibris1, /exlibris2, or to tape.

    In doing a cold backup, no files are created on the disk you are backing up from. (When you do a hot backup, some files are generated on the disk you are backing up from.)

    aleph needs to be stopped before oracle and started after Oracle. Thus, the steps should be:

    2. shutdown aleph:
    cd /exlibris/aleph/u18_1/alephe

    3. shutdown the oracle: util/o/1/2

    4. ...

    5. After the cold backup is done, restart the oracle and aleph (util/o/1/1, aleph_startup)

    • Article last edited: 10/8/2013