Oracle Database full backup recovery and partial Backup Recovery

We also encountered the Oracle database sequence problem, so we can simply back up and restore the entire database. As follows:

Imp/exp Method

Table mode backup:

Oracle @ sencloudServer: exp dhoffice/dhoffice rows = y indexes = n compress = n buffer = 65536 file = dhoffice_090101.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 = 65536 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 file = 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 commit = y buffer = 65536 file = exp_tianle_090101.dmp log = exp_tianle_090101.log;

Full database 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 there is time to complete it. Write down it first.