Using dbms_file_transfer
All steps in this procedure are run as the oracle user that is a member of the OSDBA group. OS authentication is used to connect to both the source and destination databases. Initial Setup 1.1 创建 xtts 目录，解压 rman_xttconvert_v3.zip 软件包 mkdir -p /home/oracle/xtts/backupmkdir -p /home/oracle/xtts/backup_incrmkdir -p /home/oracle/xtts/scriptscd /home/oracle/xttsunzip rman_xttconvert_v3.zip 1.2 配置 xtt.properties 参数 cat > xtt.properties << 'EOF'tablespaces=TBS_COCO,ITPUX01,ITPUX02,ITPUX03...
Prerequisites of XTTS
Prerequisites of XTTS 平台字节序和字符集，不支持 Windows 平台，源端与目标端的字符集需相同 -- 查询平台和字节序col PLATFORM_NAME format a30SELECT d.PLATFORM_ID,d.PLATFORM_NAME, tp.ENDIAN_FORMAT FROM V$TRANSPORTABLE_PLATFORM tp, V$DATABASE d WHERE tp.PLATFORM_NAME = d.PLATFORM_NAME;-- 查询字符集select * from nls_database_parameters where parameter like '%CHARACTERSET%';select userenv('language') from dual; 数据库时区，源端与目标端的时区需相同 select dbtimezone from dual; 数据库版本及补丁，源端 ≥10.2.0.3 企业版，目标端 ≥11.2.0.4 企业版 select * from v$version;SELECT * ...
SQLServer AlwaysOn Database Cannot Shrink Log File
SQLServer AlwaysOn Database Cannot Shrink Log File SQLServer - 2016 After the AlwaysOn database transaction log is truncated, the log file cannot be shrink, resulting in a large amount of disk space occupied by the log file. Solution If you have scheduled T-Log Backup on alwaysOn Database, After completion of T-Log Backup check the log_reuse_wait_desc of database using query select name,log_reuse_wait_desc from sys.databases where name like 'Name Of Database'; If column log_reuse_wait_des...
Orphaned Users of SQLServer
Orphaned Users of SQLServer Detect orphaned users. SELECT dp.type_desc, dp.sid, dp.name AS user_nameFROM sys.database_principals AS dpLEFT JOIN sys.server_principals AS sp ON dp.sid = sp.sidWHERE sp.sid IS NULL AND dp.authentication_type_desc = 'INSTANCE'; Resolve an orphaned user. CREATE LOGIN <login_name>WITH PASSWORD = '<use_a_strong_password_here>',SID = <SID>;ALTER USER <user_name> WITH Login = <login_name>;ALTER LOGIN <login_name> WITH PASS...
Using Recovery Manager
All steps in this procedure are run as the oracle user that is a member of the OSDBA group. OS authentication is used to connect to both the source and destination databases. Initial Setup 1.1 创建 xtts 目录，解压 rman_xttconvert_v3.zip 软件包 mkdir -p /home/oracle/xtts/backupmkdir -p /home/oracle/xtts/backup_incrmkdir -p /home/oracle/xtts/scriptscd /home/oracle/xttsunzip rman_xttconvert_v3.zip 1.2 配置 xtt.properties 参数 cat > xtt.properties << 'EOF'tablespaces=TBS_COCO,ITPUX01,ITPUX02,ITPUX03...
Setting Container Restart Policy
Setting Container Restart Policy To configure the restart policy for a container, use the --restart flag when using the docker run command. The value of the --restart flag can be any of the following: Flag Description no Do not automatically restart the container. (the default) on-failure[:max-retries] Restart the container if it exits due to an error, which manifests as a non-zero exit code. Optionally, limit the number of times the Docker daemon attem...
Using sp_help_revlogin transfer logins and passwords
Using sp_help_revlogin transfer logins and passwords Run the following script: USE masterGOIF OBJECT_ID ('sp_hexadecimal') IS NOT NULL DROP PROCEDURE sp_hexadecimalGOCREATE PROCEDURE sp_hexadecimal @binvalue varbinary(256), @hexvalue varchar (514) OUTPUTASDECLARE @charvalue varchar (514)DECLARE @i intDECLARE @length intDECLARE @hexstring char(16)SELECT @charvalue = '0x'SELECT @i = 1SELECT @length = DATALENGTH (@binvalue)SELECT @hexstring = '0123456789ABCDEF'WHILE (@i <= @length)BEGIN...
Oracle Docker Image Overview
Oracle Docker Image Overview Sample ~]$ git clone https://github.com/SakuraYumeno/docker-images.git~]$ cd docker-images/oracle/11.2.0.4/assets/~]$ docker build -t sakura/database:11.2.0.4-ee .~]$ docker run -d --privileged --name oracle11g-1 -p 15211:1521 -p 2201:22 -ip 172.17.0.2 -v /mnt/e/Temp/oracle/11.2.0.4:/install -v /mnt/e/Temp/datapump:/datapump sakura/database:11.2.0.4-ee Default Setting Database located in /u01/app/oracle directory. OS users: root/welcome oracle/oracle DB users:...
MySQL Docker Image Overview
MySQL Docker Image Overview Start a mysql server instance Starting a MySQL instance is simple: docker run --name some-mysql -p 33060:3306 -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:tag where some-mysql is the name you want to assign to your container, my-secret-pw is the password to be set for the MySQL root user and tag is the tag specifying the MySQL version you want. See the list above for relevant tags. Using a custom MySQL configuration file T...
Installing Docker Engine on Fedora
Installing Docker Engine on Fedora Uninstall old versions Older versions of Docker were called docker or docker-engine. If these are installed, uninstall them, along with associated dependencies. sudo dnf remove docker \ docker-client \ docker-client-latest \ docker-common \ docker-latest \ docker-latest-logrotate \ docker-logrotate \ docker-selinux \ docker-engine-selinux \ docker-engine Set up the dnf repository Install the dnf-plugins-core package (whic...
