Oracle ebs R12.1.1 HOT_BACKUP

Oracle ebs R12.1.1 HOT_BACKUP

                                                                                                                       

 ***********R12.1.1 HOT_BACKUP_STEPS*****************

[oracle@prasad ~]$  export $ ORACLE_SID=orcl

[oracle@prasad ~]$ echo $ORACLE_SID
idea
[oracle@prasad ~]$ 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 Directory  a on Desktop:-R12_HOTBACKUP

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

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

[oracle@prasad 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_prasad

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

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

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

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

[oracle@prasad apps]$ cp -r idea_prasad/ /home/oracle/Desktop/APPLICATION_BACKUP/


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