Hardware and Software, Engineered to Work Together. Data Backup and Recovery. From Chapter 14, Microsoft Windows 2000 Administrator's Pocket Consultant by William R. Stanek. Because data is the heart of the enterprise, it's crucial for you to protect it. And to protect your organization's data, you need to implement a data backup and recovery plan. Backing up files can protect against accidental loss of user data, database corruption, hardware failures, and even natural disasters. It's your job as an administrator to make sure that backups are performed and that backup tapes are stored in a secure location. Creating a Backup and Recovery Plan Data backup is an insurance plan. Figuring Out a Backup Plan It takes time to create and implement a backup and recovery plan. How important is the data on your systems?
The Basic Types of Backup There are many techniques for backing up files. If you view the properties of a file or directory in Windows Explorer, you'll note an attribute called Archive. Differential and Incremental Backups Selecting Backup Devices and Media. User Managed Backup --- Oracle. How to enable archivelog mode in Oracle 11g database. Manually DB Creation with 11G. Manually database creation is one of the more frequently performed actions of a professional DBA.
And, with Oracle 11g it only takes a few minutes to do :) The procedure is same as previous which we are used for 9i and 10g. In this database creation I used below features: 1. OMF (Oracle Managed File) for datafiles, redolog files & controlfiles 2. FRA (Flash Recovery Area) for Archivelog or backup files 3. ASM (Automatic Storage Mgmt) for Volume manager 1.
E:\>mkdir e:\oracle\ORA11G NOTE: above directory is for TRACE FOLDER. And for ASM I already created DGRP2 group for database. 2. E:\>set ORACLE_HOME=c:\app\m.taj\product\11.1.0\db_1 E:\>set PATH=c:\app\m.taj\product\11.1.0\db_1\bin E:\>set ORACLE_SID=ora11g 3. Two authentication method we can use. 1. 2. NOTE: Here I used OS authentication Method. 3. Open NOTEPAD file and set below parameters Save it in Temporary folder. 4. E:\>oradim -NEW -SID ora11g -STARTMODE auto Instance created. 5. 6. 7. SQL> startup nomount ORACLE instance started. 8. 9. SQLite Home Page. W3Schools Online Web Tutorials. Tip (SQL Server): List of all the DBCC commands with their syntax.