[DB] DB백업과복구 3일차
3일차. 의도치 않게 차돌정식을 먹고 수강을 시작합니다.
SQL> alter database begin backup;
Database altered.
SQL> SELECT * FROM V$BACKUP;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 ACTIVE 876309 17-FEB-16
2 ACTIVE 876309 17-FEB-16
3 ACTIVE 876309 17-FEB-16
4 ACTIVE 876309 17-FEB-16
5 ACTIVE 876309 17-FEB-16
[oracle@ocpdba ~]$ cd /u01/app/oracle/oradata/
[oracle@ocpdba oradata]$ ls
arch1 coldbackup hotbackup orcl
[oracle@ocpdba oradata]$ cp orcl/*.dbf hotbackup/
SQL> alter database end backup;
Database altered.
QL> SELECT * FROM V$BACKUP;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 876309 17-FEB-16
2 NOT ACTIVE 876309 17-FEB-16
3 NOT ACTIVE 876309 17-FEB-16
4 NOT ACTIVE 876309 17-FEB-16
5 NOT ACTIVE 876309 17-FEB-16
Not active로 바뀌었는지 확인을 해야 함.
이상으로 Hot backup을 마쳤습니다.
보통의 경우는 Table space별로 합니다. 실습의 경우 DB통으로 하였습니다.
실습 4장 3번 (실습 9페이지)
SQL> alter database backup controlfile to
2 '/u01/app/oracle/oradata/hotbackup/control01.ctl';
Database altered.
65페이지
SQL> alter tablespace users begin backup;
Tablespace altered.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 511708752 bytes
Database Buffers 331350016 bytes
Redo Buffers 5132288 bytes
Database mounted.
ORA-10873: file 4 needs to be either taken out of backup mode or media
recovered
ORA-01110: data file 4: '/u01/app/oracle/oradata/orcl/users01.dbf'
SQL> alter database end backup;
Database altered.
(귀찮으니까 Tablespace하나하나 하지 않고 통째로 End backup)
SQL> alter database open;
Database altered.
[oracle@ocpdba oradata]$ cd /u01/app/oracle/diag/rdbms/orcl/orcl/trace/
[oracle@ocpdba trace]$ ls
alert_orcl.log orcl_ora_19439.trc orcl_ora_7814.trm
orcl_arc0_9994.trc orcl_ora_19439.trm orcl_ora_7819.trc
orcl_arc0_9994.trm orcl_ora_20265.trc orcl_ora_7819.trm
orcl_arc1_9996.trc orcl_ora_20265.trm orcl_ora_7829.trc
orcl_arc1_9996.trm orcl_ora_20449.trc orcl_ora_7829.trm
orcl_arc2_20802.trc orcl_ora_20449.trm orcl_ora_7831.trc
orcl_arc2_20802.trm orcl_ora_21329.trc orcl_ora_7831.trm
orcl_arc3_10000.trc orcl_ora_21329.trm orcl_ora_7883.trc
orcl_arc3_10000.trm orcl_ora_21331.trc orcl_ora_7883.trm
orcl_ckpt_12984.trc orcl_ora_21331.trm orcl_ora_7890.trc
orcl_ckpt_12984.trm orcl_ora_21833.trc orcl_ora_7890.trm
orcl_ckpt_13627.trc orcl_ora_21833.trm orcl_ora_7918.trc
orcl_ckpt_13627.trm orcl_ora_21835.trc orcl_ora_7918.trm
orcl_ckpt_16356.trc orcl_ora_21835.trm orcl_ora_7954.trc
orcl_ckpt_16356.trm orcl_ora_21837.trc orcl_ora_7954.trm
orcl_ckpt_9774.trc orcl_ora_21837.trm orcl_ora_7956.trc
orcl_ckpt_9774.trm orcl_ora_21839.trc orcl_ora_7956.trm
orcl_dbrm_12972.trc orcl_ora_21839.trm orcl_ora_7997.trc
orcl_dbrm_12972.trm orcl_ora_21841.trc orcl_ora_7997.trm
orcl_dbrm_13342.trc orcl_ora_21841.trm orcl_ora_8001.trc
orcl_dbrm_13342.trm orcl_ora_21843.trc orcl_ora_8001.trm
orcl_dbrm_13615.trc orcl_ora_21843.trm orcl_ora_8003.trc
orcl_dbrm_13615.trm orcl_ora_22222.trc orcl_ora_8003.trm
orcl_dbrm_16344.trc orcl_ora_22222.trm orcl_ora_8005.trc
orcl_dbrm_16344.trm orcl_ora_22287.trc orcl_ora_8005.trm
orcl_dbrm_20321.trc orcl_ora_22287.trm orcl_ora_8007.trc
orcl_dbrm_20321.trm orcl_ora_22289.trc orcl_ora_8007.trm
orcl_dbrm_6155.trc orcl_ora_22289.trm orcl_ora_8009.trc
orcl_dbrm_6155.trm orcl_ora_22295.trc orcl_ora_8009.trm
orcl_dbrm_6235.trc orcl_ora_22295.trm orcl_ora_8653.trc
orcl_dbrm_6235.trm orcl_ora_22297.trc orcl_ora_8653.trm
orcl_dbrm_6279.trc orcl_ora_22297.trm orcl_ora_8655.trc
orcl_dbrm_6279.trm orcl_ora_22465.trc orcl_ora_8655.trm
orcl_dbrm_9762.trc orcl_ora_22465.trm orcl_ora_8657.trc
orcl_dbrm_9762.trm orcl_ora_22467.trc orcl_ora_8657.trm
orcl_j000_10223.trc orcl_ora_22467.trm orcl_ora_8659.trc
orcl_j000_10223.trm orcl_ora_22499.trc orcl_ora_8659.trm
orcl_j000_10363.trc orcl_ora_22499.trm orcl_ora_8661.trc
orcl_j000_10363.trm orcl_ora_22532.trc orcl_ora_8661.trm
orcl_j000_13854.trc orcl_ora_22532.trm orcl_ora_8663.trc
orcl_j000_13854.trm orcl_ora_22555.trc orcl_ora_8663.trm
orcl_j000_16477.trc orcl_ora_22555.trm orcl_ora_8665.trc
orcl_j000_16477.trm orcl_ora_22582.trc orcl_ora_8665.trm
orcl_j000_21044.trc orcl_ora_22582.trm orcl_ora_8667.trc
orcl_j000_21044.trm orcl_ora_22606.trc orcl_ora_8667.trm
orcl_j000_6400.trc orcl_ora_22606.trm orcl_ora_8669.trc
orcl_j000_6400.trm orcl_ora_22664.trc orcl_ora_8669.trm
orcl_j000_7599.trc orcl_ora_22664.trm orcl_ora_8671.trc
orcl_j000_7599.trm orcl_ora_22666.trc orcl_ora_8671.trm
orcl_j000_7932.trc orcl_ora_22666.trm orcl_ora_8673.trc
orcl_j000_7932.trm orcl_ora_22668.trc orcl_ora_8673.trm
orcl_j001_6472.trc orcl_ora_22668.trm orcl_ora_8675.trc
orcl_j001_6472.trm orcl_ora_22672.trc orcl_ora_8675.trm
orcl_j001_8572.trc orcl_ora_22672.trm orcl_ora_8677.trc
orcl_j001_8572.trm orcl_ora_22674.trc orcl_ora_8677.trm
orcl_j001_8937.trc orcl_ora_22674.trm orcl_ora_8679.trc
orcl_j001_8937.trm orcl_ora_22676.trc orcl_ora_8679.trm
orcl_j001_9863.trc orcl_ora_22676.trm orcl_ora_8681.trc
orcl_j001_9863.trm orcl_ora_22678.trc orcl_ora_8681.trm
orcl_j004_6290.trc orcl_ora_22678.trm orcl_ora_8683.trc
orcl_j004_6290.trm orcl_ora_22855.trc orcl_ora_8683.trm
orcl_j006_13163.trc orcl_ora_22855.trm orcl_ora_8685.trc
orcl_j006_13163.trm orcl_ora_22863.trc orcl_ora_8685.trm
orcl_lgwr_6245.trc orcl_ora_22863.trm orcl_ora_8687.trc
orcl_lgwr_6245.trm orcl_ora_22920.trc orcl_ora_8687.trm
orcl_m000_10727.trc orcl_ora_22920.trm orcl_ora_8689.trc
orcl_m000_10727.trm orcl_ora_22977.trc orcl_ora_8689.trm
orcl_m000_11102.trc orcl_ora_22977.trm orcl_ora_8691.trc
orcl_m000_11102.trm orcl_ora_22986.trc orcl_ora_8691.trm
orcl_m000_13108.trc orcl_ora_22986.trm orcl_ora_8693.trc
orcl_m000_13108.trm orcl_ora_23035.trc orcl_ora_8693.trm
orcl_m000_20226.trc orcl_ora_23035.trm orcl_ora_8707.trc
orcl_m000_20226.trm orcl_ora_23075.trc orcl_ora_8707.trm
orcl_m001_13112.trc orcl_ora_23075.trm orcl_ora_8709.trc
orcl_m001_13112.trm orcl_ora_23111.trc orcl_ora_8709.trm
orcl_m001_18633.trc orcl_ora_23111.trm orcl_ora_8717.trc
orcl_m001_18633.trm orcl_ora_23140.trc orcl_ora_8717.trm
orcl_m001_20453.trc orcl_ora_23140.trm orcl_ora_8731.trc
orcl_m001_20453.trm orcl_ora_23175.trc orcl_ora_8731.trm
orcl_mman_12693.trc orcl_ora_23175.trm orcl_ora_8741.trc
orcl_mman_12693.trm orcl_ora_23177.trc orcl_ora_8741.trm
orcl_mman_12978.trc orcl_ora_23177.trm orcl_ora_8743.trc
orcl_mman_12978.trm orcl_ora_23664.trc orcl_ora_8743.trm
orcl_mman_13348.trc orcl_ora_23664.trm orcl_ora_8745.trc
orcl_mman_13348.trm orcl_ora_23666.trc orcl_ora_8745.trm
orcl_mman_13621.trc orcl_ora_23666.trm orcl_ora_8747.trc
orcl_mman_13621.trm orcl_ora_24132.trc orcl_ora_8747.trm
orcl_mman_16350.trc orcl_ora_24132.trm orcl_ora_8749.trc
orcl_mman_16350.trm orcl_ora_24589.trc orcl_ora_8749.trm
orcl_mman_20327.trc orcl_ora_24589.trm orcl_ora_8751.trc
orcl_mman_20327.trm orcl_ora_24630.trc orcl_ora_8751.trm
orcl_mman_6161.trc orcl_ora_24630.trm orcl_ora_8753.trc
orcl_mman_6161.trm orcl_ora_24645.trc orcl_ora_8753.trm
orcl_mman_6241.trc orcl_ora_24645.trm orcl_ora_8771.trc
orcl_mman_6241.trm orcl_ora_25404.trc orcl_ora_8771.trm
orcl_mman_6285.trc orcl_ora_25404.trm orcl_ora_8797.trc
orcl_mman_6285.trm orcl_ora_6078.trc orcl_ora_8797.trm
orcl_mman_9768.trc orcl_ora_6078.trm orcl_ora_8799.trc
orcl_mman_9768.trm orcl_ora_6165.trc orcl_ora_8799.trm
orcl_mmon_16362.trc orcl_ora_6165.trm orcl_ora_8801.trc
orcl_mmon_16362.trm orcl_ora_6178.trc orcl_ora_8801.trm
orcl_mmon_20339.trc orcl_ora_6178.trm orcl_ora_8803.trc
orcl_mmon_20339.trm orcl_ora_6262.trc orcl_ora_8803.trm
orcl_ora_10896.trc orcl_ora_6262.trm orcl_ora_8805.trc
orcl_ora_10896.trm orcl_ora_6365.trc orcl_ora_8805.trm
orcl_ora_12601.trc orcl_ora_6365.trm orcl_ora_8807.trc
orcl_ora_12601.trm orcl_ora_6409.trc orcl_ora_8807.trm
orcl_ora_12715.trc orcl_ora_6409.trm orcl_ora_8809.trc
orcl_ora_12715.trm orcl_ora_6678.trc orcl_ora_8809.trm
orcl_ora_12906.trc orcl_ora_6678.trm orcl_ora_8811.trc
orcl_ora_12906.trm orcl_ora_6720.trc orcl_ora_8811.trm
orcl_ora_12907.trc orcl_ora_6720.trm orcl_ora_8813.trc
orcl_ora_12907.trm orcl_ora_6998.trc orcl_ora_8813.trm
orcl_ora_13006.trc orcl_ora_6998.trm orcl_ora_8815.trc
orcl_ora_13006.trm orcl_ora_7091.trc orcl_ora_8815.trm
orcl_ora_13116.trc orcl_ora_7091.trm orcl_ora_8827.trc
orcl_ora_13116.trm orcl_ora_7109.trc orcl_ora_8827.trm
orcl_ora_13198.trc orcl_ora_7109.trm orcl_ora_8837.trc
orcl_ora_13198.trm orcl_ora_7117.trc orcl_ora_8837.trm
orcl_ora_13202.trc orcl_ora_7117.trm orcl_ora_9397.trc
orcl_ora_13202.trm orcl_ora_7123.trc orcl_ora_9397.trm
orcl_ora_13240.trc orcl_ora_7123.trm orcl_ora_9693.trc
orcl_ora_13240.trm orcl_ora_7169.trc orcl_ora_9693.trm
orcl_ora_13251.trc orcl_ora_7169.trm orcl_ora_9869.trc
orcl_ora_13251.trm orcl_ora_7271.trc orcl_ora_9869.trm
orcl_ora_13254.trc orcl_ora_7271.trm orcl_vktm_12679.trc
orcl_ora_13254.trm orcl_ora_7404.trc orcl_vktm_12679.trm
orcl_ora_13255.trc orcl_ora_7404.trm orcl_vktm_12964.trc
orcl_ora_13255.trm orcl_ora_7410.trc orcl_vktm_12964.trm
orcl_ora_13269.trc orcl_ora_7410.trm orcl_vktm_13334.trc
orcl_ora_13269.trm orcl_ora_7412.trc orcl_vktm_13334.trm
orcl_ora_13376.trc orcl_ora_7412.trm orcl_vktm_13607.trc
orcl_ora_13376.trm orcl_ora_7724.trc orcl_vktm_13607.trm
orcl_ora_13452.trc orcl_ora_7724.trm orcl_vktm_16336.trc
orcl_ora_13452.trm orcl_ora_7728.trc orcl_vktm_16336.trm
orcl_ora_13528.trc orcl_ora_7728.trm orcl_vktm_20313.trc
orcl_ora_13528.trm orcl_ora_7730.trc orcl_vktm_20313.trm
orcl_ora_13563.trc orcl_ora_7730.trm orcl_vktm_6147.trc
orcl_ora_13563.trm orcl_ora_7732.trc orcl_vktm_6147.trm
orcl_ora_13738.trc orcl_ora_7732.trm orcl_vktm_6227.trc
orcl_ora_13738.trm orcl_ora_7790.trc orcl_vktm_6227.trm
orcl_ora_13852.trc orcl_ora_7790.trm orcl_vktm_6271.trc
orcl_ora_13852.trm orcl_ora_7791.trc orcl_vktm_6271.trm
orcl_ora_16288.trc orcl_ora_7791.trm orcl_vktm_9754.trc
orcl_ora_16288.trm orcl_ora_7808.trc orcl_vktm_9754.trm
orcl_ora_16451.trc orcl_ora_7808.trm
orcl_ora_16451.trm orcl_ora_7814.trc
SQL> alter database backup controlfile to trace;
Database altered.
[oracle@ocpdba trace]$ vi orcl_ora_21656.trc
VI편집기로 내용을 확인하였습니다.
[oracle@ocpdba trace]$ oh
[oracle@ocpdba db_1]$ cd dbs
[oracle@ocpdba dbs]$ ls
hc_DBUA0.dat init.ora orapworcl peshm_orcl_0
hc_orcl.dat lkORCL peshm_DBUA0_0 spfileorcl.ora
spfileorcl.ora 은 바이너리 파일로 편집기로 수정을 하면깨집니다.
[oracle@ocpdba dbs]$ cat spfileorcl.ora
ã5CC"4Worcl.__db_cache_size=331350016
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=343932928
orcl.__sga_target=507510784
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=159383552
orcl.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oCC"'wracle/flash_recovery_area/orcl/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.log_archive_dest_1='location=/u01/app/oracle/oradata/arch1'
*.log_archive_format='%t_%s_%r.arc'
*.memory_target=848297984
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.uCC"*{ndo_tablespace='UNDOTBS1'
CC"FePuTTYCC"EeCC"DeC
init.ora는 sample같은 것 입니다.
[oracle@ocpdba dbs]$ cat init.ora
#
# $Header: rdbms/admin/init.ora /main/23 2009/05/15 13:35:38 ysarig Exp $
#
# Copyright (c) 1991, 1997, 1998 by Oracle Corporation
# NAME
# init.ora
# FUNCTION
# NOTES
# MODIFIED
# ysarig 05/14/09 - Updating compatible to 11.2
# ysarig 08/13/07 - Fixing the sample for 11g
# atsukerm 08/06/98 - fix for 8.1.
# hpiao 06/05/97 - fix for 803
# glavash 05/12/97 - add oracle_trace_enable comment
# hpiao 04/22/97 - remove ifile=, events=, etc.
# alingelb 09/19/94 - remove vms-specific stuff
# dpawson 07/07/93 - add more comments regarded archive start
# maporter 10/29/92 - Add vms_sga_use_gblpagfile=TRUE
# jloaiza 03/07/92 - change ALPHA to BETA
# danderso 02/26/92 - change db_block_cache_protect to _db_block_cache_p
# ghallmar 02/03/92 - db_directory -> db_domain
# maporter 01/12/92 - merge changes from branch 1.8.308.1
# maporter 12/21/91 - bug 76493: Add control_files parameter
# wbridge 12/03/91 - use of %c in archive format is discouraged
# ghallmar 12/02/91 - add global_names=true, db_directory=us.acme.com
# thayes 11/27/91 - Change default for cache_clone
# jloaiza 08/13/91 - merge changes from branch 1.7.100.1
# jloaiza 07/31/91 - add debug stuff
# rlim 04/29/91 - removal of char_is_varchar2
# Bridge 03/12/91 - log_allocation no longer exists
# Wijaya 02/05/91 - remove obsolete parameters
#
##############################################################################
# Example INIT.ORA file
#
# This file is provided by Oracle Corporation to help you start by providing
# a starting point to customize your RDBMS installation for your site.
#
# NOTE: The values that are used in this file are only intended to be used
# as a starting point. You may want to adjust/tune those values to your
# specific hardware and needs. You may also consider using Database
# Configuration Assistant tool (DBCA) to create INIT file and to size your
# initial set of tablespaces based on the user input.
###############################################################################
# Change '<ORACLE_BASE>' to point to the oracle base (the one you specify at
# install time)
db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='<ORACLE_BASE>/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='<ORACLE_BASE>/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='<ORACLE_BASE>'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (ora_control1, ora_control2)
compatible ='11.2.0'
SQL> create pfile from spfile;
File created.
[oracle@ocpdba dbs]$ cat initorcl.ora
orcl.__db_cache_size=331350016
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=343932928
orcl.__sga_target=507510784
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=159383552
orcl.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/flash_recovery_area/orcl/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.log_archive_dest_1='location=/u01/app/oracle/oradata/arch1'
*.log_archive_format='%t_%s_%r.arc'
*.memory_target=848297984
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
SQL> show parameter log_archive_format
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_format string %t_%s_%r.arc
log_archive_format 을 잘 못 바꾸어 DB가 올라가지 않는것을 Demo로 보여주셨습니다.
11g 버전 이후부터는
SQL> create pfile from memory;
를 써서 pfile을 생성할 수 있습니다.
======================================= 2 =====================================
[oracle@ocpdba dbs]$ cd /u01/app/oracle/oradata/orcl/
[oracle@ocpdba orcl]$ ls
control01.ctl redo01.log redo03.log system01.dbf undotbs01.dbf
example01.dbf redo02.log sysaux01.dbf temp01.dbf users01.dbf
확인을 하였고 Failinf은 없는것을 확인할 수 있습니다. 깨진부분이 있으면 추가적인 message와 함께 깨진 것을 확인할 수 있습니다.
깨졌으면 Total Pages Marked Corrupt : (0을 초과하는 값) 으로 확인할 수 있습니다.
5장 5-1 실습은 시간관계상 설명만 하고 넘어간다고 하셨습니다.
실습 5-2) 실습페이지 13
log switch를 실습상황을 위해 일으킵니다.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> CREATE TABLE scott.abc
2 TABLESPACE users
3 as
4 SELECT * FROM scott.emp;
Table created.
table을 생성한 이유는복구 후 table이 있으면 복구가 잘 된것을 확인할 수 있습니다.
SQL> INSERT INTO scott.abc SELECT * FROM scott.abc;
14 rows created.
복구가 끝나고 확인을 하기위해 행을 추가해 줍니다.
SQL> SELECT count(*) FROM scott.abc;
COUNT(*)
----------
28
SQL> shutdown immediate
ORA-01097: cannot shutdown while in a transaction - commit or rollback first
실습 5-2의 4번을 진행하는데 DB가 내려가지 않는 문제가 발생했습니다.
1번의 e항목을 확인 해 보았습니다.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/oradata/arch1
Oldest online log sequence 17
Next log sequence to archive 19
Current log sequence 19
SQL> SELECT f.file_name
2 FROM dba_tables t, dba_data_files f
3 WHERE table_name ='abc' and t.tablespace_name = f.tablespace_name;
no rows selected
실습 5-2를 진행하다가 무언가 잘못 된 것 같은데 것잡을 수 없게 되었습니다.
====================================== 3 ======================================
실습 16쪽의 5-3실습을 진행하였지만 문제가 있어 진행을 할 수가 없었습니다. DB를 복구한 후 추후에 해볼 수 있도록 해야겠습니다.
문제의 원인을 차근히 읽고 복사를 하여 획일화를 시켰습니다.
그 후 다시 DB를 올리니까 아까와는 달리 올라가면서 또 복구가 필요하다는 message를 확인할 수 있었습니다.
역시 또 Error가 났습니다.... 음....
SQL> alter system set control_files=
2 '/u01/app/oracle/oradata/orcl/control01.ctl',
3 '/u01/app/oracle/oradata/orcl/control02.ctl' scope=spfile;
System altered.
위의 내용을 진행하였고 강사님께서 추가로 cold/hot backup을 새로 해야한다고 알려주셨습니다.
================================= 4 ============================================
강의를 마치고 질문 및 개인 추가학습 부분입니다. 우선 어제 실습중에 놓친 부분이 있어서 오늘과같은 참사가 벌어졌습니다. 아래에는 오늘 교육 간 작업했던 접속기의 모든 내용을 캡쳐하였습니다.
위의 그림은 오늘 교육 시 SQL을 사용하기 위해 접속한 접속기의 화면을 통으로 캡쳐 한 것입니다.