{"id":308,"date":"2015-01-19T11:46:31","date_gmt":"2015-01-19T11:46:31","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=308"},"modified":"2015-01-19T11:46:31","modified_gmt":"2015-01-19T11:46:31","slug":"db-%eb%b0%b1%ec%97%85%eb%8d%b0%ec%9d%b4%ed%83%80%eb%a1%9c-%ed%83%80-%ec%84%9c%eb%b2%84-db-recovery-%eb%b0%a9%eb%b2%951-%ec%95%84%ec%b9%b4%ec%9d%b4%eb%b8%8c-%ec%a1%b4%ec%9e%ac-%ec%8b%9c-%ec%a0%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=308","title":{"rendered":"DB \ubc31\uc5c5\ub370\uc774\ud0c0\ub85c \ud0c0 \uc11c\ubc84 DB Recovery \ubc29\ubc95(1. \uc544\uce74\uc774\ube0c \uc874\uc7ac \uc2dc \uc815\uc0c1\ubcf5\uad6c, 2. \uc544\uce74\uc774\ube0c \uc720\uc2e4\uc2dc \ube44\uc815\uc0c1\ubcf5\uad6c)"},"content":{"rendered":"

DR \uc804\ud658 \uc2dc DB Recovery(1. \uc544\uce74\uc774\ube0c \uc874\uc7ac \uc2dc, 2. \ud788\ub4e0\ud30c\ub77c\ubbf8\ud130)<\/span><\/font><\/font><\/p>\n

# DB Recovery (Archivelog <\/span>\ud30c\uc77c \uc874\uc7ac\ud560 \uc2dc)<\/span><\/span><\/font><\/font><\/p>\n

1.<\/font>     <\/span><\/span><\/span>\ubcf5\uad6c \ub370\uc774\ud130\ub97c Copy <\/span>\ud558\uae30\uc5d0 \uc55e\uc11c \uc544\ub798 \ub514\ub809\ud1a0\ub9ac \uc0dd\uc131(<\/span>\uc18c\uc694\uc2dc\uac04 : 1<\/span><\/font>\ubd84<\/font>)<\/font><\/span><\/font><\/font><\/p>\n

mkdir -p \/orcl11\/sysdata\/orcl1\/<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/orcl11\/ora_data\/<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/orcl12\/ora_data\/<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/orcl13\/ora_data\/<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/orcl14\/ora_data\/<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/orcl13\/bradmark\/<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/orcl14\/archive<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/export\/home\/orcl1\/admin\/orcl1\/adump<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/export\/home\/orcl1\/admin\/orcl1\/bdump<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/export\/home\/orcl1\/admin\/orcl1\/cdump<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/export\/home\/orcl1\/admin\/orcl1\/udump<\/font><\/font><\/font><\/span><\/p>\n

 <\/font><\/span><\/p>\n

2.<\/font>     <\/span><\/span><\/span>DAT TAPE<\/span>\uc5d0\uc11c dbf <\/span>\ud30c\uc77c\uc744 Restore <\/span>\ud55c \ud6c4 \uc544\ub798 cp <\/span><\/font>\uba85\ub839\uc5b4 \uc2e4\ud589<\/font>(Local <\/font><\/span><\/font>\u00e0<\/span><\/span> DBF <\/span>\uc704\uce58\ub85c Copy<\/span>\uc18c\uc694\uc2dc\uac04 : 25<\/span><\/font><\/font>\ubd84<\/font>)<\/font><\/span><\/font><\/font><\/p>\n

cp users01.dbf \/orcl11\/sysdata\/orcl1\/users01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp TEST_IDX_NEW01.dbf \/orcl11\/ora_data\/TEST_IDX_NEW01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp undotbs01.dbf \/orcl11\/sysdata\/orcl1\/undotbs01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp system01.dbf \/orcl11\/sysdata\/orcl1\/system01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_COS_DAT01.dbf \/orcl11\/ora_data\/ORCL1_TEST_DAT01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_DAT02.dbf \/orcl12\/ora_data\/ORCL1_TEST_DAT02.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_DAT03.dbf \/orcl13\/ora_data\/ORCL1_TEST_DAT03.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_DAT04.dbf \/orcl14\/ora_data\/ORCL1_TEST_DAT04.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_DAT05.dbf \/orcl11\/ora_data\/ORCL1_TEST_DAT05.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_DAT06.dbf \/orcl12\/ora_data\/ORCL1_TEST_DAT06.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_DAT07.dbf \/orcl13\/ora_data\/ORCL1_TEST_DAT07.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_IDX01.dbf \/orcl11\/ora_data\/ORCL1_TEST_IDX01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_IDX02.dbf \/orcl12\/ora_data\/ORCL1_TEST_IDX02.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_IDX03.dbf \/orcl13\/ora_data\/ORCL1_TEST_IDX03.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_FORE_DAT01.dbf \/orcl11\/ora_data\/ORCL1_FORE_DAT01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_FORE_IDX01.dbf \/orcl12\/ora_data\/ORCL1_FORE_IDX01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_FORE_IDX02.dbf \/orcl13\/ora_data\/ORCL1_FORE_IDX02.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_FORE_IDX03.dbf \/orcl14\/ora_data\/ORCL1_FORE_IDX03.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp AIOMS_DAT01.dbf \/orcl14\/ora_data\/TEST_DAT01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp TEST_IDX101.dbf \/orcl14\/ora_data\/TEST_IDX101.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp TEST_DAT01.dbf \/orcl11\/ora_data\/TEST_DAT01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp TEST_DAT02.dbf \/orcl12\/ora_data\/TEST_DAT02.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp TEST_DAT03.dbf \/orcl13\/ora_data\/TEST_DAT03.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp sysaux01.dbf \/orcl11\/sysdata\/orcl1\/sysaux01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp TEST_DAT_NEW01.dbf \/orcl11\/ora_data\/TEST_DAT_NEW01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp bradmark.dbf \/orcl13\/bradmark\/bradmark.dbf<\/font><\/font><\/font><\/span><\/p>\n

 <\/font><\/span><\/p>\n

 <\/font><\/span><\/p>\n

3.<\/font>     <\/span><\/span><\/span>\ubc31\uc5c5 \ubc1b\uc740 pfile<\/span>\uc744 \uc774\uc6a9\ud558\uc5ec nomount <\/span>\ub2e8\uacc4\ub85c \ub9cc\ub4e0\ub2e4. (<\/span>\uc18c\uc694\uc2dc\uac04 : 5<\/span><\/font>\ubd84<\/font>)<\/font><\/span><\/font><\/font><\/p>\n

$vi initorcl1.ora<\/font><\/font><\/font><\/span><\/p>\n

orcl1.__db_cache_size=402653184<\/font><\/font><\/font><\/span><\/p>\n

orcl1.__java_pool_size=4194304<\/font><\/font><\/font><\/span><\/p>\n

orcl1.__large_pool_size=4194304<\/font><\/font><\/font><\/span><\/p>\n

orcl1.__shared_pool_size=620756992<\/font><\/font><\/font><\/span><\/p>\n

orcl1.__streams_pool_size=8388608<\/font><\/font><\/font><\/span><\/p>\n

*._gby_hash_aggregation_enabled=TRUE<\/font><\/font><\/font><\/span><\/p>\n

*.audit_file_dest=’\/export\/home\/orcl1\/admin\/orcl1\/adump’<\/font><\/font><\/font><\/span><\/p>\n

*.background_dump_dest=’\/export\/home\/orcl1\/admin\/orcl1\/bdump’<\/font><\/font><\/font><\/span><\/p>\n

*.compatible=’10.2.0.3.0′<\/font><\/font><\/font><\/span><\/p>\n

*.control_files=’\/orcl11\/sysdata\/orcl1\/control01.ctl’,’\/orcl12\/sysdata\/orcl1\/control02.ctl’,’\/orcl13\/sysdata\/orcl1\/control03.ctl’<\/font><\/font><\/font><\/span><\/p>\n

*.core_dump_dest=’\/export\/home\/orcl1\/admin\/orcl1\/cdump’<\/font><\/font><\/font><\/span><\/p>\n

*.db_block_size=8192<\/font><\/font><\/font><\/span><\/p>\n

*.db_domain=”<\/font><\/font><\/font><\/span><\/p>\n

*.db_file_multiblock_read_count=16<\/font><\/font><\/font><\/span><\/p>\n

*.db_name=’orcl1′<\/font><\/font><\/font><\/span><\/p>\n

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orcl1XDB)’<\/font><\/font><\/font><\/span><\/p>\n

*.job_queue_processes=10<\/font><\/font><\/font><\/span><\/p>\n

*.log_archive_dest_1=’location=\/orcl14\/archive’<\/font><\/font><\/font><\/span><\/p>\n

*.log_archive_format=’%t_%s_%r.arc’<\/font><\/font><\/font><\/span><\/p>\n

*.open_cursors=300<\/font><\/font><\/font><\/span><\/p>\n

*.optimizer_features_enable=’10.2.0.4′<\/font><\/font><\/font><\/span><\/p>\n

*.pga_aggregate_target=629145600<\/font><\/font><\/font><\/span><\/p>\n

*.processes=1000<\/font><\/font><\/font><\/span><\/p>\n

*.remote_login_passwordfile=’EXCLUSIVE’<\/font><\/font><\/font><\/span><\/p>\n

*.sessions=1105<\/font><\/font><\/font><\/span><\/p>\n

*.sga_target=1048576000<\/font><\/font><\/font><\/span><\/p>\n

*.undo_management=’AUTO’<\/font><\/font><\/font><\/span><\/p>\n

*.undo_tablespace=’UNDOTBS1′<\/font><\/font><\/font><\/span><\/p>\n

*.user_dump_dest=’\/export\/home\/orcl1\/admin\/orcl1\/udump’<\/font><\/font><\/font><\/span><\/p>\n

 <\/font><\/span><\/p>\n

SQL>startup pfile=’\/export\/home\/orcl1\/product\/10.2.0\/dbs\/initorcl1.ora’ nomount;<\/font><\/font><\/font><\/span><\/p>\n

4.<\/font>     <\/span><\/span><\/span>\ubc31\uc5c5 \ubc1b\uc740 Controlfile <\/span>\uc7ac\uc0dd\uc131 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc774\uc6a9\ud558\uc5ec \uc544\ub798 \ubd80\ubd84\ub9cc \ud3b8\uc9d1\ud558\uc5ec \ucffc\ub9ac\ub97c \uc218\ud589(<\/span>\uc18c\uc694\uc2dc\uac04 : 5<\/span><\/font>\ubd84<\/font>)<\/font><\/span><\/font><\/font><\/p>\n

SQL>CREATE CONTROLFILE REUSE DATABASE “ORCL1” RESETLOGS  <\/span>ARCHIVELOG<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>MAXLOGFILES 16<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>MAXLOGMEMBERS 3<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>MAXDATAFILES 100<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>MAXINSTANCES 8<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>MAXLOGHISTORY 2160<\/font><\/font><\/font><\/span><\/p>\n

LOGFILE<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>GROUP 1 (<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>‘\/orcl11\/sysdata\/orcl1\/redo01a.log’,<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>‘\/orcl12\/sysdata\/orcl1\/redo01b.log’<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>) SIZE 100M,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>GROUP 2 (<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>‘\/orcl11\/sysdata\/orcl1\/redo02a.log’,<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>‘\/orcl12\/sysdata\/orcl1\/redo02b.log’<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>) SIZE 100M,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>GROUP 3 (<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>‘\/orcl11\/sysdata\/orcl1\/redo03a.log’,<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>‘\/orcl12\/sysdata\/orcl1\/redo03b.log’<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>) SIZE 100M<\/font><\/font><\/font><\/span><\/p>\n

DATAFILE<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/sysdata\/orcl1\/system01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/sysdata\/orcl1\/undotbs01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/sysdata\/orcl1\/sysaux01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/sysdata\/orcl1\/users01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/ora_data\/ORCL1_TEST_DAT01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl12\/ora_data\/ORCL1_TEST_DAT02.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl13\/ora_data\/ORCL1_TEST_DAT03.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl14\/ora_data\/ORCL1_TEST_DAT04.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/ora_data\/ORCL1_TEST_DAT05.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl12\/ora_data\/ORCL1_TEST_DAT06.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl13\/ora_data\/ORCL1_TEST_DAT07.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/ora_data\/ORCL1_TEST_IDX01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl12\/ora_data\/ORCL1_TEST_IDX02.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl13\/ora_data\/ORCL1_TEST_IDX03.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/ora_data\/ORCL1_FORE_DAT01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl12\/ora_data\/ORCL1_FORE_IDX01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl13\/ora_data\/ORCL1_FORE_IDX02.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl14\/ora_data\/ORCL1_FORE_IDX03.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl14\/ora_data\/TEST_DAT01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl14\/ora_data\/TEST_IDX101.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/ora_data\/TEST_DAT01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl12\/ora_data\/TEST_DAT02.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl13\/ora_data\/TEST_DAT03.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl13\/bradmark\/bradmark.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/ora_data\/TEST_DAT_NEW01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/ora_data\/TEST_IDX_NEW01.dbf’<\/font><\/font><\/font><\/span><\/p>\n

CHARACTER SET US7ASCII<\/font><\/font><\/font><\/span><\/p>\n

; <\/font><\/span>\u00df<\/span><\/span> <\/font><\/span><\/font>\uc774 \ubd80\ubd84 \uae4c\uc9c0\ub9cc \uc218\ud589<\/span><\/font><\/font><\/p>\n

 <\/font><\/span><\/p>\n

— Commands to re-create incarnation table<\/font><\/font><\/font><\/span><\/p>\n

— Below log names MUST be changed to existing filenames on<\/font><\/font><\/font><\/span><\/p>\n

— disk. Any one log file from each branch can be used to<\/font><\/font><\/font><\/span><\/p>\n

— re-create incarnation records.<\/font><\/font><\/font><\/span><\/p>\n

— ALTER DATABASE REGISTER LOGFILE ‘\/orcl14\/archive\/1_1_651132086.arc’;<\/font><\/font><\/font><\/span><\/p>\n

— ALTER DATABASE REGISTER LOGFILE ‘\/orcl14\/archive\/1_1_716140947.arc’;<\/font><\/font><\/font><\/span><\/p>\n

— Recovery is required if any of the datafiles are restored backups,<\/font><\/font><\/font><\/span><\/p>\n

— or if the last shutdown was not normal or immediate.<\/font><\/font><\/font><\/span><\/p>\n

RECOVER DATABASE USING BACKUP CONTROLFILE<\/font><\/font><\/font><\/span><\/p>\n

 <\/font><\/span><\/p>\n

— Database can now be opened zeroing the online logs.<\/font><\/font><\/font><\/span><\/p>\n

ALTER DATABASE OPEN RESETLOGS;<\/font><\/font><\/font><\/span><\/p>\n

 <\/font><\/span><\/p>\n

— Commands to add tempfiles to temporary tablespaces.<\/font><\/font><\/font><\/span><\/p>\n

— Online tempfiles have complete space information.<\/font><\/font><\/font><\/span><\/p>\n

— Other tempfiles may require adjustment.<\/font><\/font><\/font><\/span><\/p>\n

ALTER TABLESPACE TEMP ADD TEMPFILE ‘\/orcl11\/sysdata\/orcl1\/temp01.dbf’<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>   <\/span>SIZE 7000M REUSE AUTOEXTEND ON NEXT 10485760  <\/span>MAXSIZE 32767M;<\/font><\/font><\/font><\/span><\/p>\n

— End of tempfile additions.<\/font><\/font><\/font><\/span><\/p>\n

—<\/font><\/font><\/font><\/span><\/p>\n

 <\/font><\/span> <\/font><\/span><\/p>\n

5.<\/font>     <\/span><\/span><\/span>\uc7ac\uc0dd\uc131\uc774 \uc644\ub8cc\ub418\uc5c8\uc73c\uba74 Recovery <\/span>\uc791\uc5c5\uc744 \uc218\ud589\ud569\ub2c8\ub2e4. <\/span>\ube68\uac04 \ubd80\ubd84\uc758 \uacbd\ub85c\uc5d0 Archive<\/span>\ub97c \uc704\uce58\ud55c \ud6c4 Enter<\/span>\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.(<\/span>\uc544\uce74\uc774\ube0c\ub85c\uadf8 \ud55c \uac1c\uc529 \uc801\uc6a9, <\/span>\ubcf5\uad6c \ub410\uc744 \uc2dc \ud604\uc7ac \uc2dc\uc810\uc744 \uc54c\uae30 \uc704\ud574\uc11c) (<\/span>\uc18c\uc694\uc2dc\uac04 :  <\/span><\/span><\/font>\ubd84<\/font>)<\/font><\/span><\/font><\/font><\/p>\n

SQL> recover database until cancel using backup controlfile;<\/font><\/font><\/font><\/span><\/p>\n

ORA-00279: change 2034211841 generated at <\/font>06\/12\/2014 04:00:01 <\/span>needed for thread1<\/font><\/font><\/font><\/span><\/p>\n

ORA-00289: suggestion : <\/font>\/orcl14\/archive\/<\/span>1_26093_716140947.arc<\/font><\/font><\/font><\/span><\/p>\n

ORA-00280: change 2034211841 for thread 1 is in sequence #26093<\/font><\/font><\/font><\/span><\/p>\n

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}<\/font><\/font><\/font><\/span><\/p>\n

\uc5d4\ud130 \uc785\ub825<\/font><\/font><\/span><\/p>\n

 <\/font><\/span><\/p>\n

6.<\/font>     <\/span><\/span><\/span>Recovery <\/span>\uc644\ub8cc \ud6c4 v$datafile<\/span>\uc5d0\uc11c status<\/span>\ub97c \ud655\uc778 \ud569\ub2c8\ub2e4.(SYSEM<\/span>\uc740 status<\/span>\uac00 SYSTEM<\/span>\uc73c\ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4. <\/span>\ub098\uba38\uc9c0 dbf<\/span>\ub294 ONLINE<\/span>\uc774\uc5b4\uc57c \ud569\ub2c8\ub2e4.) (<\/span>\uc18c\uc694\uc2dc\uac04 : 1<\/span><\/font>\ubd84<\/font>)<\/font><\/span><\/font><\/font><\/p>\n

SQL> select name,status from v$datafile;<\/font><\/font><\/font><\/span><\/p>\n

 <\/font><\/span><\/p>\n

7.<\/font>     <\/span><\/span><\/span>DB<\/span>\ub97c OPEN <\/span>\ud569\ub2c8\ub2e4. (<\/span>\uc18c\uc694\uc2dc\uac04 : 5<\/span><\/font>\ubd84<\/font>)<\/font><\/span><\/font><\/font><\/p>\n

SQL>alter database open resetlogs;<\/font><\/font><\/font><\/span><\/p>\n

 <\/font><\/span><\/p>\n

8.<\/font>     <\/span><\/span><\/span>TEMP Tablespace<\/span>\ub97c \uc0dd\uc131\ud558\uc5ec \uc90d\ub2c8\ub2e4.( <\/span>\uc704\uc5d0\uc11c Controlfile <\/span>\uc0dd\uc131 \uc2a4\ud06c\ub9bd\ud2b8\uc5d0 \uc788\ub294 \ub0b4\uc6a9) (<\/span>\uc18c\uc694\uc2dc\uac04 : 3<\/span><\/font>\ubd84<\/font>)<\/font><\/span><\/font><\/font><\/p>\n

SQL>ALTER TABLESPACE TEMP ADD TEMPFILE ‘\/orcl11\/sysdata\/orcl1\/temp01.dbf’<\/font><\/font><\/font><\/span><\/p>\n

     <\/span>SIZE 7000M REUSE AUTOEXTEND ON NEXT 10485760  <\/span>MAXSIZE 32767M;<\/font><\/font><\/font><\/span><\/p>\n


<\/span> <\/p>\n

 <\/font><\/span><\/p>\n

# DB Recovery (Archivelog <\/span>\ud30c\uc77c \uc720\uc2e4 \uc2dc, <\/span>\ud788\ub4e0 \ud30c\ub77c\ubbf8\ud130 \uc0ac\uc6a9)<\/span><\/span><\/font><\/font><\/p>\n

 <\/span>* <\/span>\uc774 \ubc29\ubc95\uc740 Oracle<\/span>\uc5d0\uc11c \ubcf4\uc7a5\ud558\uc9c0 \uc54a\ub294 \ubc29\ubc95\uc73c\ub85c \uc815\ud569\uc131\uc774 \ub9de\uc9c0 \uc54a\uc744 \uc218 \uc788\uace0 \uc624 \ub3d9\uc791\uc744 \uc77c\uc73c\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/font><\/p>\n

 <\/font><\/span><\/p>\n

1.<\/font>     <\/span><\/span><\/span>\ubcf5\uad6c \ub370\uc774\ud130\ub97c Copy <\/span>\ud558\uae30\uc5d0 \uc55e\uc11c \uc544\ub798 \ub514\ub809\ud1a0\ub9ac \uc0dd\uc131(<\/span>\uc18c\uc694\uc2dc\uac04 : 1<\/span><\/font>\ubd84<\/font>)<\/font><\/span><\/font><\/font><\/p>\n

mkdir -p \/orcl11\/sysdata\/orcl1\/<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/orcl11\/ora_data\/<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/orcl12\/ora_data\/<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/orcl13\/ora_data\/<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/orcl14\/ora_data\/<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/orcl13\/bradmark\/<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/orcl14\/archive<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/export\/home\/orcl1\/admin\/orcl1\/adump<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/export\/home\/orcl1\/admin\/orcl1\/bdump<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/export\/home\/orcl1\/admin\/orcl1\/cdump<\/font><\/font><\/font><\/span><\/p>\n

mkdir -p \/export\/home\/orcl1\/admin\/orcl1\/udump<\/font><\/font><\/font><\/span><\/p>\n

 <\/font><\/span><\/p>\n

2.<\/font>     <\/span><\/span><\/span>DAT TAPE<\/span>\uc5d0\uc11c dbf <\/span>\ud30c\uc77c\uc744 Restore <\/span>\ud55c \ud6c4 \uc544\ub798 cp <\/span><\/font>\uba85\ub839\uc5b4 \uc2e4\ud589<\/font>(Local <\/font><\/span><\/font>\u00e0<\/span><\/span> DBF <\/span>\uc704\uce58\ub85c Copy<\/span>\uc18c\uc694\uc2dc\uac04 : 25<\/span><\/font><\/font>\ubd84<\/font>)<\/font><\/span><\/font><\/font><\/p>\n

cp users01.dbf \/orcl11\/sysdata\/orcl1\/users01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp TEST_IDX_NEW01.dbf \/orcl11\/ora_data\/TEST_IDX_NEW01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp undotbs01.dbf \/orcl11\/sysdata\/orcl1\/undotbs01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp system01.dbf \/orcl11\/sysdata\/orcl1\/system01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_DAT01.dbf \/orcl11\/ora_data\/ORCL1_TEST_DAT01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_DAT02.dbf \/orcl12\/ora_data\/ORCL1_TEST_DAT02.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_DAT03.dbf \/orcl13\/ora_data\/ORCL1_TEST_DAT03.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_DAT04.dbf \/orcl14\/ora_data\/ORCL1_TEST_DAT04.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_DAT05.dbf \/orcl11\/ora_data\/ORCL1_TEST_DAT05.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_DAT06.dbf \/orcl12\/ora_data\/ORCL1_TEST_DAT06.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_DAT07.dbf \/orcl13\/ora_data\/ORCL1_TEST_DAT07.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_IDX01.dbf \/orcl11\/ora_data\/ORCL1_TEST_IDX01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_IDX02.dbf \/orcl12\/ora_data\/ORCL1_TEST_IDX02.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_TEST_IDX03.dbf \/orcl13\/ora_data\/ORCL1_TEST_IDX03.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_FORE_DAT01.dbf \/orcl11\/ora_data\/ORCL1_FORE_DAT01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_FORE_IDX01.dbf \/orcl12\/ora_data\/ORCL1_FORE_IDX01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_FORE_IDX02.dbf \/orcl13\/ora_data\/ORCL1_FORE_IDX02.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp ORCL1_FORE_IDX03.dbf \/orcl14\/ora_data\/ORCL1_FORE_IDX03.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp TEST_DAT01.dbf \/orcl14\/ora_data\/TEST_DAT01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp TEST_IDX101.dbf \/orcl14\/ora_data\/TEST_IDX101.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp TEST_DAT01.dbf \/orcl11\/ora_data\/TEST_DAT01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp TEST_DAT02.dbf \/orcl12\/ora_data\/TEST_DAT02.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp TEST_DAT03.dbf \/orcl13\/ora_data\/TEST_DAT03.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp sysaux01.dbf \/orcl11\/sysdata\/orcl1\/sysaux01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp TEST_DAT_NEW01.dbf \/orcl11\/ora_data\/TEST_DAT_NEW01.dbf<\/font><\/font><\/font><\/span><\/p>\n

cp bradmark.dbf \/orcl13\/bradmark\/bradmark.dbf<\/font><\/font><\/font><\/span><\/p>\n

 <\/font><\/span><\/p>\n

3.<\/font>     <\/span><\/span><\/span>\ubc31\uc5c5 \ubc1b\uc740 pfile<\/span>\uc5d0 \ud788\ub4e0 \ud30c\ub77c\ubbf8\ud130\ub97c \uae30\uc785\ud55c\ub2e4. <\/span>\uadf8\ub9ac\uace0 nomount <\/span>\ub2e8\uacc4\ub85c \ub9cc\ub4e0\ub2e4. (<\/span>\uc18c\uc694\uc2dc\uac04 : 5<\/span><\/font>\ubd84<\/font>)<\/font><\/span><\/font><\/font><\/p>\n

$vi initorcl1.ora<\/font><\/font><\/font><\/span><\/p>\n

orcl1.__db_cache_size=402653184<\/font><\/font><\/font><\/span><\/p>\n

orcl1.__java_pool_size=4194304<\/font><\/font><\/font><\/span><\/p>\n

orcl1.__large_pool_size=4194304<\/font><\/font><\/font><\/span><\/p>\n

orcl1.__shared_pool_size=620756992<\/font><\/font><\/font><\/span><\/p>\n

orcl1.__streams_pool_size=8388608<\/font><\/font><\/font><\/span><\/p>\n

*._gby_hash_aggregation_enabled=TRUE<\/font><\/font><\/font><\/span><\/p>\n

*.audit_file_dest=’\/export\/home\/orcl1\/admin\/orcl1\/adump’<\/font><\/font><\/font><\/span><\/p>\n

*.background_dump_dest=’\/export\/home\/orcl1\/admin\/orcl1\/bdump’<\/font><\/font><\/font><\/span><\/p>\n

*.compatible=’10.2.0.3.0′<\/font><\/font><\/font><\/span><\/p>\n

*.control_files=’\/orcl11\/sysdata\/orcl1\/control01.ctl’,’\/orcl12\/sysdata\/orcl1\/control02.ctl’,’\/orcl13\/sysdata\/orcl1\/control03.ctl’<\/font><\/font><\/font><\/span><\/p>\n

*.core_dump_dest=’\/export\/home\/orcl1\/admin\/orcl1\/cdump’<\/font><\/font><\/font><\/span><\/p>\n

*.db_block_size=8192<\/font><\/font><\/font><\/span><\/p>\n

*.db_domain=”<\/font><\/font><\/font><\/span><\/p>\n

*.db_file_multiblock_read_count=16<\/font><\/font><\/font><\/span><\/p>\n

*.db_name=’orcl1′<\/font><\/font><\/font><\/span><\/p>\n

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orcl1XDB)’<\/font><\/font><\/font><\/span><\/p>\n

*.job_queue_processes=10<\/font><\/font><\/font><\/span><\/p>\n

*.log_archive_dest_1=’location=\/orcl14\/archive’<\/font><\/font><\/font><\/span><\/p>\n

*.log_archive_format=’%t_%s_%r.arc’<\/font><\/font><\/font><\/span><\/p>\n

*.open_cursors=300<\/font><\/font><\/font><\/span><\/p>\n

*.optimizer_features_enable=’10.2.0.4′<\/font><\/font><\/font><\/span><\/p>\n

*.pga_aggregate_target=629145600<\/font><\/font><\/font><\/span><\/p>\n

*.processes=1000<\/font><\/font><\/font><\/span><\/p>\n

*.remote_login_passwordfile=’EXCLUSIVE’<\/font><\/font><\/font><\/span><\/p>\n

*.sessions=1105<\/font><\/font><\/font><\/span><\/p>\n

*.sga_target=1048576000<\/font><\/font><\/font><\/span><\/p>\n

*.undo_management=’AUTO’<\/font><\/font><\/font><\/span><\/p>\n

*.undo_tablespace=’UNDOTBS1′<\/font><\/font><\/font><\/span><\/p>\n

*.user_dump_dest=’\/export\/home\/orcl1\/admin\/orcl1\/udump’<\/font><\/font><\/font><\/span><\/p>\n

*._corrupted_rollback_segments”=true<\/font><\/font><\/span><\/p>\n

 <\/font><\/span><\/p>\n

SQL>startup pfile=’\/export\/home\/orcl1\/product\/10.2.0\/dbs\/initorcl1.ora’ nomount;<\/font><\/font><\/font><\/span><\/p>\n

4.<\/font>     <\/span><\/span><\/span>\ubc31\uc5c5 \ubc1b\uc740 Controlfile <\/span>\uc7ac\uc0dd\uc131 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc774\uc6a9\ud558\uc5ec \uc544\ub798 \ubd80\ubd84\ub9cc \ud3b8\uc9d1\ud558\uc5ec \ucffc\ub9ac\ub97c \uc218\ud589(<\/span>\uc18c\uc694\uc2dc\uac04 : 5<\/span><\/font>\ubd84<\/font>)<\/font><\/span><\/font><\/font><\/p>\n

SQL>CREATE CONTROLFILE REUSE DATABASE “ORCL1” RESETLOGS  <\/span>ARCHIVELOG<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>MAXLOGFILES 16<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>MAXLOGMEMBERS 3<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>MAXDATAFILES 100<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>MAXINSTANCES 8<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>MAXLOGHISTORY 2160<\/font><\/font><\/font><\/span><\/p>\n

LOGFILE<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>GROUP 1 (<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>‘\/orcl11\/sysdata\/orcl1\/redo01a.log’,<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>‘\/orcl12\/sysdata\/orcl1\/redo01b.log’<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>) SIZE 100M,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>GROUP 2 (<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>‘\/orcl11\/sysdata\/orcl1\/redo02a.log’,<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>‘\/orcl12\/sysdata\/orcl1\/redo02b.log’<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>) SIZE 100M,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>GROUP 3 (<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>‘\/orcl11\/sysdata\/orcl1\/redo03a.log’,<\/font><\/font><\/font><\/span><\/p>\n

    <\/span>‘\/orcl12\/sysdata\/orcl1\/redo03b.log’<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>) SIZE 100M<\/font><\/font><\/font><\/span><\/p>\n

DATAFILE<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/sysdata\/orcl1\/system01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/sysdata\/orcl1\/undotbs01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/sysdata\/orcl1\/sysaux01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/sysdata\/orcl1\/users01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/ora_data\/ORCL1_TEST_DAT01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl12\/ora_data\/ORCL1_TEST_DAT02.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl13\/ora_data\/ORCL1_TEST_DAT03.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl14\/ora_data\/ORCL1_TEST_DAT04.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/ora_data\/ORCL1_TEST_DAT05.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl12\/ora_data\/ORCL1_TEST_DAT06.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl13\/ora_data\/ORCL1_TEST_DAT07.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/ora_data\/ORCL1_TEST_IDX01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl12\/ora_data\/ORCL1_TEST_IDX02.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl13\/ora_data\/ORCL1_TEST_IDX03.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/ora_data\/ORCL1_FORE_DAT01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl12\/ora_data\/ORCL1_FORE_IDX01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl13\/ora_data\/ORCL1_FORE_IDX02.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl14\/ora_data\/ORCL1_FORE_IDX03.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl14\/ora_data\/TEST_DAT01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl14\/ora_data\/TEST_IDX101.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/ora_data\/TEST_DAT01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl12\/ora_data\/TEST_DAT02.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl13\/ora_data\/TEST_DAT03.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl13\/bradmark\/bradmark.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/ora_data\/TEST_DAT_NEW01.dbf’,<\/font><\/font><\/font><\/span><\/p>\n

  <\/span>‘\/orcl11\/ora_data\/TEST_IDX_NEW01.dbf’<\/font><\/font><\/font><\/span><\/p>\n

CHARACTER SET US7ASCII<\/font><\/font><\/font><\/span><\/p>\n

; <\/font><\/span>\u00df<\/span><\/span> <\/font><\/span><\/font>\uc774 \ubd80\ubd84 \uae4c\uc9c0\ub9cc \uc218\ud589<\/span><\/font><\/font><\/p>\n

 <\/font><\/span><\/p>\n

— Commands to re-create incarnation table<\/font><\/font><\/font><\/span><\/p>\n

— Below log names MUST be changed to existing filenames on<\/font><\/font><\/font><\/span><\/p>\n

— disk. Any one log file from each branch can be used to<\/font><\/font><\/font><\/span><\/p>\n

— re-create incarnation records.<\/font><\/font><\/font><\/span><\/p>\n

— ALTER DATABASE REGISTER LOGFILE ‘\/orcl14\/archive\/1_1_651132086.arc’;<\/font><\/font><\/font><\/span><\/p>\n

— ALTER DATABASE REGISTER LOGFILE ‘\/orcl14\/archive\/1_1_716140947.arc’;<\/font><\/font><\/font><\/span><\/p>\n

— Recovery is required if any of the datafiles are restored backups,<\/font><\/font><\/font><\/span><\/p>\n

— or if the last shutdown was not normal or immediate.<\/font><\/font><\/font><\/span><\/p>\n

RECOVER DATABASE USING BACKUP CONTROLFILE<\/font><\/font><\/font><\/span><\/p>\n

 <\/font><\/span><\/p>\n

— Database can now be opened zeroing the online logs.<\/font><\/font><\/font><\/span><\/p>\n

ALTER DATABASE OPEN RESETLOGS;<\/font><\/font><\/font><\/span><\/p>\n

 <\/font><\/span><\/p>\n

— Commands to add tempfiles to temporary tablespaces.<\/font><\/font><\/font><\/span><\/p>\n

— Online tempfiles have complete space information.<\/font><\/font><\/font><\/span><\/p>\n

— Other tempfiles may require adjustment.<\/font><\/font><\/font><\/span><\/p>\n

ALTER TABLESPACE TEMP ADD TEMPFILE ‘\/orcl11\/sysdata\/orcl1\/temp01.dbf’<\/font><\/font><\/font><\/span><\/p>\n

     <\/span>SIZE 7000M REUSE AUTOEXTEND ON NEXT 10485760  <\/span>MAXSIZE 32767M;<\/font><\/font><\/font><\/span><\/p>\n

— End of tempfile additions.<\/font><\/font><\/font><\/span><\/p>\n

—<\/font><\/font><\/font><\/span><\/p>\n

 <\/font><\/span> <\/font><\/span><\/p>\n

5.<\/font>     <\/span><\/span><\/span>SQL <\/span>\uc218\ud589(<\/span>\uc18c\uc694\uc2dc\uac04 : 1<\/span><\/font>\ubd84<\/font>)<\/font><\/span><\/font><\/font><\/p>\n

SQL> alter session set events ‘10015 trace name adjust_scn level 1’;<\/font><\/font><\/font><\/span><\/p>\n

 <\/font><\/span><\/p>\n

6.<\/font>     <\/span><\/span><\/span>\uc7ac\uc0dd\uc131\uc774 \uc644\ub8cc\ub418\uc5c8\uc73c\uba74 Recovery <\/span>\uc791\uc5c5\uc744 \uc218\ud589\ud569\ub2c8\ub2e4. <\/span>\ube68\uac04 \ubd80\ubd84\uc758 \uacbd\ub85c\uc5d0 Archive<\/span>\ub97c \uc704\uce58\ud55c \ud6c4 Cancel <\/span>\uc785\ub825\ud569\ub2c8\ub2e4.(<\/span>\uc544\uce74\uc774\ube0c\ub85c\uadf8 \ud55c \uac1c\uc529 \uc801\uc6a9, <\/span>\ubcf5\uad6c \ub410\uc744 \uc2dc \ud604\uc7ac \uc2dc\uc810\uc744 \uc54c\uae30 \uc704\ud574\uc11c) (<\/span>\uc18c\uc694\uc2dc\uac04 : 1<\/span><\/font>\ubd84<\/font>)<\/font><\/span><\/font><\/font><\/p>\n

SQL> recover database until cancel using backup controlfile;<\/font><\/font><\/font><\/span><\/p>\n

ORA-00279: change 2034211841 generated at <\/font>06\/12\/2014 04:00:01 <\/span>needed for thread1<\/font><\/font><\/font><\/span><\/p>\n

ORA-00289: suggestion : <\/font>\/orcl14\/archive\/<\/span>1_26093_716140947.arc<\/font><\/font><\/font><\/span><\/p>\n

ORA-00280: change 2034211841 for thread 1 is in sequence #26093<\/font><\/font><\/font><\/span><\/p>\n

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}<\/font><\/font><\/font><\/span><\/p>\n

cancel <\/span>\uc785\ub825<\/span><\/font><\/font><\/p>\n

 <\/font><\/span><\/p>\n

7.<\/font>     <\/span><\/span><\/span>DB<\/span>\ub97c OPEN <\/span>\ud569\ub2c8\ub2e4. (<\/span>\uc18c\uc694\uc2dc\uac04 : 5<\/span><\/font>\ubd84<\/font>)<\/font><\/span><\/font><\/font><\/p>\n

SQL>alter database open resetlogs;<\/font><\/font><\/font><\/span><\/p>\n

 <\/font><\/span><\/p>\n

8.<\/font>     <\/span><\/span><\/span>TEMP Tablespace<\/span>\ub97c \uc0dd\uc131\ud558\uc5ec \uc90d\ub2c8\ub2e4.( <\/span>\uc704\uc5d0\uc11c Controlfile <\/span>\uc0dd\uc131 \uc2a4\ud06c\ub9bd\ud2b8\uc5d0 \uc788\ub294 \ub0b4\uc6a9) (<\/span>\uc18c\uc694\uc2dc\uac04 : 3<\/span><\/font>\ubd84<\/font>)<\/font><\/span><\/font><\/font><\/p>\n

SQL>ALTER TABLESPACE TEMP ADD TEMPFILE ‘\/orcl11\/sysdata\/orcl1\/temp01.dbf’<\/font><\/font><\/font><\/span><\/p>\n

     <\/span>SIZE 7000M REUSE AUTOEXTEND ON NEXT 10485760  <\/span>MAXSIZE 32767M;<\/font><\/font><\/font><\/span><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

DR \uc804\ud658 \uc2dc DB Recovery(1. \uc544\uce74\uc774\ube0c \uc874\uc7ac \uc2dc, 2. \ud788\ub4e0\ud30c\ub77c\ubbf8\ud130) # DB Recovery (Archivelog \ud30c\uc77c \uc874\uc7ac\ud560 \uc2dc) 1.     \ubcf5\uad6c \ub370\uc774\ud130\ub97c Copy \ud558\uae30\uc5d0 \uc55e\uc11c \uc544\ub798 \ub514\ub809\ud1a0\ub9ac \uc0dd\uc131(\uc18c\uc694\uc2dc\uac04 : 1\ubd84) mkdir -p \/orcl11\/sysdata\/orcl1\/ mkdir -p \/orcl11\/ora_data\/ mkdir -p \/orcl12\/ora_data\/ mkdir -p \/orcl13\/ora_data\/ mkdir -p \/orcl14\/ora_data\/ mkdir -p \/orcl13\/bradmark\/ mkdir -p \/orcl14\/archive mkdir -p \/export\/home\/orcl1\/admin\/orcl1\/adump mkdir -p \/export\/home\/orcl1\/admin\/orcl1\/bdump […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[14],"tags":[22,23],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/308"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=308"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/308\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=308"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}