資料庫異機冷備恢復

tian1982tian發表於2012-09-11

具體為以下幾個步驟：
一：在新的機器安裝系統，建立oralce使用者及目錄和賦相應的許可權，配置目的機器的oracle安裝路徑跟原機器一致
二：關閉原資料庫，拷貝資料庫所有目錄下的檔案到另外一臺機器的對應目錄下
三：sqlplus /nolog startup啟動資料庫

###################OS Installing###################################
1:在linux5u2裡安裝虛擬機器，在虛擬機器裡安裝red hat 5u2 64bit作業系統
[oracle@test-vm-5u2-64 ~]$ cat /proc/cpuinfo | grep processor
processor : 0
processor : 1
[oracle@test-vm-5u2-64 ~]$ cat /proc/meminfo | awk -F: '/MemTotal/ {print $2/1024/1024}'
4.83774
[oracle@test-vm-5u2-64 ~]$ getconf LONG_BIT
64
[oracle@test-vm-5u2-64 ~]$
2:安裝完畢後掛5塊盤，及格式化，mount,在/etc/rc.local中寫入，具體步驟
如下：
建立目錄：
mkdir /oracle
mkdir /oraredo
mkdir /oraundo
mkdir /oradataa
mkdir /oradatab
格式化分割槽：
mkfs.ext3 /dev/sdb
mkfs.ext3 /dev/sdc
mkfs.ext3 /dev/sdd
mkfs.ext3 /dev/sde
mkfs.ext3 /dev/sdf
掛載裝置：
mount /dev/sdb /oracle
mount /dev/sdc /oraredo
mount /dev/sdd /oradataa
mount /dev/sde /oraundo
mount /dev/sdf /oradatab

[oracle@test-vm-5u2-64 ~]$ vi /etc/rc.local
#!/bin/sh
#
# This script. will be executed *after* all the other init scripts.
# You can put your own initialization stuff in here if you don't
# want to do the full Sys V style. init stuff.

touch /var/lock/subsys/local

mount /dev/sdb /oraredo
mount /dev/sdc /oraundo
mount /dev/sdd /oradataa
mount /dev/sde /oradatab
mount /dev/sdf /oracle

################OS Parameter Set######################################
echo 'set kernel parameter'

echo "#   settings for ora10g" >> /etc/sysctl.conf
echo "fs.file-max=327679" >> /etc/sysctl.conf
echo "kernel.msgmni=2878" >> /etc/sysctl.conf
echo "kernel.msgmax=8192" >> /etc/sysctl.conf
echo "kernel.msgmnb=65536" >> /etc/sysctl.conf
echo "kernel.sem=250 32000 100 142" >> /etc/sysctl.conf
echo "kernel.shmmni=4096" >> /etc/sysctl.conf
echo "kernel.shmall=3279547" >> /etc/sysctl.conf
echo "#   set to a value half the size of physical memory" >> /etc/sysctl.conf
echo "kernel.shmmax=2147483648" >> /etc/sysctl.conf
echo "kernel.sysrq=1" >> /etc/sysctl.conf
echo "#   rmem_max can be tuned based on workload to balance performance vs lowmem usage" >> /etc/sysctl.conf
echo "net.core.rmem_default=262144" >> /etc/sysctl.conf
echo "net.core.rmem_max=2097152" >> /etc/sysctl.conf
echo "net.core.wmem_default=262144" >> /etc/sysctl.conf
echo "net.core.wmem_max=262144" >> /etc/sysctl.conf
echo "fs.aio-max-nr=3145728" >> /etc/sysctl.conf
echo "vm.lower_zone_protection=100" >> /etc/sysctl.conf
echo "net.ipv4.ip_local_port_range=1024 65000" >> /etc/sysctl.conf
sysctl -p

echo "    # depending on size of db, these may need to be larger" >> /etc/security/limits.conf
echo "oracle soft    nofile 131072" >> /etc/security/limits.conf
echo "oracle hard    nofile 131072" >> /etc/security/limits.conf
echo "oracle soft    nproc   131072" >> /etc/security/limits.conf
echo "oracle hard    nproc   131072" >> /etc/security/limits.conf
echo "oracle soft    core    unlimited" >> /etc/security/limits.conf
echo "oracle hard    core    unlimited" >> /etc/security/limits.conf
echo "    # set to allow oracle to use hugepages" >> /etc/security/limits.conf
echo "oracle soft    memlock 50000000" >> /etc/security/limits.conf
echo "oracle hard    memlock 50000000" >> /etc/security/limits.conf

echo 'set kernel parameter success!'

echo 'all the env setting success!'

###################OS裁剪##########################################

chkconfig --level 3 acpid off
chkconfig --level 3 anacron off
chkconfig --level 3 apmd off
chkconfig --level 3 canna off
chkconfig --level 3 mdmonitor off
chkconfig --level 3 openibd off
chkconfig --level 3 xinetd off
chkconfig --level 3 sendmail off
chkconfig --level 3 rpcgssd off
chkconfig --level 3 cups off
chkconfig --level 3 rawdevices off
chkconfig --level 3 messagebus off
chkconfig --level 3 atd off
chkconfig --level 3 arptables_jf off
chkconfig --level 3 iiim off
chkconfig --level 3 gpm off
chkconfig --level 3 autofs off
chkconfig --level 3 cpuspeed off
chkconfig --level 3 haldaemon off
chkconfig --level 3 nfslock off
chkconfig --level 3 portmap off
chkconfig --level 3 cups-config-daemon off
chkconfig --level 3 lm_sensors off
chkconfig --level 3 rhnsd off
chkconfig --level 3 xfs off
chkconfig --level 3 netfs off
chkconfig --level 3 iptables off
chkconfig --level 3 smartd off
chkconfig --level 3 ip6tables off
chkconfig --level 3 isdn off
chkconfig --level 3 rpcidmapd off
chkconfig --level 3 microcode_ctloff
chkconfig --level 3 microcode_ctl off
chkconfig --level 3 pcmcia off
chkconfig --level 3 hpoj off
chkconfig --level 3 network on
chkconfig --level 3 syslog on
chkconfig --level 3 sshd on
chkconfig --level 3 netfs on
chkconfig --level 3 sysstat on
chkconfig --level 3 irqbalance on
chkconfig --level 3 kudzu on
chkconfig --level 3 messagebus on
chkconfig --level 3 ntpd on
chkconfig --level 3 crond on

###################CP oracle files#################################
cd /oracle
scp oracle@192.168.0.123:/oracle/* .
cd /oraredo
scp oracle@192.168.0.123:/oraredo/* .
cd /oraundo
scp oracle@192.168.0.123:/oraundo/* .
cd /oradataa
scp oracle@192.168.0.123:/oradataa/* .
cd /oradatab
scp oracle@192.168.0.123:/oradatab/* .

###################Create User ADD Privs Setting###################
echo 'create oracle user and group'

        groupadd dba
        groupadd oinstall
        useradd -g oinstall -G dba oracle
        echo 'please set oracle default password:'
        passwd oracle

echo 'create oracle directory '

        chown oracle.oinstall /oracle
        chown -R oracle.oinstall /oracle/ora10
        chmod 755 /oracle

echo 'setting directory owner'

chown -R oracle.oinstall /oracle
chown -R oracle.oinstall /oradataa
chown -R oracle.oinstall /oraredo
chown -R oracle.oinstall /oraundo
chown -R oracle.oinstall /oradatab

################Set OraEnv############################################
# oracle 10g
export ORACLE_BASE=/oracle/ora10
export ORACLE_HOME=/oracle/ora10/product
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_OWNER=oracle
export ORACLE_SID=ora10g

unset USERNAME
umask 022

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

#
# change this NLS settings to suit your country:
# example:
# german_germany.we8iso8859p15, american_america.we8iso8859p2 etc.
#export NLS_LANG='american_america.ZHS16GBK'
export NLS_LANG='american_america.AL32UTF8'

# User specific environment and startup programs

PATH=$PATH:/usr/sbin:/sbin
export PATH

[root@test-vm-5u2-64 ~]# su - oracle
[oracle@test-vm-5u2-64 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Sep 11 18:02:53 2012

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 1577058304 bytes
Fixed Size                  2084264 bytes
Variable Size             486539864 bytes
Database Buffers         1073741824 bytes
Redo Buffers               14692352 bytes
Database mounted.
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: '/oradatab/datab01.dbf'

SQL> recover datafile 5;
ORA-00283: recovery session canceled due to errors
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: '/oraredo/redo01b.red'
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: '/oraredo/redo01a.red'

檢視alert日誌
[oracle@test-vm-5u2-64 bdump]$ tail -f 100 alert_ora10g.log
tail: cannot open `100' for reading: No such file or directory
==> alert_ora10g.log <==
parallel recovery started with 2 processes
Tue Sep 11 18:03:26 2012
Errors in file /oracle/ora10/admin/ora10g/udump/ora10g_ora_22889.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: '/oraredo/redo01b.red'
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: '/oraredo/redo01a.red'
Tue Sep 11 18:03:27 2012
Media Recovery failed with error 322
ORA-283 signalled during: ALTER DATABASE RECOVER datafile 5 ...

SQL> desc v$logfile;
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
GROUP#                                             NUMBER
STATUS                                             VARCHAR2(7)
TYPE                                               VARCHAR2(7)
MEMBER                                             VARCHAR2(513)
IS_RECOVERY_DEST_FILE                              VARCHAR2(3)

SQL> col member format a45
SQL> select * from v$logfile;

    GROUP# STATUS TYPE    MEMBER                                        IS_
---------- ------- ------- --------------------------------------------- ---
         1         ONLINE /oraredo/redo01a.red                          NO
         2         ONLINE /oraredo/redo02a.red                          NO
         3         ONLINE /oraredo/redo03a.red                          NO
         1         ONLINE /oraredo/redo01b.red                          NO
         2         ONLINE /oraredo/redo02b.red                          NO
         3         ONLINE /oraredo/redo03b.red                          NO

6 rows selected.

SQL> set linesize 400
SQL> select * from v$log;

    GROUP#    THREAD# SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------
         1          1        251 209715200          2 NO CURRENT                3236486 29-AUG-12
         3          1        250 209715200          2 YES INACTIVE               3136454 16-JUL-12
         2          1        249 209715200          2 YES INACTIVE               3072395 29-JUN-11
SQL> recover database until time '2012-09-09 00:00:00';
ORA-00283: recovery session canceled due to errors
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: '/oraredo/redo01b.red'
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: '/oraredo/redo01a.red'

SQL> recover database until cancel;
ORA-00279: change 3272052 generated at 09/07/2011 17:21:53 needed for thread 1
ORA-00289: suggestion : /oracle/ora10/oradata/ora10g/archive/1_251_771101551.dbf
ORA-00280: change 3272052 for thread 1 is in sequence #251

Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log '/oracle/ora10/oradata/ora10g/archive/1_251_771101551.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

ORA-00308: cannot open archived log '/oracle/ora10/oradata/ora10g/archive/1_251_771101551.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/oracle/ora10/oradata/ora10g/system01.dbf'

檢視歸檔日誌，看看是否有1_251_771101551.dbf檔案
[oracle@test-vm-5u2-64 archive]$ ll
total 407176
-rwxr-xr-x 1 oracle oinstall 205882880 Sep 11 16:39 1_249_771101551.dbf
-rwxr-xr-x 1 oracle oinstall 209581568 Sep 11 16:39 1_250_771101551.dbf
-rwxr-xr-x 1 oracle oinstall 1056768 Sep 11 16:39 block.dbf
[oracle@test-vm-5u2-64 archive]$
我們可以看到沒有這個檔案，這個檔案明顯比已歸檔的檔案號大，據估計肯定在
redo重做日誌裡，所以在下面我們用重做日誌恢復

Specify log: {=suggested | filename | AUTO | CANCEL}
/oraredo/redo01a.red
--在這裡輸入重做日誌檔案，因為在上面我們已經查了redo01a.red是當前組檔案
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/oracle/ora10/oradata/ora10g/system01.dbf'

ORA-01112: media recovery not started

在這裡我們看到，已經恢復成功！
SQL> recover database until cancel;
Media recovery complete.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;

Database altered.

SQL> select * from v$log;

SQL> alter system switch logfile;

System altered.

SQL> select * from v$log;

SQL> alter system switch logfile;

System altered.

SQL> select * from v$log;

SQL>

[oracle@test-vm-5u2-64 archive]$ ll
total 524064
-rw-r----- 1 oracle oinstall    238080 Sep 11 18:26 1_1_793736516.dbf
-rwxr-xr-x 1 oracle oinstall 205882880 Sep 11 16:39 1_249_771101551.dbf
-rwxr-xr-x 1 oracle oinstall 209581568 Sep 11 16:39 1_250_771101551.dbf
-rw-r----- 1 oracle oinstall 119318528 Sep 11 18:21 1_251_771101551.dbf
-rw-r----- 1 oracle oinstall      1024 Sep 11 18:26 1_2_793736516.dbf
-rwxr-xr-x 1 oracle oinstall   1056768 Sep 11 16:39 block.dbf
[oracle@test-vm-5u2-64 archive]$
檢視重做日誌已經成功歸檔

至此，整個資料庫就已經成功啟動，下來開發人員就可以正常使用了

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/16400082/viewspace-743132/，如需轉載，請註明出處，否則將追究法律責任。

Oracle資料庫冷備份的異地恢復
2011-01-06
Oracle資料庫
Oracle資料庫的冷備份及冷備份異地恢復方法
2012-05-24
Oracle資料庫
oracle冷備份、恢復和異機恢復
2014-03-11
Oracle
Oracle資料庫冷備和恢復
2018-11-22
Oracle資料庫
資料庫備份與異機恢復——熱備份方式
2013-11-18
資料庫
RAC資料庫的RMAN備份異機恢復到單節點資料庫
2017-08-28
資料庫
oracle冷備恢復
2021-10-08
Oracle
用 RMAN 備份異機恢復遷移資料
2013-12-18
【備份恢復】從備份恢復資料庫
2015-01-20
資料庫
“借屍還魂”恢復Windows 9i冷備資料庫
2014-10-11
Windows資料庫
Oracle備份恢復之熱備份恢復及異機恢復
2018-02-05
Oracle
oracle 冷備及恢復
2014-06-03
Oracle
講解Oracle資料庫冷備份恢復的具體步驟
2014-11-13
Oracle資料庫
Oracle異地資料庫恢復
2016-11-07
Oracle資料庫
使用冷備份與冷備份後的資料庫歸檔日誌檔案進行資料庫不完整恢復
2011-05-16
資料庫
oracle 9I 資料庫異機恢復( Catalog 庫 )
2008-02-14
Oracle資料庫
ORACLE中採用rman備份異機恢復資料庫詳細過程
2015-02-03
Oracle資料庫
備份與恢復：polardb資料庫備份與恢復
2020-11-13
資料庫
standby全庫rman備份檔案恢復到異機
2012-08-04
【備份恢復】noarchive模式下使用增量備份恢復資料庫
2016-10-17
Hive模式資料庫
資料庫資料的恢復和備份
2015-08-30
資料庫
ClickHouse資料庫單機安裝及備份恢復
2022-11-24
資料庫
同平臺異機備份恢復
2014-09-26
資料庫異機恢復開啟報錯ORA-36961
2012-08-19
資料庫
達夢資料庫備份恢復
2020-01-13
資料庫
postgresql備份與恢復資料庫
2020-12-15
SQL資料庫
mongo資料庫備份與恢復
2017-04-01
Go資料庫
資料庫的備份與恢復
2010-08-25
資料庫
Informix資料庫備份與恢復
2006-05-15
ORM資料庫
備份和恢復postgreSQL資料庫
2013-05-03
SQL資料庫
Oracle資料庫備份與恢復之匯出／匯入（EXP/IMP）、熱備份和冷備份
2014-02-08
Oracle資料庫
Oracle冷備份級冷備份的不完全恢復
2010-12-20
Oracle
【備份恢復】RMAN catalog 恢復目錄資料庫
2016-10-16
資料庫
rman資料庫全庫備份與恢復
2013-12-19
資料庫
RMAN備份異機恢復流程總結
2011-12-19
【資料庫資料恢復】SAP資料庫資料恢復案例
2022-05-05
資料庫資料恢復
PostgreSql資料庫的備份和恢復
2021-04-17
SQL資料庫
Mongo 資料庫備份和恢復命令
2023-12-24
Go資料庫

資料庫異機冷備恢復

相關文章