backup

thomasliju
thomasliju used Ask the Experts™
on
How can we backup a production database using RMAN...
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Oracle Database Administrator III
Commented:
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
Commented:
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

Author

Commented:
What are the things we need to keep in mind when we backup a production database other that the status of archive log

Author

Commented:
yes good answer
Steve WalesSenior Database Administrator

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial