Ŭ ġǾ ִ Ƽǿ ũ Ǯ(full) ణ Ȯϴ Դϴ.
1. dump Ȯ
(file>pfile)/#more inittest.ora ---- 丮 ġ Ȯ.
- pfile 丮 Ŭ 丮 /admin 丮 .
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=/oracle/admin/nice/bdump
core_dump_dest=/oracle/admin/nice/cdump
timed_statistics=TRUE
user_dump_dest=/oracle/admin/nice/udump
#####################
# Archive mode
#####################
log_archive_start=true
log_archive_dest=/oracle/oradata/nice/arch
log_archive_format="%S.ARC"
------------------------------------------------------
(file>admin)/#pwd
/oracle/admin/nice
(file>admin)/#ls
bdump cdump create pfile udump
(file>admin)/#
- bdump , cdump , udump ִ .
(file>bdump)/#ls -alt | more
- -alt ̿ Ͽ ֱٿ Ϻ ǵ մϴ.
(file>bdump)/#rm nice_arc0_11933.trc
- rm .
- Ǵ tar ִµ ü . ( rm -rf *.* )
- tar xvf bdump.tar ./*
(file>cdump)/#rm core_10120
- rm .
- Ǵ tar ִµ ü . ( rm -rf *.* )
- tar xvf core.tar ./*
(file>udump)/#rm nice_ora_15535.trc
- rm .
- Ǵ tar ִµ ü . ( rm -rf *.* )
- tar xvf udump.tar ./*
2. log
(file>cdump)/#cd /oracle/app/902/network/log
dbsnmp.nohup
(file>log)/#rm dbsnmp.log listener.log nmiconf.log sqlnet.log
3. audit
(file>log)/#cd /oracle/app/902/rdbms/audit
- audit ִ .
ӽ Ŭ Ƽ Ȯ ϴ Դϴ.
- ý ī̺ α 带 ̿ ϸ鼭 Ŭ Ƽǿ
ī̺ α ȮҼ ֽϴ.
4. ī̺ α Ȯ.
(file>log)/# sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Apr 11 19:12:53 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> archive list;
SP2-0734: unknown command beginning "archive li..." - rest of line ignored.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/oradata/nics/arch ---- ī̺ α .
Oldest online log sequence 601
Next log sequence to archive 603
Current log sequence 603
SQL> quit
(file>log)/#cd /oracle/oradata/nics/arch
(file>arch)/#ls -alt --- ֱ Ϻ
(file>arch)/#rm 0000000420.ARC
- rm .
- Ǵ tar ִµ ü . ( rm -rf *.* )
- tar xvf bdump.tar ./*