In the process of configuration, initiation and recovery of Oracle database backup, many Oracle database commands are needed. In this chapter, I will sort out the commands for your reference.
Oracle user and instance related commands
# ps -ef | grep [p]mon
orauxdb 18751 1 ...
Posted by n8r0x on Sun, 02 Feb 2020 01:09:46 -0800
1. Complete database migration
2. Reorganization of database file structure
3. Verify data file integrity
Detailed Data Migration Scheme
1. Overview of the migration environment
2. source database
Database version Oracle 10g release 2
Posted by angershallreign on Mon, 27 May 2019 17:02:04 -0700
This paper contains the following two knowledge points. The environmental information is shown in the following figure:
Deploy Data Guard service;
Configuration and use of Data Guard Broker.I. Deployment of Physical Standby
1.1 Main Library Preparations
1.1.1 Enable force logging
SQL> ALTER DATABASE FORCE LOGGING;
1.1.2 Create standby data ...
Posted by alin19 on Fri, 17 May 2019 08:49:27 -0700
A friend asked such a question:
Fri May 25 20:46:06 2007 //Automatic backup control file
Starting control autobackup
Control autobackup written to DISK device
Fri May 25 20:46:11 2007 //Log switching occurs
Thread 1 advanced to log sequence 535
Posted by Timma on Sun, 21 Apr 2019 14:30:34 -0700
This paper refers to: Le Shami's World
For physically damaged data blocks, we can complete the recovery of damaged blocks through the RMAN Block Media Recovery (BLOCK MEDIA RECOVERY) function without requiring the whole recovery. data base Or all files to repair these small amounts of damaged data blocks. Restoring the entire database or ...
Posted by walkonet on Mon, 08 Apr 2019 12:39:30 -0700
From --------------------- http://blog.csdn.net/zwk626542417/article/details/39667999
Today, as usual, landing PL/SQL did fail. An error "ORA-01034" and "ORA-27101" appeared as follows:
Then it logs in through a command prompt. Oracle To see what's going on, and then the problem goes on, the e ...
Posted by lulon83 on Wed, 27 Mar 2019 16:09:32 -0700
During the RECOVER restoration process of RMAN, the RMAN interface is normal, but the alarm log is checked and refreshed. It is found that there is ORA-279 in the alarm log, as follows:
alter database recover logfile '/u06/archivelog/2019_02_19/o1_mf_1_16228_g6oznpbv_.arc'
Thu Feb 21 08:49:48 CST 2019
Media Recovery Log /u06/archivelog/2019_ ...
Posted by delassus on Thu, 28 Feb 2019 20:51:22 -0800
0x00 - Introduction to Environment
VMware version: VMware 12pro
Host operating system: RHEL6.5_64
Shared Storage Creates Shared Disk Files Using VMWARE
Database version: Oracle 11gR2 126.96.36.199.0_RAC
Oracle database files are deployed on ASM disk groups and need to complete storage migration without downtime or as short as possible. Because it is ...
Posted by aeboi80 on Tue, 18 Dec 2018 09:00:06 -0800