22 Backup & Restore a database with RMAN cold.



Again let's talk about backups. There are two types of backup: 

Saying backups cold. In this case the base is inaccessible to users and it performs a simple file copy appropriate to restore in case of trouble.
The hot backup. Aurrez you understand, it is a backup open database while user continues to work on their preferred base. It is usually this type of configuration found in production mode or can not afford to stop a database to save.

However, in some cases (Bureau study, Publisher, test environment, ..) it may be desirable to set up a backup strategy without it becoming too complicated. 

Again, a bit of thought before acting will save time later and avoid crisis situations. 

Start from the premise that the base is large and arrange for any table contains many columns of type CLOB. 

Notes: The table imports with CLOB columns are very long, because processed line by line. 

Solution 1: export for backup / import for restoration. 

Compared our case study, it may be possible but may take considerable time. 
So in case of data loss, restoration can be problematic:
Duration of import / export relatively long.
In panic mode, we do not think at all. And you can forget, for example to create tables containing CLOB (if you still use the utility imp.exe) to redirect tablespace (impdp.exe), and probably other issues that do not come to mind.

Solution 2: Stopping the base, and all copies of the database file or from a tape backup location. 

So to restore, just stop again and copy the database files. 
As everyone knows, database administration and recovery tests in most editors are a high priority. (Irony -)). So when restoring the probality missing a data file is quite high and hit the restoration of your database becomes more complicated. 


I suggest you stop the "DIY" and uses this ORACLE kindly put at our disposal. 
I am willing to nominate Recovery Manager (RMAN). 

To restore, it is necessary to have a backup. 

Before effecuter it, you connect yourself with a test user and create some tables and fill. 
Unless you (which should be the case) schemes with applications you need. 

Step 1:'s perform a cold backup database: 

Start> Run> cmd 

 sqlplus / nolog
 CONNECT / AS SYSDBA
 SHUTDOWN IMMEDIATE;
 QUIT

RMAN target /
RMAN> STARTUP MOUNT;
RMAN> BACKUP DATABASE FULL;
RMAN> ALTER DATABASE OPEN;
RMAN> QUIT

Note: Throughout this example, we see that RMAN has authority to stop or start a base! 

Step 2: Returning in SQL PLUS 

 TRUNCATE TABLE T1; 
 DROP TABLE T3; 
sqlplus / nolog 
SQL> CONNECT LAO / LAO - (this is my test with three user table t1, t2, t3. Original?)

Whoops! I wanted to do the opposite! 

Quickly go into panic mode; 
SQL> CONNECT / AS SYSDBA
SQL> SHUTDOWN IMMEDIATE;

And while my database is stopped, a colleague of goodwill deletes files related to SYSTEM tablespace (which of course were not saved) ==> laws MURPHY (maximum pain in the ass). 

You can always go with your dump! 


Step 3: stop the panic and remembered that we had taken the time to think to solve this kind of problems. 

Start> Run> cmd 

SET ORACLE_SID = oradb (if ever there are several bases on your computer). 

RMAN target /
RMAN> STARTUP MOUNT;
RMAN> RESTORE DATABASE;

.... If all goes well, a little message that says "End of restore in DD / MM / YY" 

RMAN> QUIT 

Just a little effort, 

sqlplus / nolog
SQL> CONNECT / AS SYSDBA
SQL> RECOVER DATABASE UNTIL CANCEL;

The insults you receive some of our friend ORACLE. 
Simply type without trembling and then CANCEL 

SQL> ALTER DATABASE OPEN RESETLOGS; 

Oh and magic, a message saying "Database changed" 

Let's crazy! 
SQL> CONNECT LAO / LAO 

Maintanant and you can check! the tables are all the, and with the same number of lines at the time of backup. 

Conclusion: This method is the same that the proposed solution number 2: one small detail is that RMAN handles for you to know which files to backup and especially where they are! 

22 comments:

priya said...

Thanks for the useful informations shared. It's very valuable.

Path Infotech said...

Thanks for sharing the information

Oracle Certification Path

Emi Jackson said...

Your blog is really useful for me.

Regards

Oracle Training in Chennai

Anonymous said...

The information you posted here is useful to make my career better keep updates..I did Salesforce Training in Chennai at FITA academy. Its really useful for me to make bright future in IT industry.

Emi Jackson said...



Thanks for sharing this valuable information.and I gathered some information from this blog. I did SAP Course in Chennai, at FITA Academy which offer best SAP Training in Chennai with years of experienced professionals.

Victoria John said...

Its really awesome blog..If anyone wants to get Software Testing Training in Chennai visit FITA IT academy located at Chennai. Rated as No.1 Software Testing Training Institutes in Chennai

Regards.....

Testing Training in Chennai | QTP Training in Chennai

christina jeni said...


The information you posted here is useful to make my career better keep updates...If anyone want to get Cloud Computing Course in Chennai, Please visit FITA academy located at Chennai. Rated as No.1 Cloud Computing Training Institutes in Chennai

christina jeni said...

I have read your blog and i got a very useful and knowledgeable information from your blog.You have done a great job . If anyone want to get Salesforce Admin Training in Chennai, Please visit FITA academy located at Chennai Velachery. Rated as No.1 Salesforce Training Institutes in Chennai.

surangacloud said...

very nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information.
Cloud Computing Training in chennai | Cloud Computing Training chennai | Cloud Computing Course in chennai | Cloud Computing Course chennai

dhanamlakshmi palu said...

I gathered a lot of information through this article.Every example is easy to understandable and explaining the logic easily.Thanks! Vmware certification in chennai | Vmware certification chennai

Bay Max said...

There are lots of information about latest technology and how to get trained in them, like Hadoop Training Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies(Hadoop Training in Chennai). By the way you are running a great blog. Thanks for sharing this.


Hadoop Training Chennai | Salesforce Training in Chennai

Alex said...

Very inspirational to hear about someone pursuing their dream and becoming successful instead of following the traditional path.
Oracle Remote Database Administration

john mike said...

Cloud Ace Technologies is offering Implementation Services on Cloud Computing, Cloud Services, IT Security, Storage solutionsCommvault Backup Solution in chennai

john mike said...

Best Cloud Services, IT Security Solutions, IT Storage solutions Hyderabad,India
loud Ace Technologies is offering Implementation Services on Cloud Computing, Cloud Services, IT Security, Storage solutions
Commvault Backup Solution in chennai

Oracle Fusion said...

Thanks for sharing such a useful information for us and really the point you mentioned are very realistic and easier to understand.

erpcharan said...

Thanks for sharing the best points about oracle concept and really the best information to go through

yasar said...

very nice and informative blog
big data projects chennai
mobile computing projects chennai
cloud computing projects chennai
secure computing projects chennai

oracle fusion scm training said...

Awesome article. It is so detailed and well formatted, i enjoyed reading it as well as get
some new information too.
oracle fusion hcm training

dba centre said...

Thanks for putting all these together.
Good information.
Oracle dba training in hyderabad

unknown said...

Candid institute Spring and Hibernate course provides a comprehensive introduction to Spring and Hibernate open source frameworks as well as Web Services and AJAX. Suitable for both Spring3/Hibernate3 and Spring4/Hibernate4, the course includes coverage of the core Spring and Hibernate capabilities, as well as the integration capabilities provided by Spring.
spring hibernate training institutes in chennai

Oracle dba certification cost in chennai said...

Useful post. Keep updating like this informative news.
DBA course syllabus | DBA training courses

subha a said...

I simply wanted to thank you so much again. I am not sure the things that I might have gone through without the type of hints revealed by you regarding that situation.
Best selenium training Institute in chennai

 

Oracle DBA Tutorial Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates