免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
› 论坛 › IT运维 › 存储备份 › Netbackup环境，无catalog,控制文件，数据文件等全丢失 ...
最近访问板块 发新帖
查看: 33411 | 回复: 9
打印 上一主题 下一主题

[备份软件] Netbackup环境，无catalog,控制文件，数据文件等全丢失的恢复步骤 [复制链接]

天涯明月刀

招聘 : Linux运维
论坛徽章:
0
跳转到指定楼层
1楼 [收藏(0)] [报告]
发表于 2008-07-28 17:07 |只看该作者 |倒序浏览
模拟的场景：
硬盘损坏，所有的控制文件，数据文件，redo...全部丢失
无catalog
有rman 的全库备份和archive log的备份，备份在磁带上。

1.环境准备
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 删除所有数据文件，控制文件，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 开始恢复
将数据库启动到nomount状态，
（
如果需要的话也可以新安装一台机器，
配置好Netbackup的客户端
安装好oracle,并且创建一个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 恢复控制文件
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> }

（控制文件没有恢复之前,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错误只是提示，不需要关心)

///////
不要想用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);
是否转换文件恢复位置，用了默认值，就是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楼 [报告]
发表于 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

至此恢复完毕，不完全恢复。

dbid.JPG (61.21 KB, 下载次数: 486)

dbid.JPG

arch.JPG (85.03 KB, 下载次数: 500)

arch.JPG
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
天涯明月刀

招聘 : Linux运维
论坛徽章:
0
3楼 [报告]
发表于 2008-07-29 11:31 |只看该作者
貌似没人感兴趣
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
inhell

论坛徽章:
0
4楼 [报告]
发表于 2008-07-29 13:47 |只看该作者
恢复控制文件那段一点都看不懂！ 哎..
还是把控制文件好好备份一下比较好
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
天涯明月刀

招聘 : Linux运维
论坛徽章:
0
5楼 [报告]
发表于 2008-07-29 14:14 |只看该作者
原帖由 inhell 于 2008-7-29 13:47 发表
恢复控制文件那段一点都看不懂！ 哎..
还是把控制文件好好备份一下比较好


有个catalog更好，但是现实情况是，碰到的好多系统根本没有用catalog
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
秋风No.1

论坛徽章:
0
6楼 [报告]
发表于 2008-07-29 16:57 |只看该作者
原帖由 天涯明月刀 于 2008-7-29 14:15 发表



话是如此 ，

但我现在维护的系统全备是每天夜里完成
然后每小时都会备份一次归档

你们的系统够繁忙的啊，呵呵，一个小时就要删除归档啊
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
天涯明月刀

招聘 : Linux运维
论坛徽章:
0
7楼 [报告]
发表于 2008-07-29 18:12 |只看该作者
原帖由 秋风No.1 于 2008-7-29 16:57 发表

你们的系统够繁忙的啊，呵呵，一个小时就要删除归档啊



删归档不是关键，关键是备归档

试想：
只有一个磁盘阵列，数据库和归档都在上面放着
阵列完蛋了怎么办？
到时候什么都丢了，丢一天的归档 ....
备了份的话最多也就丢一个小时的归档
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
lotusin

论坛徽章:
0
8楼 [报告]
发表于 2008-08-11 14:21 |只看该作者
步骤很详细，很不错。
不过还有改进的空间，利用netbackup备份oracle的模板脚本，记得每个oracle的备份脚本最后强制要求备份控制文件。
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
betterarcher

论坛徽章:
0
9楼 [报告]
发表于 2011-04-09 23:11 |只看该作者
先收藏了
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
月黑高飞

论坛徽章:
0
10楼 [报告]
发表于 2011-04-13 22:11 |只看该作者
好东西，谢谢。
实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？
返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号：11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们：huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP