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
- SELECT Name FROMV $ datafile;
- /U01/oracle/instance/db/apps_st/data/xxx. dbf
-
- SELECTMemberFROMV $ logfile;
- /U01/oracle/instance/db/apps_st/data/logx. dbf
-
- SELECT Name FROMV $ controlfile;
- /U01/oracle/instance/db/performance_st/data/cntrl0x. dbf
-
- SELECTT.NAME "Tablespace", F.NAME "Datafile"
- FROMV $ TABLESPACE t, V $ DATAFILE f
- WHERET. TS # = f. TS #
- ORDER BYT.NAME;
- /U01/oracle/mc3yd213/db/apps_st/data/xxx