Looking For Something ...?

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
-----------------------------------------

No comments:

Post a Comment