{"id":419,"date":"2015-08-31T09:53:40","date_gmt":"2015-08-31T09:53:40","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=419"},"modified":"2015-08-31T09:53:40","modified_gmt":"2015-08-31T09:53:40","slug":"%ec%98%a8%eb%9d%bc%ec%9d%b8-%eb%b0%b1%ec%97%85-%ec%8a%a4%ed%81%ac%eb%a6%bd%ed%8a%b8-%eb%8d%b0%ec%9d%b4%ed%84%b0%ed%8c%8c%ec%9d%bc%ec%95%84%ec%b9%b4%ec%9d%b4%eb%b8%8c","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=419","title":{"rendered":"\uc628\ub77c\uc778 \ubc31\uc5c5 \uc2a4\ud06c\ub9bd\ud2b8 \ub370\uc774\ud130\ud30c\uc77c\/\uc544\uce74\uc774\ube0c"},"content":{"rendered":"

# \ub370\uc774\ud130\ud30c\uc77c \ubc31\uc5c5\uacfc archvie\ubc31\uc5c5 \uc258\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. <\/p>\n

<\/p>\n

1. begin backup\ud560 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc218\ud589\ud569\ub2c8\ub2e4. <\/p>\n

dbbegin.sh <\/p>\n

<\/p>\n

TBS_INFO=\/tmp\/tbs_info~.$$ <\/p>\n

<\/p>\n

sqlplus \/nolog << EOF > $TBS_INFO 2>&1 <\/p>\n

connect \/ as sysdba; <\/p>\n

select ”tablespace ”||tablespace_name from dba_tablespaces; <\/p>\n

disconnect; <\/p>\n

exit <\/p>\n

EOF <\/p>\n

<\/p>\n

cat $TBS_INFO | awk ”$1 == “tablespace” { print $2 }” | while read LINE <\/p>\n

do <\/p>\n

export LINE <\/p>\n

echo “Issuing alter tablespace $LINE begin backup;” <\/p>\n

\/usr\/openv\/netbackup\/oracle\/table_begin.sh <\/p>\n

done <\/p>\n

<\/p>\n

\\rm $TBS_INFO <\/p>\n

<\/p>\n

2. \uc704\uc5d0\uc11c\uc758 table_begin.sh \ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. <\/p>\n

<\/p>\n

table_begin.sh <\/p>\n

<\/p>\n

sqlplus \/nolog << EOF > \/dev\/null 2>&1 <\/p>\n

connect \/ as sysdba; <\/p>\n

alter tablespace $LINE begin backup; <\/p>\n

disconnect; <\/p>\n

exit <\/p>\n

EOF <\/p>\n

<\/p>\n

3. dbbegin.sh \uc744 \ud558\uac8c \ub418\uba74 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uac00 backup mode\uac00 \ub429\ub2c8\ub2e4. <\/p>\n

<\/p>\n

<\/p>\n

4. \ub370\uc774\ud130\ud30c\uc77c \ub9ac\uc2a4\ud2b8\ub97c \ucd94\ucd9c\ud569\ub2c8\ub2e4. <\/p>\n

datafile_list <\/p>\n

<\/p>\n

#!\/bin\/ksh <\/p>\n

<\/p>\n

DATAFILE_INFO=\/tmp\/datafile_info~.$$ <\/p>\n

datafile_list=\/tmp\/PROD_data_list <\/p>\n

<\/p>\n

sqlplus \/nolog << EOF > $DATAFILE_INFO 2>&1 <\/p>\n

connect \/ as sysdba; <\/p>\n

select ”datafile_name ”||file_name from dba_data_files; <\/p>\n

select ”logfile_name ”||member from v\\$logfile; <\/p>\n

select ”controlfile_name ”||name from v\\$controlfile; <\/p>\n

disconnect <\/p>\n

EOF <\/p>\n

<\/p>\n

cat $DATAFILE_INFO | awk ”$1 == “datafile_name” {print $2}” <\/p>\n

> \/tmp\/PROD_dbfile_list <\/p>\n

cat $DATAFILE_INFO | awk ”$1 == “logfile_name” {print $2}” <\/p>\n

> \/tmp\/PROD_logfile_list <\/p>\n

cat $DATAFILE_INFO | awk ”$1 == “controlfile_name” {print $2}” <\/p>\n

> \/tmp\/PROD_controlfile_list <\/p>\n

<\/p>\n

cat \/tmp\/PROD_dbfile_list > $datafile_list <\/p>\n

cat \/tmp\/PROD_logfile_list >> $datafile_list <\/p>\n

cat \/tmp\/PROD_controlfile_list >> $datafile_list <\/p>\n

<\/p>\n

<\/p>\n

\\rm $DATAFILE_INFO <\/p>\n

<\/p>\n

5. \ub370\uc774\ud130\ud30c\uc77c \ub9ac\uc2a4\ud2b8\ub97c netbackup\uc5d0\uc11c tape\ubc31\uc5c5\uc744 \ud558\ub3c4\ub85d \ud569\ub2c8\ub2e4. <\/p>\n

veritas netbackup\uc5d0\uc11c \ub9ac\uc2a4\ud2b8\ub9cc \uc8fc\uba74 \ubc31\uc5c5\ud574\uc90c.. <\/p>\n

<\/p>\n

6. end backup \uc744 \ub9cc\ub4dc\ub294 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc218\ud589 <\/p>\n

dbend.sh <\/p>\n

#!\/bin\/ksh <\/p>\n

<\/p>\n

TBS_INFO=\/tmp\/tbs_info~.$$ <\/p>\n

<\/p>\n

sqlplus \/nolog << EOF > $TBS_INFO 2>&1 <\/p>\n

connect \/ as sysdba; <\/p>\n

select ”tablespace ”||tablespace_name from dba_tablespaces; <\/p>\n

disconnect; <\/p>\n

exit <\/p>\n

EOF <\/p>\n

<\/p>\n

cat $TBS_INFO |awk ”$1 == “tablespace” { print $2 }”|while read LINE <\/p>\n

do <\/p>\n

export LINE <\/p>\n

echo “Issuing alter tablespace $LINE end backup;” <\/p>\n

\/usr\/openv\/netbackup\/oracle\/table_end.sh <\/p>\n

done <\/p>\n

\\rm $TBS_INFO <\/p>\n

<\/p>\n

7. \uc704\uc5d0\uc11c table_end.sh \ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. <\/p>\n

<\/p>\n

table_end.sh <\/p>\n

sqlplus \/nolog << EOF > \/dev\/null 2>&1 <\/p>\n

connect \/ as sysdba; <\/p>\n

alter tablespace $LINE end backup; <\/p>\n

disconnect; <\/p>\n

exit <\/p>\n

EOF <\/p>\n

<\/p>\n

6. archive log\uac00 \uc5c6\uc744 \uc218 \uc788\uc73c\ubbc0\ub85c \uc218\ub3d9\uc73c\ub85c log switch \ud574\uc90d\ub2c8\ub2e4. <\/p>\n

<\/p>\n

arch_list_1 <\/p>\n

#!\/bin\/ksh <\/p>\n

<\/p>\n

sqlplus \/nolog << EOF > $LOG <\/p>\n

connect \/ as sysdba; <\/p>\n

alter system switch logfile; <\/p>\n

disconnect; <\/p>\n

exit; <\/p>\n

EOF <\/p>\n

<\/p>\n

<\/p>\n

7. archvie file\uc758 \ub9ac\uc2a4\ud2b8\ub97c \ubf51\uc544\ub0c5\ub2c8\ub2e4. <\/p>\n

<\/p>\n

arch_list <\/p>\n

<\/p>\n

#!\/bin\/ksh <\/p>\n

<\/p>\n

TBS_INFO=\/tmp\/tbs_info~.$$ <\/p>\n

ARCHIVE_DIR=\/tmp\/PROD_archive_dir.txt <\/p>\n

<\/p>\n

sqlplus \/nolog << EOF > $LOG 2>&1 <\/p>\n

connect \/ as sysdba; <\/p>\n

alter system switch logfile; <\/p>\n

disconnect; <\/p>\n

exit; <\/p>\n

EOF <\/p>\n

<\/p>\n

sqlplus \/nolog << EOF > $TBS_INFO 2>&1 <\/p>\n

connect \/ as sysdba; <\/p>\n

archive log list; <\/p>\n

disconnect; <\/p>\n

exit; <\/p>\n

EOF <\/p>\n

<\/p>\n

cat $TBS_INFO | awk ”$1 == “Archive” {print $3}” > $ARCHIVE_DIR <\/p>\n

<\/p>\n

ARCH_DIR=<\/p>\n

cat $ARCHIVE_DIR<\/p>\n

<\/p>\n

ARCH_LIST_PROD=<\/p>\n

ls -ltr $ARCH_DIR\/*.arc |wc -l<\/p>\n

<\/p>\n

echo “ARCH_LIST_PROD : $ARCH_LIST_PROD” >> $LOG <\/p>\n

<\/p>\n

ARCH_LIST_PROD_1=<\/p>\n

expr$ARCH_LIST_PROD – 1<\/p>\n

<\/p>\n

echo “ARCH_LIST_PROD_1 : $ARCH_LIST_PROD_1” >> $LOG <\/p>\n

<\/p>\n

\/usr\/bin\/ls -ltr $ARCH_DIR\/*.arc |awk ”{print $9}” |head – <\/p>\n

$ARCH_LIST_PROD_1 > \/tmp\/PROD_arch_list <\/p>\n

<\/p>\n

echo “Archive Log List Print…..O.k….<\/p>\n

\/usr\/bin\/date +%c<\/p>\n

” >> $LOG <\/p>\n

#\\rm $TBS_INFO $ARCHIVE_DIR <\/p>\n

<\/p>\n

<\/p>\n

8. \uc704\uc5d0\uc11c \/tmp\/PROD_arch_list\uc5d0 \uc788\ub294 archive\ub9ac\uc2a4\ud2b8\ub97c veritas netbackup\uc5d0\uc11c \ub123\uc5b4\uc8fc\uba74 tape\ubc31\uc5c5\uc774 \ub429\ub2c8\ub2e4.\uadf8\ub9ac\uace0 \ud2b9\uc774\ud55c \uac83\uc740 archvie file\uc740 archive file\uc744 \ubc31\uc5c5\ud588\uc73c\uba74 \uc9c0\uc6b0\ub3c4\ub85d \uc124\uc815<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

# \ub370\uc774\ud130\ud30c\uc77c \ubc31\uc5c5\uacfc archvie\ubc31\uc5c5 \uc258\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.  1. begin backup\ud560 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc218\ud589\ud569\ub2c8\ub2e4.  dbbegin.sh  TBS_INFO=\/tmp\/tbs_info~.$$  sqlplus \/nolog << EOF > $TBS_INFO 2>&1  connect \/ as sysdba;  select ”tablespace ”||tablespace_name from dba_tablespaces;  disconnect;  exit  EOF  cat $TBS_INFO | awk ”$1 == “tablespace” { print $2 }” | while read LINE  do  export LINE  echo “Issuing alter tablespace […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[3],"tags":[167,168,169],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/419"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=419"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/419\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=419"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}