■     NOARCHIVELOG 모드에서의 전체 오프라인 백업     ■ 



SVRMGR> select file_name from sys.dba_data_files;

FILE_NAME
-------------------------------------------------
E:ORAWIN95DATABASEUSR1ORCL.ORA
E:ORAWIN95DATABASERBS1ORCL.ORA
E:ORAWIN95DATABASETMP1ORCL.ORA
E:ORAWIN95DATABASESYS1ORCL.ORA

4 rows selected.

SVRMGR> select member from v$logfile;
MEMBER
---------------------------------------
E:ORAWIN95DATABASELOG2ORCL.ORA
E:ORAWIN95DATABASELOG1ORCL.ORA

2 rows selected.

SVRMGR> select value from v$parameter where name = 'control_files';

VALUE
---------------------------------------------------------------------
E:ORAWIN95DATABASEctl1orcl.ora

1 row selected.

SVRMGR> shutdown normal
Database closed.
Database dismounted.
ORACLE instance shut down.

SVRMGR> host

Microsoft(R) Windows 95
   (C)Copyright Microsoft Corp 1981-1995.

E:ORAWIN95DATABASE>copy *.* e:orawin95databasebackup
INST.ORA
INITORCL.ORA
SYS1ORCL.ORA
RBS1ORCL.ORA
TMP1ORCL.ORA
USR1ORCL.ORA
pwdorcl.ora
CTL1ORCL.ORA
LOG2ORCL.ORA
LOG1ORCL.ORA
       10 file(s) copied

E:ORAWIN95DATABASE>exit

SVRMGR> startup
ORACLE instance started.
Total System Global Area       4504332 bytes
Fixed Size                       35208 bytes
Variable Size                  4051332 bytes
Database Buffers                409600 bytes
Redo Buffers                      8192 bytes
Database mounted.
Database opened.
SVRMGR> host
이 게시물을..