How to Take full backup in oracle database?

Rameshdba.com

The contents are of my own testing and deployments. Not guaranteed that these might work in your environment. Please test before usage.


In this blog, I will teach you how to take a full database in Oracle database.


Login to the server!

Connect the rman and put this comment.

***********************************************************************

[oracle@oracle ~]$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Sat Apr 15 19:13:11 2023

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PROD (DBID=544189800)

RMAN>

Note: The below command takes the full backup with the current control file as well

**************************************************************************

RMAN> run

 {

BACKUP AS compressed backupset filesperset 10 incremental level 0 DATABASE INCLUDE CURRENT CONTROLFILE TAG Ramesh_FULL_BACKUP;

}


Starting backup at 15-APR-23

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=249 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=355 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=10 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=129 device type=DISK

allocated channel: ORA_DISK_5

channel ORA_DISK_5: SID=251 device type=DISK

allocated channel: ORA_DISK_6

channel ORA_DISK_6: SID=366 device type=DISK

allocated channel: ORA_DISK_7

channel ORA_DISK_7: SID=12 device type=DISK

allocated channel: ORA_DISK_8

channel ORA_DISK_8: SID=133 device type=DISK

allocated channel: ORA_DISK_9

channel ORA_DISK_9: SID=254 device type=DISK

allocated channel: ORA_DISK_10

channel ORA_DISK_10: SID=368 device type=DISK

allocated channel: ORA_DISK_11

channel ORA_DISK_11: SID=14 device type=DISK

allocated channel: ORA_DISK_12

channel ORA_DISK_12: SID=135 device type=DISK

allocated channel: ORA_DISK_13

channel ORA_DISK_13: SID=253 device type=DISK

allocated channel: ORA_DISK_14

channel ORA_DISK_14: SID=371 device type=DISK

allocated channel: ORA_DISK_15

channel ORA_DISK_15: SID=136 device type=DISK

allocated channel: ORA_DISK_16

channel ORA_DISK_16: SID=15 device type=DISK

allocated channel: ORA_DISK_17

channel ORA_DISK_17: SID=132 device type=DISK

allocated channel: ORA_DISK_18

channel ORA_DISK_18: SID=250 device type=DISK

allocated channel: ORA_DISK_19

channel ORA_DISK_19: SID=370 device type=DISK

allocated channel: ORA_DISK_20

channel ORA_DISK_20: SID=16 device type=DISK

allocated channel: ORA_DISK_21

channel ORA_DISK_21: SID=134 device type=DISK

allocated channel: ORA_DISK_22

channel ORA_DISK_22: SID=255 device type=DISK

allocated channel: ORA_DISK_23

channel ORA_DISK_23: SID=372 device type=DISK

allocated channel: ORA_DISK_24

channel ORA_DISK_24: SID=17 device type=DISK

channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oracle/oradata/PROD/datafile/o1_mf_system_l1vn6k9o_.dbf

channel ORA_DISK_1: starting piece 1 at 15-APR-23

channel ORA_DISK_2: starting compressed incremental level 0 datafile backup set

channel ORA_DISK_2: specifying datafile(s) in backup set

input datafile file number=00003 name=/u01/app/oracle/oradata/PROD/datafile/o1_mf_sysaux_l1vn5r5n_.dbf

channel ORA_DISK_2: starting piece 1 at 15-APR-23

channel ORA_DISK_3: starting compressed incremental level 0 datafile backup set

channel ORA_DISK_3: specifying datafile(s) in backup set

input datafile file number=00008 name=/u01/app/oracle/oradata/PROD/datafile/o1_mf_omf_l2mbfk4s_.dbf

channel ORA_DISK_3: starting piece 1 at 15-APR-23

channel ORA_DISK_4: starting compressed incremental level 0 datafile backup set

channel ORA_DISK_4: specifying datafile(s) in backup set

input datafile file number=00009 name=/u01/app/oracle/oradata/PROD/datafile/o1_mf_omf_l2mbhvwo_.dbf

channel ORA_DISK_4: starting piece 1 at 15-APR-23

channel ORA_DISK_5: starting compressed incremental level 0 datafile backup set

channel ORA_DISK_5: specifying datafile(s) in backup set

input datafile file number=00004 name=/u01/app/oracle/oradata/PROD/datafile/o1_mf_undotbs1_l1vn7omh_.dbf

channel ORA_DISK_5: starting piece 1 at 15-APR-23

channel ORA_DISK_6: starting compressed incremental level 0 datafile backup set

channel ORA_DISK_6: specifying datafile(s) in backup set

input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/bigtbs.dbf

channel ORA_DISK_6: starting piece 1 at 15-APR-23

channel ORA_DISK_7: starting compressed incremental level 0 datafile backup set

channel ORA_DISK_7: specifying datafile(s) in backup set

input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/tbs1.dbf

channel ORA_DISK_7: starting piece 1 at 15-APR-23

channel ORA_DISK_8: starting compressed incremental level 0 datafile backup set

channel ORA_DISK_8: specifying datafile(s) in backup set

input datafile file number=00007 name=/u01/app/oracle/oradata/auto.dbf

channel ORA_DISK_8: starting piece 1 at 15-APR-23

channel ORA_DISK_9: starting compressed incremental level 0 datafile backup set

channel ORA_DISK_9: specifying datafile(s) in backup set

channel ORA_DISK_10: starting compressed incremental level 0 datafile backup set

channel ORA_DISK_10: specifying datafile(s) in backup set

input datafile file number=00006 name=/u01/app/oracle/oradata/PROD/datafile/o1_mf_users_l1vn7ngo_.dbf

channel ORA_DISK_10: starting piece 1 at 15-APR-23

channel ORA_DISK_11: starting compressed incremental level 0 datafile backup set

channel ORA_DISK_11: specifying datafile(s) in backup set

including current SPFILE in backup set

channel ORA_DISK_11: starting piece 1 at 15-APR-23

channel ORA_DISK_3: finished piece 1 at 15-APR-23

piece handle=/u01/ramesh/backup/Ramesh_FULL_PROD_t1134242050_s77_p1 tag=RAMESH_FULL_BACKUP comment=NONE

channel ORA_DISK_3: backup set complete, elapsed time: 00:00:02

channel ORA_DISK_4: finished piece 1 at 15-APR-23

piece handle=/u01/ramesh/backup/Ramesh_FULL_PROD_t1134242050_s78_p1 tag=RAMESH_FULL_BACKUP comment=NONE

channel ORA_DISK_4: backup set complete, elapsed time: 00:00:02

channel ORA_DISK_7: finished piece 1 at 15-APR-23

piece handle=/u01/ramesh/backup/Ramesh_FULL_PROD_t1134242051_s81_p1 tag=RAMESH_FULL_BACKUP comment=NONE

channel ORA_DISK_7: backup set complete, elapsed time: 00:00:01

channel ORA_DISK_8: finished piece 1 at 15-APR-23

piece handle=/u01/ramesh/backup/Ramesh_FULL_PROD_t1134242051_s82_p1 tag=RAMESH_FULL_BACKUP comment=NONE

channel ORA_DISK_8: backup set complete, elapsed time: 00:00:01

including current control file in backup set

channel ORA_DISK_9: starting piece 1 at 15-APR-23

channel ORA_DISK_11: finished piece 1 at 15-APR-23

piece handle=/u01/ramesh/backup/Ramesh_FULL_PROD_t1134242051_s85_p1 tag=RAMESH_FULL_BACKUP comment=NONE

channel ORA_DISK_11: backup set complete, elapsed time: 00:00:01

channel ORA_DISK_6: finished piece 1 at 15-APR-23

piece handle=/u01/ramesh/backup/Ramesh_FULL_PROD_t1134242051_s80_p1 tag=RAMESH_FULL_BACKUP comment=NONE

channel ORA_DISK_6: backup set complete, elapsed time: 00:00:01

channel ORA_DISK_9: finished piece 1 at 15-APR-23

piece handle=/u01/ramesh/backup/Ramesh_FULL_PROD_t1134242051_s83_p1 tag=RAMESH_FULL_BACKUP comment=NONE

channel ORA_DISK_9: backup set complete, elapsed time: 00:00:01

channel ORA_DISK_10: finished piece 1 at 15-APR-23

piece handle=/u01/ramesh/backup/Ramesh_FULL_PROD_t1134242051_s84_p1 tag=RAMESH_FULL_BACKUP comment=NONE

channel ORA_DISK_10: backup set complete, elapsed time: 00:00:02

channel ORA_DISK_5: finished piece 1 at 15-APR-23

piece handle=/u01/ramesh/backup/Ramesh_FULL_PROD_t1134242051_s79_p1 tag=RAMESH_FULL_BACKUP comment=NONE

channel ORA_DISK_5: backup set complete, elapsed time: 00:00:05

channel ORA_DISK_2: finished piece 1 at 15-APR-23

piece handle=/u01/ramesh/backup/Ramesh_FULL_PROD_t1134242050_s76_p1 tag=RAMESH_FULL_BACKUP comment=NONE

channel ORA_DISK_2: backup set complete, elapsed time: 00:00:38

channel ORA_DISK_1: finished piece 1 at 15-APR-23

piece handle=/u01/ramesh/backup/Ramesh_FULL_PROD_t1134242050_s75_p1 tag=RAMESH_FULL_BACKUP comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:48

Finished backup at 15-APR-23


RMAN>


Check the location you will get the backup pieces.


 
                                                                Thank you!!


0 Comments

DELETE Statement in ORACLE DB— Step by Step Internal Flow with classroom example.

by
Imagine your Oracle database like a school, and you’re Teacher decides to remove a student (row) from the classroom(table). Let’s see how the journey works step by step: 1)Classroom = Oracle Table 2)Students = Rows (Records) 3)Class Teacher = Oracle Server Process 4)Attendance Register = Data Dictionary User fires DELETE statement: DELETE FROM students WHERE grade = 'D'; Internal Processing Steps: Client Process Sends DELETE Statement to Server Process The teacher receives a request to remove a student from the classroom. Syntax Check (Parsing) The teacher checks if the request is grammatically correct — proper command, keywords, and a semicolon. Semantic Check Teacher verifies if the classroom exists and whether the condition (like grade = 'D') makes sense. Object Resolution Teacher confirms that the ‘students’ classroom (table) exists in the school records (data dictionary). Optimization Decides the fastest way to find those students — by roll number, grade, or al...
Image