RMAN introductory practice!

xiaoxiao2021-03-06  75

Environment: Win2k Server; Oracle 817, Legato NetWorker

1 Place the target database in archive mode

Change Init.ora

2 CATALOG library

3 Construction table space, user, allocation permission on Target, Catalog

SQL> CREATE TABLESPACE RMAN_TS DATAFILE D: /Oracle/oradata/rman/rman_ts.dbf "Size 20M;

SQL> CREATE User Rman Identified by Rman Default TableSpace Rman_ts Temporary TableSpace Temp Quota Unlimited On RMAN_TS;

SQL> Grant Recovery_catalog_owner to rman;

SQL> Grant Connect, Resource to Rman;

4 Create a recovery directory in the Catalog side

C: /> Rman Catalog RMAN / RMAN

Rman> CREATE CATALOG TABLESPACE RMAN_TS;

5 Register in the recovery directory

C: /> Rman Target Internal / Oracle @ His Catalog RMAN / RMAN @ rman

Rman> Register Database;

6 full-quality

Run> Run {2> # backup the Complete Database to Disk; Allocate Channel Dev1 Type Disk; 4> Backup 5> Full 6> Tag Full_DB_BACKUP 7> Format "/ Oracle / Backups / DB_T% T_S% S_P% P" 8> (Database); 9> Release Channel dev1; 10>}

Quote: http://oraasp.vicp.net/Article/Article.aspx? Id = 107

转载请注明原文地址:https://www.9cbs.com/read-121533.html

New Post(0)