root> su - oracle
oracle> export ORACLE_SID=venu
oracle> !sq
SQL> startup
Steps :
1.create the backup directory structure.
2.alter database begin backup;
3.Take the backup of datafiles at Operating System level.
4.alter database end backup;
5.Take the backup of control file at Oracle level.
6.alter system switch logfile;
SQL> select name,open_mode,log_mode from v$database;
SQL> select instance_name,status from v$instance;
SQL> select name from v$datafile;
SQL> select member from v$logfile;
root> mkdir -p /u01/hotbkp
root> chown -R oracle:oinstall /u01/hotbkp
root> chmod -R 775 /u01/hotbkp
SQL> select * from v$backup;
SQL> alter database begin backup;
SQL> select * from v$backup;
oracle> cd /u01/app/oracle/venu
oracle venu> ls
oracle venu> cp *.dbf /u01/hotbkp
SQL> alter database end backup;
SQL> select * from v$backup;
SQL> alter database backup controlfile to '/u01/hotbkp';
SQL> alter system switch logfile;
SQL> conn scott/tiger
scott> insert into salgrade select * from salgrade;
scott> /
scott> commit;
scott> select count(*) from salgrade;
scott> conn / as sysdba
SQL> alter system switch logfile;
