Backup Restore the backup RESTORE command under Oracle database Winserver and Linxu is the same basic format:  IMP and exp are not suitable for large file backups, and if the file exceeds 20 g, this approach is inefficient and if the file is too large, Can be backed up and restored using Rman exp bim_dev/[email protected] file=c:\bim_dev.dmp owner=bim_devimp bim_dev/[email Protected] File=c:\bim_dev.dmp full=y ignore=yl error Information Processing: If it is a local link import library, do not need to add @ounion, plus this situation needs to configure the TNS file, similar to the Plsql backup restore individual tables: exp bim_dev/[email protected] File=/oracle/datahan.dmp tables=gh_jfxx_lsimp bim_dev/[email Protected] file=c:/datahan.dmp tables=gh_jfxx_ls //shutdown Restart library su oraclecd ~ go to root directory source $HOME/.bash_profile// Make configuration file effective Lsnrctl start//Start monitoring Sqlplus/nolog//No log status login Sqlplusconnect/as sysdba//with DB.A login link. Startup//Open database .bash_profile file information exp bim_dev/[email protected] file=c:\ounionpart.dmp tables= (DZ_SWBM,DZ _SWDJRQ) Imp bim_dev/[email protected] file=/home/oracle/ounionpart.dmp log=/home/oracle/ounionpart.log tables = "(DZ_SWBM,DZ_SWDJRQ)" Fromuser=bim_dev touser=oadmin buffer=10000000 statistics=none when redeploying a database, you can use Plsql to connect to the database. Remove all tables, views, triggers, sequence...... Then use IMP command to import Fine wisdom this side 139 the Oracle database on the server is powered on, 49 may be, I am not sure, if not, you can manually open it, now 20 real Machine 46 server is Linux oracle -- Windows: Open step: 1.MSTSC remote connection 492. Open cmd, enter sqlplus/nolog2. Input Conn/as SYSDBA enter 3. Enter startup carriage return 4. Wait! After the database has been loaded, exit CMD5. Run Services.msc Open the Services window to see if the listening service starting with Oracle is open, no, open close steps: 1. Open cmd, enter sqlplus/nolog2. Input Conn/as SYSDBA carriage return 2. Enter shutdown immediate carriage return 3. Wait! After the database has been uninstalled, exit cmd --linux: Open step: 1.su oracle2.cd ~3.source $HOME/.bash_profile4.lsnrctl start5.sqlplus /nolog6.connect/as sysdba7.startup Close step: 1.su oracle2.cd ~3.source $HOME/.bash_profile4.sqlplus/nolog5.connect /as Sysdba6.shutdown Immediate
Restore the Oracle database by backup
