19 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! 

19 comments:

Path Infotech said...

Thanks for sharing the information

Oracle Certification Path

Unknown 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.

Unknown 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.

Unknown 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

Unknown 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

Unknown 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

Unknown 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

Alex said...

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

Unknown said...

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

Unknown 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

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

Anonymous said...

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

Oracle dba certification cost in chennai said...

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

shiny said...

Informative post.Thank u.You have delivered oracledescription in very simple way.Good knowledge sharing.
moto service center in chennai
motorola service center in chennai
moto service centre chennai

unknown said...

Informative post indeed, I’ve being in and out reading posts regularly and I see alot of engaging people sharing things and majority of the shared information is very valuable and so, here’s my fine read.
click here button gif
click here book
click here button image
click here button html
click here blinking button

 

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