亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

  免費注冊 查看新帖 |

Chinaunix

  平臺 論壇 博客 文庫
最近訪問板塊 發(fā)新帖
查看: 33793 | 回復(fù): 9
打印 上一主題 下一主題

[備份軟件] Netbackup環(huán)境,無catalog,控制文件,數(shù)據(jù)文件等全丟失的恢復(fù)步驟 [復(fù)制鏈接]

招聘 : Linux運維
論壇徽章:
0
跳轉(zhuǎn)到指定樓層
1 [收藏(0)] [報告]
發(fā)表于 2008-07-28 17:07 |只看該作者 |倒序瀏覽
模擬的場景:
硬盤損壞,所有的控制文件,數(shù)據(jù)文件,redo...全部丟失
無catalog
有rman 的全庫備份和archive log的備份,備份在磁帶上。

1.環(huán)境準備
Netbackup client : node2
Netbackup Server : nub-server
Netbackup version : 6.0 + oracle Agent
Oracle RDBMS version : 10.2.0.2


1.1 做備份
(Netbackup的配置這里不多描述,請參考其它文檔)
[oracle@node2 ~]$ $ORACLE_HOME/bin/rman target /
Recovery Manager: Release 10.2.0.2.0 - Production on Wed Jul 23 14:54:35 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: STREAM2 (DBID=1117116731)
先刪除所有的備份
RMAN> allocate channel for maintenance type 'SBT_TAPE';
released channel: ORA_DISK_1
allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: sid=91 devtype=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_1: VERITAS NetBackup for Oracle - Release 6.0 (2006110304)
RMAN> delete backup;
List of Backup Pieces
BP Key BS Key Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
5       5       1   1   AVAILABLE   SBT_TAPE    STREAM2_tablespace_20080715_8.bak
6       6       1   1   AVAILABLE   SBT_TAPE    STREAM2_tablespace_20080715_9.bak
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=STREAM2_tablespace_20080715_8.bak recid=5 stamp=660161646
deleted backup piece
backup piece handle=STREAM2_tablespace_20080715_9.bak recid=6 stamp=660161825
Deleted 2 objects
RMAN> list backup;
RMAN>
做全庫備份,并include current controlfile;
RMAN> run {     
2> allocate channel t1 type 'sbt_tape';
3> send 'NB_ORA_CLIENT=node2,NB_ORA_SERV=nub-server';
4> backup incremental level 0
5> filesperset 15
6> database format 'dbfull_%I_%t_%s_%p' diskratio=0 include current controlfile;
7> release channel t1;
8> }

allocated channel: t1
channel t1: sid=100 devtype=SBT_TAPE
channel t1: VERITAS NetBackup for Oracle - Release 6.0 (2006110304)
sent command to channel: t1
Starting backup at 23-JUL-08
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/oradata/stream2/system01.dbf
input datafile fno=00003 name=/u01/oradata/stream2/sysaux01.dbf
input datafile fno=00005 name=/u01/oradata/stream2/example01.dbf
input datafile fno=00002 name=/u01/oradata/stream2/undotbs01.dbf
input datafile fno=00006 name=/u01/oradata/stream2/streams_tbs.dbf
input datafile fno=00004 name=/u01/oradata/stream2/users01.dbf
channel t1: starting piece 1 at 23-JUL-08
channel t1: finished piece 1 at 23-JUL-08
piece handle=dbfull_1117116731_660844580_14_1 tag=TAG20080723T155620 comment=API Version 2.0,MMS Version 5.0.0.0
channel t1: backup set complete, elapsed time: 00:03:10
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel t1: starting piece 1 at 23-JUL-08
channel t1: finished piece 1 at 23-JUL-08
piece handle=dbfull_1117116731_660844771_15_1 tag=TAG20080723T155620 comment=API Version 2.0,MMS Version 5.0.0.0
channel t1: backup set complete, elapsed time: 00:02:04
Finished backup at 23-JUL-08
released channel: t1
備份歸檔:
RMAN> run{
2> allocate channel t1 type 'sbt_tape';
3> send 'NB_ORA_CLIENT=node2,NB_ORA_SERV=nub-server';
4> sql 'alter system archive log current';
5> backup format 'arch_%I_%t_%s_%p' diskratio=0 archivelog all delete input;
6> release channel t1;
7> }

using target database control file instead of recovery catalog
allocated channel: t1
channel t1: sid=91 devtype=SBT_TAPE
channel t1: VERITAS NetBackup for Oracle - Release 6.0 (2006110304)
sent command to channel: t1
sql statement: alter system archive log current
Starting backup at 23-JUL-08
current log archived
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 07/23/2008 16:05:55
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/oradata/stream2_arch/1_7_657198652.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

上面這個問題的原因是:
手動刪除過歸檔日志,但是信息還保存在controlfile中,需要crosscheck這些信息。
RMAN> crosscheck archivelog all;
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=91 devtype=DISK
validation failed for archived log
archive log filename=/u01/oradata/stream2_arch/1_7_657198652.dbf recid=1 stamp=657214492
validation failed for archived log
archive log filename=/u01/oradata/stream2_arch/1_8_657198652.dbf recid=2 stamp=660148746
validation failed for archived log
archive log filename=/u01/oradata/stream2_arch/1_9_657198652.dbf recid=3 stamp=660828063
validation failed for archived log
archive log filename=/u01/oradata/stream2_arch/1_10_657198652.dbf recid=4 stamp=660840663
validation succeeded for archived log
archive log filename=/u01/oradata/stream2_arch/1_11_657198652.dbf recid=5 stamp=660845154
validation succeeded for archived log
archive log filename=/u01/oradata/stream2_arch/1_12_657198652.dbf recid=6 stamp=660845155
Crosschecked 6 objects

RMAN> list archivelog all;

List of Archived Log Copies
Key     Thrd Seq     S Low Time Name
------- ---- ------- - --------- ----
1       1    7       X 12-JUN-08 /u01/oradata/stream2_arch/1_7_657198652.dbf
2       1    8       X 12-JUN-08 /u01/oradata/stream2_arch/1_8_657198652.dbf
3       1    9       X 15-JUL-08 /u01/oradata/stream2_arch/1_9_657198652.dbf
4       1    10      X 23-JUL-08 /u01/oradata/stream2_arch/1_10_657198652.dbf
5       1    11      A 23-JUL-08 /u01/oradata/stream2_arch/1_11_657198652.dbf
6       1    12      A 23-JUL-08 /u01/oradata/stream2_arch/1_12_657198652.dbf
RMAN> run{
2> allocate channel t1 type 'sbt_tape';
3> send 'NB_ORA_CLIENT=node2,NB_ORA_SERV=nub-server';
4> sql 'alter system archive log current';
5> backup format 'arch_%I_%t_%s_%p' diskratio=0 archivelog all delete input;
6> release channel t1;
7> }

released channel: ORA_DISK_1
allocated channel: t1
channel t1: sid=91 devtype=SBT_TAPE
channel t1: VERITAS NetBackup for Oracle - Release 6.0 (2006110304)
sent command to channel: t1
sql statement: alter system archive log current
Starting backup at 23-JUL-08
current log archived
channel t1: starting archive log backupset
channel t1: specifying archive log(s) in backup set
input archive log thread=1 sequence=11 recid=5 stamp=660845154
input archive log thread=1 sequence=12 recid=6 stamp=660845155
input archive log thread=1 sequence=13 recid=7 stamp=660845283
input archive log thread=1 sequence=14 recid=8 stamp=660845286
channel t1: starting piece 1 at 23-JUL-08
channel t1: finished piece 1 at 23-JUL-08
piece handle=arch_1117116731_660845286_16_1 tag=TAG20080723T160806 comment=API Version 2.0,MMS Version 5.0.0.0
channel t1: backup set complete, elapsed time: 00:01:52
channel t1: deleting archive log(s)
archive log filename=/u01/oradata/stream2_arch/1_11_657198652.dbf recid=5 stamp=660845154
archive log filename=/u01/oradata/stream2_arch/1_12_657198652.dbf recid=6 stamp=660845155
archive log filename=/u01/oradata/stream2_arch/1_13_657198652.dbf recid=7 stamp=660845283
archive log filename=/u01/oradata/stream2_arch/1_14_657198652.dbf recid=8 stamp=660845286
Finished backup at 23-JUL-08
released channel: t1
RMAN>

查看一下所有的備份
RMAN> list backup;

List of Backup Sets
===================
BS Key Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Incr 0 643.50M    SBT_TAPE    00:03:09     23-JUL-08      
        BP Key: 7   Status: AVAILABLE Compressed: NO Tag: TAG20080723T155620
        Handle: dbfull_1117116731_660844580_14_1   Media:
List of Datafiles in backup set 7
File LV Type Ckp SCN    Ckp Time Name
---- -- ---- ---------- --------- ----
1    0 Incr 578944     23-JUL-08 /u01/oradata/stream2/system01.dbf
2    0 Incr 578944     23-JUL-08 /u01/oradata/stream2/undotbs01.dbf
3    0 Incr 578944     23-JUL-08 /u01/oradata/stream2/sysaux01.dbf
4    0 Incr 578944     23-JUL-08 /u01/oradata/stream2/users01.dbf
5    0 Incr 578944     23-JUL-08 /u01/oradata/stream2/example01.dbf
6    0 Incr 578944     23-JUL-08 /u01/oradata/stream2/streams_tbs.dbf
BS Key Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Incr 0 7.00M      SBT_TAPE    00:02:00     23-JUL-08      
        BP Key: 8   Status: AVAILABLE Compressed: NO Tag: TAG20080723T155620
        Handle: dbfull_1117116731_660844771_15_1   Media:
Control File Included: Ckp SCN: 578982       Ckp time: 23-JUL-08
SPFILE Included: Modification time: 23-JUL-08
BS Key Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9       5.75M      SBT_TAPE    00:01:48     23-JUL-08      
        BP Key: 9   Status: AVAILABLE Compressed: NO Tag: TAG20080723T160806
        Handle: arch_1117116731_660845286_16_1   Media:
List of Archived Logs in backup set 9
Thrd Seq     Low SCN    Low Time Next SCN   Next Time
---- ------- ---------- --------- ---------- ---------
1    11      576844     23-JUL-08 579972     23-JUL-08
1    12      579972     23-JUL-08 579978     23-JUL-08
1    13      579978     23-JUL-08 580115     23-JUL-08
1    14      580115     23-JUL-08 580121     23-JUL-08

1.2 刪除所有數(shù)據(jù)文件,控制文件,redo
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
[oracle@node2 stream2]$ ls
control01.ctl control03.ctl redo01.log redo03.log       sysaux01.dbf temp01.dbf     users01.dbf
control02.ctl example01.dbf redo02.log streams_tbs.dbf system01.dbf undotbs01.dbf
[oracle@node2 stream2]$ rm ./*
[oracle@node2 stream2]$ pwd

/u01/oradata/stream2
[oracle@node2 stream2]$ cd ../stream2_arch
[oracle@node2 stream2_arch]$ ls -l

total 0


2 開始恢復(fù)
將數(shù)據(jù)庫啟動到nomount狀態(tài),

如果需要的話也可以新安裝一臺機器,
配置好Netbackup的客戶端
安裝好oracle,并且創(chuàng)建一個instance


2.1 先要獲取dbid:
好多種方式,我的備份集使用了%I,所以備份的名稱中有dbid




[oracle@node2 ~]$ $ORACLE_HOME/bin/rman target /
Recovery Manager: Release 10.2.0.2.0 - Production on Wed Jul 23 17:23:16 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: stream2 (not mounted)
RMAN> set dbid=1117116731
executing command: SET DBID
2.2 從Netbackup 恢復(fù)控制文件
RMAN> run {
2> allocate channel t1 type 'sbt_tape';
3> send 'NB_ORA_CLIENT=node2,NB_ORA_SERV=nub-server';
4> restore controlfile from 'dbfull_1117116731_660844771_15_1';
5> release channel t1;
6> }


(控制文件沒有恢復(fù)之前,rman肯定查不到備份信息,可以通過在netbackup中可以找到近期的備份,然后通過job的detail看到備份的file list,看上面那張圖)

using target database control file instead of recovery catalog
allocated channel: t1
channel t1: sid=101 devtype=SBT_TAPE
channel t1: VERITAS NetBackup for Oracle - Release 6.0 (2006110304)
sent command to channel: t1
Starting restore at 23-JUL-08
channel t1: restoring control file
channel t1: restore complete, elapsed time: 00:01:58
output filename=/u01/oradata/stream2/control01.ctl
output filename=/u01/oradata/stream2/control02.ctl
output filename=/u01/oradata/stream2/control03.ctl
Finished restore at 23-JUL-08
released channel: t1

RMAN> sql 'alter database mount';
sql statement: alter database mount
RMAN> list backup;

List of Backup Sets
===================
BS Key Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Incr 0 643.50M    SBT_TAPE    00:03:09     23-JUL-08      
        BP Key: 7   Status: AVAILABLE Compressed: NO Tag: TAG20080723T155620
        Handle: dbfull_1117116731_660844580_14_1   Media:
List of Datafiles in backup set 7
File LV Type Ckp SCN    Ckp Time Name
---- -- ---- ---------- --------- ----
1    0 Incr 578944     23-JUL-08 /u01/oradata/stream2/system01.dbf
2    0 Incr 578944     23-JUL-08 /u01/oradata/stream2/undotbs01.dbf
3    0 Incr 578944     23-JUL-08 /u01/oradata/stream2/sysaux01.dbf
4    0 Incr 578944     23-JUL-08 /u01/oradata/stream2/users01.dbf
5    0 Incr 578944     23-JUL-08 /u01/oradata/stream2/example01.dbf
6    0 Incr 578944     23-JUL-08 /u01/oradata/stream2/streams_tbs.dbf

很明顯,里邊沒有archive log 的備份信息,因為備份控制文件的時候還沒有做archive log備份。
所以,想通過rman restore archivelog就不可能了。

RMAN> run {
2> allocate channel t1 type 'sbt_tape';
3> send 'NB_ORA_CLIENT=node2,NB_ORA_SERV=nub-server';
4> restore archivelog all;
5> release channel t1;
6> }


allocated channel: t1
channel t1: sid=101 devtype=SBT_TAPE
channel t1: VERITAS NetBackup for Oracle - Release 6.0 (2006110304)
sent command to channel: t1
Starting restore at 23-JUL-08
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/23/2008 17:29:46
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of log thread 1 seq 10 lowscn 556389 found to restore
RMAN-06025: no backup of log thread 1 seq 9 lowscn 531476 found to restore
RMAN-06025: no backup of log thread 1 seq 8 lowscn 496237 found to restore
RMAN-06025: no backup of log thread 1 seq 7 lowscn 495496 found to restore
很明顯,根本就不知道還有seq 11,12,13,14 這幾個archivelog(RMAN-06025錯誤只是提示,不需要關(guān)心)

///////
不要想用restore archivelog all from 'xxx',會抱錯:
RMAN> run {
2> allocate channel t1 type 'sbt_tape';
3> send 'NB_ORA_CLIENT=node2,NB_ORA_SERV=nub-server';
4> restore archivelog all from 'arch_1117116731_660845286_16_1';
5> release channel t1;
6> }

using target database control file instead of recovery catalog
allocated channel: t1
channel t1: sid=82 devtype=SBT_TAPE
channel t1: VERITAS NetBackup for Oracle - Release 6.0 (2006110304)

sent command to channel: t1
Starting restore at 24-JUL-08
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/24/2008 17:14:00
RMAN-06509: only SPFILE or control file can be restored from autobackup
////////////


沒辦法,使用dbms_backup_restore
[oracle@node2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.2.0 - Production on Thu Jul 24 16:06:06 2008
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select open_mode from v$database;
OPEN_MODE
----------
MOUNTED

SQL> DECLARE
2 devtype varchar2(256);
3 done boolean;
4 BEGIN
5 devtype:=sys.dbms_backup_restore.deviceAllocate(type=>'sbt_tape',ident=>'T1',params=>'ENV=(NB_ORA_CLIENT=node2,NB_ORA_SERV=nub-server)');
6 sys.dbms_backup_restore.restoreSetArchivedLog;
7 sys.dbms_backup_restore.restoreArchivedLogRange;
8 sys.dbms_backup_restore.restoreBackupPiece(done=>done,handle=>'arch_1117116731_660845286_16_1');
9 sys.dbms_backup_restore.deviceDeallocate;
10 END;
11 /

PL/SQL procedure successfully completed.

handle可通過下圖獲取



//////
具體,dbms_backup_restore的語法可以參考 $ORACLE_HOME/rdbms/admin/dbmsbkrs.sql 里的注釋
--*********************************************
-- Restore Conversation Initiation Procedures--
--********************************************--  部分
。

5 devtype:=sys.dbms_backup_restore.deviceAllocate(type=>'sbt_tape',ident=>'T1',params=>'ENV=(NB_ORA_CLIENT=node2,NB_ORA_SERV=nub-server)');
說明:類似rman的分配通道


6 sys.dbms_backup_restore.restoreSetArchivedLog;
PROCEDURE restoreSetArchivedLog(destination IN varchar2 default NULL);
是否轉(zhuǎn)換文件恢復(fù)位置,用了默認值,就是no。


7 sys.dbms_backup_restore.restoreArchivedLogRange;
PROCEDURE restoreArchivedLogRange(
                              low_change   IN number default 0
                             ,high_change  IN number default 281474976710655 );
這里都用了默認值,0-281474976710655。


8 sys.dbms_backup_restore.restoreBackupPiece(done=>done,handle=>'arch_1117116731_660845286_16_1');
PROCEDURE restoreBackupPiece( handle   IN   varchar2
                               ,done     OUT  boolean
                               ,params   IN   varchar2  default NULL
                               ,fromdisk IN   boolean   default FALSE );
handle就是備份集名稱。


9 sys.dbms_backup_restore.deviceDeallocate;
釋放通道


//////




[ 本帖最后由 天涯明月刀 于 2008-7-28 17:29 編輯 ]

招聘 : Linux運維
論壇徽章:
0
2 [報告]
發(fā)表于 2008-07-28 17:09 |只看該作者
SQL>
[oracle@node2 admin]$ cd /u01/oradata/stream2_arch
[oracle@node2 stream2_arch]$ ls -l

total 5860
-rw-r----- 1 oracle oinstall 5881344 Jul 24 16:06 1_11_657198652.dbf
-rw-r----- 1 oracle oinstall    1024 Jul 24 16:06 1_12_657198652.dbf
-rw-r----- 1 oracle oinstall   94208 Jul 24 16:06 1_13_657198652.dbf
-rw-r----- 1 oracle oinstall    1536 Jul 24 16:06 1_14_657198652.dbf


recover database
SQL> recover database using backup controlfile;
ORA-00279: change 578944 generated at 07/23/2008 15:56:20 needed for thread 1
ORA-00289: suggestion : /u01/oradata/stream2_arch/1_11_657198652.dbf
ORA-00280: change 578944 for thread 1 is in sequence #11


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

...... ...... 省略了一些

ORA-00279: change 580115 generated at 07/23/2008 16:08:02 needed for thread 1
ORA-00289: suggestion : /u01/oradata/stream2_arch/1_14_657198652.dbf
ORA-00280: change 580115 for thread 1 is in sequence #14
ORA-00278: log file '/u01/oradata/stream2_arch/1_13_657198652.dbf' no longer
needed for this recovery


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00279: change 580121 generated at 07/23/2008 16:08:06 needed for thread 1
ORA-00289: suggestion : /u01/oradata/stream2_arch/1_15_657198652.dbf
ORA-00280: change 580121 for thread 1 is in sequence #15
ORA-00278: log file '/u01/oradata/stream2_arch/1_14_657198652.dbf' no longer
needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
'/u01/oradata/stream2_arch/1_15_657198652.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> recover database using backup controlfile;
ORA-00279: change 580121 generated at 07/23/2008 16:08:06 needed for thread 1
ORA-00289: suggestion : /u01/oradata/stream2_arch/1_15_657198652.dbf
ORA-00280: change 580121 for thread 1 is in sequence #15

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/oradata/stream2/system01.dbf'
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 580121 generated at 07/23/2008 16:08:06 needed for thread 1
ORA-00289: suggestion : /u01/oradata/stream2_arch/1_15_657198652.dbf
ORA-00280: change 580121 for thread 1 is in sequence #15

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.
SQL> select open_mode from v$database;
OPEN_MODE
----------
READ WRITE

至此恢復(fù)完畢,不完全恢復(fù)。

dbid.JPG (61.21 KB, 下載次數(shù): 501)

dbid.JPG

arch.JPG (85.03 KB, 下載次數(shù): 514)

arch.JPG

招聘 : Linux運維
論壇徽章:
0
3 [報告]
發(fā)表于 2008-07-29 11:31 |只看該作者
貌似沒人感興趣

論壇徽章:
0
4 [報告]
發(fā)表于 2008-07-29 13:47 |只看該作者
恢復(fù)控制文件那段一點都看不懂! 哎..
還是把控制文件好好備份一下比較好

招聘 : Linux運維
論壇徽章:
0
5 [報告]
發(fā)表于 2008-07-29 14:14 |只看該作者
原帖由 inhell 于 2008-7-29 13:47 發(fā)表
恢復(fù)控制文件那段一點都看不懂! 哎..
還是把控制文件好好備份一下比較好


有個catalog更好,但是現(xiàn)實情況是,碰到的好多系統(tǒng)根本沒有用catalog

論壇徽章:
0
6 [報告]
發(fā)表于 2008-07-29 16:57 |只看該作者
原帖由 天涯明月刀 于 2008-7-29 14:15 發(fā)表



話是如此 ,

但我現(xiàn)在維護的系統(tǒng)全備是每天夜里完成
然后每小時都會備份一次歸檔

你們的系統(tǒng)夠繁忙的啊,呵呵,一個小時就要刪除歸檔啊

招聘 : Linux運維
論壇徽章:
0
7 [報告]
發(fā)表于 2008-07-29 18:12 |只看該作者
原帖由 秋風No.1 于 2008-7-29 16:57 發(fā)表

你們的系統(tǒng)夠繁忙的啊,呵呵,一個小時就要刪除歸檔啊



刪歸檔不是關(guān)鍵,關(guān)鍵是備歸檔

試想:
只有一個磁盤陣列,數(shù)據(jù)庫和歸檔都在上面放著
陣列完蛋了怎么辦?
到時候什么都丟了,丟一天的歸檔 ....
備了份的話最多也就丟一個小時的歸檔

論壇徽章:
0
8 [報告]
發(fā)表于 2008-08-11 14:21 |只看該作者
步驟很詳細,很不錯。
不過還有改進的空間,利用netbackup備份oracle的模板腳本,記得每個oracle的備份腳本最后強制要求備份控制文件。

論壇徽章:
0
9 [報告]
發(fā)表于 2011-04-09 23:11 |只看該作者
先收藏了

論壇徽章:
0
10 [報告]
發(fā)表于 2011-04-13 22:11 |只看該作者
好東西,謝謝。
您需要登錄后才可以回帖 登錄 | 注冊

本版積分規(guī)則 發(fā)表回復(fù)

  

北京盛拓優(yōu)訊信息技術(shù)有限公司. 版權(quán)所有 京ICP備16024965號-6 北京市公安局海淀分局網(wǎng)監(jiān)中心備案編號:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年舉報專區(qū)
中國互聯(lián)網(wǎng)協(xié)會會員  聯(lián)系我們:huangweiwei@itpub.net
感謝所有關(guān)心和支持過ChinaUnix的朋友們 轉(zhuǎn)載本站內(nèi)容請注明原作者名及出處

清除 Cookies - ChinaUnix - Archiver - WAP - TOP