Oracle database backup and recovery - Explain how to create a RMAN recovery
catalog posted by Babu
Kunwar
Explain how to create a RMAN recovery catalog
Creating RMAN account:
SQL> create tablespace rman datafile '+data1' 2 size 125m auto extend on
next 50m maxsize 500m;
We will get am message that tablespace created.
SQL> grant recovery_catalog_owner to rman identified by rman;
Grant succeeded.
SQL> alter user rman default tablespace rman 2 quota unlimited on rman;
User altered.
Now the RMAN recovery catalog has been created and we can log on and use it.
More links
Define PL/SQL. Explain its purpose
Advantages of PL/SQL
Main Features of PL/SQL
PL/SQL Architecture
Basic Structure of PL/SQL
Variables and Types.............
|
