There are some situations where it is relevant for DBA to use FLASHBACK or Database Point-in-Time Recovery such as when a user modifies some data incorrectly or also when an upgrade failed and if it wishes to revert the previous situation of the database among several others possibilities. With this, in this post I will be explaining in a simple way how to use Database Point-in-Time Recovery. Therefore, I will be considering some requirements for this operation be possible: – The database must be enabled in Archivelog mode: – The…
Month: May 2018
[Oracle 12c] BACKUP PLUGGABLE DATABASE
Backing up the Oracle database is always very important. In version 12c, there is the possibility of backing up one or more PDBs. There are two methods to back up the PDB, one is connecting directly as a ROOT in RMAN and using the “BACKUP PLUGGABLE DATABASE” command or the option to connect directly to the PDB through the service and execute the “BACKUP DATABASE” command. So, in this post I will be explaining just how to backup the PDB by connecting as ROOT and using as an example a…
[Oracle 12c] BACKUP DATABASE ROOT
Backing up the Oracle database is always very important. In version 12c, there is a possibility of backing up the ROOT database that has important metadata for the CDB. So, in this post I’ll be illustrating how to backup the ROOT database: 1. Connect to the RMAN catalog: 2- Execute the command BACKUP DATABASE ROOT: Efetuar o backup do banco de dados Oracle é sempre muito importante. Na versao 12c, há a possibilidade de se efetuar o backup do banco de dados ROOT que possui possui metadados importantes para…