SUJEET JHA
***********R12.1.1 HOT_BACKUP_STEPS*****************
[oracle@sujeet ~]$ export $ ORACLE_SID=orcl
[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 Directory 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***********************************************
No comments:
Post a Comment