Posted by Mir Sayeed Hassan on 29th April 2023
Backup and restore tablespace by using the RMAN ENCRYPTION Method in Oracle 19c Login to Database. [oracle@testdb ~]$ sqlplus sys/testdb as sysdba SQL*Plus: Release 19.0.0.0.0 – Production on Tue Nov 8 04:03:38 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition… Read more..
Posted in RMAN | Comments Off on Backup and restore tablespace by using the RMAN ENCRYPTION Method in Oracle 19c
Posted by Mir Sayeed Hassan on 7th December 2022
Backup and restore tablespace by using the RMAN ENCRYPTION Method in Oracle 19c This scenario is to test the encryption method while performing the backup & restore operation. Connect to Database [oracle@testdb ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 – Production on Tue Nov 8 04:03:38 2022 Version 19.3.0.0.0 Copyright… Read more..
Posted in RMAN | Comments Off on Backup and restore tablespace by using the RMAN ENCRYPTION Method in Oracle 19c
Posted by Mir Sayeed Hassan on 4th October 2021
How to create a RMAN Catalog & register in Oracle Database 12c(12.2.0.0) Overview of recovery catalog The recovery catalog contains metadata about RMAN operations for each registered target database. therefore when RMAN is connected to a recovery catalog, the RMAN obtains its metadata exclusively from the catalog db, to perform this operation you need to Read More
Posted in RMAN | Comments Off on How to create a RMAN Catalog & register in Oracle Database 12c(12.2.0.0)
Posted by Mir Sayeed Hassan on 20th July 2020
How to delete the backup which is no longer needed or obsolete in Oracle database using RMAN Note: You can delete the backup which is not needed as per the rman configuration policy set Check the RMAN Configuration policy RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters… Read Read More
Posted in RMAN | Comments Off on How to delete the backup which is no longer needed or obsolete in Oracle database using RMAN
Posted by Mir Sayeed Hassan on 20th July 2020
How to backup Individual Database files like Tablespace, Datafiles, Archivelogs, Spfile, Controlfile by using RMAN BACKUP OF ALL ARCHIVELOG RMAN> backup archivelog all; Starting backup at 20-JUL-20 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived… Read more..
Posted in RMAN | Comments Off on How to backup Individual Database files like Tablespace, Datafiles, Archivelogs, Spfile, Controlfile by using RMAN
Posted by Mir Sayeed Hassan on 25th June 2019
RMAN Backup of Container Database (CDB) & Pluggable Database (PDB), Partial PDB Connect to the CDB Database Connect to the RMAN Root Container Database (CDB) by using rman target sys/<password>@<dbname> or rman target / Example: rman target sys/******@ora18c or rman target / – The result will be same Connect… Read more..
Posted in RMAN | Comments Off on RMAN Backup of Container Database (CDB) & Pluggable Database (PDB), Partial PDB