{"id":3010,"date":"2018-09-17T10:25:15","date_gmt":"2018-09-17T10:25:15","guid":{"rendered":"http:\/\/dbtut.com\/?p=3010"},"modified":"2018-11-24T18:57:08","modified_gmt":"2018-11-24T18:57:08","slug":"configuration-of-rman-using-oracle-10g","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/09\/17\/configuration-of-rman-using-oracle-10g\/","title":{"rendered":"Configuration of RMAN using Oracle 10g"},"content":{"rendered":"
<\/p>\n
There are many ways to setup the RMAN. Here i am using the separete database to store backup catalog information with windows Server 2008 (OS). Please remember, the directories and folder might change based on the OS and environment.<\/p>\n
Here i am using UMIS<\/strong> as primary database and CATDB<\/strong> as catalog database.<\/p>\n
Step1.<\/strong><\/span> Enable the archive log in UMIS database<\/p>\n
SQL> archive log list\r\nDatabase log mode No Archive Mode<\/pre>\n
Startup your database in mount state:<\/strong><\/p>\n
SQL> startup mount;\r\n\r\nORACLE instance started.\r\nTotal System Global Area 1503199232 bytes\r\nFixed Size 2288584 bytes\r\nVariable Size 905970744 bytes\r\nDatabase Buffers 587202560 bytes\r\nRedo Buffers 7737344 bytes\r\nDatabase mounted.<\/pre>\n
<\/p>\n
Configure your database in archivelog mode by issue the following:<\/strong><\/p>\n
SQL> alter database archivelog;\r\nDatabase altered.<\/pre>\n
<\/p>\n
Step2.<\/span><\/strong> Install the CATDB and Create the tablespace and user in catalog database to hold backup information.<\/p>\n
SQL> CONNECT sys\/password@catdb AS SYSDBA\r\nConnected.<\/pre>\n
SQL> CREATE TABLESPACE RMAN DATAFILE \u2018F:\\CATDB\\RMAN01.DBF' SIZE 480M\r\nAUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED\r\nLOGGING\r\nONLINE\r\nEXTENT MANAGEMENT LOCAL AUTOALLOCATE\r\nBLOCKSIZE 8K\r\nSEGMENT SPACE MANAGEMENT AUTO\r\nFLASHBACK ON;\r\nTablespace created.<\/strong><\/pre>\n
SQL> CREATE USER rman IDENTIFIED BY rman\r\nTEMPORARY TABLESPACE temp\r\nDEFAULT TABLESPACE rman\r\nQUOTA UNLIMITED ON rman;\r\nUser created.\r\n<\/strong><\/pre>\n
SQL> GRANT connect, resource, recovery_catalog_owner TO rman;\r\nGrant succeeded.<\/strong><\/pre>\n
<\/p>\n
Step3.<\/strong> Create the recovery catalog in catalog database.<\/p>\n
C:\\>rman catalog=rman\/rman@catdb\r\nRecovery Manager: Release 10.2.0.1.0 - Production on Thu May 21 09:59:26 2009\r\nCopyright (c) 1982, 2005, Oracle. All rights reserved.\r\nConnected to recovery catalog database<\/pre>\n
RMAN> create catalog tablespace \"RMAN\"; -- This is a logically tablespace.\r\nRecovery catalog created<\/strong><\/pre>\n
Step4.<\/strong> Register the database with Catalog database. Each database should be registered to catalog database to run RMAN backup.<\/p>\n
C:\\>rman catalog=rman\/rman@catdb target=sys\/password@UMIS\r\nRecovery Manager: Release 10.2.0.1.0 - Production on Thu May 21 09:59:26 2009\r\nCopyright (c) 1982, 2005, Oracle. All rights reserved.\r\nConnected to recovery catalog database<\/pre>\n
RMAN> Register Database;\r\nDatabase registered in Recovery catalog\r\n<\/strong>Starting full resync of recovery catalog\r\nfull resync complete\r\n<\/strong><\/pre>\n
Step5.<\/strong> Configure the persistent parameters.<\/p>\n
C:\\>rman catalog=rman\/rman@catdb target=sys\/password@UMIS\r\nRecovery Manager: Release 10.2.0.1.0 - Production on Thu May 21 09:59:26 2009\r\nCopyright (c) 1982, 2005, Oracle. All rights reserved.\r\nConnected to recovery catalog database<\/pre>\n
RMAN> configure retention policy to recovery window of 2 days;<\/pre>\n
<\/p>\n
New RMAN configuration parameters: \n<\/strong><\/p>\n
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;\r\nnew RMAN configuration parameters are successfully stored\r\nstarting full resync of recovery catalog\r\nfull resync complete<\/pre>\n
RMAN> configure default device type to disk;<\/pre>\n
New RMAN configuration parameters:<\/strong><\/p>\n
CONFIGURE DEFAULT DEVICE TYPE TO DISK;\r\nnew RMAN configuration parameters are successfully stored\r\nstarting full resync of recovery catalog\r\nfull resync complete<\/pre>\n
New RMAN configuration parameters:<\/strong><\/p>\n
CONFIGURE CONTROLFILE AUTOBACKUP ON;\r\nnew RMAN configuration parameters are successfully stored\r\nstarting full resync of recovery catalog\r\nfull resync complete<\/pre>\n
RMAN> Configure channel device type disk format 'F:\\rmanbackup\\Backup%d_DB_%U_%S_%P';<\/pre>\n
New RMAN configuration parameters:<\/strong><\/p>\n
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'F:\\rmanbackup\\Backup%d_DB_%U_%S_%P';\r\nnew RMAN configuration parameters are successfully stored\r\nstarting full resync of recovery catalog\r\nfull resync complete<\/pre>\n
<\/p>\n
Step 6.<\/strong> Take database full backup. The full database backup should be taken first time. Afterwards, archivelog backup will be taken.<\/p>\n
C:\\>rman catalog=rman\/rman@catdb target=sys\/password@orcl\r\nRecovery Manager: Release 10.2.0.1.0 - Production on Thu May 21 10:16:09 2009\r\nCopyright (c) 1982, 2005, Oracle. All rights reserved.\r\nConnected to target database: ORCL (DBID=1215124933)\r\nconnected to recovery catalog database<\/pre>\n
RMAN> run{backup database plus archivelog; delete noprompt obsolete;}\r\nStarting full resync of recovery catalog\r\n<\/strong>full resync complete<\/pre>\n
RMAN> exit\r\nRecovery Manager complete<\/pre>\n
Now the RMAN setup is completed successfully. Here is the info about RMAN.<\/p>\n
Primary DB = UMIS\r\nCatalog DB = CATDB\r\nRMAN Backup location = F:\\rmanbackup.\r\nNow the full backup is taken. Every day, the below script should run and backup the new archive log files.\r\nC:\\>rman catalog=rman\/rman@catdb target=sys\/oracle@UMIS\r\nRecovery Manager: Release 10.2.0.1.0 - Production on Thu May 21 10:16:09 2009\r\nCopyright (c) 1982, 2005, Oracle. All rights reserved.\r\nConnected to target database: ORCL (DBID=1215124933)\r\nconnected to recovery catalog database<\/pre>\n