■     ARCHIVELOG 모드에서의 온라인 테이블스페이스의 데이타 파일 백업     ■ 


1. init.ora화일의 내용을 수정함.

log_archive_start = true      # if you want automatic archiving
log_archive_dest=%ORACLE_HOME%DATABASEARCHIVE
log_archive_format=%s.dbf



E:ORAWIN95DATABASE>svrmgr

Oracle Server Manager Release 2.3.3.0.0 - Production

Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.

Personal Oracle7 Release 7.3.3.0.0 - Production Release
With the distributed and replication options
PL/SQL Release 2.3.3.0.0 - Production

SVRMGR> connect internal
Connected.

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

SVRMGR> startup mount
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.

SVRMGR> archive log list
Database log mode              No Archive Mode
Automatic archival             Enabled
Archive destination            E:ORAWIN95DATABASEARCHIVE
Oldest online log sequence     1
Current log sequence           1

SVRMGR> alter database archivelog;
Statement processed.

SVRMGR> alter database open;
Statement processed.

SVRMGR> select * from v$database;
NAME      CREATED              LOG_MODE     CHECKPOINT ARCHIVE_CH
--------- -------------------- ------------ ---------- ----------
ORACLE    09/22/97 19:59:53    ARCHIVELOG         7603          0
1 row selected.

SVRMGR> select tablespace_name, file_name from sys.dba_data_files
     2> where tablespace_name='USER_DATA';

TABLESPACE_NAME   FILE_NAME
---------------- ------------------------------------
USER_DATA         E:ORAWIN95DATABASEUSR1ORCL.ORA

1 row selected.

SVRMGR> ALTER TABLESPACE USER_DATA BEGIN BACKUP;
Statement processed.

SVRMGR> !copy usr1orcl.ora e:orawin95databasearch_bac
        1 file(s) copied

SVRMGR> ALTER TABLESPACE USER_DATA END BACKUP;
Statement processed.
이 게시물을..