oracle 0级备份如下代码 是否有错误。

以下备份信息是别人帮做的,自己查看发现0级备份 里有两行最后文件命名为" L1"了,是否应该为"L0"
#!/bin/ksh
echo "start /home/oraprd/backupshell/lv0.sh"; date
#env
export ORACLE_HOME=/oracle/PRD/102_64
ORACLE_SID=PRD
export ORACLE_SID
#backup
$ORACLE_HOME/bin/rman<<EOF
connect target
backup incremental level 0 database tag 'dbL0' format '/backupsys/prd_oracle_bak/PRDbkup_%d_%T_%U_L0' filesperset 4;
sql 'alter system archive log current';
backup archivelog all delete input format '/backupsys/prd_oracle_bak/archivelog_%d_%T_%U';
backup current controlfile tag 'ctr' format '/backupsys/prd_oracle_bak/control_%d_%T_%U_L1';此处最后的L1是否要改成L0
backup spfile tag 'spfile' format '/backu/prd_oracle_bak/spfile_%d_%T_%U_L1';
crosscheck archivelog all;
delete noprompt expired archivelog all;
crosscheck backup;
delete noprompt obsolete;
exit;
EOF
echo "end"; date
[sapdb:root:/home/oraprd/backupshell]

0

1个回答

0
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
Script:0级备份和1级备份
printing stored script: backup_lv0 { backup incremental level 0 device type disk tag 'level_0' format '/backup_01/prod/backupset/lv0_%U' database include current controlfile; allocate channel c1 type
0级备份和全备
Full bakcup_ @6fd X.M(oisa backup of a datafile that includes every allocated block in the file being backed up. A full backup of a datafile can be an image copy, in which case every data bloc...
ORACLE全备份和0级增量备份的区别
比较官方的说法FullA backup of a datafile that includes every allocated block in the file being backed up. A full backup of a datafile can be an image copy, in which case every data block is backed up. It c
定制正确的oracle备份策略 0级备份
oracle备份策略的定制关系到oracle数据库的运行,正确的oracle备份策略不仅能保证数据库服务器的24*7的高性能的运行,还能保证备份与恢复的快速性与可靠性。 采用多级备份就是为了减少每天备份所需要的时间,而又保证系统有良好的恢复性。恢复时间与备份时间要有一个权衡。比如只要进行一个数据库的全备份,然后就只备份归档也可以保证能把数据库恢复到最新的状态,但是这样的恢复时间将是不可容忍的
请问如下代码有和错误?
void __fastcall TfrmMain::btnOpenClick(TObject *Sender)rnrn if(OpenDialog->Execute())rn PlayList->Items->Clear();rn PlayList->Items->BeginUpdate();rn for(int i=0; iFiles->Count; i++)rn PlayList->Items->Add(ExtractFileName(OpenDialog->Files[i].Text));rn rn PlayList->Items->EndUpdate();rn EnableAll();rn rn
rman全备份和0级备份的区别
向各位大师请教rnrman全备份和0级备份的区别在哪呢,我看备份出的文件都一样呀,占用的大小也差不多。rn只用0级备份可以异机还原吗?rn
关于Infomix的0级备份(十万火急!!!)
我第一次作Infomix备份,老板让我一天内搞定,迫于无奈只好求救各位高手了:rnrn请告诉我命令行下0级备份的完整命令?谢谢了!!!
如下简单代码有何错误?
case WM_LBUTTONDOWN:rn rn TCHAR buffer[256];rn int i;rn i = swprintf(buffer, "%u", message);rn buffer[i] = 0;rn MessageBox(hwnd, buffer, NULL, MB_OK);rn return 0;rn rnrn消息框中出现的是乱码
oracle导入备份错误
IMP-00017: following statement failed with ORACLE error 20001: &quot;DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :=&quot; &quot; NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVAL...
关于rman 0级备份的一个问题。
rman备份脚本是系统任务计划里自动调用执行的。所以,有可能上次备份没完成,这次就开始了。rn如果现在正在运行着一个0级备份,这时又有一个0级备份启动了。 那么会不会在第一个0级备份备份完一个备份片的时候rnchannel t1: starting piece 1 at 20-DEC-14rnchannel t1: finished piece 1 at 22-DEC-14rnpiece handle=bak02_full_20141220_26138_1 tag=TAG20141220T220007 comment=API Version 2.0,MMS Version 5.4.1.0rn 第二个备份开始利用这个通道备份呢。。我现在这有这样一个 备份脚本运行的日志。求大神帮忙看一下。rnrn[code=text]rnrn# more backup0.logrnrnRecovery Manager: Release 11.2.0.3.0 - Production on Sat Dec 20 22:00:00 2014rnrnCopyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.rnrnconnected to target database: ZBSB (DBID=4133029982)rnrnRMAN> run rn2> allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';rn3> backup incremental level 0 rn4> format 'bak02_full_%T_%s_%p' diskratio=0 database include current controlfile;rn5> release channel t1;rn6> rn7> rnusing target database control file instead of recovery catalogrnallocated channel: t1rnchannel t1: SID=1002 device type=SBT_TAPErnchannel t1: Data Protection for Oracle: version 5.4.1.0rnrnStarting backup at 20-DEC-14rnchannel t1: starting incremental level 0 datafile backup setrnchannel t1: specifying datafile(s) in backup setrninput datafile file number=00168 name=/zbsb/zbsb/tsi_md3_1.datrninput datafile file number=00042 name=/zbsb/zbsb/tsi_md3_7.datrninput datafile file number=00071 name=/zbsb/zbsb/ts_be3_8.datrninput datafile file number=00153 name=/zbsb/zbsb/ts_ad3_1.datrninput datafile file number=00221 name=/zbsb/zbsb/tsi_si3_2.datrninput datafile file number=00226 name=/zbsb/zbsb/tsi_si3_3.datrninput datafile file number=00235 name=/zbsb/zbsb/tsi_md3_2.datrninput datafile file number=00240 name=/zbsb/zbsb/ts_si3_10.datrninput datafile file number=00245 name=/zbsb/zbsb/ts_md3_4.datrninput datafile file number=00250 name=/zbsb/zbsb/ts_md3_5.datrninput datafile file number=00255 name=/zbsb/zbsb/tsi_si3_9.datrninput datafile file number=00319 name=/zbsb/zbsb/tsi_si3_10.datrninput datafile file number=00336 name=/zbsb/zbsb/tsi_md3_5.datrninput datafile file number=00345 name=/zbsb/zbsb/ts_si3_15.datrninput datafile file number=00036 name=/zbsb/zbsb/ts_sjs_02.dbfrninput datafile file number=00004 name=/zbsb/zbsb/users01.dbfrninput datafile file number=00323 name=/zbsb/zbsb/ts_si0001_2.datrninput datafile file number=00003 name=/zbsb/zbsb/undo03.dbfrninput datafile file number=00169 name=/zbsb/zbsb/ts_mh3_1.datrninput datafile file number=00208 name=/zbsb/zbsb/TS_MA3_01.dbfrninput datafile file number=00049 name=/zbsb/zbsb/tsi_be3_3.datrninput datafile file number=00298 name=/zbsb/zbsb/ts_lm3_5.datrninput datafile file number=00064 name=/zbsb/zbsb/tsi_md3_8.datrninput datafile file number=00258 name=/zbsb/zbsb/tsi_mh3_2.datrninput datafile file number=00265 name=/zbsb/zbsb/ts_lm3_a5.datrninput datafile file number=00175 name=/zbsb/zbsb/TS_ISBM_1.DATrninput datafile file number=00074 name=/zbsb/zbsb/ts_his_1.datrninput datafile file number=00200 name=/zbsb/zbsb/ts_sc_2rninput datafile file number=00007 name=/zbsb/zbsb/tsi_si_3.datrninput datafile file number=00012 name=/zbsb/zbsb/tsi_si_8.datrninput datafile file number=00017 name=/zbsb/zbsb/tsi_si_13.datrninput datafile file number=00022 name=/zbsb/zbsb/ts_si_2.datrninput datafile file number=00027 name=/zbsb/zbsb/ts_si_7.datrninput datafile file number=00032 name=/zbsb/zbsb/ts_si_12.datrninput datafile file number=00116 name=/zbsb/zbsb/ts_zw_1.datrninput datafile file number=00122 name=/zbsb/zbsb/ts_mvlog4.datrninput datafile file number=00127 name=/zbsb/zbsb/ts_mvlog9.datrninput datafile file number=00136 name=/zbsb/zbsb/tsi_IC_1.dbfrninput datafile file number=00300 name=/zbsb/zbsb/tsi_lm3_2.datrninput datafile file number=00198 name=/zbsb/zbsb/LR_PUBLIC_TS_1.datrninput datafile file number=00190 name=/zbsb/zbsb/ts_scmis_1.datrninput datafile file number=00176 name=/zbsb/zbsb/TSI_ISBM_1.DATrninput datafile file number=00051 name=/zbsb/zbsb/ts_bpoverhaul_1.datrninput datafile file number=00054 name=/zbsb/zbsb/tsi_activiti_1.datrninput datafile file number=00275 name=/zbsb/zbsb/ts_hsdep_1.datrninput datafile file number=00164 name=/zbsb/zbsb/tsi_hm3_1.datrninput datafile file number=00191 name=/zbsb/zbsb/tsi_scmis_1.datrninput datafile file number=00134 name=/zbsb/zbsb/ts_asp.datrninput datafile file number=00288 name=/zbsb/zbsb/ts_ls.dbfrninput datafile file number=00289 name=/zbsb/zbsb/ts_ldsoa_1.datrninput datafile file number=00140 name=/zbsb/zbsb/tsi_seas_1.datrninput datafile file number=00308 name=/zbsb/zbsb/TS_RP3_1.datrninput datafile file number=00046 name=/zbsb/zbsb/ts_sibk_1.datrninput datafile file number=00057 name=/zbsb/zbsb/ts_plan_1.datrninput datafile file number=00114 name=/zbsb/zbsb/ts_bk_3.datrninput datafile file number=00204 name=/zbsb/zbsb/LRMIS_EMP_TABLESPACE.datrninput datafile file number=00269 name=/zbsb/zbsb/tsi_isso_1.dbfrninput datafile file number=00311 name=/zbsb/zbsb/TSI_PP3_1.datrnchannel t1: starting piece 1 at 20-DEC-14rnchannel t1: finished piece 1 at 22-DEC-14rnpiece handle=bak02_full_20141220_26138_1 tag=TAG20141220T220007 comment=API Version 2.0,MMS Version 5.4.1.0rnchannel t1: backup set complete, elapsed time: 35:48:28rnchannel t1: starting incremental level 0 datafile backup setrnchannel t1: specifying datafile(s) in backup setrninput datafile file number=00160 name=/zbsb/zbsb/tsi_cd3_1.datrninput datafile file number=00211 name=/zbsb/zbsb/TS_SBK03.dbfrninput datafile file number=00044 name=/zbsb/zbsb/ts_md3_8.datrninput datafile file number=00073 name=/zbsb/zbsb/ts_lm3_8.datrninput datafile file number=00172 name=/zbsb/zbsb/rtsi_si3_1.datrninput datafile file number=00223 name=/zbsb/zbsb/ts_si3_4.datrninput datafile file number=00228 name=/zbsb/zbsb/tsi_ad3_5.datrninput datafile file number=00237 name=/zbsb/zbsb/ts_si3_7.datrninput datafile file number=00242 name=/zbsb/zbsb/ts_si3_12.datrninput datafile file number=00247 name=/zbsb/zbsb/tsi_si3_6.datrninput datafile file number=00252 name=/zbsb/zbsb/ts_ad3_3.datrninput datafile file number=00257 name=/zbsb/zbsb/tsi_ad3_4.datrninput datafile file number=00327 name=/zbsb/zbsb/ts_be3_3.datrninput datafile file number=00342 name=/zbsb/zbsb/tsi_si3_12.datrninput datafile file number=00348 name=/zbsb/zbsb/ts_be3_6.datrninput datafile file number=00165 name=/zbsb/zbsb/tsi_cd3_2.datrninput datafile file number=00304 name=/zbsb/zbsb/ts_be3_2.datrninput datafile file number=00177 name=/zbsb/zbsb/ts_sjs_01.dbfrninput datafile file number=00157 name=/zbsb/zbsb/ts_bi3_1.datrninput datafile file number=00159 name=/zbsb/zbsb/ts_cd3_1.datrninput datafile file number=00178 name=/zbsb/zbsb/TS_SITS_3.datrninput datafile file number=00305 name=/zbsb/zbsb/tsi_be3_2.datrninput datafile file number=00066 name=/zbsb/zbsb/ts_md3_9.datrninput datafile file number=00259 name=/zbsb/zbsb/ts_mh3_2.datrninput datafile file number=00266 name=/zbsb/zbsb/ts_lm3_a6.datrninput datafile file number=00038 name=/zbsb/zbsb/ts_sjs_04.dbfrninput datafile file number=00295 name=/zbsb/zbsb/ts_lm3_2.datrninput datafile file number=00005 name=/zbsb/zbsb/tsi_si_1.datrninput datafile file number=00010 name=/zbsb/zbsb/tsi_si_6.datrninput datafile file number=00015 name=/zbsb/zbsb/tsi_si_11.datrninput datafile file number=00020 name=/zbsb/zbsb/tsi_si_15.datrninput datafile file number=00025 name=/zbsb/zbsb/ts_si_5.datrninput datafile file number=00030 name=/zbsb/zbsb/ts_si_10.datrninput datafile file number=00035 name=/zbsb/zbsb/ts_si_15.datrninput datafile file number=00120 name=/zbsb/zbsb/ts_mvlog2.datrninput datafile file number=00125 name=/zbsb/zbsb/ts_mvlog7.datrninput datafile file number=00130 name=/zbsb/zbsb/ts_mvlog11.datrninput datafile file number=00148 name=/zbsb/zbsb/ts_mn_1.datrninput datafile file number=00303 name=/zbsb/zbsb/tsi_lm3_5.datrninput datafile file number=00207 name=/zbsb/zbsb/TS_JHK01.dbfrninput datafile file number=00133 name=/zbsb/zbsb/ts_ilss.datrninput datafile file number=00332 name=/zbsb/zbsb/lr_lbs.dbfrninput datafile file number=00052 name=/zbsb/zbsb/tsi_bpoverhaul_1.datrninput datafile file number=00180 name=/zbsb/zbsb/ts_se_01.dbfrninput datafile file number=00063 name=/zbsb/zbsb/ts_mi_3.datrninput datafile file number=00184 name=/zbsb/zbsb/LR_APP_LR_TS.DATrninput datafile file number=00313 name=/zbsb/zbsb/TSI_CA3_1.datrninput datafile file number=00287 name=/zbsb/zbsb/TS_ADRDS01.datrninput datafile file number=00166 name=/zbsb/zbsb/ts_hsps.dbfrninput datafile file number=00188 name=/zbsb/zbsb/LR_IDX_LR_TS.DATrninput datafile file number=00290 name=/zbsb/zbsb/ts_ldsoa_2.datrninput datafile file number=00202 name=/zbsb/zbsb/tsi_hsps.dbfrninput datafile file number=00182 name=/zbsb/zbsb/LR_APP_LA_TS.DATrninput datafile file number=00112 name=/zbsb/zbsb/ts_bk_1.datrninput datafile file number=00201 name=/zbsb/zbsb/sss.dbfrninput datafile file number=00312 name=/zbsb/zbsb/TS_CA3_1.datrninput datafile file number=00048 name=/zbsb/zbsb/ts_sibk_3.datrninput datafile file number=00113 name=/zbsb/zbsb/ts_bk_2.datrninput datafile file number=00203 name=/zbsb/zbsb/LRMIS_EMP_INDEXSPACE.datrninput datafile file number=00268 name=/zbsb/zbsb/ts_isso_1.dbfrninput datafile file number=00310 name=/zbsb/zbsb/TS_PP3_1.datrn[b]channel t1: starting piece 1 at 22-DEC-14rnchannel t1: finished piece 1 at 21-DEC-14[/b]------这个日期有点不对rnpiece handle=bak02_full_20141219_26136_1 tag=TAG20141213T220005 comment=API Version 2.0,MMS Version 5.4.1.0rnchannel t1: backup set complete, elapsed time: 51:49:16rnchannel t1: starting incremental level 0 datafile backup setrnchannel t1: specifying datafile(s) in backup setrnincluding current control file in backup setrnincluding current SPFILE in backup setrnchannel t1: starting piece 1 at 21-DEC-14rnchannel t1: finished piece 1 at 22-DEC-14rnpiece handle=bak02_full_20141221_26139_1 tag=TAG20141213T220005 comment=API Version 2.0,MMS Version 5.4.1.0rnchannel t1: backup set complete, elapsed time: 16:36:41rnFinished backup at 22-DEC-14rnrnreleased channel: t1rnrnRecovery Manager complete.rnrnrn[/code]
如下的代码有什么问题?
package test;rnrnpublic class AssignTest rn public long[][] time = null;rn public AssignTest() rn rnrn public void setArray(long[][] a) rn a = new long[3][4];rn for (int i = 0; i < a.length; i++) rn for (int j = 0; j < a[i].length; j++) rn a[i][j] = i * j;rn rn rn rnrn public void printArray() rnrn setArray(this.time);//通过这个函数对成员变量进行赋值rn for (int i = 0; i < time.length; i++) rn for (int j = 0; j < time[i].length; j++) rn System.out.println(time[i][j]);rn rn rn rnrn public static void main(String[] args) rn AssignTest at = new AssignTest();rn at.printArray();rn rnrnrnrnjava.lang.NullPointerExceptionrnrn at test.AssignTest.printArray(AssignTest.java:20)rnrn at test.AssignTest.main(AssignTest.java:29)rnrnException in thread "main" rn
如下代码有什么问题???
int method;rnrnprivate void button4_Click(object sender, System.EventArgs e)rn rn method = 4;rn rnrnprivate void button2_Click(object sender, System.EventArgs e)rn rn method = 1;rn rnrnprivate void button3_Click(object sender, System.EventArgs e)rn rn method = 2;rn rnrnprivate void button5_Click(object sender, System.EventArgs e)rn rn method = 3;rn rnprivate void button1_Click(object sender, System.EventArgs e)rn rn int left;rn int right;rn int sum;rn left = int.Parse(textBox1.Text); //change the text to a numberrn right = int.Parse(textBox2.Text);rnrn if (method == 1) rn rn sum = left + right;rn textBox3.Text = sum.ToString();rn rn if (method == 2) rn rn sum = left - right;rn textBox3.Text = sum.ToString();rn rn if (method == 3) rn rn sum = left * right;rn textBox3.Text = sum.ToString();rn rn if (method == 4) rn rn sum = left / right;rn textBox3.Text = sum.ToString();rn rn else rn rn textBox3.Text = "Error";rn rn如上代码为什么只有我在计算除法的时候,也就是当method=4的时候才能计算出正确的值,当method为其他值时textbox3.text都显示为"Error"
如下代码有什么问题?????????????????????
#ifdef UNICODErn #define TCHAR wchar_trn#elsern #define TCHAR charrn#endifrnrnTCHAR *Sample::CreateBuffer( TCHAR **buffer)rnrn *buffer = (TCHAR*) malloc(500);rn memset(*buffer, 0, 500);rn return *buffer;rn
C#备份Oracle代码
项目开发中,需要远程备份数据库,以下为C#远程备份数据库的代码 /// /// 数据库备份 /// /// dmp文件名称 /// log文件名称 /// true:备份成功;false:备份失败 public static bool DBBackup(string dmpFileName, st
Informix之ontape 0级备份和恢复实例详解
一、备份 一共涉及8个参数,其中2个BACKUP_FILTER、RESTORE_FILTER用于数据变换指定过滤器程序,不常使用;其他6个如下所示用于创建存储空间和逻辑日志备份。 1、修改onconfig中以下6个参数。 # System Archive Tape Device TAPEDEV         /home/share       # Tape device path TA
备份数据库时为什么会报如下错误?
在备份一个使用正常的数据库时,不论在查询分析器中用脚本直接执行,还是在企业管理器中执行(选择的是完全备份,追加到媒体和重写现有媒体都试过),都会报错,查看日志文件,就是有以下三条记录。rnrn源:SPID68rnInternal I/O request 0x04AC4AC0: Op: Write, pBuffer: 0x04BF0000, Size: 983040, Position: 546575872, UMS: Internal: 0x103, InternalHigh: 0x0, Offset: 0x20941600, OffsetHigh: 0x0, m_buf: 0x04BF0000, m_len: 983040, m_actualBytes: 0, m_errcode: 2, BackupFile: D:\BACKUP\PD.DATrnrn源:BACKUPrnBACKUP 未能完成命令 BACKUP DATABASE [PD] TO DISK = N'D:\BACKUP\PD.DAT' WITH NOINIT , NOUNLOAD , NAME = N'PD 备份', NOSKIP , STATS = 10, NOFORMAT rnrn源:SPID68rnBackupMedium::ReportIoError: 在备份设备“D:\BACKUP\PD.DAT”上 write 失败。操作系统错误 2(系统找不到指定的文件。)。rnrn请高手帮忙看看是什么问题,如何解决?谢谢!
在备份数据库时发生如下错误:
xxx.mdf发生不可恢复的I/O错误,请问各位高手这是什么原因,另外在查询一个视图时发生连接中断错误。
segmentation fault 错误 代码如下
在REDHAT 4.2 下使用gcc编译器编译通过,但是运行时出现segmentation fault错误提示,请指教:(读取8G数据到内存并打印到屏幕,运行时出现time 0: 6 ……time 4: 6 DATA1: segmentation fault)rn#define _CRT_SECURE_NO_DEPRECATE 1rnrn#include rn#include rn#include rn#include rnrnunsigned int *data1;rnunsigned int *data2;rntime_t time_0;rnrnint main()rnrn FILE *fp;rn int i;rn unsigned long long n, data_size;rn char file_name[32];rnrn // data1 申请5G空间rn data1 = (unsigned int *)malloc( ((unsigned long long)5)<<30 );rn // data2 申请3G空间rn data2 = (unsigned int *)malloc( ((unsigned long long)3)<<30 );rnrn time( &time_0 );rn data_size = 0;rn for(i=0; i<5; i++)rn rn sprintf(file_name, "%d.dat", i);rn if( (fp=fopen(file_name, "rb")) == NULL )rn rn printf("Can not open the file %s!\n", file_name);rn exit(1);rn rnrn n = fread(data1+data_size, 4, 1<<28, fp);// 1<<30rn data_size += (n<<7);rnrn fclose(fp);rn rn printf("time %d: %8ld\n", i, time(0)-time_0);rn rnrn printf("DATA1:\n");rn for(i=0; i<20; i++)rn rn printf("%08x\n", data1[data_size-(1<
找出如下代码的错误地方
程序目的是判断奇数和偶数rnrn[code=Java]publice class Test rnpublice sataic void main (string[]gras ) rn rnint(n=100,n>=1000,n++) rnSystem.out.println(n%2=0?A;B) rnrn[/code]rnrn找出错误,不要直接给代码
源程序如下:有何错误?
Private Sub Command1_Click()rn Dim c As MSDataGridLib.Columnrnrn sSql = "Select * From dept"rn Set rst = New ADODB.Recordsetrn rst.CursorLocation = adUseClientrn rst.Open sSql, cnn, 3, 3rn Set frmMain.Adodc1.Recordset = rst ' adoData是一个ADODC控件rnrn '将DataGrid的列与查询出来的列绑定rn '删除原来的列rn For i = dgdEmployee.Columns.Count - 1 To 1 Step -1rn dgdEmployee.Columns.Remove (i)rn Nextrn '加入新列rn For i = 0 To frmMain.Adodc1.Recordset.Fields.Count - 1rn If i = 0 Thenrn Set c = dgdEmployee.Columns(i)rn Elsern Set c = dgdEmployee.Columns.Add(dgdEmployee.Columns.Count)rn End Ifrn c.Visible = Truern c.Width = 1000rn c.Caption = frmMain.Adodc1.Recordset.Fields(i).Namern c.Alignment = dbgRightrn Nextrnrn Set DataGrid1.DataSource = frmMain.Adodc1.RecordsetrnrnEnd Subrn执行到:rst.Open sSql, cnn, 3, 3rn时提示出错:实时错误3001 the application is using arguments that are of wrong type,are out of acceptable range ,or are in confilt with one another.
Oracle备份Oracle备份
Oracle备份Oracle备份Oracle备份Oracle备份Oracle备份Oracle备份Oracle备份Oracle备份Oracle备份
Oracle rman 备份错误列表
备份错误1: RMAN-03009: backup 命令 (ORA_DISK_1 通道上,在 07/28/2012 10:23:22上) ORA-19602: 无法按 NOARCHIVELOG 模式备份或复制活动文件 原因是:自动归档没有开启 解决方法:  1、开启归档   a. 关闭数据库shutdown immediate   b. startup mount   c. a
备份oracle出现oracle942错误
备份oracle时出现:EXP-00008: 遇到 ORACLE 错误 942ORA-00942: 表或视图不存在EXP-00024: 未安装导出视图,请通知您的 DBAEXP-00000: 导出终止失败出现该错误的原因是:由于exp的版本与数据库的版本不相同,虽然9.2.0.8的安装包已经安装成功,但是数据字典表中的相关信息并未更新。修复过程:C:/Documents and Settings/Administrator>sqlplus /nologSQL> conn sys/sys@test as sy
Oracle备份遇到错误 ORA-31631
ORA-31631:需要特权ORA-39161:完整数据库作业需要特权 grant exp_full_database,imp_full_database to user_name
是否有备份表的语句????
我知道有备份整个库的SQL语句,但没见过有备份单个表的SQL语句。rn
在aspx文件有如下代码
rn rn rn rn rn
请问如下代码有什么用?
if(top != self)rn top.location.href = 'default.aspx';
【错误更正】oracle 备份: 每天备份,全备份,保留七天。
1. 保留七天 只保留七天的备份是这样设置的 RMAN> connect target/   connected to target database: DBSID (DBID=3100778490) RMAN> configure retention policy to recovery window of 7 days;  2. 备份脚本 vi /root/rma
浅析oracle备份脚本代码
oracle9i备份脚本:     全备(level 0):     bash-3.00$ more ora9i_rman_bak.sh | grep -v "#"     CUSER=`id |cut -d"(" -f2 | cut -d ")" -f1`     RMAN_LOG_FILE=${0}.out     if [ -f "$RMAN_LOG_FILE" ]     th
看看如下servlet 代码,是否有未关闭的连接
看看如下servlet 代码,是否有未关闭的连接:rn以下servlet用来接收编辑后的资料然后更新数据库存后返回显示页面,但是现在只要提交几次后就会报错,数据源连接池满.不知道是不是下面代码有没关闭的类rnrnpackage dev;rnrnimport javax.servlet.*;rnimport javax.servlet.http.*;rnimport java.io.*;rnimport java.util.*;rnimport java.sql.*;rnimport javax.sql.DataSource;rnimport dev.DatabaseConn;rn/**rn * Title: rn * Description: rn * Copyright: Copyright (c) 2007rn * Company: rn * @author not attributablern * @version 1.0rn */rnrnpublic class upinfo extends HttpServlet rn private static final String CONTENT_TYPE = "text/html; charset=GBK";rn //Initialize global variablesrn private Connection conn;rn private Statement stmt;rn public void init() throws ServletException rn rn //Process the HTTP Get requestrn public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException rn response.setContentType(CONTENT_TYPE);rn PrintWriter out = response.getWriter();rn // out.print("tests");rn String sid=request.getParameter("sid");rn String tile=request.getParameter("zt");rn String frm=request.getParameter("frm");rn String content=request.getParameter("content");rnrn try rn conn.close();rn conn=dev.DatabaseConn.getConnection();rn stmt=conn.createStatement();rn // out.print("tes14ts");rn stmt.executeUpdate("update nt01 set N001='"+tile+"',n002='"+frm+"',n003='"+content+"' where id="+sid+"");rn stmt.close();rn conn.close();rn rn catch (Exception ex) rn ex.printStackTrace();rn rnrn response.sendRedirect("admin/info/list.jsp");rn //RequestDispatcher requestDispatcher=request.getRequestDispatcher("admin/info/list.jsp");rn //requestDispatcher.forward(request,response);rn rn //Clean up resourcesrn public void destroy() rnrn rn
错误如下:
File 'c:\mysql\share\charsets\gb2312.conf' not found (Errcode: 2) Character set '#24' is not a compiled character set and is not specified in the 'c:\mysql\share\charsets\Index' file rnNotice: Undefined variable: subject in d:\inetpub\wwwroot\post.php on line 12rnrn发表文章 rn--------------------------------------------------------------------------------rnrn标题: Notice: Undefined variable: id in d:\inetpub\wwwroot\post.php on line 24rnrnNotice: Undefined variable: subject in d:\inetpub\wwwroot\post.php on line 33rnvalue='' >rn姓名: Notice: Undefined variable: author in d:\inetpub\wwwroot\post.php on line 39rn>rn电子邮件: Notice: Undefined variable: email in d:\inetpub\wwwroot\post.php on line 43rn>rn文章内容:rn rnNotice: Undefined variable: contents in d:\inetpub\wwwroot\post.php on line 48 rnrnrn rnrn请勿多次提交,否则您的文章将重复出现。 rnrnrn--------------------------------------------------------------------------------rnrn返回文章列表rn
竞答:看看如下代码有何错误?
[code=HTML]rn上传: rn上传: rn上传: rn上传: rn上传: rn上传: rn rn rn查看您所上传的文件 rn rn查看服务器中允许下载的文件 rn [/code]rnrn
请问如下代码有何错误:if form4.ModalResult =1 then
请问各位前辈,这是应用程序的DPR文件中的代码,FORM4是登陆窗体,谢谢!!
android native程序,为什么有错误呢,代码如下...
init:rn glHint(GL_PERSPECTIVE_CORRECTION_HINT, GL_FASTEST);rn glEnable(GL_CULL_FACE);rn glShadeModel(GL_SMOOTH);rn glDisable(GL_DEPTH_TEST); rn rn draw linern glClearColor(0.0f, 0.0f, 0.0f, 0.0f);rn glMatrixMode(GL_PROJECTION);rn glLoadIdentity();rn glOrthof(0.0f, 1.0f, 0.0f, 1.0f, -1.0f, 1.0f);rn glVertexPointer(3, GL_FLOAT, 0, square);rn glEnableClientState(GL_VERTEX_ARRAY);rn rnrn glColor4f(0,0,1.0,1);rn GLfloat v[4];rn v[0]=100;v[1]=150;v[2]=200;v[3]=250;rn glLineWidth(2.0);rn glVertexPointer(2,GL_FLOAT,0,v);rn glDrawArrays(GL_LINES,0,2);rn glFlush();rn rn rn rn eglSwapBuffers(engine->display, engine->surface);rnrn这段代码的本意是:使用OPENGL ES绘制一条直线 ,为什么总是不成功呢,屏幕上没有看到直线!
请问我在asp+sql 2000中用如下代码有错误吗?
请问我在asp+sql 2000中用如下代码有错误吗?rn还有我想知道在一些SQL语句中ACCESS与sql server 2000有什么区别?rnselect * from article where DATEDIFF('d',addtime,Now()) < 1 and ( title like '%1%' ) order by id descrnrn我得到的是如下错误:rnMicrosoft OLE DB Provider for SQL Server (0x80040E14)rn/manage/searchresult.asp, 第 43 行rn
为什么如下代码有这样的错误:too many initializers
rnint st[7][4][2] = rnrn rn 0,0,0,1,0,2,0,3 ,rn 0,0,-1,0,-2,0,-3,0 ,rn 0,0,0,1,0,2,0,3 ,rn 0,0,-1,0,-2,0,-3,0 rn ,rnrn rn 0,0,0,1,-1,0,-1,1 ,rn 0,0,0,1,-1,0,-1,1 ,rn 0,0,0,1,-1,0,-1,1 ,rn 0,0,0,1,-1,0,-1,1 rn ,rnrn rn 0,0,0,-1,0,1,-1,0 ,rn 0,0,0,1,-1,0,1,0 ,rn 0,0,0,-1,0,1,1,0 ,rn 0,0,0,-1,-1,0,1,0 rn ,rnrn rn 0,0,-1,0,-2,0,0,1 ,rn 0,0,0,1,0,2,1,0 ,rn 0,0,0,-1,1,0,2,0 ,rn 0,0,0,-1,0,-2,-1,0 rn ,rn rn 0,0,0,1,-1,1,-2,1 ,rn 0,0,0,1,0,2,-1,0 ,rn 0,0,0,1,1,0,2,0 ,rn 0,0,0,-1,0,-2,1,0 rn ,rn rn 0,0,0,1,-1,0,-1,-1 ,rn 0,0,-1,0,0,-1,1,-1 ,rn 0,0,0,1,-1,0,-1,-1 ,rn 0,0,-1,0,0,-1,1,-1 rn ,rn rn 0,0,0,-1,-1,0,-1,1 ,rn 0,0,0,-1,-1,-1,1,0 ,rn 0,0,0,-1,-1,0,-1,1 ,rn 0,0,0,-1,-1,-1,1,0 rn rn;rnrn错误提示如下:rn error C2078: too many initializersrnError executing cl.exe.
oracle 9i恢复出现如下错误
RMAN> restore database; rn 启动 restore 于 15-12月-05 rn 分配的通道: ORA_DISK_1 rn 通道 ORA_DISK_1: sid=13 devtype=DISK rn 通道 ORA_DISK_1: 正在开始恢复数据文件备份集 rn 通道 ORA_DISK_1: 正在指定从备份集恢复的数据文件 rn 正将数据文件00001恢复到C:\ORACLE\ORADATA\TEST\SYSTEM01.DBF rn 正将数据文件00002恢复到C:\ORACLE\ORADATA\TEST\UNDOTBS01.DBF rn 正将数据文件00003恢复到C:\ORACLE\ORADATA\TEST\CWMLITE01.DBF rn 正将数据文件00004恢复到C:\ORACLE\ORADATA\TEST\DRSYS01.DBF rn 正将数据文件00005恢复到C:\ORACLE\ORADATA\TEST\EXAMPLE01.DBF rn 正将数据文件00006恢复到C:\ORACLE\ORADATA\TEST\INDX01.DBF rn 正将数据文件00007恢复到C:\ORACLE\ORADATA\TEST\ODM01.DBF rn 正将数据文件00008恢复到C:\ORACLE\ORADATA\TEST\TOOLS01.DBF rn 正将数据文件00009恢复到C:\ORACLE\ORADATA\TEST\USERS01.DBF rn 正将数据文件00010恢复到C:\ORACLE\ORADATA\TEST\XDB01.DBF rn RMAN-00571: =========================================================== rn RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== rn RMAN-00571: =========================================================== rn RMAN-03002: failure of restore command at 12/15/2005 10:21:46 rn ORA-19573: 无法获得 exclusive 入队 (数据文件 1 的) rnrn请问这个怎样解决啊?rnrn
oracle客户端出现如下错误,连不上数据库
oracle出现如下错误。连不上数据库rnConnecting....rnrnThe test did not succeed.rnORA-12571: TNS:包写入程序失败rnrnThere may be an error in the fields enteredrnor the server may not be ready for a connection.rnYou can check the server and retry, or continue.rn其他机器可以连接,该机器重装一次也不行rnrn客户端是oracle lite+winxp 服务器是oracle8.0.4+win2000rnrn以前好用,突然不好用了rn
jdbc 连接oracle 为什么出现如下错误????
ORACLE 数据库连接正常rnrn我有如下代码: rn连接oracle rnResultSet rset=stmt.executeQuery(query); rn其他都正确 rn有如下的异常输出: rnORA-00600: 内部错误代码,参数: [ttcgcshnd-1], [0], [], [], [], [], [], []
jdbc连接oracle报如下错误
Exception in thread "main" java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriverrn at java.net.URLClassLoader$1.run(Unknown Source)rn at java.security.AccessController.doPrivileged(Native Method)rn at java.net.URLClassLoader.findClass(Unknown Source)rn at java.lang.ClassLoader.loadClass(Unknown Source)rn at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)rn at java.lang.ClassLoader.loadClass(Unknown Source)rn at java.lang.Class.forName0(Native Method)rn at java.lang.Class.forName(Unknown Source)rn at test.ConnectionDB.main(ConnectionDB.java:18)