Oracle single instance migration to Oracle single instance

Catalog 1. Environment deployment 2 1. 1. Modify the database to archive mode. 2 1. 2 create test table 2 2. Backup preparation 2 2. 1 full database backup 2 2. 2 copy parameter file 2 2. 2. 1 view parameter file path 2 2. 2.2 copy parameter file 3 2. 2.4 creating dynamic files 3 2. 5 copying archives 3 ...

Posted on Fri, 13 Mar 2020 05:50:20 -0400 by lin

RMAN Migration Library in ORACLE10G Non-archiving Mode

Environmental information: Source Library Target Library operating system WIN7 WIN SVR 2012 R2 IP x.x.x.216 x.x.x.112 Database Version 10.2.0.4.0 - 64bi 10.2.0.4.0 - 64bi Storage Single instance Single instance ORACLE_HOME D:\oracle\product\10.2.0\db_1 D:\oracle\product\10.2.0\db_1 ORACLE_SID ORCL ORCL RMAN Recovery Idea Ste ...

Posted on Sat, 04 Jan 2020 15:12:49 -0500 by davidz

Duplicate replicates the database and creates a physical StandBy(spfile + different instance names + different paths)

Processes and Duplicate replicates the database and creates a physical StandBy Similarly, you just don't need to restart the database. Objective: To create standby without restarting the source database 1 Set the environment as follows: Primary Database IP 172.17.22.16 SID orcl Standby database IP 172.17.22.17 SID orcl_standby Set p ...

Posted on Sat, 04 Jan 2020 01:42:30 -0500 by jbbadaz

Oracle Dataguard next block repair technology system data table

To test the scenario when the following system table OBJ $has bad blocks, can the database automatically repair the bad blocks? (I) database environment # Database version sys@ORCL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release ...

Posted on Sat, 07 Dec 2019 21:57:53 -0500 by stuartshields

Oracle DG--Rman backup set to build a backup database

There are two common ways to build online backup databases: Rman auxiliary and Rman backup set recovery.(1)When the environment configuration is OK, a Rman command can be used to complete the initialization synchronization of the standby database, which is relatively simple. # Land rman target sys/Oracle123@orcl_pri auxiliary sys/Oracle123@orcl ...

Posted on Mon, 02 Dec 2019 00:08:57 -0500 by jeff_lawik

Record the irresponsible way of filing and supporting explosion in the first guide warehouse

There is another problem in the test data verification, but the card owner is still in the process of importing. Then I look at the logs and find that a large number of archive logs are generated during the import of impdp, so the storage and archive space is full, so it gets stuck Tail / u01 / APP / Oracle / diag / RDBMS / zhanky / zhanky / ...

Posted on Fri, 15 Nov 2019 16:21:29 -0500 by bo0

New feature of Oracle 12c -- PDBs point in time recoverys

concept You can now recover a PDB to a specific point-in-time. This feature is a high availability enhancement for consolidation and extends point-in-time recovery functionality to PDBs. You can now restore the PDB to a specific point in time. This feature is a high availability enhancement to consolidation and extends point t ...

Posted on Mon, 11 Nov 2019 17:52:14 -0500 by Taro

Recover standby database after primary resetlogs

Generally, when the main library needs to be restored and opened by open resetlogs, the standby needs to be redo to construct the main and standby synchronization architecture. But in some cases, it is not necessary to spend a lot of time. Only the flash back function of the standby needs to be turned on, the main and standby synchronization pr ...

Posted on Tue, 22 Jan 2019 11:51:13 -0500 by 9999

ORACLE uses rman backup to restore and recover standby library ORA-10877

1. standby exception reporting Yesterday morning, a sudden surge in disk space led to an abnormal oracle backup, alarm, and then came to clean up the backup files of the disk. After that, the archive log can be synchronized. However, the standby found that the mrp did not start. The background error was as follows: google, said that this ...

Posted on Sun, 09 Dec 2018 21:48:04 -0500 by nadnad