How Oracle Regulates Cleaning v$archived_log Records

There are many V $archived_logs on the stand-alone instance, and there are tens of thousands of records, so you have to clean them up, otherwise every query will be scrolled directly. SQL> select sequence#,applied from v$archived_log order by sequence# ; SEQUENCE# APPLIED .................... SEQU ...

Posted on Sun, 13 Oct 2019 07:48:10 -0700 by mk1200

Why does RMAN control the name format of automatic file backup not follow the% F rule

The simpler the question in Oracle, the more difficult it is to find the answer. For example: Have you ever noticed that when backing up RMAN, the name of the automatically generated control file is generated according to the% F rule? The format of automatic backup path for control files is described in detail in another blog post. Click on ...

Posted on Sun, 09 Jun 2019 18:08:24 -0700 by Hebbs

Migrating Oracle 11g R2 To Oracle 19c

All environments in this article use the same operating system: Oracle Linux 7.5.11g data files are stored on the file system, 19c data files are stored on ASM, NFS is used to temporarily store data files in the middle, and then migrated through rman's transportable tablespace characteristics. 1. Source End Check Since rman cannot automaticall ...

Posted on Mon, 29 Apr 2019 04:30:36 -0700 by dotbands

Oracle Control File

Article directory 1. Functions and characteristics 2. Control the location of files 3. File Update Mechanism 4. Actual combat: control file diversification (multiplexing) 5. Actual combat: backup and reconstruction of control files 6. Method of Restoring Control Documents 1. Functions and characteristics Record the curr ...

Posted on Mon, 22 Apr 2019 18:09:34 -0700 by vikette

RMAN-04006: error from auxiliary database

During the construction of Oracle 11g RAC + DG, the following mistakes were made when duplicate was carried out in the backup:[oracle@xxxx-dg:/u01/app/oracle/11.2/db_1/dbs]$rman target sys/password@racdb  auxiliary sys/password@racdg nocatalog Recovery Manager: Release 11.2.0.4.0 - Product ...

Posted on Tue, 12 Feb 2019 04:21:21 -0800 by techmeister

Using RMAN duplicate to build 12C Data Guard environment

1. Experimental environment   Main end Backup terminal host name 12cr2 oracle IP address 192.168.16.81 192.168.16.130 db_unique_name newcdb newcdbdg 2. Host database environment [oracle@12cr2 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Sat Jun ...

Posted on Wed, 26 Dec 2018 13:57:06 -0800 by garry