Oracle database backup and recovery - What is RMAN and how does one use it?
posted by Babu Kunwar
What is RMAN and how does one use it?
RMAN in Oracle stands for Oracle Recovery Manager. RMAN takes backup and
recovery to a new level of protection and ease of use. We can use RMAN with
command line mode and with OEM web interface. It serves as an optional catalog
for database recovery in Oracle. In order to use RMAN one has to create RMAN
account.
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 account has been created and we can log on and use it.
More links
What is a PeopleSoft database?
How does the PeopleSoft database interact with the Oracle database?
What is the order of installing PeopleSoft on Oracle?
How can the client workstation connect to a PeopleSoft database?
What is the sizing of a generic PeopleSoft HRMS database?...........
|
