R12.1.1 HOT BACKUP STEPS

[oracle@sujeet ~]$ echo $ORACLE_SID
idea
[oracle@sujeet ~]$ sqlplus

Enter user-name: sys as sysdba
Enter password: sys
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size                  1318172 bytes
Variable Size             427819748 bytes
Database Buffers          629145600 bytes
Redo Buffers               13049856 bytes
Database mounted.
Database opened.

SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /R12/oracle/idea/db/tech_st/11.1.0/dbs/arch
Oldest online log sequence     3
Current log sequence           4

NOTE:-DATABASE is No Archive Mode.must be in ARCHIVE mode:-

SQL> shut immediate
  
ORACLE instance shut down.
 
SQL> startup mount
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size                  1318172 bytes
Variable Size             427819748 bytes
Database Buffers          629145600 bytes
Redo Buffers               13049856 bytes
Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /R12/oracle/idea/db/tech_st/11.1.0/dbs/arch
Oldest online log sequence     3
Next log sequence to archive   4
Current log sequence           4

***NOW DATABASE IS IN ARCHIVE MODE*****

SQL> alter database open;
Database altered.

SQL> alter database begin backup;

Database altered.

#.COPY DATA_FILE SOURCE TO DESTINE>>>>
#.MAKE Dir. a on Desktop:-R12_HOTBACKUP

[oracle@sujeet apps_st]$ cp -r data/ /home/oracle/Desktop/R12_HOTBACKUP/

[oracle@sujeet apps_st]$ pwd
/R12/oracle/idea/db/apps_st

[oracle@sujeet apps_st]$ du -sh
43G  
   .
SQL> alter database end backup;

Database altered.

*****COPY ALL TOP SOURCE TO DESTINE********** 

(1).$ORACLE_HOME>>/R12/oracle/idea/apps/

(2).APPL_TOP>>/R12/oracle/idea/apps/apps_st/appl

(3).COMMON_TOP>>/R12/oracle/idea/apps/apps_st/comn

(4).ORA_TOP>>/R12/oracle/idea/inst/apps/idea_sujeet

********MAKE A DIR. ON DESKTOP APPLICATIN_BACKUP******

[oracle@sujeet apps]$ cp -r tech_st/ /home/oracle/Desktop/APPLICATION_BACKUP/

[oracle@sujeet apps_st]$ cp -r appl/ /home/oracle/Desktop/APPLICATION_BACKUP/

[oracle@sujeet apps_st]$ cp -r comn/ /home/oracle/Desktop/APPLICATION_BACKUP/

[oracle@sujeet apps]$ cp -r idea_sujeet/ /home/oracle/Desktop/APPLICATION_BACKUP/


******************************END***********************************************