Solved

backup

Posted on 2014-03-02
7
458 Views
Last Modified: 2014-06-09
How can we backup a production database using RMAN...
0
Comment
Question by:thomasliju
7 Comments
 
LVL 23

Accepted Solution

by:
David earned 250 total points
ID: 39899308
Say more if you have specific needs.  Conceptually, one commonly creates a full backup image and adds incremental updates; repeats the process; then arranges for obsolete sets to be routinely expunged.   Lots and lots of searchable references, but watch out for the info specific to your O/S and RDBMS versions.

Concepts
Quickstart
User Guide
0
 
LVL 8

Assisted Solution

by:Pepe2323
Pepe2323 earned 250 total points
ID: 39900587
Hi

Not sure if this is answering your question, but when i perform a full backup i do something like this

rman target / log=/path/rman_backup.log
run{
ALLOCATE CHANNEL c1 DEVICE TYPE DISK FORMAT '/Path_where_backup_will_be/%U';
BACKUP FULL DATABASE PLUS ARCHIVELOG;
BACKUP CURRENT CONTROLFILE;
}

YOu can add more channels if the information is hugh

Regards
0
 

Author Comment

by:thomasliju
ID: 39900897
What are the things we need to keep in mind when we backup a production database other that the status of archive log
0
 

Author Comment

by:thomasliju
ID: 39905035
yes good answer
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 40121520
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Wrap Oraccle SQL*Plus executable Command 4 84
Oracle DATE Column Space 11 80
Wrong number of values in the INTO list of a FETCH statement 16 66
Oracle - SQL Parse String 5 34
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to take different types of Oracle backups using RMAN.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question