Oracle Database Full-scale backup recovery and partial backup recovery

Today, we encountered Oracle database sequence problems, simply to a full library of backup and recovery. As follows

Imp/exp Way

Table mode Backup: Oracle@sencloudserver:exp dhoffice/dhoffice rows=y indexes=n compress=n buffer=65536. DMP Log=exp_tianle_090101.log Tables=david.tianle;

User-mode backup:
oracle@sencloudserver:exp dhoffice/dhoffice owner=david rows=y indexes=n compress=n buffer=655 File=dhoffice__090101.dmp Log=exp_david_090101.log;

Full Mode backup:
oracle@sencloudserver:exp dhoffice/dhoffice rows=y indexes=n compress=n buffer=65536 full=y fi Le=dhoffice_fulldatabase_090101.dmp Log=exp_fulldatabase_090101.log;

Table mode recovery:
oracle@sencloudserver:imp dhoffice/dhoffice fromuser=david touser=david rows=y indexes=n commit=y buffer=65536 file=exp_tianle_090101.dmp Log=imp_tianle_090101.log;

User-mode recovery:
oracle@sencloudserver:imp dhoffice/dhoffice fromuser=david touser=david rows=y indexes=n Commi T=y buffer=65536 file=exp_tianle_090101.dmp Log=exp_tianle_090101.log;

Full-Library mode recovery:

Oracle@sencloudserver:imp dhoffice/dhoffice rows=y indexes=n commit=y full=y ignore=y buffer=65536 file=/tmp/exp_ Fulldatabase_090101.dmp Log=/tmp/imp.log;

Rman method

There is no time to write this part of the script, wait until the back of time to complete. Write it down first.