()ý
Home
Ȩ ȸҰ ý Ʈ ũ
 
 
ۼ : 06-03-02 16:31
oracle cold backup ̽
 ۾ :
ȸ : 6,798  
  cold backup ̿Ͽ ͺ̽ ϴ ͺ̽ İ ϴ մϴ. ͺ̽ No archive mode  쿡 ̹ ̸ archive mode  쿡 ̿ ֽϴ.

cold backup .
  - copy ϴ
  -
  - ֿ

cold backup .
  - ϳ ߸ Ǵ ü
  - Ŀ ڷ .
  - cold backup ̿ؼ ( Host backup ̿Ͽ Ұ )
  - ϴ ͺ̽ .

.

 - ͺ̽ α ̹ ̽ ۵ ϵ ߽ϴ. ͺ̽ ޽ ߻.

SQL> startup
ORACLE instance started.

Total System Global Area  202868256 bytes
Fixed Size                  730656 bytes
Variable Size            167772160 bytes
Database Buffers          33554432 bytes
Redo Buffers                811008 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/OraHome1/orcl/test.dbf'

SQL>

 1. ̽ .

SQL> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.

 2. ޾Ҵ α, Ʈ .


SQL> !cp /data1/dbs/* /oracle/dbs

SQL> !cp /data1/oradata/orcl/* /oracle/oradata/orcl

SQL> !cp /data1/OraHome1/orcl/* /OraHome1/orcl

 cold backup datafiles, controlfile, redo log file ( ִ ġ) մϴ.Ķ /н , archiv log mode Ǿ ִٸ archive log file մϴ.

 3. ̽ .

SQL> startup
ORACLE instance started.

Total System Global Area  202868256 bytes
Fixed Size                  730656 bytes
Variable Size            167772160 bytes
Database Buffers          33554432 bytes
Redo Buffers                811008 bytes
Database mounted.
Database opened.
SQL>

 
 

Total 136
ȣ     ۾ ¥ ȸ
16 sysstat1.5 ýۻ¸
2006/03/03 3986
15 oracle cold backup ̽
2006/03/02 6799
14 oracle cold backup - ͺ̽
2006/03/02 5777
13 ORACLE LISTENER
2006/03/02 6651
12 TAPE DEVICE ġ ̸ .
2006/03/02 4209
11 mrtg ġ  solaris 9
2005/12/21 6082
10 pfile & spfile
2006/02/21 5537
9 ORACLE Instance oratest - Can not allocate log, archival req
2005/08/24 6730
8 Raid 0 + 1 , 1+ 0
2006/01/19 6945
7 oracle 9.2.0.7.0 patch
2006/02/27 6263
6 oracle Ȯ.
2006/02/24 6627
5 ORA-16032: parameter LOG_ARCHIVE_DEST
2006/02/21 10701
4 Archive log mode
2006/02/21 4841
3 oracle archive log mode & noarchive log mode
2006/02/21 6766
2 oracle export - import
2006/02/03 10301
 1  2  3  4  5  6  7  8  9  10  
 
 
 
Administrator Login