Oracle 12.2 came with a new feature , we can simply recover a single table in a database. In below example we will see how we can restore a table of pluggable database. Step 1 : Connect to RMAN Step 2 : Use following command to recover table I.E. here I have table TEST which […]
ADR – Automatic Diagnostic Repository is a file-based directory structure formed in a hierarchical way to store diagnostic information of the database. For each database instance, ADR directories are created and maintained. In 12c release two, it is not changed. Hence we are having one instance for root container only. ADR directories are managed for […]
In this post, we can refresh the PDB in read write mode. Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us the Invitation or Follow us: Telegram Channel: https://t.me/helporacle Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ Joel Perez’s LinkedIn: Joel Perez’s Profile LinkedIn Group: Oracle Cloud DBAAS Facebook Page: OracleHelp
I missed coma (,) after defining first partition. Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us the Invitation or Follow us: Telegram Channel: https://t.me/helporacle Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ Joel Perez’s LinkedIn: Joel Perez’s Profile LinkedIn Group: Oracle Cloud DBAAS Facebook Page: OracleHelp
In this post, we will see how to restore spfile ORA-01078 is a common error we are facing when we have lost our parameter file. In above case we need to restore spfile from backup When rman does not find any parameter file , it will use default parameter and open database in nomount mode […]
We have seen an ERROR in the opening database. let’s recover it. Step 1: Connect to the database and start the database using STARTUP command
[oracle@dbatesting orclpdb]$ echo $ORACLE_SID
[oracle@dbatesting orclpdb]$ sqlplus / as sysdba
SQL*Plus: Release 22.214.171.124.0 Production on Wed Dec 26 17:40:07 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 2097152000 bytes
Fixed Size 8794696 bytes
Variable Size 620760504 bytes
Database Buffers 1459617792 bytes
Redo Buffers 7979008 bytes
ORA-01157: cannot identify/lock data file 13 - see DBWR trace file
ORA-01110: data file 13: '/home/appndb/oracle/oradata/orcl/orclpdb/test01.dbf'
We can see in the above output database is unable to open . And it threw an error that it cannot identify/lock data file 13. Step 2: Let’s make […]
In the previous article, we have created a recovery catalogue database and registered database. Creation of Recovery Catalog and Registering Database In this article, we will take incremental backup using a recovery catalog. Step 1: Connect rman with target and catalog clause Target: Database for which you want to create a backup Catalog: Catalog database […]
Recovery Catalog: RMAN metadata is stored in a different database instead of the control file. That database works as a repository. Follow the given steps to create a recovery catalog database Step 1: Connect to the target database which you want to use as a recovery catalog. Here in my case, I am using pdb […]
In this article we will enable block change tracking Now, what is block change tracking? Block change tracking is a mechanism of Oracle database to record changed blocks in a file. It helps us in taking incremental backups. While tracking incremental backups, instead of scanning all datafiles for changed blocks RMAN can simply read change […]
We know that when we take backup using RMAN it has its configuration for Retention Policy. Every backup has its retention policy either in days or in a number of back-ups. And backups are stored in the Fast recovery area. Once a backup exceeds from its retention policy it becomes obsolete. But today we will […]