💡 스토리지가 asm 이면
오라클 데이터 백업은 무조건 RMAN 을 사용해야함
[실습1] 아카이브 모드로 변환하시오
[orcl:~]$ . oraenv
ORACLE_SID = [orcl] ? orcl
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[orcl:~]$ sys
SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 17 15:07:35 2025
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup mount
SQL>
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 13
Next log sequence to archive 15
Current log sequence 15
SQL>[실습2] rman 으로 전체 백업을 수행하시오
[orcl:~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Sep 17 15:10:23 2025
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1324638472)
RMAN> configure controlfile autobackup on;
using target database control file instead of recovery catalog
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
RMAN> backup database;
Starting backup at 17-SEP-25
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/orcl/datafile/system.256.796857621
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.796857623
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.796857625
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.796857803
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.796857625
input datafile file number=00006 name=+DATA/orcl/datafile/ts01.267.1212062749
channel ORA_DISK_1: starting piece 1 at 17-SEP-25