Wednesday, June 27, 2007

RMAN:Create and assign recovery catalog

SQL> create tablespace rmants datafile '/vg_ora/oracle/rman/rman.dbf' size 50M;

Tablespace created.

SQL> create user rman identified by rman
default tablespace rmants quota unlimited on rmants;

User created.

SQL> grant recovery_catalog_owner, connect, resource to rman;

Grant succeeded.

RMAN> create catalog tablespace "RMANTS";

recovery catalog created

Then logon to thr=e target:

=>rman target sbiswas/sbiswas

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jun 27 16:00:33 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1153619437)

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/vg_ora/oracle/db/dbs/snapcf_orcl.f'; # default

No comments:

Post a Comment