Step 1: First of all your must mount point out your database using ORACLE_SID in windows ORAENV in linux.
C:>set oracle_sid=samdb
C:>sqlplus “/as sysdba”
SQL*Plus: Release 10.2.0.1.0 – Production on Thu Jan 6 19:51:53 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Production With the Partitioning, OLAP and Data Mining options
SQL> select log_mode from v$database; LOG_MODE ———— ARCHIVELOG
Step2 : Create Rman Tablespace
SQL> CREATE TABLESPACE RMAN01 DATAFILE ‘F:oracleproduct10.2.0oradatasamdbRMAN01.DBF’ SIZE 100M REUSE AUTOEXTEND ON; Tablespace created.
Step 3: Create RMAN user and password. Here i have been using rman01 and rman01 and assign default tablespace RMAN01 and temporary tablespace TEMP.
SQL> CREATE USER RMAN01 IDENTIFIED BY RMAN01 DEFAULT TABLESPACE RMAN01 TEMPORARY TABLESPACE TEMP;
User created.
Step 4: Grant appropriate permission to rman user (the above user)
SQL> GRANT CONNECT, RESOURCE, RECOVERY_CATALOG_OWNER TO RMAN01;
Grant succeeded.
Step 5: Lanch rman tool.
C:>RMAN
Recovery Manager: Release 10.2.0.1.0 – Production on Thu Jan 6 20:51:53 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved.
Step 6: Connect catalog database using the above rman user.
RMAN> CONNECT CATALOG RMAN01/RMAN01@samdb connected to recovery catalog database
Step 7: Once you connect catalog database immediately run the following query using the given tablespace. RMAN> CREATE CATALOG TABLESPACE RMAN01; recovery catalog created The recovery catalog will store information about target database.
Step 8: Once connect target databse immediately Register your database. this is called incornation database (reference for the catalog database). Once incarnation database register there are some steps configre targer databaes. The target database that will store information about bacup’s and recovery.
C:> RMAN TARGET / CATALOG RMAN01/RMAN01@ADAPTIME Recovery Manager: Release 10.2.0.1.0 – Production on Thu Jan 6 22:51:53 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: KEYSTONE (DBID=3390662877) connected to recovery catalog database
RMAN> REGISTER DATABASE; database registered in recovery catalog starting full resync of recovery catalog full resync complete
RMAN> SHOW ALL; 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 ‘F:ORACLEPRODUCT10.2.0DB_1DATABASES NCFKEYSTONE.ORA’; # default RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; new RMAN configuration parameters: CONFIGURE CONTROLFILE AUTOBACKUP ON; new RMAN configuration parameters are successfully stored starting full resync of recovery catalog full resync complete
Expert are always welcome for their valuable comment or suggestion for the above post.
Related Post:
http://samadhandba.wordpress.com/2010/12/26/rman-login-syntax%e2%80%a6/
http://samadhandba.wordpress.com/2011/02/17/oracle-backup-and-recovery-solutions/
http://samadhandba.wordpress.com/2011/02/10/what-happens-during-oracle-database-hot-backup/
http://samadhandba.wordpress.com/2011/02/10/user-managed-hot-backup-of-oracle-database/
http://samadhandba.wordpress.com/2011/01/08/backing-up-the-db-in-noarchivelog-mode/
http://samadhandba.wordpress.com/2010/12/26/rman-%e2%80%93-recovery-manager-commands%e2%80%a6/
http://samadhandba.wordpress.com/2010/12/26/run-a-command-file-from-the-rman-prompt/
http://samadhandba.wordpress.com/2010/12/26/starting-up-and-shutting-down-the-database-with-rman/
http://samadhandba.wordpress.com/2010/12/26/making-a-full-backup-with-rman/
Hi Samadhan,
Great Work!!!!!
Am new to oracle.
I have a few questions.
In my current project we do database refresh for every 3months.
Issue is our production database is around 2TB and its very difficult to move all the data files (around 800 datafiles) from production server to test server.
Right now we move it by scripts which we create it every time.
If I use RMAN we can automate this process. Can you please suggest me your view.
My question:
• What are the requirements to setup rman.
• We don’t have tape (TSM). We don’t take backups for test database.
• We have two servers so I can create rman catalog database.
Dear Naresh,
Extremely sorry for late reply.
. As you said you have two so you can create rman catalog database on same.
.Although you don’t have tape backup but you can manage with Disk backup.
Hope this info help you, let me know if you required any more info.
Thanks & Regards,
Samadhan
http://samadhandba.wordpress.com/
“Key for suceess, always fight even knowing your defeat is certain….!!!!”
Dear samadhan
Thank you,
This configuration works fine,
but how to take backup & recovery please help
Really Good explaination…………. god bless you
Dear Mohsin,
Thx for your kind wirds and same to you….!!!!
Thanks & Regards,
Samadhan
http://samadhandba.wordpress.com/
Thanks for sharing , Great information
Sir
I am very new dba and i had a backup taken last month but lost the catalog database. I have to restore the database now can i do it without the catalog ?
my database is 10g
Dear Sameer,
Though you lost your catalog database you can restore the database using control file as same info what is in catalog is present in control file as well.Btw nice query and keep commenting and tc.
Thanks & Regards,
Samadhan
Dear Samadhan,
My name is Sohail and iam very new to DBA . So can i have all Rman steps
and bit theary of Rman. And also i want steps for Data guard. Waiting for
reply…………………….
Sohail
Dear Sohail,
You will find this in my blog…. please search the required info in my blog….
You are right door….
Thanks & Regards,
Samadhan
May i have some questions and answers related to Data Pump Utilities…
Regards,
Sohaill
Please go ahead….
Dear Samadhan,
What is the meaning of Fractured block?
Dear Sohail,
A block in which the header and footer are not consistent at a given SCN…
Thanks & Regards,
Samadhan
chekpoint also written SCN on -onlinerelo logfiles also?
Dear Sohail,
Sorry but i didn’t got your question. So let me tell you first difference between SCN and checkpoint.
Checkpoint number is the SCN number at which all the dirty buffers are written to the disk, there can be a checkpoint at object/tablespace/datafile/database level.
There is only one SCN at a time in the entire system. SCN is generated continuously in the database representing the database time or internal clock. Whenever a transaction completes, the scn is generated, SCN’s are assigned to transactions as they complete.
When we commit a transaction, that transaction is assigned a SCN, but it does not mean the SCN is generated when the transaction is committed. When a transaction is committed, the SCN at that particular time is assigned to that transaction.
Thanks & Regards,
Samadhan
Thanks a lot dear……………… you r Mr.Perfect…………….
Great going………..