Sunday, January 23, 2011

Taking export in Compressed form + Running Export in nohup mode

It is one of the regular DBA activity to take the Backup of database of the schema via exp utility..if we are facing any issue related to the space we can alway is this command to compress the backups and ...if export schema is big and going to take time no need to waste your sleep just run that in backgroung using nohup

 and here it goes

=== Generating Export dump in compressed form ====


iinerva(ammsc001):/m002/oradata/ak>vi exp_4schm.sh

"exp_4schm.sh" 1 line, 1 character

rm exp_pipe

mknod exp_pipe p

compress < exp_pipe > 4Schema_SRF100303.dmp.Z &

exp userid=vijay/spring*****@AMMSC001 file=exp_pipe owner=SALSY,SALEX,SALPF,SALVO statistics=none
buffer=100000
~
~
====== Running in nohup mode =======

iinerva(ammsc001):/m002/oradata/ak>nohup sh exp_4schm.sh &

[1] 74842

iinerva(ammsc001):/m002/oradata/ak>Sending nohup output to nohup.out.

iinerva(ammsc001):/m002/oradata/ak>tail -f nohup.out

About to export SALSY's objects ...

. exporting database links

. exporting sequence numbers

. exporting cluster definitions

. about to export SALSY's tables via Conventional Path ...

. . exporting table AFDELINGEN 7510 rows exported

. . exporting table AFDELINGENGROEPEN 58 rows exported

. . exporting table AFDELINGENGROEPKODES 14 rows exported

. . exporting table AHOLD_LOONKODES 734 rows exported

. . exporting table AHOLD_MUTATIES 5748 rows exported

. . exporting table ARBEIDSRELATIES 450424 rows exported

. . exporting table AVW_CAO_KODES 81 rows exported

. . exporting table AVW_GROEPEN 3215 rows exported

. . exporting table AVW_GROEPKODES 58 rows exported

. . exporting table

........



No comments:

Post a Comment