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

Description:
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
aleph_shutdown

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:
examples:
>>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.

Resolution:
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
aleph_shutdown

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