hirasawa@ubuntu1204-20:~/oraclebkup$ cat 1.txt |more
SQL> select name from v$datafile;
/opt/oracle/app/oradata/orcl/system01.dbf
/opt/oracle/app/oradata/orcl/sysaux01.dbf
/opt/oracle/app/oradata/orcl/undotbs01.dbf
/opt/oracle/app/oradata/orcl/users01.dbf
SQL>
SQL> select name from v$controlfile;
/opt/oracle/app/oradata/orcl/control01.ctl
/opt/oracle/app/flash_recovery_area/orcl/control02.ctl
SQL>
SQL> select group#,member from v$logfile;
GROUP# ,MEMBER
1 ,/opt/oracle/app/oradata/orcl/redo01.log
2 ,/opt/oracle/app/oradata/orcl/redo02.log
3 ,/opt/oracle/app/oradata/orcl/redo03.log
SQL>
SQL> select name from v$recovery_file_dest;
/opt/oracle/app/flash_recovery_area
SQL>
SQL> r
1 select name,value from v$parameter where name like 'log_archive_dest_%'
2* and name not like 'log_archive_dest_state%'
log_archive_dest_1
,
log_archive_dest_2
,
log_archive_dest_3
,
log_archive_dest_4
,
log_archive_dest_5
,
log_archive_dest_6
,
log_archive_dest_7
,
log_archive_dest_8
,
log_archive_dest_9
,
log_archive_dest_10
,
log_archive_dest_11
,
log_archive_dest_12
,
log_archive_dest_13
,
log_archive_dest_14
,
log_archive_dest_15
,
log_archive_dest_16
,
log_archive_dest_17
,
log_archive_dest_18
,
log_archive_dest_19
,
log_archive_dest_20
,
log_archive_dest_21
,
log_archive_dest_22
,
log_archive_dest_23
,
log_archive_dest_24
,
log_archive_dest_25
,
log_archive_dest_26
,
log_archive_dest_27
,
log_archive_dest_28
,
log_archive_dest_29
,
log_archive_dest_30
,
log_archive_dest_31
,
SQL>
---------
1) before shutdown
[oracle@cent5-64b-40 ~]$ ps -ef | grep oracle
oracle 5908 1 0 08:56 ? 00:00:41 /opt/oracle/app/product/11.2.0/d
bhome_1/bin/tnslsnr LISTENER -inherit
oracle 6057 1 0 08:56 ? 00:00:02 ora_pmon_orcl
oracle 6059 1 0 08:56 ? 00:00:00 ora_vktm_orcl
oracle 6063 1 0 08:56 ? 00:00:00 ora_gen0_orcl
oracle 6065 1 0 08:56 ? 00:00:00 ora_diag_orcl
oracle 6067 1 0 08:56 ? 00:00:00 ora_dbrm_orcl
oracle 6069 1 0 08:56 ? 00:00:03 ora_psp0_orcl
oracle 6071 1 0 08:56 ? 00:00:32 ora_dia0_orcl
oracle 6073 1 0 08:56 ? 00:00:01 ora_mman_orcl
oracle 6075 1 0 08:56 ? 00:00:03 ora_dbw0_orcl
oracle 6077 1 0 08:56 ? 00:00:06 ora_lgwr_orcl
oracle 6079 1 0 08:56 ? 00:00:05 ora_ckpt_orcl
oracle 6081 1 0 08:56 ? 00:00:03 ora_smon_orcl
oracle 6083 1 0 08:56 ? 00:00:00 ora_reco_orcl
oracle 6085 1 0 08:56 ? 00:00:05 ora_mmon_orcl
oracle 6087 1 0 08:56 ? 00:00:04 ora_mmnl_orcl
oracle 6089 1 0 08:56 ? 00:00:00 ora_d000_orcl
oracle 6091 1 0 08:56 ? 00:00:00 ora_s000_orcl
oracle 6146 1 0 08:56 ? 00:00:00 ora_qmnc_orcl
oracle 6189 1 0 08:56 ? 00:00:10 ora_cjq0_orcl
oracle 6700 1 0 08:56 ? 00:00:06 /opt/oracle/app/product/11.2.0/d
bhome_1/perl/bin/perl /opt/oracle/app/product/11.2.0/dbhome_1/bin/emwd.pl dbcons
ole /opt/oracle/app/product/11.2.0/dbhome_1/cent5-64b-40_orcl/sysman/log/emdb.no
hup
oracle 6722 6700 0 08:56 ? 00:03:33 /opt/oracle/app/product/11.2.0/d
bhome_1/jdk/bin/java -server -Xmx384M -XX:MaxPermSize=400M -XX:MinHeapFreeRatio=
20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/opt/oracle/app/product/11.2.0/dbhome_1
-Doracle.home=/opt/oracle/app/product/11.2.0/dbhome_1/oc4j -Doracle.oc4j.localh
ome=/opt/oracle/app/product/11.2.0/dbhome_1/cent5-64b-40_orcl/sysman -DEMSTATE=/
opt/oracle/app/product/11.2.0/dbhome_1/cent5-64b-40_orcl -Doracle.j2ee.dont.use.
memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.ja
zn.config=/opt/oracle/app/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_cent5
-64b-40_orcl/config/jazn.xml -Djava.security.policy=/opt/oracle/app/product/11.2
.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_cent5-64b-40_orcl/config/java2.policy -Djav
ax.net.ssl.KeyStore=/opt/oracle/app/product/11.2.0/dbhome_1/sysman/config/OCMTru
stedCerts.txt-Djava.security.properties=/opt/oracle/app/product/11.2.0/dbhome_1/
oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/opt/oracle/app/product/11.2
.0/dbhome_1/cent5-64b-40_orcl -Dsysman.md5password=true -Drepapi.oracle.home=/op
t/oracle/app/product/11.2.0/dbhome_1 -Ddisable.checkForUpdate=true -Doracle.sysm
an.ccr.ocmSDK.websvc.keystore=/opt/oracle/app/product/11.2.0/dbhome_1/jlib/emocm
clnt.ks -Dice.pilots.html4.ignoreNonGenericFonts=true -Djava.awt.headless=true -
jar /opt/oracle/app/product/11.2.0/dbhome_1/oc4j/j2ee/home/oc4j.jar -config /opt
/oracle/app/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_cent5-64b-40_orcl/c
onfig/server.xml
oracle 6732 6700 0 08:56 ? 00:00:34 /opt/oracle/app/product/11.2.0/d
bhome_1/bin/emagent
oracle 6793 1 0 08:56 ? 00:00:00 ora_q000_orcl
oracle 6795 1 0 08:56 ? 00:00:00 ora_q001_orcl
oracle 7284 1 0 09:01 ? 00:00:00 ora_smco_orcl
root 12916 12886 0 21:36 pts/1 00:00:00 su -l oracle
oracle 12917 12916 0 21:36 pts/1 00:00:00 -bash
oracle 13216 1 0 21:42 ? 00:00:00 ora_w000_orcl
oracle 13709 12917 0 21:52 pts/1 00:00:00 sqlplus as sysdba
oracle 13710 13709 0 21:52 ? 00:00:00 oracleorcl (DESCRIPTION=(LOCAL=Y
ES)(ADDRESS=(PROTOCOL=beq)))
root 13808 13780 0 21:52 pts/2 00:00:00 su -l oracle
oracle 13809 13808 0 21:52 pts/2 00:00:00 -bash
oracle 13852 1 1 21:53 ? 00:00:00 ora_j000_orcl
oracle 13854 1 0 21:53 ? 00:00:00 ora_j001_orcl
oracle 13855 13809 0 21:53 pts/2 00:00:00 ps -ef
oracle 13856 13809 0 21:53 pts/2 00:00:00 grep oracle
[oracle@cent5-64b-40 ~]$
[oracle@cent5-64b-40 ~]$
2)exec shutdown
SQL> shutdown
データベースがクローズされました。
データベースがディスマウントされました。
ORACLEインスタンスがシャットダウンされました。
SQL>
3) after
[oracle@cent5-64b-40 ~]$ ps -ef | grep oracle
oracle 5908 1 0 08:56 ? 00:00:41 /opt/oracle/app/product/11.2.0/dbhome_1/bin/tnslsnr LISTENER -inherit
oracle 6700 1 0 08:56 ? 00:00:06 /opt/oracle/app/product/11.2.0/dbhome_1/perl/bin/perl /opt/oracle/app/product/11.2.0/dbhome_1/bin/emwd.pl dbconsole /opt/oracle/app/product/11.2.0/dbhome_1/cent5-64b-40_orcl/sysman/log/emdb.nohup
oracle 6722 6700 0 08:56 ? 00:03:33 /opt/oracle/app/product/11.2.0/dbhome_1/jdk/bin/java -server -Xmx384M -XX:MaxPermSize=400M -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/opt/oracle/app/product/11.2.0/dbhome_1 -Doracle.home=/opt/oracle/app/product/11.2.0/dbhome_1/oc4j -Doracle.oc4j.localhome=/opt/oracle/app/product/11.2.0/dbhome_1/cent5-64b-40_orcl/sysman -DEMSTATE=/opt/oracle/app/product/11.2.0/dbhome_1/cent5-64b-40_orcl -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/opt/oracle/app/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_cent5-64b-40_orcl/config/jazn.xml -Djava.security.policy=/opt/oracle/app/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_cent5-64b-40_orcl/config/java2.policy -Djavax.net.ssl.KeyStore=/opt/oracle/app/product/11.2.0/dbhome_1/sysman/config/OCMTrustedCerts.txt-Djava.security.properties=/opt/oracle/app/product/11.2.0/dbhome_1/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/opt/oracle/app/product/11.2.0/dbhome_1/cent5-64b-40_orcl -Dsysman.md5password=true -Drepapi.oracle.home=/opt/oracle/app/product/11.2.0/dbhome_1 -Ddisable.checkForUpdate=true -Doracle.sysman.ccr.ocmSDK.websvc.keystore=/opt/oracle/app/product/11.2.0/dbhome_1/jlib/emocmclnt.ks -Dice.pilots.html4.ignoreNonGenericFonts=true -Djava.awt.headless=true -jar /opt/oracle/app/product/11.2.0/dbhome_1/oc4j/j2ee/home/oc4j.jar -config /opt/oracle/app/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_cent5-64b-40_orcl/config/server.xml
oracle 6732 6700 0 08:56 ? 00:00:34 /opt/oracle/app/product/11.2.0/dbhome_1/bin/emagent
root 12916 12886 0 21:36 pts/1 00:00:00 su -l oracle
oracle 12917 12916 0 21:36 pts/1 00:00:00 -bash
oracle 13709 12917 0 21:52 pts/1 00:00:00 sqlplus as sysdba
oracle 13710 13709 0 21:52 ? 00:00:00 oracleorcl (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
root 13808 13780 0 21:52 pts/2 00:00:00 su -l oracle
oracle 13809 13808 0 21:52 pts/2 00:00:00 -bash
oracle 13927 13809 0 21:55 pts/2 00:00:00 ps -ef
oracle 13928 13809 0 21:55 pts/2 00:00:00 grep oracle
[oracle@cent5-64b-40 ~]$
4) copy files
[oracle@cent5-64b-40 ~]$ mkdir oracle_bkup_depo
[oracle@cent5-64b-40 ~]$ cd oracle_bkup_depo/
[oracle@cent5-64b-40 oracle_bkup_depo]$ ls -ltr
合計 0
[oracle@cent5-64b-40 oracle_bkup_depo]$
4-1) dbf files
[oracle@cent5-64b-40 orcl]$ pwd
/opt/oracle/app/oradata/orcl
[oracle@cent5-64b-40 orcl]$ ls -ltr | grep dbf
-rw-r----- 1 oracle oinstall 71311360 8月 25 19:44 temp01.dbf
-rw-r----- 1 oracle oinstall 1555832832 8月 25 21:54 users01.dbf
-rw-r----- 1 oracle oinstall 387981312 8月 25 21:54 undotbs01.dbf
-rw-r----- 1 oracle oinstall 734011392 8月 25 21:54 system01.dbf
-rw-r----- 1 oracle oinstall 639639552 8月 25 21:54 sysaux01.dbf
[oracle@cent5-64b-40 orcl]$
4-2) check md5sum
[oracle@cent5-64b-40 oracle_bkup_depo]$
[oracle@cent5-64b-40 oracle_bkup_depo]$ md5sum *
f69c9a6300ef5a154ce687a96691230e sysaux01.dbf
404cfa6ff2ada3c14c3cf0fa801f107c system01.dbf
8ed3f0800ba932ccb1403c9c160c6771 undotbs01.dbf
abd59da2432c77cdcc69a7e3813aaf8a users01.dbf
[oracle@cent5-64b-40 oracle_bkup_depo]$
[oracle@cent5-64b-40 orcl]$ md5sum *dbf
f69c9a6300ef5a154ce687a96691230e sysaux01.dbf
404cfa6ff2ada3c14c3cf0fa801f107c system01.dbf
5fb7ffcf465956ad3f8d4c9595570559 temp01.dbf
8ed3f0800ba932ccb1403c9c160c6771 undotbs01.dbf
abd59da2432c77cdcc69a7e3813aaf8a users01.dbf
[oracle@cent5-64b-40 orcl]$
[oracle@cent5-64b-40 orcl]$ cp -pr control01.ctl /home/oracle/oracle_bkup_depo/
[oracle@cent5-64b-40 orcl]$ md5sum control01.ctl
49dfa03fd591e3b621cc9edf4c4df5f1 control01.ctl
[oracle@cent5-64b-40 orcl]$
[oracle@cent5-64b-40 oracle_bkup_depo]$ md5sum control01.ctl
49dfa03fd591e3b621cc9edf4c4df5f1 control01.ctl
[oracle@cent5-64b-40 oracle_bkup_depo]$
[oracle@cent5-64b-40 orcl]$ pwd
/opt/oracle/app/flash_recovery_area/orcl
[oracle@cent5-64b-40 orcl]$ cp -pr control02.ctl /home/oracle/oracle_bkup_depo/
[oracle@cent5-64b-40 orcl]$ md5sum control02.ctl
3c115dcaa3879477505ed32c4d6e366a control02.ctl
[oracle@cent5-64b-40 orcl]$
[oracle@cent5-64b-40 oracle_bkup_depo]$ md5sum control02.ctl
3c115dcaa3879477505ed32c4d6e366a control02.ctl
[oracle@cent5-64b-40 oracle_bkup_depo]$ md5sum control0*
49dfa03fd591e3b621cc9edf4c4df5f1 control01.ctl
3c115dcaa3879477505ed32c4d6e366a control02.ctl
[oracle@cent5-64b-40 oracle_bkup_depo]$
--------------------------------
[oracle@cent5-64b-40 orcl]$ cp -pr redo0
redo01.log redo02.log redo03.log
[oracle@cent5-64b-40 orcl]$ cp -pr redo0*.log /home/oracle/oracle_bkup_depo/
[oracle@cent5-64b-40 orcl]$ md5sum *log
c2ae7da4fff3199a9334120ce87a4399 redo01.log
7121df8381ceb10cb5d778058a3665f3 redo02.log
644ae0c410ca3c3b41bedbb0eef289c3 redo03.log
[oracle@cent5-64b-40 orcl]$
[oracle@cent5-64b-40 oracle_bkup_depo]$ pwd
/home/oracle/oracle_bkup_depo
[oracle@cent5-64b-40 oracle_bkup_depo]$ md5sum *log
c2ae7da4fff3199a9334120ce87a4399 redo01.log
7121df8381ceb10cb5d778058a3665f3 redo02.log
644ae0c410ca3c3b41bedbb0eef289c3 redo03.log
[oracle@cent5-64b-40 oracle_bkup_depo]$
-----------------------------------
5-1) startup db!
backup done!
SQL> startup
ORACLEインスタンスが起動しました。
Total System Global Area 2505338880 bytes
Fixed Size 2215944 bytes
Variable Size 1677725688 bytes
Database Buffers 822083584 bytes
Redo Buffers 3313664 bytes
データベースがマウントされました。
データベースがオープンされました。
SQL>
[oracle@cent5-64b-40 oracle_bkup_depo]$ ps -ef | grep oracle
oracle 5908 1 0 08:56 ? 00:00:42 /opt/oracle/app/product/11.2.0/dbhome_1/bin/tnslsnr LISTENER -inherit
oracle 6700 1 0 08:56 ? 00:00:06 /opt/oracle/app/product/11.2.0/dbhome_1/perl/bin/perl /opt/oracle/app/product/11.2.0/dbhome_1/bin/emwd.pl dbconsole /opt/oracle/app/product/11.2.0/dbhome_1/cent5-64b-40_orcl/sysman/log/emdb.nohup
oracle 6722 6700 0 08:56 ? 00:03:37 /opt/oracle/app/product/11.2.0/dbhome_1/jdk/bin/java -server -Xmx384M -XX:MaxPermSize=400M -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/opt/oracle/app/product/11.2.0/dbhome_1 -Doracle.home=/opt/oracle/app/product/11.2.0/dbhome_1/oc4j -Doracle.oc4j.localhome=/opt/oracle/app/product/11.2.0/dbhome_1/cent5-64b-40_orcl/sysman -DEMSTATE=/opt/oracle/app/product/11.2.0/dbhome_1/cent5-64b-40_orcl -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/opt/oracle/app/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_cent5-64b-40_orcl/config/jazn.xml -Djava.security.policy=/opt/oracle/app/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_cent5-64b-40_orcl/config/java2.policy -Djavax.net.ssl.KeyStore=/opt/oracle/app/product/11.2.0/dbhome_1/sysman/config/OCMTrustedCerts.txt-Djava.security.properties=/opt/oracle/app/product/11.2.0/dbhome_1/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/opt/oracle/app/product/11.2.0/dbhome_1/cent5-64b-40_orcl -Dsysman.md5password=true -Drepapi.oracle.home=/opt/oracle/app/product/11.2.0/dbhome_1 -Ddisable.checkForUpdate=true -Doracle.sysman.ccr.ocmSDK.websvc.keystore=/opt/oracle/app/product/11.2.0/dbhome_1/jlib/emocmclnt.ks -Dice.pilots.html4.ignoreNonGenericFonts=true -Djava.awt.headless=true -jar /opt/oracle/app/product/11.2.0/dbhome_1/oc4j/j2ee/home/oc4j.jar -config /opt/oracle/app/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_cent5-64b-40_orcl/config/server.xml
oracle 6732 6700 0 08:56 ? 00:00:35 /opt/oracle/app/product/11.2.0/dbhome_1/bin/emagent
root 12916 12886 0 21:36 pts/1 00:00:00 su -l oracle
oracle 12917 12916 0 21:36 pts/1 00:00:00 -bash
oracle 13709 12917 0 21:52 pts/1 00:00:00 sqlplus as sysdba
root 13808 13780 0 21:52 pts/2 00:00:00 su -l oracle
oracle 13809 13808 0 21:52 pts/2 00:00:00 -bash
root 14058 14030 0 21:58 pts/3 00:00:00 su -l oracle
oracle 14059 14058 0 21:58 pts/3 00:00:00 -bash
oracle 14575 1 0 22:18 ? 00:00:00 ora_pmon_orcl
oracle 14577 1 0 22:18 ? 00:00:00 ora_vktm_orcl
oracle 14581 1 0 22:18 ? 00:00:00 ora_gen0_orcl
oracle 14583 1 0 22:18 ? 00:00:00 ora_diag_orcl
oracle 14585 1 0 22:18 ? 00:00:00 ora_dbrm_orcl
oracle 14587 1 0 22:18 ? 00:00:00 ora_psp0_orcl
oracle 14589 1 0 22:18 ? 00:00:00 ora_dia0_orcl
oracle 14591 1 2 22:18 ? 00:00:01 ora_mman_orcl
oracle 14593 1 0 22:18 ? 00:00:00 ora_dbw0_orcl
oracle 14595 1 0 22:18 ? 00:00:00 ora_lgwr_orcl
oracle 14597 1 0 22:18 ? 00:00:00 ora_ckpt_orcl
oracle 14599 1 0 22:18 ? 00:00:00 ora_smon_orcl
oracle 14601 1 0 22:18 ? 00:00:00 ora_reco_orcl
oracle 14603 1 1 22:18 ? 00:00:01 ora_mmon_orcl
oracle 14605 1 0 22:18 ? 00:00:00 ora_mmnl_orcl
oracle 14607 1 0 22:18 ? 00:00:00 ora_d000_orcl
oracle 14609 1 0 22:18 ? 00:00:00 ora_s000_orcl
oracle 14672 13709 3 22:18 ? 00:00:01 oracleorcl (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 14674 1 0 22:18 ? 00:00:00 ora_qmnc_orcl
oracle 14692 1 2 22:18 ? 00:00:00 ora_cjq0_orcl
oracle 14694 1 0 22:19 ? 00:00:00 ora_q000_orcl
oracle 14696 1 0 22:19 ? 00:00:00 ora_q001_orcl
oracle 14699 1 1 22:19 ? 00:00:00 ora_j000_orcl
oracle 14701 1 0 22:19 ? 00:00:00 ora_j001_orcl
oracle 14703 1 1 22:19 ? 00:00:00 ora_j002_orcl
oracle 14705 1 0 22:19 ? 00:00:00 ora_j003_orcl
oracle 14729 13809 0 22:19 pts/2 00:00:00 ps -ef
oracle 14730 13809 0 22:19 pts/2 00:00:00 grep oracle
[oracle@cent5-64b-40 oracle_bkup_depo]$
-----------------------------------------
6-1) change db a blit
SQL> update zip set updatereason=1 where zipcode=2030013;
1行が更新されました。
SQL> select updatereason from zip where zipcode=2030013;
UPDATEREASON
------------
1
SQL> commit;
-----------------------------------------
7-1) shudown
SQL> shutdown
データベースがクローズされました。
データベースがディスマウントされました。
ORACLEインスタンスがシャットダウンされました。
SQL>
---------------------------
7-2) to make sure
[oracle@cent5-64b-40 orcl]$ pwd
/opt/oracle/app/oradata/orcl
[oracle@cent5-64b-40 orcl]$ ls -ltr
合計 3421336
-rw-r----- 1 oracle oinstall 71311360 8月 25 19:44 temp01.dbf
-rw-r----- 1 oracle oinstall 52429312 8月 25 22:18 redo03.log
-rw-r----- 1 oracle oinstall 52429312 8月 25 22:18 redo01.log
-rw-r----- 1 oracle oinstall 1555832832 8月 25 22:24 users01.dbf
-rw-r----- 1 oracle oinstall 387981312 8月 25 22:24 undotbs01.dbf
-rw-r----- 1 oracle oinstall 734011392 8月 25 22:24 system01.dbf
-rw-r----- 1 oracle oinstall 639639552 8月 25 22:24 sysaux01.dbf
-rw-r----- 1 oracle oinstall 52429312 8月 25 22:24 redo02.log
-rw-r----- 1 oracle oinstall 9748480 8月 25 22:24 control01.ctl
[oracle@cent5-64b-40 orcl]$
[oracle@cent5-64b-40 orcl]$ pwd
/opt/oracle/app/oradata/orcl
[oracle@cent5-64b-40 orcl]$ cd /opt/oracle/app/flash_recovery_area/orcl/
[oracle@cent5-64b-40 orcl]$ ls -ltr
合計 9540
-rw-r----- 1 oracle oinstall 9748480 8月 25 22:24 control02.ctl
[oracle@cent5-64b-40 orcl]$
[oracle@cent5-64b-40 orcl]$ md5sum temp01.dbf
5fb7ffcf465956ad3f8d4c9595570559 temp01.dbf
[oracle@cent5-64b-40 orcl]$
------------------------------
triple make sure sure
[oracle@cent5-64b-40 orcl]$ pwd
/opt/oracle/app/oradata/orcl
[oracle@cent5-64b-40 orcl]$
[oracle@cent5-64b-40 orcl]$ ls -ltr
合計 3421336
-rw-r----- 1 oracle oinstall 71311360 8月 25 19:44 temp01.dbf
-rw-r----- 1 oracle oinstall 52429312 8月 25 22:18 redo03.log
-rw-r----- 1 oracle oinstall 52429312 8月 25 22:18 redo01.log
-rw-r----- 1 oracle oinstall 1555832832 8月 25 22:24 users01.dbf
-rw-r----- 1 oracle oinstall 387981312 8月 25 22:24 undotbs01.dbf
-rw-r----- 1 oracle oinstall 734011392 8月 25 22:24 system01.dbf
-rw-r----- 1 oracle oinstall 639639552 8月 25 22:24 sysaux01.dbf
-rw-r----- 1 oracle oinstall 52429312 8月 25 22:24 redo02.log
-rw-r----- 1 oracle oinstall 9748480 8月 25 22:24 control01.ctl
[oracle@cent5-64b-40 orcl]$
[oracle@cent5-64b-40 orcl]$ cd ..
[oracle@cent5-64b-40 oradata]$ ls -ltr
合計 16
drwxr-x--- 2 oracle oinstall 4096 10月 7 2011 orcl
[oracle@cent5-64b-40 oradata]$
[oracle@cent5-64b-40 oradata]$ cp -pr orcl orcl.bk
[oracle@cent5-64b-40 oradata]$
[oracle@cent5-64b-40 oradata]$ ls -ltr
合計 24
drwxr-x--- 2 oracle oinstall 4096 10月 7 2011 orcl.bk
drwxr-x--- 2 oracle oinstall 4096 10月 7 2011 orcl
[oracle@cent5-64b-40 oradata]$
[oracle@cent5-64b-40 oradata]$
[oracle@cent5-64b-40 oradata]$
[oracle@cent5-64b-40 oradata]$
[oracle@cent5-64b-40 oradata]$ ls -ltr orcl.bk/
合計 3421332
-rw-r----- 1 oracle oinstall 71311360 8月 25 19:44 temp01.dbf
-rw-r----- 1 oracle oinstall 52429312 8月 25 22:18 redo03.log
-rw-r----- 1 oracle oinstall 52429312 8月 25 22:18 redo01.log
-rw-r----- 1 oracle oinstall 1555832832 8月 25 22:24 users01.dbf
-rw-r----- 1 oracle oinstall 387981312 8月 25 22:24 undotbs01.dbf
-rw-r----- 1 oracle oinstall 734011392 8月 25 22:24 system01.dbf
-rw-r----- 1 oracle oinstall 639639552 8月 25 22:24 sysaux01.dbf
-rw-r----- 1 oracle oinstall 52429312 8月 25 22:24 redo02.log
-rw-r----- 1 oracle oinstall 9748480 8月 25 22:24 control01.ctl
[oracle@cent5-64b-40 oradata]$
[oracle@cent5-64b-40 flash_recovery_area]$
[oracle@cent5-64b-40 flash_recovery_area]$ cd /opt/oracle/app/flash_recovery_area/
[oracle@cent5-64b-40 flash_recovery_area]$ ls -ltr
合計 16
drwxr-x--- 2 oracle oinstall 4096 10月 7 2011 orcl
[oracle@cent5-64b-40 flash_recovery_area]$
[oracle@cent5-64b-40 flash_recovery_area]$ cd orcl/
[oracle@cent5-64b-40 orcl]$ ls -ltr
合計 9540
-rw-r----- 1 oracle oinstall 9748480 8月 25 22:24 control02.ctl
[oracle@cent5-64b-40 orcl]$
[oracle@cent5-64b-40 orcl]$ cd ..
[oracle@cent5-64b-40 flash_recovery_area]$ ls -ltr
合計 16
drwxr-x--- 2 oracle oinstall 4096 10月 7 2011 orcl
[oracle@cent5-64b-40 flash_recovery_area]$
[oracle@cent5-64b-40 flash_recovery_area]$ cp -pr orcl orcl.bk
[oracle@cent5-64b-40 flash_recovery_area]$
[oracle@cent5-64b-40 flash_recovery_area]$
[oracle@cent5-64b-40 flash_recovery_area]$ ls -ltr
合計 24
drwxr-x--- 2 oracle oinstall 4096 10月 7 2011 orcl.bk
drwxr-x--- 2 oracle oinstall 4096 10月 7 2011 orcl
[oracle@cent5-64b-40 flash_recovery_area]$
[oracle@cent5-64b-40 flash_recovery_area]$ cd orcl.bk/
[oracle@cent5-64b-40 orcl.bk]$ ls -ltr
合計 9540
-rw-r----- 1 oracle oinstall 9748480 8月 25 22:24 control02.ctl
[oracle@cent5-64b-40 orcl.bk]$
[oracle@cent5-64b-40 orcl.bk]$
[oracle@cent5-64b-40 orcl.bk]$
------------------------------------
8) restore!
--- before
[oracle@cent5-64b-40 oradata]$ cd orcl
[oracle@cent5-64b-40 orcl]$ ls -ltr
合計 3421336
-rw-r----- 1 oracle oinstall 71311360 8月 25 19:44 temp01.dbf
-rw-r----- 1 oracle oinstall 52429312 8月 25 22:18 redo03.log
-rw-r----- 1 oracle oinstall 52429312 8月 25 22:18 redo01.log
-rw-r----- 1 oracle oinstall 1555832832 8月 25 22:24 users01.dbf
-rw-r----- 1 oracle oinstall 387981312 8月 25 22:24 undotbs01.dbf
-rw-r----- 1 oracle oinstall 734011392 8月 25 22:24 system01.dbf
-rw-r----- 1 oracle oinstall 639639552 8月 25 22:24 sysaux01.dbf
-rw-r----- 1 oracle oinstall 52429312 8月 25 22:24 redo02.log
-rw-r----- 1 oracle oinstall 9748480 8月 25 22:24 control01.ctl
[oracle@cent5-64b-40 orcl]$
[oracle@cent5-64b-40 orcl]$
--- exec
[oracle@cent5-64b-40 oracle_bkup_depo]$ cp -pr *dbf *log control01.ctl /opt/oracle/app/oradata/orcl/
--- after
[oracle@cent5-64b-40 orcl]$ ls -ltr
合計 3421336
-rw-r----- 1 oracle oinstall 52429312 8月 25 09:26 redo03.log
-rw-r----- 1 oracle oinstall 52429312 8月 25 16:00 redo01.log
-rw-r----- 1 oracle oinstall 71311360 8月 25 19:44 temp01.dbf
-rw-r----- 1 oracle oinstall 1555832832 8月 25 21:54 users01.dbf
-rw-r----- 1 oracle oinstall 387981312 8月 25 21:54 undotbs01.dbf
-rw-r----- 1 oracle oinstall 734011392 8月 25 21:54 system01.dbf
-rw-r----- 1 oracle oinstall 639639552 8月 25 21:54 sysaux01.dbf
-rw-r----- 1 oracle oinstall 52429312 8月 25 21:54 redo02.log
-rw-r----- 1 oracle oinstall 9748480 8月 25 21:54 control01.ctl
[oracle@cent5-64b-40 orcl]$
-----before
[oracle@cent5-64b-40 orcl]$ cd /opt/oracle/app/flash_recovery_area/orcl
[oracle@cent5-64b-40 orcl]$ ls -ltr
合計 9540
-rw-r----- 1 oracle oinstall 9748480 8月 25 22:24 control02.ctl
[oracle@cent5-64b-40 orcl]$ pwd
/opt/oracle/app/flash_recovery_area/orcl
[oracle@cent5-64b-40 orcl]$
----exec
[oracle@cent5-64b-40 oracle_bkup_depo]$ cp -pr control02.ctl /opt/oracle/app/flash_recovery_area/orcl/
[oracle@cent5-64b-40 oracle_bkup_depo]$
---after
[oracle@cent5-64b-40 orcl]$ ls -ltr
合計 9540
-rw-r----- 1 oracle oinstall 9748480 8月 25 21:54 control02.ctl
[oracle@cent5-64b-40 orcl]$
9) re startup db !!!! -------------------------
SQL>
SQL> startup
ORACLEインスタンスが起動しました。
Total System Global Area 2505338880 bytes
Fixed Size 2215944 bytes
Variable Size 1677725688 bytes
Database Buffers 822083584 bytes
Redo Buffers 3313664 bytes
データベースがマウントされました。
データベースがオープンされました。
SQL>
10) check if it works!
SQL> select updatereason from zip where zipcode='2030013';
UPDATEREASON
------------
0
SQL>
hirasawa@ubuntu1204-20:~/oraclebkup$