$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
|
373
|
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