RMAN – Recovery Manager
- Backup is happen on the data block level. It can save time and space. Would detect the HWM on the file and do not backup data block higher the HWM.
- Compression
- Can detect the bad data block
- Backup Level 0-5. 0 is Full backup. 1-5 can be differential or incremental .
RMAN Catalog
-- Create tablepsace to hold repository
CREATE TABLESPACE RMAN
DATAFILE '/u01/app/oracle/oradata/oracledb1/RMAN01.DBF' SIZE 50M REUSE
AUTOEXTEND ON NEXT 64K MAXSIZE 32767M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
-- Create rman schema owner
CREATE USER rman IDENTIFIED BY rman
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE rman
QUOTA UNLIMITED ON rman;
GRANT connect, resource, recovery_catalog_owner TO rman;
rman catalog username/passowrd@SID target username/password@SID
- If SID is not provided, it use the current $ORACLE_SID
- Catalog’s username name and password is the one we create in the above.
- In below screenshot, we only connect to the catalog
In below screenshot, we connect to the $ORACLE_SID database and catalog and then register database.
Backup database
backup database;
backup database plus archivelog;
Here is the screenshot of the backup database plus archivelog
Backup tablespace
backup tablespace <TABLESPACE NAME>
backup tablepsace exmple;
Backup data file
backup datafile [datafile path]
backup datafile '/u01/app/oracle/oradata/oracledb1/example01.dbf';
Backup control file
backup current controlfile;
Differential Incremental backup
- Incremental backup would only backup the changed block since the last level 0 incremental backup.
- If there is no level 0 incremental backup. RMAN will first create level 0 and then create the level 1 backup.
- Oracle would not use the FULL backup as base (parent ) for increment backup ( level 1).
- The level 1 backup would only backup the changes since last level 0 or level 1 backup.
backup incremental level 1 database;
Cumulative Incremental backup
RMAN can also backup Cumulative backup base on the last level 0 backup.
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE database
List backup
# Show all backup
list backup;
# Show/Delete items not needed for recovery
report obsolete;
delete obsolete;

I strongly believe that there will be great opportunities for those who looked into this area. Thanks much for sharing such a nice article keep sharing on...
ReplyDeleteBest Online Software Training Institute | Oracle Training
Great Article Internship in Chennai projects for cse JavaScript Training in Chennai JavaScript Training in Chennai Project Centers in Chennai
DeleteWow, Excellent post. This article is really very interesting and effective
ReplyDeleteOracle DBA Training
Oracle PLSQL Training
Oracle Performance Tunning Training
nice article
ReplyDeleteUnicsol offers Best full stack developer course in hyderabadget trained by 10+years of experienced faculty and get placed as full stack developer.
Nice Post..
ReplyDeletebitwise aptitude questions
how to hack flipkart legally
zenq interview questions
count ways to n'th stair(order does not matter)
zeus learning subjective test
ajax success redirect to another page with data
l&t type 2 coordination chart
html rollover image
hack android phone using cmd
how to hack internet speed upto 100mbps
Good..
ReplyDeleteinternships in chennai
winter internship mechanical engineering
internship for aeronautical engineering students in india 2019
kaashiv
list of architectural firms in chennai for internship
paid internships in pune for computer science students
diploma final year project topics for information technology
internship
data science internship report
inplant training
nice post...
ReplyDeleteinternship report on python
free internship in chennai for ece students
free internship for bca
internship for computer science engineering students in india
internships in hyderabad for cse students 2018
electrical companies in hyderabad for internship
internships in chennai for cse students 2019
internships for ece students
inplant training in tcs chennai
internship at chennai
very nice post and useful information........
ReplyDeleter programming training in chennai
internship in bangalore for ece students
inplant training for mechanical engineering students
summer internships in hyderabad for cse students 2019
final year project ideas for information technology
bba internship certificate
internship in bangalore for ece
internship for cse students in hyderabad
summer training for ece students after second year
robotics courses in chennai
Nice Infromation....
ReplyDeleteinternship in chennai for ece students with stipend
internship for mechanical engineering students in chennai
inplant training in chennai
free internship in pune for computer engineering students
internship in chennai for mca
iot internships
internships for cse students in hyderabad
implant training in chennai
internship for aeronautical engineering students in bangalore
inplant training certificate
ReplyDeleteit is best blogs for you...!!!
paid internships in pune for computer science students
machine learning training in chennai
data science internship in chennai
dot net training in chennai
kaashiv infotech chennai
internship for aeronautical engineering students in india
internship in automobile industry
big data internship in chennai
machine learning internship in chennai
internship in chennai for it students
Nice post...
ReplyDelete3d-modeler-resume-samples
3d modeler resume samples
accounting-assistant-resume-sample
accounting-clerk-resume-sample
accounting-manager-resume-samples
account-manager-resume-examples
accounts-payable-resume-sample
admin-manager-resume-samples
advocate-resume-sample
advocate-resume-sample
nice post.......
ReplyDeleteapache solr resume sample
apache spark sample resume
application developer resume samples
application support engineer resume sample
asp dotnet mvc developer resume
asp net core developer resume
asp net developer resume samples
assistant accountant cv sample
assistant accountant resume
assistant accountant resume sample
branch-operations-manager-resume-samples
ReplyDeletebusiness-executive-resume-samples
business-owner-resume-samples
business-to-business-sales-resume-sample-sales-resumes
cad-design-engineer-resume-samples
call-centre-jobs-resume-sample
ca-resume-samples-chartered-accountant-resume-format
cassandra-database-administrator-resume
category/accountant-resume
category/admin-resume
nice....
ReplyDeletecategory/advocate-resume
category/agriculture-forestry-fishing
category/android-developer-resume
category/assistant-professor-resume
category/chartered-accountant-resume
category/database-resume
category/design-engineer-resume
category/developer-resume
category/engineer-resume
category/entrepreneur-and-financial-services-resume
good..nice..
ReplyDeleteassistant-director-resume-format
assistant-director-resume-sample
assistant-professor-resume-sample
back-office-executive-resume-samples
bank-branch-manager-resume-samples
basketball-coach-resume-sample-coach-resumes
bca-fresher-resume-sample
best-general-manager-resume-example
bpo-resume-freshers-sample
bpo-resume-samples-for-freshers
good ....nice...
ReplyDeleteresume/category/software-testing-resume
resume/category/sslc-resume
resume/category/storekeeper-resume
resume/category/stylist-resume
resume/category/teachers-resume
resume/category/technical-architect-resume
resume/category/web-developer-resume
cics-system-programmer-resume-example
resume/cisco-network-engineer-resume
resume/cisco-network-engineer-resume-sample
good.....nice..
ReplyDeletecategory/maintenance-resume
category/manager-resume
category/mechanical-engineering-resume
category/network-engineer-resume
category/officer-resume
category/operations-resume
category/process-associate-resume
category/quality-control-resumes
category/software-engineer-resume
good... nice... very useful..
ReplyDeleteassistant-director-resume-format
director-resume-sample
assistant-professor-resume-sample
back-office-executive-resume-samples
bank-branch-manager-resume-samples
basketball-coach-resume-sample-coach-resumes
bca-fresher-resume-sample
best-general-manager-resume-example
bpo-resume-freshers-sample
bpo-resume-samples-for-freshers
it is best blogs ....
ReplyDeletecivil-engineer-resume-format
client-service-executive-resume-sample
cognos-developer-resume-samples
college-lecturer-resume
college-lecturer-resume-sample
commercial-assistant-resume-sample
compliance-officer-resume-samples
computer-teacher-resume-format
computer-teacher-resume-sample
cordova-developer-resume-sample
ReplyDeletefilm-director-resume
finance-and-accounting-manager-resume-samples
finance-director-resume-examples
fire-safety-officer-resume-sample
fleet-maintenance-manager-resume-samples
format-for-resume-writing
fresher-computer-engineers-resume-sample
fresher-hr-resume-sample
fresher-hr-resume-sample-2
fresher-lecturer-resume
good .........very useful
ReplyDeletefresher-marketing-resume-sample
front-end-developer-resume-sample
full-stack-developer-resume-samples
fund-accountant-resume-samples
general-ledger-accountant-resume-sample
government-jobs-resume
hadoop-developer-sample-resume
hadoop-developer-sample-resume
hardware-and-networking-resume-samples
hardware-engineer-resume-sample
useful information..nice..
ReplyDeletedevops-engineer-resume-samples
digital-marketing-resume-samples
digital-marketing-resume-samples
electronics-engineer-resume-sample
engineering-lab-technician-resume-samples
english-teacher-cv-sample
english-teacher-resume-example
english-teacher-resume-sample
excel-expert-resume-sample
executive-secretary-resume-samples
Great article by the great author, it is very massive and informative but still preaches the way to sound like that it has some beautiful thoughts described so I really appreciate this article. oracle fusion scm online training
ReplyDeletereplica rolex uk , were established in 1905 and have replica Rolex Sea-Dweller watches been in the field of innovation for more than a century. The first certified chronometer, the first self-winding watch and the first effective waterproof case are milestones in Rolex design. Today, the Rolex brand is immediately recognized as a symbol of global reputation, luxury and innovation. Buying a Rolex watch means you are buying a piece of watch history. Here we have a large catalog of used Rolex special watches for sale.
ReplyDelete