Now is the time to configure our RMAN environment to allow us to run all RMAN scenarios.
Have a look at the following command:
SQL> CREATE USER backup_admin IDENTIFIED BY bckpwd DEFAULT TABLESPACE users; SQL> GRANT sysbackup TO backup_admin; $ rman target=backup_admin/bckpwd@pdborcl
Have a look at the following command:
RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUSET; RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAL '/data/pdborcl/backups /bck_orcl_%U'; RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 200m MAXOPENFILES 8 RATE 150m; RMAN> CONFIGURE BACKUP OPTIMIZATION ON; RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; RMAN> CONFIGURE CONROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data/pdborcl/backups/controlfile/ctl_orcl_%F'; RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS; RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;
Have a look at the following command:
SQL> CREATE TABLESPACE catalog_tbs DATAFILE '/data/pdborcl /catalog_01_tbs.dbf' SIZE 100m; SQL> CREATE USER catalog_bck IDENTIFIED BY rmancatalog DEFAULT TABLESPACE catalog_tbs QUOTA UNLIMITED ON catalog_tbs; SQL> GRANT connect, resource, recovery_catalog_owner TO catalog_bck;
Have a look at the following command:
$ rman target / catalog=catalog_bck/rmancatalog@pdborcl RMAN> CREATE CATALOG tablespace catalog_tbs;
Have a look at the following command:
$ rman target=backup_admin/bckpwd catalog=catalog_bck/rmancatalog@pdborcl RMAN> REGISTER DATABASE; RMAN> REPORT SCHEMA;
Have a look at the following command:
SQL> CREATE USER fmunoz IDENTIFIED BY alvarez DEFAULT TABLESPACE catalog_tbs; SQL> GRANT recovery_catalog_owner TO fmunoz; $ rman catalog=catalog_bck/rmancatalog@pdborcl RMAN> GRANT CATALOG FOR DATABASE pdborcl TO fmunoz; RMAN> GRANT REGISTER DATABASE TO fmunoz; rman catalog=fmunoz/alvarez@pdborcl RMAN> CREATE VIRTUAL CATALOG;