Oracle cold backup preparation
- 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