Oracle database backup and restore Notes

There are three ways of Oracle backup and restore. They are export/import, hot backup and cold backup. Export/import is a logical backup, while hot and cold backups are physical backups. [References( https://blog.csdn.net/happylee6688/article/details/13620937]) Only the way the export/import backups and restores are recorded here. In the actual ...

Posted on Sat, 12 Oct 2019 02:48:38 -0700 by warmwind

Interpretation of Oracle Connection Configuration

After installing ORACLE database software, dbca needs to configure listener to connect to database after installing database. Here are some concepts that are difficult to understand and record some of the conclusions of the analysis. Start with the connection end. 1. How to connect database oracle's connection string consists of several parts. ...

Posted on Mon, 16 Sep 2019 01:17:52 -0700 by rslnerd

Initial level Oracle 12C database migration to Oracle 18C and some basic data query methods

The good news is that the assessment project has been completed independently, but it has exceeded the scheduled date. I don't know what the final evaluation will be. My heart is still a little cold! However, in the future, I will not simply take the needs of the company as my own needs to develop, but will follow the trend to learn useful know ...

Posted on Mon, 29 Jul 2019 04:50:28 -0700 by gilbertwang

ORA-01017 Errors and Some Typical Cases

Summary Basic Ideas for Resolving ORA-01017 Errors Documents and information that need to be viewed in general Case 1 Error 11g Case Sensitive due to password enhancement to ORA-01017 Case 2: ORA-01017 caused by case 2 password file password file Case 3: ORA-01017 error 121122 Password Version Exclusively due to password enhancement Case 4 ...

Posted on Tue, 25 Jun 2019 14:55:00 -0700 by sandeepjayan

ORA-00600 [kcratr_nab_less_than_odr] [4194] Error Resolution

Business Scenario: The company's cable was broken, and the sudden power outage caused by the downtime.  [oracle@slave1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 17 11:09:59 2017 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 6 ...

Posted on Thu, 14 Feb 2019 14:33:18 -0800 by Eclectic

2017-11-21 DBA diary, oracle asm ha configuration full record

Case Description In order to achieve high availability of ORACLE DATABASE, but there is not enough budget to purchase ORACLE RAC components, we have to use HA architecture. In the past, we usually used HA software based on operating system layer + ORACLE + file system (based on operating system layer, such as ext4,jfs2 to store data). This ...

Posted on Fri, 11 Jan 2019 16:33:11 -0800 by tycragg

Preparations for installation of Oracle 11gR2 under suse linux 11sp1 and basic settings for completion of installation

Installation of oracle Database Detection and Completion of RPM Packets Required binutils-2.19,gcc-4.3,gcc-c++-4.3,glibc-2.9,glibc-devel-2.9,ksh-93t,libstdc++33-3.3.3,libstdc++43-4.3.3_20081022,libstdc++43-devel-4.3.3_20081022,libaio-0.3.104,libaio-devel-0.3.104,libgcc43-4.3.3_20081022,libstdc++-devel-4.3,make-3.81,sysstat-8.1.5 You can use ...

Posted on Tue, 18 Dec 2018 23:45:04 -0800 by habib009pk

11.2.0.3.0 Play PSU Patch - Automation (p14727347_112030_AIX64-5L.zip)

11.2.0.3.0 dozen PSU patches (p14727347_112030_AIX64-5L.zip) Operating System Platform AIX 61009 grid and oracle versions 11.2.0.3   Preparations before patching 1. Backup the spfile file of ASM/RDBMS grid users $sqlplus '/as sysasm' SQL>create pfile='/apps/*****/backup/pfile_grid_201410.ora' from spfile; ora ...

Posted on Wed, 12 Dec 2018 04:48:06 -0800 by stridox