| |
Posted: Feb 20, 2008 01:10:38 AM |
Total Post: 43
Joined: Sep, 2007
|
if my Archive log file is full the what should i do?
|
|
|
 ramesh |
| Posted: Feb 20, 2008 01:44:37 AM |  |
|
Total Post: 40
Joined: Aug, 2007
|
hellow,
You can move them temporarly to any one of location by using this
Alter system archive log move to '/-------';
|
|
|
|
|
| Mohammed Taj |
| Posted: Feb 20, 2008 02:32:29 AM | |
|
Total Post: 704
Joined: Jul, 2007
|
Take database backup and delete or move all archivelog before backup to tape drive or backup archive location.
it is better take database backup regulary and delete all archivelog before backup.
|
|
|
|
|
| |
| Posted: Feb 20, 2008 03:34:11 AM | |
|
Total Post: 43
Joined: Sep, 2007
|
Thanks a lot Taj and Ramesh.
Really i m very happy to get the answer
Thanks a lots.
|
|
|
|
|
| shantanu |
| Posted: Feb 21, 2008 02:17:46 PM | |
|
Total Post: 42
Joined: May, 2007
|
Best way is to redirect the log stream to another file system temporarily and kick off an archive log backup to free up arch log space in the principal location. Later divert log stream to its original location.
SQL> alter system set log_archive_dest = 'new file system path';
|
|
|
|
|
| |
| Posted: Feb 22, 2008 12:03:58 AM | |
|
Total Post: 43
Joined: Sep, 2007
|
Thanks a lot Santanu.
one more questions plz.
i want to know the archive log file size, means how many free space is in the archive log file,that i can aware of filing the archive log file.and before filling the archive log ,i can able to take backup of these archive log file and set the new path for new achive..
plz suggests me as soon as possible.
|
|
|
|
|
| shantanu |
| Posted: Feb 22, 2008 01:38:08 PM | |
|
Total Post: 42
Joined: May, 2007
|
Be in the archive log file system and check for the space usage df -k . unix command will tell you free space in the arch log file s/m. Once it reaches 85% or higher you can divert log stream and take arch log backup.
|
|
|
|
|
| |
| Posted: Feb 23, 2008 12:45:59 PM | |
|
Total Post: 43
Joined: Sep, 2007
|
Thanks for replying me again,
but i m using Win NT 2003, and my oracle version is 9.2.0.1.0.
plz tell me the same procedure in windows NT.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
