Looking For Something ...?

Showing posts with label archive log. Show all posts
Showing posts with label archive log. Show all posts

Sunday, June 28, 2009

Oracle DataBase BackUp

DATABASE BACKUP
BackUp: Server Managed Backup & User Managed Backup .
Steps to backup your oracle database:
1- Enable Archive Logging ( SqlPlus:> Alter Database Archivelog ; )
2- Create Rman Target / Catalog .
Where : Rman is a user name which was granted Recovery_Catalog_Owner Role .
3- Enable Control File Auto Backup ( Rman> Configure ControlFile Autobackup on )
4-
Rman> Create catalog tablespace Rman
Rman> Register database
5- Backup your database
Rman> Backup Incremental Level 0 Database
-----------------------------------------