$ORACLE_HOME : /oracle/product/10.2.0/db_1
백업경로 : /backup/archive1
/archive2
/close/dbs
/ora10g
/open/dbs
/ora10g
-------------------------------------------------------------------------------------------------------------------
SQL> col name format a45
SQL> select name, status from v$datafile;
NAME STATUS
--------------------------------------------- -------
/oracle/oradata/ora10g/system01.dbf SYSTEM
/oracle/oradata/ora10g/undotbs01.dbf ONLINE
/oracle/oradata/ora10g/sysaux01.dbf ONLINE
/oracle/oradata/ora10g/users01.dbf ONLINE
/oracle/oradata/ora10g/example01.dbf ONLINE
SQL>
SQL> select * from v$controlfile;
STATUS NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS
------- --------------------------------------------- --- ---------- --------------
/oracle/oradata/ora10g/control01.ctl NO 16384 430
/oracle/oradata/ora10g/control02.ctl NO 16384 430
/oracle/oradata/ora10g/control03.ctl NO 16384 430
SQL> col member format a45
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- --------------------------------------------- ---
3 ONLINE /oracle/oradata/ora10g/redo03.log NO
2 ONLINE /oracle/oradata/ora10g/redo02.log NO
1 ONLINE /oracle/oradata/ora10g/redo01.log NO
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> !cp /oracle/oradata/ora10g/* /backup/close/ora10g
SQL> !cp $ORACLE_HOME/dbs/* /backup/close/dbs
SQL> !rm -rf /backup/archive1/*
SQL> !rm -rf /backup/archive2/*
SQL> !tar cvfz /backup/oracle.tar.gz /oracle
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 88082676 bytes
Database Buffers 75497472 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL>
닫힌 백업
|
2006.10.30 10:42:41
|
2006.10.30 10:42:41
|
698
|
Aiden
Total of Attached file
0.00 Bytes of 0 files
2006.11.15
2006.11.02
2006.11.02
2006.10.31
2006.10.30
2006.10.30
2006.10.26
2006.10.25
2006.09.11
2006.04.10
2005.10.21