HOST = 158.58.88.102)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = eskdb))) 按网上所说的道理， 1、最后的orcl...是数据库名称，我数据库名称就是eskdb，但是不对 2、最后的orcl是 service_name 但是配置的SERVICE_NAME 也是 eskdb 最后纠结无语，找数据库DBA帮忙，...不对，于是更改url为 url=jdbc:oracle:thin:@158.58.88.102:1521: eskdb1 然后重启项目，OK了 得出结论：数据库url连接最后一个 orcl
Q 题目 The ORCL database has CONTROL FILE AUTOBACKUP and BACKUP OPTIMIZATION enabled.TBS1 and TBS2 are...the only user-defined tablespaces in ORCL.USER1.EMP is able in TBS1.
所有实例和服务的状态 $ srvctl status database -d orcl Instance orcl1 is running on node linux1 Instance orcl2.../orcl/onlinelog/group_4.260.570918295 +ORCL_DATA1/orcl/controlfile/current.259.570913189 +ORCL_DATA1/...orcl/datafile/example.257.570913311 +ORCL_DATA1/orcl/datafile/indx.270.570920045 +ORCL_DATA1/orcl/datafile...+ORCL_DATA1/orcl/datafile/undotbs1.271.570920865 +ORCL_DATA1/orcl/datafile/undotbs2.265.570913331 +ORCL_DATA1.../orcl/datafile/undotbs2.272.570921065 +ORCL_DATA1/orcl/datafile/users.264.570913355 +ORCL_DATA1/orcl/
/orcl@orcl file=d:\orcl_full.dmp full=y 非DBA用户使用full=y参数会报错： exp scott/scott@orcl file=d:\1.dmp full=.../scott@orcl file=d:\scott.dmp # 同exp scott/scott@orcl file=d:\scott.dmp owner=scott exp system/orcl@orcl..., scott.salgrade) exp system/orcl@orcl file=d:\scott_dept.dmp tables=scott.dept exp system/orcl@orcl...@orcl file=d:\orcl_full.dmp # IMP-00031：必须指定FULL=y或提供FROMUSER/TOUSER或TABLES参数 imp system/orcl@orcl file.../orcl@orcl file=d:\orcl_full.dmp FROMUSER=scott, test # 观察到scott用户的表对象，test的函数对象被成功还原 imp system/orcl
环境准备 主机名 ip DB Version db_name db_unique_name 主库 orcl 192.168.56.120 11.2.0.4 orcl orcl 备库 orcl_stby...192.168.56.121 11.2.0.4 orcl orcl_stby Notes： 1、db_unique_name主备库不能相同。...##第二个orcl是TNSNAME CREATE CONFIGURATION pri AS PRIMARY DATABASE IS orcl CONNECT IDENTIFIER IS orcl;...##第一个orcl_stby是db_unique_name ##第二个orcl_stby是TNSNAME ADD DATABASE orcl_stby AS CONNECT IDENTIFIER IS...##备库DGMGRL操作 FAILOVER TO orcl_stby IMMEDIATE; ? 原主库切换为备库： ##备库DGMGRL操作 REINSTATE DATABASE orcl; ?
/redo03.log' to '/oradata/ORCL_STBY/redo03.log'; alter database rename file '/oradata/ORCL/redo02.log.../ORCL_STBY/redo01.log'; alter database rename file '/oradata/ORCL/standby_redo04.log' to '/oradata/ORCL_STBY.../ORCL_STBY/pdbseed/system01.dbf", "/oradata/ORCL_STBY/pdbseed/sysaux01.dbf", "/oradata/ORCL_STBY/.../redo03.log /oradata/ORCL_STBY/redo02.log /oradata/ORCL_STBY/redo01.log /oradata/ORCL/standby_redo04....log /oradata/ORCL/standby_redo05.log /oradata/ORCL/standby_redo06.log /oradata/ORCL/standby_redo07.log
directory DATA_DUMP_ORCL as '/oradata/rmanbak/orcl'; 3、创建DBLINK ##创建ORCL的dblink用来传输dump到本地 sqlplus /...导出命令脚本 cat /oradata/rmanbak/orcl/expdp_all_orcl.txt directory=DATA_DUMP_ORCL dumpfile=orcl_\%U.dmp.../rmanbak/orcl/orcl_02.dmp /oradata/rmanbak/orcl/orcl_03.dmp /oradata/rmanbak/orcl/orcl_04.dmp /...oradata/rmanbak/orcl/orcl_05.dmp /oradata/rmanbak/orcl/orcl_06.dmp /oradata/rmanbak/orcl/orcl_07....dmp /oradata/rmanbak/orcl/orcl_08.dmp 限制: 1.
:00 1 orcl ORCL 6729 17 4月 2019 02:00 1 orcl ORCL 6730 17...4月 2019 03:00 1 orcl ORCL 6731 17 4月 2019 04:00 1 orcl ORCL...6732 17 4月 2019 05:00 1 orcl ORCL 6733 17 4月 2019 06:00 1 orcl ORCL...:00 1 orcl ORCL 6729 17 4月 2019 02:00 1 orcl ORCL 6730 17...4月 2019 03:00 1 orcl ORCL 6731 17 4月 2019 04:00 1 orcl ORCL
所有实例和服务的状态 $ srvctl status database -d orcl Instance orcl1 is running on node linux1 Instance orcl2.../orcl/onlinelog/group_4.260.570918295 +ORCL_DATA1/orcl/controlfile/current.259.570913189 +ORCL_DATA1.../orcl/datafile/example.257.570913311 +ORCL_DATA1/orcl/datafile/indx.270.570920045 +ORCL_DATA1/orcl/.../undotbs1.261.570913263 +ORCL_DATA1/orcl/datafile/undotbs1.271.570920865 +ORCL_DATA1/orcl/datafile/...+ORCL_DATA1/orcl/onlinelog/group_2.263.570913205 +ORCL_DATA1/orcl/onlinelog/group_3.266.570918279
/control01.ctl | more }|{z JORCL L-+RG +ORCL +ORCL orcl orcl -+-=' -+-=' /u01/app/oracle/oradata.../orcl/redo03.log /u01/app/oracle/oradata/orcl/redo3.log /u01/app/oracle/oradata/orcl/redo02.log /u01...orcl/tbs1_2.dbf /u01/app/oracle/oradata/orcl/tbs1_1.dbf /u01/app/oracle/oradata/orcl/example01.dbf.../oradata/orcl/redo02.log /u01/app/oracle/oradata/orcl/redo2.log /u01/app/oracle/oradata/orcl/redo01...ls /u01/app/oracle/admin/orcl/udump/*5110.* -- */ /u01/app/oracle/admin/orcl/udump/orcl_ora_5110.trc
@PCNAME-orcl labs]$ rm /u01/app/oracle/oradata/orcl/example01.dbf [oracle@PCNAME-orcl labs]$ SYS@orcl.../oradata/orcl/ora_control* /u01/app/oracle/oradata/orcl/ora_control01 /u01/app/oracle/oradata/orcl/...ora_control02 [oracle@PCNAME-orcl orcl]$ mv /u01/app/oracle/oradata/orcl/ora_control01 /u01/app/oracle.../oradata/orcl/ora_control01.bak [oracle@PCNAME-orcl orcl]$ mv /u01/app/oracle/oradata/orcl/ora_control02....bak [oracle@PCNAME-orcl orcl]$ [oracle@PCNAME-orcl orcl]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0
/ORCL/sysaux01.dbf /oradata/ORCL/undotbs01.dbf /oradata/ORCL/pdbseed/system01.dbf /oradata/ORCL/pdbseed.../sysaux01.dbf /oradata/ORCL/users01.dbf /oradata/ORCL/pdbseed/undotbs01.dbf 7 rows selected....ORCL [oracle@orcl19c:/home/oracle]$ cat $ORACLE_HOME/network/admin/tnsnames.ora # tnsnames.ora Network...LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl19C)(PORT = 1521)) ORCL = (DESCRIPTION =...) (SERVICE_NAME = orcl) ) ) 使用 tnsnames 服务名登录 [oracle@orcl19c:/home/oracle]$ sqlplus sys
/orcl2/database/ [root@ orcl2 database]# cd ....@orcl2 ~]$ exit logout [root@orcl2 database]# cd /u01/app/12.1.0/grid/bin/ [root@orcl2 bin]# ....[root@orcl2 bin]# [root@orcl2 bin]# cd /u01/app/grid/tfa/orcl2/database/BERKELEY_JE_DB [root@orcl2...@orcl2 bin]# ....TFA Started and listening for commands [root@orcl2 bin]# [root@orcl2 bin]# cd /u01/app/grid/tfa/orcl2
/oradata/orcl/Test.dbf /u01/app/oracle/oradata/orcl/ORCL/datafile/o1_mf_s_5vrl1t7h_.dbf /*查看物理文件，缺省为.../oradata/orcl/Test.dbf /u01/app/oracle/oradata/orcl/ORCL/datafile/o1_mf_s_5vrl1t7h_.dbf /u01/app/oracle.../oradata/orcl/ORCL/datafile/o1_mf_t_5vrlgqtl_.dbf SQL> ho ls -lh /u01/app/oracle/oradata/orcl/ORCL/datafile.../oradata/orcl/Test.dbf /u01/app/oracle/oradata/orcl/ORCL/datafile/o1_mf_s_5vrl1t7h_.dbf /u01/app/oracle.../oradata/orcl/Test.dbf /u01/app/oracle/oradata/orcl/ORCL/datafile/o1_mf_s_5vrl1t7h_.dbf SQL> ho ls
06:38:25.INF – Import of policy orcl9i_oracle_database, schedule Default-Application-Backup (orcl9i_...INF – Importing policy orcl9i_oracle_database, schedule Default-Application-Backup (orcl9i_1400020689...INF – Importing policy orcl9i_oracle_database, schedule Default-Application-Backup (orcl9i_1400020688...INF – Importing policy orcl9i_oracle_database, schedule Default-Application-Backup (orcl9i_1400020351...[root@nbu71 images]# cd orcl9i[root@nbu71 orcl9i]# ls1400000000[root@nbu71 orcl9i]# cd 1400000000/[root
二、环境准备 主机名 ip DB Version db_name db_unique_name 主库 orcl 192.168.56.120 11.2.0.4 orcl orcl 备库 orcl_stby...192.168.56.121 11.2.0.4 orcl orcl_stby Notes： 1、db_unique_name主备库不能相同。.../AllOracleSilent.sh -i 192.168.56.120 -d 11g -n orcl -o orcl -b /u01/app -s AL32UTF8 ?...; ALTER SYSTEM SET FAL_CLIENT=ORCL; ALTER SYSTEM SET DB_FILE_NAME_CONVERT='/oradata/orcl','/oradata/orcl...*.fal_client='ORCL_STBY' *.fal_server='ORCL' *.log_archive_config='DG_CONFIG=(ORCL_STBY,ORCL)' *.log_archive_dest
/system01.dbf /oradata/orcl11g/sysaux01.dbf /oradata/orcl11g/undotbs01.dbf /oradata/orcl11g/users01.dbf...:/oradata/ORCL11G/datafile]$ mv o1_mf_test_j7jfm30c_.dbf /oradata/orcl11g/test01.dbf [oracle@orcl11g:.../system01.dbf /oradata/orcl11g/sysaux01.dbf /oradata/orcl11g/undotbs01.dbf /oradata/orcl11g/users01.dbf.../system01.dbf /oradata/orcl11g/sysaux01.dbf /oradata/orcl11g/undotbs01.dbf /oradata/orcl11g/users01.dbf.../oradata/orcl11g/example01.dbf /oradata/orcl11g/test01.dbf 6 rows selected.
__db_cache_size=889192448orcl.__java_pool_size=16777216orcl.__large_pool_size=33554432orcl....__pga_aggregate_target=419430400orcl.__sga_target=1241513984orcl.__shared_io_pool_size=0orcl....__shared_pool_size=285212672orcl..../app/oracle/fast_recovery_area/orcl/control02.ctl'*.db_block_size=8192*.db_domain=''*.db_name='orcl'*.../adumpmkdir -p /oradata/orcl/mkdir -p /u01/app/oracle/fast_recovery_area/orcl/mkdir /archivelogmkdir
suse11a:oracle:orcl101 > sqlplus -v SQL*Plus: Release 10.2.0.5.0 - Production suse11a:oracle:orcl101...orcl102 $ srvctl start service -d orcl10 -s statspack_suse11a_srvc $ srvctl start service -d orcl10...(s) orcl102, orcl101 Service statspack_suse11a_srvc is running on instance(s) orcl101 Service statspack_suse11b_srvc...is running on instance(s) orcl102 $ srvctl config service -d orcl10 orcl10_srv PREF: orcl102...orcl101 AVAIL: statspack_suse11a_srvc PREF: orcl101 AVAIL: statspack_suse11b_srvc PREF: orcl102 AVAIL
领取专属 10元无门槛券
手把手带您无忧上云
云服务器
ICP备案
对象存储
即时通信 IM
实时音视频
