Oracle Rman错误 ORA-17629:/ORA-17627:/ ORA-01017:

两边oracle是同版本11.2.0的,但平台一个是redhat 一个window。

[oracle@testdb ~]$ rman target sys/root@orcl auxiliary sys/oracle@ORCL2

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 28 14:52:32 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCL (DBID=1451001194)
connected to auxiliary database: ORCL (not mounted)

RMAN> duplicate target database for standby from active database;

Starting Duplicate Db at 28-OCT-16
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=193 device type=DISK

contents of Memory Script:
{
backup as copy reuse
targetfile '/oracle/product/11.2.0/db_1/dbs/orapworcl' auxiliary format
'E:\app\Administrator\product\11.2.0\dbhome_1\DATABASE\PWDorcl.ORA' ;
}
executing Memory Script

Starting backup at 28-OCT-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=191 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/28/2016 14:56:00
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/28/2016 14:56:00
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01017: invalid username/password; logon denied
ORA-17629: Cannot connect to the remote database server

RMAN> duplicate target database for standby from active database;

Starting Duplicate Db at 28-OCT-16
using channel ORA_AUX_DISK_1

contents of Memory Script:
{
backup as copy reuse
targetfile '/oracle/product/11.2.0/db_1/dbs/orapworcl' auxiliary format
'E:\app\Administrator\product\11.2.0\dbhome_1\DATABASE\PWDorcl.ORA' ;
}
executing Memory Script

Starting backup at 28-OCT-16
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/28/2016 15:05:13
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/28/2016 15:05:13
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01017: invalid username/password; logon denied
ORA-17629: Cannot connect to the remote database server

1个回答

ORA-17627: ORA-01017: invalid username/password; logon denied
检查下用户名和密码

wyl43381998
wyl43381998 用户名密码没有错误,远程可以互相连接上
3 年多之前 回复
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
SpringBoot连接Oracle数据库报ORA-01017: invalid username/password; logon denied

我本地用Sql Developer 和 Navicat连接都没问题,但是在项目中连接运行就报错。 我项目中已经导入ojdbc的jar包了,谁知道该怎么连数据库阿!!!!! ![图片说明](https://img-ask.csdn.net/upload/201911/24/1574566960_128010.png) ![图片说明](https://img-ask.csdn.net/upload/201911/24/1574566967_439930.png) 有人告诉我该怎么做吗

ORA-17627: ORA-12577: Message 12577 not found;

**rman target sys/oracle@orcl auxiliary sys/oracle@ORCL2** Recovery Manager: Release 11.2.0.1.0 - Production on Mon Oct 31 10:09:17 2016 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1451001194) connected to auxiliary database: ORCL (not mounted) **RMAN> duplicate target database for standby from active database;** Starting Duplicate Db at 31-OCT-16 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=131 device type=DISK contents of Memory Script: { backup as copy reuse targetfile '/oracle/product/11.2.0/db_1/dbs/orapworcl' auxiliary format 'E:\app\Administrator\product\11.2.0\dbhome_1\DATABASE\PWDorcl.ORA' ; } executing Memory Script Starting backup at 31-OCT-16 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=131 device type=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 10/31/2016 10:09:30 RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/31/2016 10:09:30 ORA-17627: ORA-12577: Message 12577 not found; product=RDBMS; facility=ORA

Oracle连接显示ERROR:ORA-01031: insufficient privileges

安装后,在DOS上输入sqlplus / as sysdba 出现ERROR: ORA-01031: insufficient privileges让输入用户名进入,可以直接输入 sys as sysdba (还以超级用户的进入) 密码为你安装时设置的密码,就可以进入特权用户下解锁其他用户使用。请问谁有解决ERROR: ORA-01031: insufficient privileges让的办法吗?配置是NTS,这里没有错。

ERROR: ORA-12541: TNS:no listener

使用pl/sql连接远程Linux上的oracle出现ERROR: ORA-12541: TNS:no listener 本人用的是win系统,想使用pl/sql连接远程oracle,配置文件都配了,实在是没有办法了,求大神救救我

oracle之报错:ORA-00054: 资源正忙,要求指定 NOWAIT

问题如下: SQL> conn scott/tiger@vm_database Connected to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 Connected as scott 。。。。。。 SQL> drop table student2; drop table student2 ORA-00054: 资源正忙, 但指定以 NOWAIT 方式获取资源, 或者超时失效

rman备份报错 ORA-19571

昨天晚上做数据库备份出现这么个问题 ORA-19571: archived log RECID 11953 STAMP 947229923 not found in control file 说是跟下面这个参数有关,没太懂 SQL> show parameter control_file NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_file_record_keep_time integer 7 归档我也是定期删除的; 请大家指教!

RMAN-06054: and starting SCN of 1025204

RMAN> recover database; Starting recover at 03-JUL-16 using channel ORA_DISK_1 starting media recovery channel ORA_DISK_1: starting archived log restore to default destination channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=9 channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=10 channel ORA_DISK_1: reading from backup piece /tmp/hotbackup/arch04r9pbud_4_1 channel ORA_DISK_1: piece handle=/tmp/hotbackup/arch04r9pbud_4_1 tag=TAG20160703T143804 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 archived log file name=/arch/1_9_916194414.dbf thread=1 sequence=9 archived log file name=/arch/1_10_916194414.dbf thread=1 sequence=10 unable to find archived log archived log thread=1 sequence=11 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 07/03/2016 14:50:19 RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 11 and starting SCN of 1025204

PL/SL登陆报错,ORA-12505:

ORA-12505: TNS: 监听程序当前无法识别连接描述符中所给出的SID 应该如何修改啊。跪求解决方案。弄了一天了。 # tnsnames.ora Network Configuration File: D:\Oracle10g\network\admin\tnsnames.ora # Generated by Oracle configuration tools. ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (sid = orcl) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )

oracle dg复制备库约到如下错误

连接主备库 rman target sys/oracle@fc91 auxiliary sys/oracle@fc94 执行脚本: run{ allocate channel c1 type disk; allocate channel c2 type disk; allocate channel c3 type disk; allocate AUXILIARY channel c4 type disk; allocate AUXILIARY channel c5 type disk; allocate AUXILIARY channel c6 type disk; DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER NOFILENAMECHECK; release channel c1; release channel c2; release channel c3; release channel c4; release channel c5; release channel c6; } Recovery Manager: Release 19.0.0.0.0 - Production on Tue Jan 21 16:23:00 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: FC91 (DBID=2505363336) connected to auxiliary database: FC91 (DBID=2505363336, not open) RMAN> 现在日志如下: using target database control file instead of recovery catalog allocated channel: c1 channel c1: SID=729 device type=DISK allocated channel: c2 channel c2: SID=1094 device type=DISK allocated channel: c3 channel c3: SID=609 device type=DISK allocated channel: c4 channel c4: SID=1212 device type=DISK allocated channel: c5 channel c5: SID=1333 device type=DISK allocated channel: c6 channel c6: SID=1454 device type=DISK Starting Duplicate Db at 21-JAN-20 contents of Memory Script: { backup as copy reuse passwordfile auxiliary format '/opt/oracle/product/19c/dbhome_1/dbs/orapwFC94' ; } executing Memory Script Starting backup at 21-JAN-20 Finished backup at 21-JAN-20 contents of Memory Script: { restore clone from service 'fc91' standby controlfile; } executing Memory Script Starting restore at 21-JAN-20 channel c4: starting datafile backup set restore channel c4: using network backup set from service fc91 channel c4: restoring control file channel c4: restore complete, elapsed time: 00:00:01 output file name=/opt/oracle/oradata/FC94/control01.ctl output file name=/opt/oracle/oradata/FC94/control02.ctl Finished restore at 21-JAN-20 contents of Memory Script: { sql clone 'alter database mount standby database'; } executing Memory Script sql statement: alter database mount standby database contents of Memory Script: { set newname for tempfile 1 to "/opt/oracle/oradata/FC94/temp01.dbf"; set newname for tempfile 2 to "/opt/oracle/oradata/FC94/pdbseed/temp012020-01-21_11-02-57-925-AM.dbf"; set newname for tempfile 3 to "/opt/oracle/oradata/FC94/ORCLPDB1/temp01.dbf"; switch clone tempfile all; set newname for datafile 1 to "/opt/oracle/oradata/FC94/system01.dbf"; set newname for datafile 3 to "/opt/oracle/oradata/FC94/sysaux01.dbf"; set newname for datafile 4 to "/opt/oracle/oradata/FC94/undotbs01.dbf"; set newname for datafile 5 to "/opt/oracle/oradata/FC94/pdbseed/system01.dbf"; set newname for datafile 6 to "/opt/oracle/oradata/FC94/pdbseed/sysaux01.dbf"; set newname for datafile 7 to "/opt/oracle/oradata/FC94/users01.dbf"; set newname for datafile 8 to "/opt/oracle/oradata/FC94/pdbseed/undotbs01.dbf"; set newname for datafile 9 to "/opt/oracle/oradata/FC94/ORCLPDB1/system01.dbf"; set newname for datafile 10 to "/opt/oracle/oradata/FC94/ORCLPDB1/sysaux01.dbf"; set newname for datafile 11 to "/opt/oracle/oradata/FC94/ORCLPDB1/undotbs01.dbf"; set newname for datafile 12 to "/opt/oracle/oradata/FC94/ORCLPDB1/users01.dbf"; restore from nonsparse from service 'fc91' clone database ; sql 'alter system archive log current'; } executing Memory Script executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME renamed tempfile 1 to /opt/oracle/oradata/FC94/temp01.dbf in control file renamed tempfile 2 to /opt/oracle/oradata/FC94/pdbseed/temp012020-01-21_11-02-57-925-AM.dbf in control file renamed tempfile 3 to /opt/oracle/oradata/FC94/ORCLPDB1/temp01.dbf in control file executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting restore at 21-JAN-20 channel c4: starting datafile backup set restore channel c4: using network backup set from service fc91 channel c4: specifying datafile(s) to restore from backup set channel c4: restoring datafile 00001 to /opt/oracle/oradata/FC94/system01.dbf released channel: c1 released channel: c2 released channel: c3 released channel: c4 released channel: c5 released channel: c6 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 01/21/2020 16:12:58 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script ORA-19845: error in backupDataFile while communicating with remote database server ORA-17628: Oracle error 19602 returned by remote Oracle server ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode ORA-19660: some files in the backup set could not be verified ORA-19661: datafile 1 could not be verified ORA-19845: error in backupDataFile while communicating with remote database server ORA-17628: Oracle error 19602 returned by remote Oracle server ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

Rman为什么会尝试应用今天全库备份之前的归档呢?不是应该应用全库备份之后产生的归档吗?

我用Rman做了全库备份和归档日志备份,以下是备份: arc_936057575_53_3762.arc 归档 arc_936068367_55_3763.arc arc_936079186_60_3764.arc arc_936089969_62_3765.arc full_DAWH_20170216_1prsmkom_1_1 全库 full_DAWH_20170216_1qrsmkon_1_1 o1_mf_s_936068379_db998vw3_.bkp controlfile和spfile备份 o1_mf_s_936073797_db9gl5pw_.bkp o1_mf_s_936079201_db9mv286_.bkp o1_mf_s_936089985_db9yd1xo_.bkp 这是我今天中午为止这一天内产生的备份。 恢复的时候,先restore,然后recover的时候, 从下面会看出rman在找昨天的3761~3627的归档日志,而今天产生的3762~3765的归档却不应用。 3761~3627这段归档,是昨天的归档, 今天16号的归档只有3762~3765。 那么问题来了,restore了今天的全备,为什么recover的时候会去找做了全备之前的归档呢? 如果是因为controlfile太老了,那不是应该应用正确的归档把controlfile更新吗?怎么不应用正确的归档呢? RMAN> recover database; Starting recover at 16-FEB-17 using channel ORA_DISK_1 starting media recovery Oracle Error: 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: '/DAWH/oradata/DAWH/system01.dbf' RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 02/16/2017 17:53:20 RMAN-06053: unable to perform media recovery because of missing log RMAN-06025: no backup of archived log for thread 1 with sequence 3761 and starting SCN of 1320314801 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 3760 and starting SCN of 1320288564 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 3759 and starting SCN of 1320259166 found to restore ......................................................... RMAN-06025: no backup of archived log for thread 1 with sequence 3672 and starting SCN of 1315631128 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 3671 and starting SCN of 1315503024 found to restore .................................................. RMAN-06025: no backup of archived log for thread 1 with sequence 3629 and starting SCN of 1312028064 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 3628 and starting SCN of 1311948459 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 3627 and starting SCN of 1311875444 found to restore RMAN-00567: Recovery Manager could not print some error messages

数据库报错内部错误ORA-00600

数据库dblink访问其他数据库报错如截图,尝试各种解决,但还是不明白怎么解决![图片说明](https://img-ask.csdn.net/upload/202004/08/1586359675_140619.png)

10G的Oracle数据备份导入到11G的问题

一个10G版本的Oracle数据库备份文件(dmp),在导入到11G数据库时,报错。 报错信息如下: IMP-00003: 遇到 ORACLE 错误 910 ORA-00910: 指定的长度对于数据类型而言过长 IMP-00017: 由于 ORACLE 错误 910, 以下语句失败: 根据网上搜索,大家都认为是字符集不同引起的。可是10G的字符集是UTF8,11G的字符集是AL32UTF8(问题是安装11G时,已经没有UTF8让我选择了,只能选相近的AL32UTF8) 不知道该怎样解决?请大家指点。谢谢

rman备份的归档日志恢复不成功,求指教

用的增量备份策略其中归档日志备份如下: backup as compressed backupset archivelog all format '/home/oracle/0_level/arch_%s_%d_T' delete input; 在进行恢复的时候,recover database;时恢复了归档日志,但是归档日志恢复的不全,而且有的不成功,提示如下,数据库也可以打开,数据貌似也都回来了。 channel ORA_DISK_1: starting archive log restore to default destination channel ORA_DISK_1: restoring archive log archive log thread=1 sequence=9 channel ORA_DISK_1: reading from backup piece /home/oracle/1_level/arch_1_47_CHEN_T channel ORA_DISK_1: restored backup piece 1 piece handle=/home/oracle/1_level/arch_1_47_CHEN_T tag=TAG20150610T093812 channel ORA_DISK_1: restore complete, elapsed time: 00:00:02 archive log filename=/oracle/app/flash_recovery_area/CHEN/archivelog/2015_06_10/o1_mf_1_9_bqh8ndy4_.arc thread=1 sequence=9 channel default: deleting archive log(s) archive log filename=/oracle/app/flash_recovery_area/CHEN/archivelog/2015_06_10/o1_mf_1_9_bqh8ndy4_.arc recid=109 stamp=882009357 channel ORA_DISK_1: starting archive log restore to default destination channel ORA_DISK_1: restoring archive log archive log thread=1 sequence=10 channel ORA_DISK_1: reading from backup piece /home/oracle/1_level/arch_1_48_CHEN_T channel ORA_DISK_1: restored backup piece 1 piece handle=/home/oracle/1_level/arch_1_48_CHEN_T tag=TAG20150610T093812 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 archive log filename=/oracle/app/flash_recovery_area/CHEN/archivelog/2015_06_10/o1_mf_1_10_bqh8ng8q_.arc thread=1 sequence=10 unable to find archive log archive log thread=1 sequence=1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 06/10/2015 10:36:02 RMAN-06054: media recovery requesting unknown log: thread 1 seq 1 lowscn 1019414 RMAN> alter database open resetlogs; database opened

关于oracle DG搭建时的 静态监听问题

在搭建DG时 连接rman进行standby文件创建时输入rman target sys/123456@orcl auxiliary sys/123456@orcls,提示 error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections。查了资料好像是备库监听问题,说是要陪静态监听,但是我应该已经配置了静态监听了,配置文件如下:请问哪里配错了? LISTENER= (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.174.31)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY =EXTPROC1521)) ) ) SID_LIST_LISTENER= (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl) (ORACLE_HOME =/ora01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = orcls) ) )

rman的备份时报了这个错误

rman20039 format requires %c when duplexing

rman 全备份 恢复无效

最近再学习rman。 完全备份后 修改数据 再恢复,发现恢复无效。 环境:vm虚拟机 centos6.7 oracle12c 操作数据: 1.**启用archivelog模式: ** ``` [root@localhost ~]# su - oracle -bash-4.1$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Wed Apr 24 01:53:58 2019 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination /home/oracle/product/12.2.0/db_1/dbs/arch Oldest online log sequence 1 Next log sequence to archive 1 Current log sequence 1 SQL> ``` 2.进入rman ``` Last login: Wed Apr 24 01:53:04 2019 from 192.168.30.1 [root@localhost ~]# su - oracle -bash-4.1$ rman target / nocatalog Recovery Manager: Release 12.2.0.1.0 - Production on Wed Apr 24 01:57:30 2019 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. connected to target database: LESP (DBID=1750011068) using target database control file instead of recovery catalog RMAN> ``` 3.全备份 ``` RMAN> backup database; Starting backup at 24-APR-19 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=55 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00001 name=/home/oracle/oradata/lesp/system01.dbf input datafile file number=00003 name=/home/oracle/oradata/lesp/sysaux01.dbf input datafile file number=00004 name=/home/oracle/oradata/lesp/undotbs01.dbf input datafile file number=00005 name=/home/oracle/oradata/lesp/ts_data_lesp_etl_001.dbf input datafile file number=00007 name=/home/oracle/oradata/lesp/users01.dbf channel ORA_DISK_1: starting piece 1 at 24-APR-19 channel ORA_DISK_1: finished piece 1 at 24-APR-19 piece handle=/home/oracle/product/12.2.0/db_1/dbs/34tvomv8_1_1 tag=TAG20190424T015904 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45 Finished backup at 24-APR-19 Starting Control File and SPFILE Autobackup at 24-APR-19 piece handle=/home/oracle/product/12.2.0/db_1/dbs/c-1750011068-20190424-0a comment=NONE Finished Control File and SPFILE Autobackup at 24-APR-19 ``` 4.查看备份信息 ``` RMAN> list backupset ; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 106 Full 1.07G DISK 00:00:43 24-APR-19 BP Key: 106 Status: AVAILABLE Compressed: NO Tag: TAG20190424T015904 Piece Name: /home/oracle/product/12.2.0/db_1/dbs/34tvomv8_1_1 List of Datafiles in backup set 106 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- --------- ----------- ------ ---- 1 Full 2016498 24-APR-19 NO /home/oracle/oradata/lesp/system01.dbf 3 Full 2016498 24-APR-19 NO /home/oracle/oradata/lesp/sysaux01.dbf 4 Full 2016498 24-APR-19 NO /home/oracle/oradata/lesp/undotbs01.dbf 5 Full 2016498 24-APR-19 NO /home/oracle/oradata/lesp/ts_data_lesp_etl_001.dbf 7 Full 2016498 24-APR-19 NO /home/oracle/oradata/lesp/users01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 107 Full 10.66M DISK 00:00:00 24-APR-19 BP Key: 107 Status: AVAILABLE Compressed: NO Tag: TAG20190424T015950 Piece Name: /home/oracle/product/12.2.0/db_1/dbs/c-1750011068-20190424-0a SPFILE Included: Modification time: 24-APR-19 SPFILE db_unique_name: LESP Control File Included: Ckp SCN: 2016523 Ckp time: 24-APR-19 ``` 6.修改数据库数据: 之前: ``` SQL> select count(1) from tabs; COUNT(1) ---------- 0 ``` 创建一个表: ``` SQL> select count(1) from tabs; COUNT(1) ---------- 1 ``` 7.恢复: 1.nomount ``` RMAN> shutdown abort; Oracle instance shut down RMAN> startup nomount; connected to target database (not started) Oracle instance started Total System Global Area 784334848 bytes Fixed Size 8625608 bytes Variable Size 658506296 bytes Database Buffers 113246208 bytes Redo Buffers 3956736 bytes ``` 7.2.restore controlfile ``` RMAN> restore controlfile from '/home/oracle/product/12.2.0/db_1/dbs/c-1750011068-20190424-0a' 2> ; Starting restore at 24-APR-19 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=37 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 output file name=/home/oracle/oradata/lesp/control01.ctl output file name=/home/oracle/oradata/lesp/control02.ctl Finished restore at 24-APR-19 ``` 7.3 mount /restore/ recover ``` RMAN> alter database mount; Statement processed released channel: ORA_DISK_1 RMAN> restore database; Starting restore at 24-APR-19 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=37 device type=DISK channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to /home/oracle/oradata/lesp/system01.dbf channel ORA_DISK_1: restoring datafile 00003 to /home/oracle/oradata/lesp/sysaux01.dbf channel ORA_DISK_1: restoring datafile 00004 to /home/oracle/oradata/lesp/undotbs01.dbf channel ORA_DISK_1: restoring datafile 00005 to /home/oracle/oradata/lesp/ts_data_lesp_etl_001.dbf channel ORA_DISK_1: restoring datafile 00007 to /home/oracle/oradata/lesp/users01.dbf channel ORA_DISK_1: reading from backup piece /home/oracle/product/12.2.0/db_1/dbs/34tvomv8_1_1 channel ORA_DISK_1: piece handle=/home/oracle/product/12.2.0/db_1/dbs/34tvomv8_1_1 tag=TAG20190424T015904 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:36 Finished restore at 24-APR-19 RMAN> recover database; Starting recover at 24-APR-19 using channel ORA_DISK_1 starting media recovery archived log for thread 1 with sequence 1 is already on disk as file /home/oracle/oradata/lesp/redo01.log archived log file name=/home/oracle/oradata/lesp/redo01.log thread=1 sequence=1 media recovery complete, elapsed time: 00:00:01 Finished recover at 24-APR-19 RMAN> alter database open resetlogs; Statement processed RMAN> ``` 8.查看效果; ``` SQL> select count(1) from tabs; COUNT(1) ---------- 1 ``` 没有恢复 还是备份之后的数据

为什么一顿操作,啥也没改变?RMAN还原数据库。

为什么我还原数据库,数据库没有被还原? 操作如下,请大佬们帮忙解答。 ``` [oracle@dg1 ~]$ rman target / Recovery Manager: Release 19.0.0.0.0 - Production on Mon Dec 23 15:08:56 2019 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1554676977) RMAN> shutdown immediate using target database control file instead of recovery catalog database closed database dismounted Oracle instance shut down RMAN> startup mount; connected to target database (not started) Oracle instance started database mounted Total System Global Area 1795159104 bytes Fixed Size 8897600 bytes Variable Size 503316480 bytes Database Buffers 1275068416 bytes Redo Buffers 7876608 bytes RMAN> restore database; Starting restore at 23-DEC-19 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=11 device type=DISK channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to /oracleDB/app/oracle/oradata/ORCL/system01.dbf channel ORA_DISK_1: restoring datafile 00002 to /oracleDB/app/oracle/oradata/ORCL/SNSYSINDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00003 to /oracleDB/app/oracle/oradata/ORCL/sysaux01.dbf channel ORA_DISK_1: restoring datafile 00004 to /oracleDB/app/oracle/oradata/ORCL/undotbs01.dbf channel ORA_DISK_1: restoring datafile 00005 to /oracleDB/app/oracle/oradata/ORCL/SNSYSDATA_TBS.dbf channel ORA_DISK_1: restoring datafile 00007 to /oracleDB/app/oracle/oradata/ORCL/users01.dbf channel ORA_DISK_1: restoring datafile 00008 to /oracleDB/app/oracle/oradata/ORCL/SNOPDATA_TBS.dbf channel ORA_DISK_1: restoring datafile 00009 to /oracleDB/app/oracle/oradata/ORCL/SNOPINDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00010 to /oracleDB/app/oracle/oradata/ORCL/SNMQDATA_TBS.dbf channel ORA_DISK_1: restoring datafile 00011 to /oracleDB/app/oracle/oradata/ORCL/SNMQINDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00012 to /oracleDB/app/oracle/oradata/ORCL/SNMONITORDATA_TBS.dbf channel ORA_DISK_1: restoring datafile 00013 to /oracleDB/app/oracle/oradata/ORCL/SNMONITORINDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00014 to /oracleDB/app/oracle/oradata/ORCL/SNHRDATA_TBS.dbf channel ORA_DISK_1: restoring datafile 00015 to /oracleDB/app/oracle/oradata/ORCL/SNHRINDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00016 to /oracleDB/app/oracle/oradata/ORCL/SNBUDGE_TBS.dbf channel ORA_DISK_1: restoring datafile 00017 to /oracleDB/app/oracle/oradata/ORCL/OPTDATA_TBS.dbf channel ORA_DISK_1: restoring datafile 00018 to /oracleDB/app/oracle/oradata/ORCL/RATIFY_TBS.dbf channel ORA_DISK_1: restoring datafile 00019 to /oracleDB/app/oracle/oradata/ORCL/COMM_TBS.dbf channel ORA_DISK_1: restoring datafile 00020 to /oracleDB/app/oracle/oradata/ORCL/MSG_TBS.dbf channel ORA_DISK_1: restoring datafile 00021 to /oracleDB/app/oracle/oradata/ORCL/PO_TBS.dbf channel ORA_DISK_1: restoring datafile 00022 to /oracleDB/app/oracle/oradata/ORCL/FUND_TBS.dbf channel ORA_DISK_1: restoring datafile 00023 to /oracleDB/app/oracle/oradata/ORCL/OFIN_TBS.dbf channel ORA_DISK_1: restoring datafile 00024 to /oracleDB/app/oracle/oradata/ORCL/TAX_TBS.dbf channel ORA_DISK_1: restoring datafile 00025 to /oracleDB/app/oracle/oradata/ORCL/CARGO_TBS.dbf channel ORA_DISK_1: restoring datafile 00026 to /oracleDB/app/oracle/oradata/ORCL/INV_TBS.dbf channel ORA_DISK_1: restoring datafile 00027 to /oracleDB/app/oracle/oradata/ORCL/CARGO_IDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00028 to /oracleDB/app/oracle/oradata/ORCL/PO_IDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00029 to /oracleDB/app/oracle/oradata/ORCL/FUND_IDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00030 to /oracleDB/app/oracle/oradata/ORCL/COST_IDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00031 to /oracleDB/app/oracle/oradata/ORCL/STOCK_IDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00032 to /oracleDB/app/oracle/oradata/ORCL/FIN_IDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00033 to /oracleDB/app/oracle/oradata/ORCL/FIN_TBS.dbf channel ORA_DISK_1: restoring datafile 00034 to /oracleDB/app/oracle/oradata/ORCL/CFIN_TBS.dbf channel ORA_DISK_1: restoring datafile 00035 to /oracleDB/app/oracle/oradata/ORCL/CFIN_IDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00036 to /oracleDB/app/oracle/oradata/ORCL/COST_TBS.dbf channel ORA_DISK_1: restoring datafile 00037 to /oracleDB/app/oracle/oradata/ORCL/INV_IDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00038 to /oracleDB/app/oracle/oradata/ORCL/STOCK_TBS.dbf channel ORA_DISK_1: restoring datafile 00039 to /oracleDB/app/oracle/oradata/ORCL/MSG_IDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00040 to /oracleDB/app/oracle/oradata/ORCL/SYSDATA_TBS.dbf channel ORA_DISK_1: restoring datafile 00041 to /oracleDB/app/oracle/oradata/ORCL/FINDATA_TBS.dbf channel ORA_DISK_1: restoring datafile 00042 to /oracleDB/app/oracle/oradata/ORCL/OPTINDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00043 to /oracleDB/app/oracle/oradata/ORCL/EDI_TBS.dbf channel ORA_DISK_1: restoring datafile 00044 to /oracleDB/app/oracle/oradata/ORCL/OFIN_IDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00045 to /oracleDB/app/oracle/oradata/ORCL/SYSINDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00046 to /oracleDB/app/oracle/oradata/ORCL/FININDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00047 to /oracleDB/app/oracle/oradata/ORCL/HRDATA_TBS.dbf channel ORA_DISK_1: restoring datafile 00048 to /oracleDB/app/oracle/oradata/ORCL/HRINDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00049 to /oracleDB/app/oracle/oradata/ORCL/AVICERP_IDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00050 to /oracleDB/app/oracle/oradata/ORCL/AVICERP_TBS.dbf channel ORA_DISK_1: restoring datafile 00051 to /oracleDB/app/oracle/oradata/ORCL/AVICWMS_IDX_TBS.dbf channel ORA_DISK_1: restoring datafile 00052 to /oracleDB/app/oracle/oradata/ORCL/AVICWMS_TBS.dbf channel ORA_DISK_1: restoring datafile 00053 to /oracleDB/app/oracle/oradata/ORCL/AVICIDC_TBS.dbf channel ORA_DISK_1: restoring datafile 00054 to /oracleDB/app/oracle/oradata/ORCL/AVICIDC_IDX_TBS.dbf channel ORA_DISK_1: reading from backup piece /oracleDB/app/oracle/fast_recovery_area/ORCL_P/backupset/2019_12_23/o1_mf_nnndf_TAG20191223T092841_h0062bm7_.bkp channel ORA_DISK_1: piece handle=/oracleDB/app/oracle/fast_recovery_area/ORCL_P/backupset/2019_12_23/o1_mf_nnndf_TAG20191223T092841_h0062bm7_.bkp tag=TAG20191223T092841 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:01:26 Finished restore at 23-DEC-19 RMAN> recover database; Starting recover at 23-DEC-19 using channel ORA_DISK_1 starting media recovery media recovery complete, elapsed time: 00:00:03 Finished recover at 23-DEC-19 RMAN> alter database open; Statement processed RMAN> exit Recovery Manager complete. [oracle@dg1 ~]$ lsnrctl status LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 23-DEC-2019 15:13:52 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dg1)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 19-DEC-2019 10:45:38 Uptime 4 days 4 hr. 28 min. 14 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /oracleDB/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora Listener Log File /oracleDB/app/oracle/diag/tnslsnr/dg1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg1)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=dg1)(PORT=5500))(Security=(my_wallet_directory=/oracleDB/app/oracle/admin/orcl_p/xdb_wallet))(Presentation=HTTP)(Session=RAW)) Services Summary... Service "orcl" has 1 instance(s). Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... Service "orclXDB" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Service "orcl_p" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@dg1 ~]$ ```

linux下安装oracle11g后创建数据库报错(执行dbca命令)

UnsatisfiedLinkError exception loading native library: njni11 java.lang.UnsatisfiedLinkError: no njni11 in java.library.path Exception in thread "main" java.lang.UnsatisfiedLinkError: get at oracle.net.common.NetGetEnv.get(Native Method) at oracle.net.config.Config.getNetDir(Unknown Source) at oracle.net.config.Config.initConfig(Unknown Source) at oracle.net.config.Config.<init>(Unknown Source) 未提供命令行参数 "sysPassword" 的值。缺少此参数值将无法继续。

如何清除orcle中过期的归档日志

orcle中的归档日志太多了 导致orcle总是与服务器断开 怎么清除啊 网上的rman的方法也试了 总是失败

定量遥感中文版 梁顺林著 范闻捷译

这是梁顺林的定量遥感的中文版,由范闻捷等翻译的,是电子版PDF,解决了大家看英文费时费事的问题,希望大家下载看看,一定会有帮助的

Java 最常见的 200+ 面试题:面试必备

这份面试清单是从我 2015 年做了 TeamLeader 之后开始收集的,一方面是给公司招聘用,另一方面是想用它来挖掘在 Java 技术栈中,还有那些知识点是我不知道的,我想找到这些技术盲点,然后修复它,以此来提高自己的技术水平。虽然我是从 2009 年就开始参加编程工作了,但我依旧觉得自己现在要学的东西很多,并且学习这些知识,让我很有成就感和满足感,那所以何乐而不为呢? 说回面试的事,这份面试...

机器学习初学者必会的案例精讲

通过六个实际的编码项目,带领同学入门人工智能。这些项目涉及机器学习(回归,分类,聚类),深度学习(神经网络),底层数学算法,Weka数据挖掘,利用Git开源项目实战等。

远程工具,免费

远程工具,免费

java jdk 8 帮助文档 中文 文档 chm 谷歌翻译

JDK1.8 API 中文谷歌翻译版 java帮助文档 JDK API java 帮助文档 谷歌翻译 JDK1.8 API 中文 谷歌翻译版 java帮助文档 Java最新帮助文档 本帮助文档是使用谷

csma/ca和csma/cd的matlab仿真源代码带有详细的注释

csma/ca和csma/cd的matlab仿真源代码带有详细的注释,载波侦听,随意设置节点数,带有炫酷的图形展示效果。

Java基础知识面试题(2020最新版)

文章目录Java概述何为编程什么是Javajdk1.5之后的三大版本JVM、JRE和JDK的关系什么是跨平台性?原理是什么Java语言有哪些特点什么是字节码?采用字节码的最大好处是什么什么是Java程序的主类?应用程序和小程序的主类有何不同?Java应用程序与小程序之间有那些差别?Java和C++的区别Oracle JDK 和 OpenJDK 的对比基础语法数据类型Java有哪些数据类型switc...

软件测试入门、SQL、性能测试、测试管理工具

软件测试2小时入门,让您快速了解软件测试基本知识,有系统的了解; SQL一小时,让您快速理解和掌握SQL基本语法 jmeter性能测试 ,让您快速了解主流来源性能测试工具jmeter 测试管理工具-禅道,让您快速学会禅道的使用,学会测试项目、用例、缺陷的管理、

pokemmo的资源

pokemmo必须的4个rom 分别为绿宝石 火红 心金 黑白 还有汉化补丁 资源不错哦 记得下载

三个项目玩转深度学习(附1G源码)

从事大数据与人工智能开发与实践约十年,钱老师亲自见证了大数据行业的发展与人工智能的从冷到热。事实证明,计算机技术的发展,算力突破,海量数据,机器人技术等,开启了第四次工业革命的序章。深度学习图像分类一直是人工智能的经典任务,是智慧零售、安防、无人驾驶等机器视觉应用领域的核心技术之一,掌握图像分类技术是机器视觉学习的重中之重。针对现有线上学习的特点与实际需求,我们开发了人工智能案例实战系列课程。打造:以项目案例实践为驱动的课程学习方式,覆盖了智能零售,智慧交通等常见领域,通过基础学习、项目案例实践、社群答疑,三维立体的方式,打造最好的学习效果。

无线通信中的智能天线:IS-95和第3代CDMA应用_.pdf

无线通信中的智能天线:IS-95和第3代CDMA应用_.pdf

设计模式(JAVA语言实现)--20种设计模式附带源码

课程亮点: 课程培训详细的笔记以及实例代码,让学员开始掌握设计模式知识点 课程内容: 工厂模式、桥接模式、组合模式、装饰器模式、外观模式、享元模式、原型模型、代理模式、单例模式、适配器模式 策略模式、模板方法模式、观察者模式、迭代器模式、责任链模式、命令模式、备忘录模式、状态模式、访问者模式 课程特色: 笔记设计模式,用笔记串连所有知识点,让学员从一点一滴积累,学习过程无压力 笔记标题采用关键字标识法,帮助学员更加容易记住知识点 笔记以超链接形式让知识点关联起来,形式知识体系 采用先概念后实例再应用方式,知识点深入浅出 提供授课内容笔记作为课后复习以及工作备查工具 部分图表(电脑PC端查看):

Java8零基础入门视频教程

这门课程基于主流的java8平台,由浅入深的详细讲解了java SE的开发技术,可以使java方向的入门学员,快速扎实的掌握java开发技术!

玩转Linux:常用命令实例指南

人工智能、物联网、大数据时代,Linux正有着一统天下的趋势,几乎每个程序员岗位,都要求掌握Linux。本课程零基础也能轻松入门。 本课程以简洁易懂的语言手把手教你系统掌握日常所需的Linux知识,每个知识点都会配合案例实战让你融汇贯通。课程通俗易懂,简洁流畅,适合0基础以及对Linux掌握不熟练的人学习; 【限时福利】 1)购课后按提示添加小助手,进答疑群,还可获得价值300元的编程大礼包! 2)本月购买此套餐加入老师答疑交流群,可参加老师的免费分享活动,学习最新技术项目经验。 --------------------------------------------------------------- 29元=掌握Linux必修知识+社群答疑+讲师社群分享会+700元编程礼包。 &nbsp;

极简JAVA学习营第四期(报名以后加助教微信:eduxy-1)

想学好JAVA必须要报两万的培训班吗? Java大神勿入 如果你: 零基础想学JAVA却不知道从何入手 看了一堆书和视频却还是连JAVA的环境都搭建不起来 囊中羞涩面对两万起的JAVA培训班不忍直视 在职没有每天大块的时间专门学习JAVA 那么恭喜你找到组织了,在这里有: 1. 一群志同道合立志学好JAVA的同学一起学习讨论JAVA 2. 灵活机动的学习时间完成特定学习任务+每日编程实战练习 3. 热心助人的助教和讲师及时帮你解决问题,不按时完成作业小心助教老师的家访哦 上一张图看看前辈的感悟: &nbsp; &nbsp; 大家一定迫不及待想知道什么是极简JAVA学习营了吧,下面就来给大家说道说道: 什么是极简JAVA学习营? 1. 针对Java小白或者初级Java学习者; 2. 利用9天时间,每天1个小时时间; 3.通过 每日作业 / 组队PK / 助教答疑 / 实战编程 / 项目答辩 / 社群讨论 / 趣味知识抢答等方式让学员爱上学习编程 , 最终实现能独立开发一个基于控制台的‘库存管理系统’ 的学习模式 极简JAVA学习营是怎么学习的? &nbsp; 如何报名? 只要购买了极简JAVA一:JAVA入门就算报名成功! &nbsp;本期为第四期极简JAVA学习营,我们来看看往期学员的学习状态: 作业看这里~ &nbsp; 助教的作业报告是不是很专业 不交作业打屁屁 助教答疑是不是很用心 &nbsp; 有奖抢答大家玩的很嗨啊 &nbsp; &nbsp; 项目答辩终于开始啦 &nbsp; 优秀者的获奖感言 &nbsp; 这是答辩项目的效果 &nbsp; &nbsp; 这么细致的服务,这么好的氛围,这样的学习效果,需要多少钱呢? 不要1999,不要199,不要99,只要9.9 是的你没听错,只要9.9以上所有就都属于你了 如果你: 1、&nbsp;想学JAVA没有基础 2、&nbsp;想学JAVA没有整块的时间 3、&nbsp;想学JAVA没有足够的预算 还等什么?赶紧报名吧,抓紧抢位,本期只招300人,错过只有等时间待定的下一期了 &nbsp; 报名请加小助手微信:eduxy-1 &nbsp; &nbsp;

Python数据清洗实战入门

本次课程主要以真实的电商数据为基础,通过Python详细的介绍了数据分析中的数据清洗阶段各种技巧和方法。

董付国老师Python全栈学习优惠套餐

购买套餐的朋友可以关注微信公众号“Python小屋”,上传付款截图,然后领取董老师任意图书1本。

linux下利用/proc进行进程树的打印

在linux下利用c语言实现的进程树的打印,主要通过/proc下的目录中的进程文件,获取status中的进程信息内容,然后利用递归实现进程树的打印

MySQL数据库面试题(2020最新版)

文章目录数据库基础知识为什么要使用数据库什么是SQL?什么是MySQL?数据库三大范式是什么mysql有关权限的表都有哪几个MySQL的binlog有有几种录入格式?分别有什么区别?数据类型mysql有哪些数据类型引擎MySQL存储引擎MyISAM与InnoDB区别MyISAM索引与InnoDB索引的区别?InnoDB引擎的4大特性存储引擎选择索引什么是索引?索引有哪些优缺点?索引使用场景(重点)...

HoloLens2开发入门教程

本课程为HoloLens2开发入门教程,讲解部署开发环境,安装VS2019,Unity版本,Windows SDK,创建Unity项目,讲解如何使用MRTK,编辑器模拟手势交互,打包VS工程并编译部署应用到HoloLens上等。

150讲轻松搞定Python网络爬虫

【为什么学爬虫?】 &nbsp; &nbsp; &nbsp; &nbsp;1、爬虫入手容易,但是深入较难,如何写出高效率的爬虫,如何写出灵活性高可扩展的爬虫都是一项技术活。另外在爬虫过程中,经常容易遇到被反爬虫,比如字体反爬、IP识别、验证码等,如何层层攻克难点拿到想要的数据,这门课程,你都能学到! &nbsp; &nbsp; &nbsp; &nbsp;2、如果是作为一个其他行业的开发者,比如app开发,web开发,学习爬虫能让你加强对技术的认知,能够开发出更加安全的软件和网站 【课程设计】 一个完整的爬虫程序,无论大小,总体来说可以分成三个步骤,分别是: 网络请求:模拟浏览器的行为从网上抓取数据。 数据解析:将请求下来的数据进行过滤,提取我们想要的数据。 数据存储:将提取到的数据存储到硬盘或者内存中。比如用mysql数据库或者redis等。 那么本课程也是按照这几个步骤循序渐进的进行讲解,带领学生完整的掌握每个步骤的技术。另外,因为爬虫的多样性,在爬取的过程中可能会发生被反爬、效率低下等。因此我们又增加了两个章节用来提高爬虫程序的灵活性,分别是: 爬虫进阶:包括IP代理,多线程爬虫,图形验证码识别、JS加密解密、动态网页爬虫、字体反爬识别等。 Scrapy和分布式爬虫:Scrapy框架、Scrapy-redis组件、分布式爬虫等。 通过爬虫进阶的知识点我们能应付大量的反爬网站,而Scrapy框架作为一个专业的爬虫框架,使用他可以快速提高我们编写爬虫程序的效率和速度。另外如果一台机器不能满足你的需求,我们可以用分布式爬虫让多台机器帮助你快速爬取数据。 &nbsp; 从基础爬虫到商业化应用爬虫,本套课程满足您的所有需求! 【课程服务】 专属付费社群+每周三讨论会+1v1答疑

MySQL 8.0.19安装教程(windows 64位)

话不多说直接开干 目录 1-先去官网下载点击的MySQL的下载​ 2-配置初始化的my.ini文件的文件 3-初始化MySQL 4-安装MySQL服务 + 启动MySQL 服务 5-连接MySQL + 修改密码 先去官网下载点击的MySQL的下载 下载完成后解压 解压完是这个样子 配置初始化的my.ini文件的文件 ...

Python数据挖掘简易入门

&nbsp; &nbsp; &nbsp; &nbsp; 本课程为Python数据挖掘方向的入门课程,课程主要以真实数据为基础,详细介绍数据挖掘入门的流程和使用Python实现pandas与numpy在数据挖掘方向的运用,并深入学习如何运用scikit-learn调用常用的数据挖掘算法解决数据挖掘问题,为进一步深入学习数据挖掘打下扎实的基础。

深度学习原理+项目实战+算法详解+主流框架(套餐)

深度学习系列课程从深度学习基础知识点开始讲解一步步进入神经网络的世界再到卷积和递归神经网络,详解各大经典网络架构。实战部分选择当下最火爆深度学习框架PyTorch与Tensorflow/Keras,全程实战演示框架核心使用与建模方法。项目实战部分选择计算机视觉与自然语言处理领域经典项目,从零开始详解算法原理,debug模式逐行代码解读。适合准备就业和转行的同学们加入学习! 建议按照下列课程顺序来进行学习 (1)掌握深度学习必备经典网络架构 (2)深度框架实战方法 (3)计算机视觉与自然语言处理项目实战。(按照课程排列顺序即可)

网络工程师小白入门--【思科CCNA、华为HCNA等网络工程师认证】

本课程适合CCNA或HCNA网络小白同志,高手请绕道,可以直接学习进价课程。通过本预科课程的学习,为学习网络工程师、思科CCNA、华为HCNA这些认证打下坚实的基础! 重要!思科认证2020年2月24日起,已启用新版认证和考试,包括题库都会更新,由于疫情原因,请关注官网和本地考点信息。题库网络上很容易下载到。

Ubuntu18.04安装教程

Ubuntu18.04.1安装一、准备工作1.下载Ubuntu18.04.1 LTS2.制作U盘启动盘3.准备 Ubuntu18.04.1 的硬盘空间二、安装Ubuntu18.04.1三、安装后的一些工作1.安装输入法2.更换软件源四、双系统如何卸载Ubuntu18.04.1新的改变功能快捷键合理的创建标题,有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列...

sql语句 异常 Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your

在我们开发的工程中,有时候会报 [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ------ 这种异常 不用多想,肯定是我们的sql语句出现问题,下面...

西南交通大学新秀杯数学建模试题

题目比较难,如果符合大家的口味欢迎大家下载哈,提高你的思维想象能力

Windows版YOLOv4目标检测实战:训练自己的数据集

课程演示环境:Windows10; cuda 10.2; cudnn7.6.5; Python3.7; VisualStudio2019; OpenCV3.4 需要学习ubuntu系统上YOLOv4的同学请前往:《YOLOv4目标检测实战:训练自己的数据集》 课程链接:https://edu.csdn.net/course/detail/28745 YOLOv4来了!速度和精度双提升! 与 YOLOv3 相比,新版本的 AP (精度)和 FPS (每秒帧率)分别提高了 10% 和 12%。 YOLO系列是基于深度学习的端到端实时目标检测方法。本课程将手把手地教大家使用labelImg标注和使用YOLOv4训练自己的数据集。课程实战分为两个项目:单目标检测(足球目标检测)和多目标检测(足球和梅西同时检测)。 本课程的YOLOv4使用AlexyAB/darknet,在Windows系统上做项目演示。包括:安装软件环境、安装YOLOv4、标注自己的数据集、整理自己的数据集、修改配置文件、训练自己的数据集、测试训练出的网络模型、性能统计(mAP计算)和先验框聚类分析。还将介绍改善YOLOv4目标检测性能的技巧。 除本课程《Windows版YOLOv4目标检测实战:训练自己的数据集》外,本人将推出有关YOLOv4目标检测的系列课程。请持续关注该系列的其它视频课程,包括: 《Windows版YOLOv4目标检测实战:人脸口罩佩戴检测》 《Windows版YOLOv4目标检测实战:中国交通标志识别》 《Windows版YOLOv4目标检测:原理与源码解析》

Spring Boot -01- 快速入门篇(图文教程)

Spring Boot -01- 快速入门篇 今天开始不断整理 Spring Boot 2.0 版本学习笔记,大家可以在博客看到我的笔记,然后大家想看视频课程也可以到【慕课网】手机 app,去找【Spring Boot 2.0 深度实践】的课程,令人开心的是,课程完全免费! 什么是 Spring Boot? Spring Boot 是由 Pivotal 团队提供的全新框架。Spring Boot...

相关热词 aero c# c#压缩图片 c# udp服务器 100线程 c# c# fidller请求 c# 参数 调用exe c# 打字母小游戏 c#显示未能加载文件 c# 右击菜单加快捷键 c#将重复的数据保留一条
立即提问