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:
https://samadhandba.wordpress.com/2010/12/26/rman-login-syntax%e2%80%a6/
https://samadhandba.wordpress.com/2011/02/17/oracle-backup-and-recovery-solutions/
https://samadhandba.wordpress.com/2011/02/10/what-happens-during-oracle-database-hot-backup/
https://samadhandba.wordpress.com/2011/02/10/user-managed-hot-backup-of-oracle-database/
https://samadhandba.wordpress.com/2011/01/08/backing-up-the-db-in-noarchivelog-mode/
https://samadhandba.wordpress.com/2010/12/26/rman-%e2%80%93-recovery-manager-commands%e2%80%a6/
https://samadhandba.wordpress.com/2010/12/26/run-a-command-file-from-the-rman-prompt/
https://samadhandba.wordpress.com/2010/12/26/starting-up-and-shutting-down-the-database-with-rman/
https://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
https://samadhandba.wordpress.com/
“Key for suceess, always fight even knowing your defeat is certain….!!!!”
i am very much pleasure to know that
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
https://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………..
Dear Samadhan,
Please Tell me How to create New DataBase.
Manual Creation not DBCA and OMF.
if you any information plz send me the Details .
Dear please chk my manula DB creation post in my blog ….. 🙂
hi samadhan,
Recently i got my first job after BE(cs) and they have put me on ORACLE DBA without any training and it seems tough to understand so i m planning for oracle DBA course so that not only i can understand dba related terms but also keep pace with the people like you…
so would you plz suggest me how exactly i should start ?
What kind of course i have to do .
Regards
Dipanshu
Well as fresher it is hard to get job in oracle DBA , just enter in IT with any other profile …. keep reading blog / learning …. make practice on dummy DB …. all the best 🙂
sir i am ocp in 10g and i want to update ocp 11g without any coaching is it possible ……and tell me what the procedure……..now what i can do
Hi Dear , yes you can go for 11g OCP exam without any coaching …. well i never recomend but u can check out recent exam dumps … and just go for it …. all the best 🙂
Hi samadhan DADA,
I am very much pleasure to see this type of blog.
I always want to connect with this blog.
Pray for me.
Thanks & Regards
Karim
Bangladesh.
Dear Karim,
So kind of you, I always pray for you and wish u all the best for ur future.
Thanks & Regards,
Samadhan
After upgrade oracle database 10g to 11g but when i connect
“sqlplus /as sysdba”
It shows
SQL*Plus: Release 11.1.0.7.0 – Production
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 32bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Pls help
Thanks
Hey,
Sorry for late reply….. don’t worry it seems to be that u upgrade DB only on 11g.
But your client is still running as 10g, so please upgrade client as well.
Please let me know if you still have any issue or any update.
Thanks & Regards,
Samadhan
Excellent Work Samadhan .. Your information is very helpful
I want to take a dump without data is it possible to take this kind of backup
Please let me know
Yes dear , you can take it by using export expdp content=metadata_only option …. hope you are talking about this only…..
what is the difference between expdp and export?
Well in short expdp is new in Oracle 10g and having lots of feature such as compression , directory specification and for detail you can google it and also will come up with my new post for this requirement 🙂
magnificent put up, very informative. I wonder why the
opposite specialists of this sector don’t understand this.
You should proceed your writing. I am confident, you have a great readers’ base already!