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
/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
/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
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
@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
所有实例和服务的状态 $ 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
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
/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
/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
---------------- /oradata/orcl/system01.dbf /oradata/orcl/sysaux01.dbf /oradata/orcl/undotbs01.dbf /oradata.../orcl/users01.dbf /oradata/orcl/example01.dbf /oradata/orcl/ogg01.dbf 6 rows selected....+DATA/orcl/datafile/users.278.1068222161 +DATA/orcl/datafile/example.275.1068222157 +DATA/orcl/tempfile...+DATA/orcl/onlinelog/group_3.282.1068223535 +DATA/orcl/controlfile/control01.ctl +DATA/orcl/controlfile...-n orcl -a DATA [oracle@s11g ~]$ srvctl config database -d orcl Database unique name: orcl Database
/sqlplus/admin/plustrce.sql即可: SYS@orcl> @?.../sqlplus/admin/plustrce.sql SYS@orcl> SYS@orcl> drop role plustrace; drop role plustrace *...SYS@orcl> SYS@orcl> grant select on v_$sesstat to plustrace; Grant succeeded....SYS@orcl> grant select on v_$mystat to plustrace; Grant succeeded....SYS@orcl> SYS@orcl> set echo off SYS@orcl> 可以看到这个角色就是封装了对v_$sesstat,v_$statname,v_$mystat这几个视图的查询权限。
__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
领取专属 10元无门槛券
手把手带您无忧上云