| Deepakkumar |
Posted: Jul 16, 2008 01:35:40 AM |
Total Post: 34
Joined: Dec, 2007
|
hi, i am facing one problem .when i used to take a export back up its size was nearly 20 mb but now a days it shriks to 12 mb.i have not deleted any data,table,tablespace or anything .can anybody tell me how come it automatically shrinks? i give 'exp system/manager filename.dmp full=y'
command from client machine.
|
|
|
 Avnish |
| Posted: Jul 16, 2008 02:18:58 AM |  |
|
Total Post: 154
Joined: Dec, 2007
|
Hi,
Did you done any Comparisons from Older backup & New Backup. Put your new backup online & older one & compare First.
Thanks & Regards
Avnish Yadav
|
|
|
|
|
| Deepakkumar |
| Posted: Jul 16, 2008 05:24:06 AM | |
|
Total Post: 34
Joined: Dec, 2007
|
thanks avnish for the quick reply.though the back up size got smaller but the normal functioning of application is going fine.and all the data is available.and cold back up size is as it is.
|
|
|
|
|
| Avnish |
| Posted: Jul 16, 2008 05:29:09 AM | |
|
Total Post: 154
Joined: Dec, 2007
|
Hi,
Please check your log file when you have last backup & Compare it with 20MB size backup's log file. or Are you using DATAPUMP?
Thanks & Regards
Avnish Yadav
|
|
|
|
|
| Avnish |
| Posted: Jul 16, 2008 05:31:43 AM | |
|
Total Post: 154
Joined: Dec, 2007
|
Hi,
Please forward you complete command lines which you are using for backup now. & Also forward send your command line which you are using when your database backup is 20MB in size.
Thanks & Regards
Avnish Yadav
|
|
|
|
|
| Avnish |
| Posted: Jul 16, 2008 05:32:57 AM | |
|
Total Post: 154
Joined: Dec, 2007
|
Hi,
If your using DATAPUMP (Oracle 10g EXPORT) then it will automatically shrink some of size of your backup file.
Thanks & Regards
Avnish Yadav
|
|
|
|
|
| Avnish |
| Posted: Jul 18, 2008 12:56:39 AM | |
|
Total Post: 154
Joined: Dec, 2007
|
Hi,
Did You Find any Solutions... Please update this thread if you got the solutions.
Thanks & Regards
Avnish Yadav
|
|
|
|
|
| Deepakkumar |
| Posted: Jul 18, 2008 04:58:09 AM | |
|
Total Post: 34
Joined: Dec, 2007
|
not find any solution. i am using oracle 9i on red hat linux.
command line exp system/manager file=<filename>.dmp full=y
|
|
|
|
|
| Deepakkumar |
| Posted: Jul 18, 2008 04:59:31 AM | |
|
Total Post: 34
Joined: Dec, 2007
|
not find any solution. i am using oracle 9i on red hat linux.
command line exp system/manager file=<filename>.dmp log=<filename>.log full=y
this is the only command line i am using.
|
|
|
|
|
| positive |
| Posted: Aug 11, 2008 09:18:26 PM | |
|
Total Post: 483
Joined: Jun, 2008
|
http://neworacledba.blogspot.com
|
|
|
|
|
| positive |
| Posted: Aug 11, 2008 09:18:30 PM | |
|
Total Post: 483
Joined: Jun, 2008
|
http://neworacledba.blogspot.com
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
