Oracle EBS Instance Cold Backup method (Cold Backup)

Oracle EBS Instance Cold Backup method (Cold Backup)1. Disable Oracle Application Server and DB Server
2. SSH to Server using oracle users (Database Management Users)

3. Create a backup directory

4. Copy all the files in the DATA_TOP directory (/u01/oracle/instance/db/apps_st/data) to the backup directory.$ Cp-r/u01/oracle/instance/db/pai_st/data/*/backup_dirHow to view EBS Instance data files, log files, Database Control files, and tablespace files

1. SELECT Name FROMV $ datafile;
2. /U01/oracle/instance/db/apps_st/data/xxx. dbf
4. SELECTMemberFROMV $ logfile;
5. /U01/oracle/instance/db/apps_st/data/logx. dbf
7. SELECT Name FROMV $ controlfile;
8. /U01/oracle/instance/db/performance_st/data/cntrl0x. dbf
10. SELECTT.NAME "Tablespace", F.NAME "Datafile"
11. FROMV $ TABLESPACE t, V $ DATAFILE f
12. WHERET. TS # = f. TS #
13. ORDER BYT.NAME;
14. /U01/oracle/mc3yd213/db/apps_st/data/xxx

1 2 Next Page