유닉스 기술문서 - 오라클 Arch 장애시 해결 방법

[UNIX]
[1] Solaris 에서 Password Aging 확인
# passwd -s User명
[2] ufsdump backup 명령어
ufsdump 0uf - / | (cd /WORK/osbackup/; ufsrestore rf -)
ufsdump 0uf - /opt | (cd /WORK/osbackup_opt/; ufsrestore rf -)

[ORACLE]
[1] Oracle Arch 장애시 해결 방법
1)현상
ARC0: Archiving not possible: error count exceeded
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance ORA8 - Archival Error
ARCH: Connecting to console port...
ORA-16038: log 3 sequence# 7420 cannot be archived
ARC0: Archiving not possible: No primary destinations
2)조치
이런 Oracle 오류는 ARCH 가 Full 났을경우 나타남...
먼저
-- Arch 백업을 받고, ARCH 삭제한다.
-- sqlplus internal 로그인해서 아래와 같이 실행한다.
SQL> alter system archive log start
3) reference
Refer to this note: metalink(ORA-16038)
1074990.6 Archiving Not Possible: No Primary Destinations

<UFSDUMP Restore>

cd /opt
mt -f /dev/rmt/0 status
mt -f /dev/rmt/0 rew
mt -f /dev/rmt/0n fsf 1 --> /opt 헤더 영역으로 이동
ufsrestore if /dev/rmt/0n
ufsrestore>
ufsrestore> ls
ufsrestore> add mfcobol --> *mfcobol
ufsrestore> ls
ufsrestore> extract
Specify next volume #: 1

set owner/mode for '.'? [yn] y
ufsrestore>

truss -p 17619

#ufsdump 0uf - / | (cd /WORK/osbackup/; ufsrestore rf -)
ufsdump 0uf - /opt | (cd /WORK/osbackup_opt/; ufsrestore rf -)
#ufsdump 0f - /ORAINDEX | (rsh call " cd /ORAINDEX; ufsrestore xvf - )
tar cvpf - . | ( cd /a; tar xvpt - )

find rc* -name grep swapadd {} \;
find rc* -exec grep swapadd {} \;
find rc* -exec grep -l swapadd {} \;
find * -exec grep -l License {} \;

# 추가 정보 #
mt -f /dev/rmt/0 rewind
mt -f /dev/rmt/0 status
dd if=./libpython2.2.a of=/dev/rmt/0n
dd if=./nmap-3.00-sol26-sparc-local.gz of=/dev/rmt/0n


mt -f /dev/rmt/0n fsf 1
dd if=/dev/rmt/0n of=tttt

## remote copy
#ufsdump 0f - /ORAINDEX | (rsh new " cd /ORAINDEX; ufsrestore xvf - ")