Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

backup

Posted on 2014-03-02
7
459 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
Queries 15 45
making a message body variable from an oracle select statement 4 23
Help with Oracle IF statment 5 23
oracle sqlplus query delimiter 8 17
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…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

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