Posted by Mir Sayeed Hassan on 16th February 2025
How to validate the database files for backup purpose in Oracle 19C Database. This is to validate the database files, in case if the backup is failing due to the any corruption of datafiles or control files etc. Issue the below command RMAN> validate database; Starting validate at 16-FEB-25 using target database control file instead… Read More
Posted in RMAN | Comments Off on How to validate the database files for backup purpose in Oracle 19C Database.
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
