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
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
WIN SVR 2012 R2
10.2.0.4.0 - 64bi
10.2.0.4.0 - 64bi
RMAN Recovery Idea Ste ...
Posted on Sat, 04 Jan 2020 15:12:49 -0500 by davidz
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:
Set p ...
Posted on Sat, 04 Jan 2020 01:42:30 -0500 by jbbadaz
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;
Oracle Database 11g Enterprise Edition Release ...
Posted on Sat, 07 Dec 2019 21:57:53 -0500 by stuartshields
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.
rman target sys/Oracle123@orcl_pri auxiliary sys/Oracle123@orcl ...
Posted on Mon, 02 Dec 2019 00:08:57 -0500 by jeff_lawik
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
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
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
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