Specific steps of oracle rman recovery
rman uses level 0 backup set for different recovery
$ rman target /
/*
It is used for testing. It is found that the test fails. It is very useful if you need to restore spfile
There is no parameter file. An instance of DUMMY will be generated under the command of RMAN
RMAN> set dbid=1234567890;
*/
Start datab ...
Posted on Sat, 02 May 2020 14:32:50 -0400 by dalecosp
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