레도널스의 개발자 되어가기

[oracle@localhost ~]$ pwd

/home/oracle

[oracle@localhost ~]$ mkdir backup

[oracle@localhost ~]$ cd backup/

[oracle@localhost backup]$ mkdir uman rman arch1

[oracle@localhost backup]$ ls

arch1  rman  uman

[oracle@localhost backup]$ cd

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jun 21 14:15:37 2018

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, OLAP, Data Mining and Real Application Testing options

SYS> alter tablespace users begin backup;

Tablespace altered.

SYS> select file_name from dba_data_files

  2  where tablespace_name = 'USERS';

FILE_NAME

------------------------------------------------------------------------------------------------------------------------

/u01/app/oracle/oradata/orcl/users01.dbf

SYS> !cp /u01/app/oracle/oradata/orcl/users01.dbf /home/oracle/backup/uman/users01.bk

SYS> alter tablespace users end backup;

Tablespace altered.

SYS> !ls /home/oracle/backup/uman

users01.bk

SYS> alter tablespace users begin backup;

Tablespace altered.

SYS> shutdown abort

ORACLE instance shut down.

SYS> startup

ORACLE instance started.

Total System Global Area  623546368 bytes

Fixed Size                  1338308 bytes

Variable Size             457180220 bytes

Database Buffers          159383552 bytes

Redo Buffers                5644288 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'

SYS> alter database datafile 4 end backup;

Database altered.

SYS> alter database open;

Database altered.

[oracle@localhost ~]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jun 21 14:26:14 2018

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1505954632)

RMAN> backup tablespace users;

Starting backup at 21-JUN-18

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=47 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=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf

channel ORA_DISK_1: starting piece 1 at 21-JUN-18

channel ORA_DISK_1: finished piece 1 at 21-JUN-18

piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2018_06_21/o1_mf_nnndf_TAG20180621T142633_flpfr9j8_.bkp tag=TAG20180621T142633 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

Finished backup at 21-JUN-18

SYS> alter database backup controlfile to '/home/oracle/backup/uman/control.bk';

Database altered.

SYS> !ls /home/oracle/backup/uman

control.bk  users01.bk

SYS> show parameter user_dump

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

user_dump_dest                       string      /u01/app/oracle/diag/rdbms/orc

                                                 l/orcl/trace

SYS> SELECT s.sid, p.spid

  2  FROM v$process p JOIN v$session s

  3  ON (p.addr = s.paddr)

  4  WHERE s.username = 'SYS';

       SID SPID

---------- ------------------------

         1 8772

SYS> alter database backup controlfile to trace;

Database altered.

>> 파일 확인하기

[oracle@localhost ~]$ cd /u01/app/oracle/diag/rdbms/orcl/orcl/trace

[oracle@localhost trace]$ ls

afiedt.buf           orcl_mman_7601.trm   orcl_ora_5283.trc

alert_orcl.log       orcl_mman_8708.trc   orcl_ora_5283.trm

orcl_arc0_24345.trc  orcl_mman_8708.trm   orcl_ora_5293.trc

orcl_arc0_24345.trm  orcl_mman_9751.trc   orcl_ora_5293.trm

orcl_arc1_24347.trc  orcl_mman_9751.trm   orcl_ora_5301.trc

orcl_arc1_24347.trm  orcl_mmnl_13380.trc  orcl_ora_5301.trm

orcl_arc1_27024.trc  orcl_mmnl_13380.trm  orcl_ora_5307.trc

orcl_arc1_27024.trm  orcl_mmon_5243.trc   orcl_ora_5307.trm

orcl_arc1_5306.trc   orcl_mmon_5243.trm   orcl_ora_5842.trc

orcl_arc1_5306.trm   orcl_ora_10146.trc   orcl_ora_5842.trm

orcl_arc1_5312.trc   orcl_ora_10146.trm   orcl_ora_5857.trc

orcl_arc1_5312.trm   orcl_ora_10242.trc   orcl_ora_5857.trm

orcl_arc1_9629.trc   orcl_ora_10242.trm   orcl_ora_5880.trc

orcl_arc1_9629.trm   orcl_ora_11016.trc   orcl_ora_5880.trm

orcl_arc2_5308.trc   orcl_ora_11016.trm   orcl_ora_5889.trc

orcl_arc2_5308.trm   orcl_ora_11171.trc   orcl_ora_5889.trm

orcl_arc3_24351.trc  orcl_ora_11171.trm   orcl_ora_6237.trc

orcl_arc3_24351.trm  orcl_ora_11191.trc   orcl_ora_6237.trm

orcl_ckpt_13372.trc  orcl_ora_11191.trm   orcl_ora_6243.trc

orcl_ckpt_13372.trm  orcl_ora_11426.trc   orcl_ora_6243.trm

orcl_ckpt_26269.trc  orcl_ora_11426.trm   orcl_ora_6261.trc

orcl_ckpt_26269.trm  orcl_ora_11593.trc   orcl_ora_6261.trm

orcl_ckpt_26966.trc  orcl_ora_11593.trm   orcl_ora_6268.trc

orcl_ckpt_26966.trm  orcl_ora_12019.trc   orcl_ora_6268.trm

orcl_ckpt_5255.trc   orcl_ora_12019.trm   orcl_ora_6279.trc

orcl_ckpt_5255.trm   orcl_ora_12450.trc   orcl_ora_6279.trm

orcl_ckpt_7607.trc   orcl_ora_12450.trm   orcl_ora_6288.trc

orcl_ckpt_7607.trm   orcl_ora_12451.trc   orcl_ora_6288.trm

orcl_dbrm_10220.trc  orcl_ora_12451.trm   orcl_ora_6294.trc

orcl_dbrm_10220.trm  orcl_ora_12456.trc   orcl_ora_6294.trm

orcl_dbrm_13360.trc  orcl_ora_12456.trm   orcl_ora_6295.trc

orcl_dbrm_13360.trm  orcl_ora_13290.trc   orcl_ora_6295.trm

orcl_dbrm_24019.trc  orcl_ora_13290.trm   orcl_ora_6310.trc

orcl_dbrm_24019.trm  orcl_ora_13430.trc   orcl_ora_6310.trm

orcl_dbrm_26954.trc  orcl_ora_13430.trm   orcl_ora_6312.trc

orcl_dbrm_26954.trm  orcl_ora_13450.trc   orcl_ora_6312.trm

orcl_dbrm_5218.trc   orcl_ora_13450.trm   orcl_ora_6317.trc

orcl_dbrm_5218.trm   orcl_ora_13459.trc   orcl_ora_6317.trm

orcl_dbrm_5225.trc   orcl_ora_13459.trm   orcl_ora_6329.trc

orcl_dbrm_5225.trm   orcl_ora_13496.trc   orcl_ora_6329.trm

orcl_dbrm_5236.trc   orcl_ora_13496.trm   orcl_ora_6330.trc

orcl_dbrm_5236.trm   orcl_ora_13539.trc   orcl_ora_6330.trm

orcl_dbrm_5243.trc   orcl_ora_13539.trm   orcl_ora_6333.trc

orcl_dbrm_5243.trm   orcl_ora_13541.trc   orcl_ora_6333.trm

orcl_dbrm_7595.trc   orcl_ora_13541.trm   orcl_ora_6344.trc

orcl_dbrm_7595.trm   orcl_ora_13617.trc   orcl_ora_6344.trm

orcl_dbrm_8702.trc   orcl_ora_13617.trm   orcl_ora_6353.trc

orcl_dbrm_8702.trm   orcl_ora_13619.trc   orcl_ora_6353.trm

orcl_dbrm_9745.trc   orcl_ora_13619.trm   orcl_ora_6371.trc

orcl_dbrm_9745.trm   orcl_ora_13788.trc   orcl_ora_6371.trm

orcl_j000_11018.trc  orcl_ora_13788.trm   orcl_ora_6390.trc

orcl_j000_11018.trm  orcl_ora_13797.trc   orcl_ora_6390.trm

orcl_j000_11242.trc  orcl_ora_13797.trm   orcl_ora_6393.trc

orcl_j000_11242.trm  orcl_ora_13933.trc   orcl_ora_6393.trm

orcl_j000_13453.trc  orcl_ora_13933.trm   orcl_ora_6402.trc

orcl_j000_13453.trm  orcl_ora_13935.trc   orcl_ora_6402.trm

orcl_j000_13981.trc  orcl_ora_13935.trm   orcl_ora_6406.trc

orcl_j000_13981.trm  orcl_ora_14031.trc   orcl_ora_6406.trm

orcl_j000_18981.trc  orcl_ora_14031.trm   orcl_ora_6408.trc

orcl_j000_18981.trm  orcl_ora_14044.trc   orcl_ora_6408.trm

orcl_j000_21344.trc  orcl_ora_14044.trm   orcl_ora_6411.trc

orcl_j000_21344.trm  orcl_ora_14091.trc   orcl_ora_6411.trm

orcl_j000_24474.trc  orcl_ora_14091.trm   orcl_ora_7498.trc

orcl_j000_24474.trm  orcl_ora_14092.trc   orcl_ora_7498.trm

orcl_j000_24605.trc  orcl_ora_14092.trm   orcl_ora_7523.trc

orcl_j000_24605.trm  orcl_ora_14145.trc   orcl_ora_7523.trm

orcl_j000_27052.trc  orcl_ora_14145.trm   orcl_ora_7661.trc

orcl_j000_27052.trm  orcl_ora_14651.trc   orcl_ora_7661.trm

orcl_j000_27104.trc  orcl_ora_14651.trm   orcl_ora_7691.trc

orcl_j000_27104.trm  orcl_ora_15697.trc   orcl_ora_7691.trm

orcl_j000_5304.trc   orcl_ora_15697.trm   orcl_ora_7696.trc

orcl_j000_5304.trm   orcl_ora_16506.trc   orcl_ora_7696.trm

orcl_j000_5314.trc   orcl_ora_16506.trm   orcl_ora_7789.trc

orcl_j000_5314.trm   orcl_ora_16636.trc   orcl_ora_7789.trm

orcl_j000_5332.trc   orcl_ora_16636.trm   orcl_ora_7802.trc

orcl_j000_5332.trm   orcl_ora_17374.trc   orcl_ora_7802.trm

orcl_j000_5338.trc   orcl_ora_17374.trm   orcl_ora_7936.trc

orcl_j000_5338.trm   orcl_ora_17659.trc   orcl_ora_7936.trm

orcl_j000_6466.trc   orcl_ora_17659.trm   orcl_ora_8559.trc

orcl_j000_6466.trm   orcl_ora_17870.trc   orcl_ora_8559.trm

orcl_j000_7431.trc   orcl_ora_17870.trm   orcl_ora_8628.trc

orcl_j000_7431.trm   orcl_ora_19495.trc   orcl_ora_8628.trm

orcl_j000_8276.trc   orcl_ora_19495.trm   orcl_ora_8629.trc

orcl_j000_8276.trm   orcl_ora_19893.trc   orcl_ora_8629.trm

orcl_j000_9657.trc   orcl_ora_19893.trm   orcl_ora_8772.trc

orcl_j000_9657.trm   orcl_ora_19902.trc   orcl_ora_8772.trm

orcl_j000_9840.trc   orcl_ora_19902.trm   orcl_ora_9493.trc

orcl_j000_9840.trm   orcl_ora_22566.trc   orcl_ora_9493.trm

orcl_j001_14977.trc  orcl_ora_22566.trm   orcl_ora_9665.trc

orcl_j001_14977.trm  orcl_ora_23932.trc   orcl_ora_9665.trm

orcl_j003_5310.trc   orcl_ora_23932.trm   orcl_ora_9675.trc

orcl_j003_5310.trm   orcl_ora_24099.trc   orcl_ora_9675.trm

orcl_j003_5320.trc   orcl_ora_24099.trm   orcl_ora_9678.trc

orcl_j003_5320.trm   orcl_ora_24381.trc   orcl_ora_9678.trm

orcl_j004_5340.trc   orcl_ora_24381.trm   orcl_ora_9685.trc

orcl_j004_5340.trm   orcl_ora_24431.trc   orcl_ora_9685.trm

orcl_j004_5346.trc   orcl_ora_24431.trm   orcl_ora_9814.trc

orcl_j004_5346.trm   orcl_ora_24469.trc   orcl_ora_9814.trm

orcl_lgwr_24030.trc  orcl_ora_24469.trm   orcl_ora_9817.trc

orcl_lgwr_24030.trm  orcl_ora_25524.trc   orcl_ora_9817.trm

orcl_lgwr_5235.trc   orcl_ora_25524.trm   orcl_ora_9856.trc

orcl_lgwr_5235.trm   orcl_ora_25879.trc   orcl_ora_9856.trm

orcl_lgwr_5246.trc   orcl_ora_25879.trm   orcl_ora_9873.trc

orcl_lgwr_5246.trm   orcl_ora_26176.trc   orcl_ora_9873.trm

orcl_lgwr_5253.trc   orcl_ora_26176.trm   orcl_ora_9891.trc

orcl_lgwr_5253.trm   orcl_ora_26305.trc   orcl_ora_9891.trm

orcl_m000_26317.trc  orcl_ora_26305.trm   orcl_vktm_10212.trc

orcl_m000_26317.trm  orcl_ora_26880.trc   orcl_vktm_10212.trm

orcl_m000_8774.trc   orcl_ora_26880.trm   orcl_vktm_13352.trc

orcl_m000_8774.trm   orcl_ora_27018.trc   orcl_vktm_13352.trm

orcl_m000_9499.trc   orcl_ora_27018.trm   orcl_vktm_24010.trc

orcl_m000_9499.trm   orcl_ora_27066.trc   orcl_vktm_24010.trm

orcl_mman_10227.trc  orcl_ora_27066.trm   orcl_vktm_26249.trc

orcl_mman_10227.trm  orcl_ora_27237.trc   orcl_vktm_26249.trm

orcl_mman_13366.trc  orcl_ora_27237.trm   orcl_vktm_26946.trc

orcl_mman_13366.trm  orcl_ora_27564.trc   orcl_vktm_26946.trm

orcl_mman_24026.trc  orcl_ora_27564.trm   orcl_vktm_5210.trc

orcl_mman_24026.trm  orcl_ora_27566.trc   orcl_vktm_5210.trm

orcl_mman_26263.trc  orcl_ora_27566.trm   orcl_vktm_5217.trc

orcl_mman_26263.trm  orcl_ora_27608.trc   orcl_vktm_5217.trm

orcl_mman_26960.trc  orcl_ora_27608.trm   orcl_vktm_5228.trc

orcl_mman_26960.trm  orcl_ora_29615.trc   orcl_vktm_5228.trm

orcl_mman_5224.trc   orcl_ora_29615.trm   orcl_vktm_5235.trc

orcl_mman_5224.trm   orcl_ora_5143.trc    orcl_vktm_5235.trm

orcl_mman_5231.trc   orcl_ora_5143.trm    orcl_vktm_7587.trc

orcl_mman_5231.trm   orcl_ora_5146.trc    orcl_vktm_7587.trm

orcl_mman_5242.trc   orcl_ora_5146.trm    orcl_vktm_8694.trc

orcl_mman_5242.trm   orcl_ora_5160.trc    orcl_vktm_8694.trm

orcl_mman_5249.trc   orcl_ora_5160.trm    orcl_vktm_9737.trc

orcl_mman_5249.trm   orcl_ora_5166.trc    orcl_vktm_9737.trm

orcl_mman_7601.trc   orcl_ora_5166.trm    sbtio.log

[oracle@localhost trace]$ ls *8772*

orcl_ora_8772.trc  orcl_ora_8772.trm

>> Control file 백업하기

[oracle@localhost trace]$ cp *8772*.trc /home/oracle/backup/uman/cre_con.sql

[oracle@localhost trace]$ cd

[oracle@localhost ~]$ cd /home/oracle/backup/uman

[oracle@localhost uman]$ ls

control.bk  cre_con.sql  users01.bk

[oracle@localhost uman]$ 

HR> conn / as sysdba

Connected.

SYS> select group#, members, sequence#, status                        

  2  from v$log;

    GROUP#    MEMBERS  SEQUENCE# STATUS

---------- ---------- ---------- ----------------

         1          2        106 CURRENT

         2          2        104 INACTIVE

         3          2        105 INACTIVE

SYS> alter system switch logfile;

System altered.

SYS> /

System altered.

SYS> select group#, members, sequence#, status

  2  from v$log;

    GROUP#    MEMBERS  SEQUENCE# STATUS

---------- ---------- ---------- ----------------

         1          2        106 ACTIVE

         2          2        107 ACTIVE

         3          2        108 CURRENT

SYS> alter system checkpoint;

System altered.

SYS> select group#, members, sequence#, status

  2  from v$log;

    GROUP#    MEMBERS  SEQUENCE# STATUS

---------- ---------- ---------- ----------------

         1          2        106 INACTIVE

         2          2        107 INACTIVE

         3          2        108 CURRENT

[oracle@localhost orcl]$ pwd

/u01/app/oracle/oradata/orcl

[oracle@localhost orcl]$ ls

control01.ctl  redo02b.log  redo03.log    temp01.dbf

redo01b.log    redo02.log   sysaux01.dbf  undotbs01.dbf

redo01.log     redo03b.log  system01.dbf  users01.dbf

[oracle@localhost orcl]$ rm redo02.log

SYS> startup force

ORACLE instance started.

Total System Global Area  623546368 bytes

Fixed Size                  1338308 bytes

Variable Size             457180220 bytes

Database Buffers          159383552 bytes

Redo Buffers                5644288 bytes

Database mounted.

Database opened.

SYS> col member for a50

SYS> select group#, member, status

  2  from v$logfile;

    GROUP# MEMBER                                             STATUS

---------- -------------------------------------------------- -------

         1 /u01/app/oracle/oradata/orcl/redo01.log

         2 /u01/app/oracle/oradata/orcl/redo02.log            INVALID

         3 /u01/app/oracle/oradata/orcl/redo03.log

         1 /u01/app/oracle/oradata/orcl/redo01b.log

         2 /u01/app/oracle/oradata/orcl/redo02b.log

         3 /u01/app/oracle/oradata/orcl/redo03b.log

6 rows selected.

SYS> alter database clear logfile group 2;

Database altered.

SYS> SELECT group#, member, status

  2  FROM v$logfile;

    GROUP# MEMBER                                             STATUS

---------- -------------------------------------------------- -------

         1 /u01/app/oracle/oradata/orcl/redo01.log

         2 /u01/app/oracle/oradata/orcl/redo02.log

         3 /u01/app/oracle/oradata/orcl/redo03.log

         1 /u01/app/oracle/oradata/orcl/redo01b.log

         2 /u01/app/oracle/oradata/orcl/redo02b.log

         3 /u01/app/oracle/oradata/orcl/redo03b.log

6 rows selected.