How to use Rman to back up an Oracle database

1, backup the entire database

Backup database format ' C:\rman\all_%U.bak ';

2. Backup table Space

Backup tablespace ABC format ' C:\rman\t_%U.bak ';

3, Backup data files

1 backup datafile 5 format ' C:\rman\d_%U.bak ';

2) Backup datafile ' C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ABC. DBF '

Format ' C:\rman\d_%U.bak ';

4. Backup control files

Backup current controlfile format ' c:\rman\ctr_%U.ctl ';

5, backup the data file at the same time backup control files

Backup datafile 5 format ' C:\rman\d_c_%U.bak '

Include current controlfile;

6, Backup SPFile files

Backup spfile format ' C:\RMAN\SP_%U.SP ';

7. BACKUP LOG Files

Backup archivelog sequence between format ' C:\rman\ar_%U.log '

Delete all input (optional, which indicates that the original log file is deleted after the log file is backed up);

8, back up the database and log files

Backup DATABASE plus archivelog format ' c:\rman\ d_ar_%u.d_a ';

9, copy function (equivalent to user management backup)

Backup as Copy database format ' c:\rman\%U.cy ';

Copy datafile 5 to ' c:\rman\d_%U.cy ';

Note:backup as copy can back up the entire database

Copy can only back up current Controlfile, datafile, tablespace, etc., this database does not support

Oracle Video Tutorials Please focus on: http://u.youku.com/user_video/id_UMzAzMjkxMjE2.html

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/