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