Home » RDBMS Server » Backup & Recovery » BACKUP & RECOVERY
BACKUP & RECOVERY [message #171428] Tue, 09 May 2006 23:13 Go to next message
anandhi
Messages: 31
Registered: April 2006
Location: Chennai
Member
hi

can anyone explain or suggest a website " WHAT HAPPENS AT THE BACKGROUNG WITH RESPECT TO ARCHITECTURE DURING BACKUP AND RECOVERY?"

I want to know exactly what happens at the background? what are the processes involved?

i want a detailed information like how they explained for SQL STATEMENT EXECUTION.

thanks
Anandhi
Re: BACKUP & RECOVERY [message #171543 is a reply to message #171428] Wed, 10 May 2006 06:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
How about this same website/google?
Did you try to search.
Re: BACKUP & RECOVERY [message #171548 is a reply to message #171543] Wed, 10 May 2006 06:54 Go to previous messageGo to next message
anandhi
Messages: 31
Registered: April 2006
Location: Chennai
Member
hi

I didnt get any related article. i got documents related to the RMAN backup.

I didnt get any article which explains "what happens at the background during backup and recovery"

thanks
Anandhi
Re: BACKUP & RECOVERY [message #171551 is a reply to message #171548] Wed, 10 May 2006 06:58 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Did you download documentation from Oracle's website and tried reading it? You can download it for free.

Or did you try reading any good book related to backup & recovery?

[Updated on: Wed, 10 May 2006 06:58]

Report message to a moderator

Re: BACKUP & RECOVERY [message #171553 is a reply to message #171548] Wed, 10 May 2006 07:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
YOu must be talking about the BEGIN backup/ ENd backup thingy.
It is out-of-date method. Concentrate in RMAN.
http://www.orafaq.com/forum/m/164452/42800/?srch=Tim+Gorman#msg_164452
http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14192/glossary.htm#i432099

Re: BACKUP & RECOVERY [message #171554 is a reply to message #171551] Wed, 10 May 2006 07:04 Go to previous messageGo to next message
anandhi
Messages: 31
Registered: April 2006
Location: Chennai
Member
I have the oracle documentation but in those documents also they didnt mention what exactly happens at the background.

In oracle documentation they clearly explained what happens when we issue DML statements and which process is responsible for what activities...

the same way i want to know what happens exactly atthe background when we perform backup and recovery.
Re: BACKUP & RECOVERY [message #171557 is a reply to message #171554] Wed, 10 May 2006 07:06 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Try going through the links that Mahesh provided you and then come back with some thing specific because if you will be precise in asking questions then you will get fast answers.And sorry in saying but no body can explain you Backup & Recovery here. It's a very big topic to cover.


Warm regards,
Tarun

[Updated on: Wed, 10 May 2006 07:07]

Report message to a moderator

Re: BACKUP & RECOVERY [message #171558 is a reply to message #171554] Wed, 10 May 2006 07:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Are you sure?
I have no idea which document you are using.
The one i use, clearly explains what happens in
Backup mode and in restoration mode.
http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14191/toc.htm
Re: BACKUP & RECOVERY [message #171562 is a reply to message #171558] Wed, 10 May 2006 07:11 Go to previous messageGo to next message
anandhi
Messages: 31
Registered: April 2006
Location: Chennai
Member
hi Mahesh

I have gone through the documents that you have sent to me.

my question is

1) when you issue DML statement, we clearly know what is happening at the back ground
ie Parsing, executing and Fetching
DBWR will write datafiles and LGWR will write to redo log etc.


the same way when we issue Recover database command what exactly happens at the background....
ie it will bring the data to the large pool and the what transactions exactly happens at the background.

i hope i am clear.

thanks
anandhi


Re: BACKUP & RECOVERY [message #171656 is a reply to message #171562] Wed, 10 May 2006 21:15 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> ie it will bring the data to the large pool
What 'large pool' ?
The large pool of the database being restored?
Your question is trivial.
RMAN does the restoration/recovery in a much lower level.

Please be Warned.
I am about to recap the words from backup & recovery manual in a few lines and my statements can easily mislead
or even be grossly inaccurate.

When you restore a database, it should be in nomount stage (in RMAN).
By RESTORE you are just copying the datafiles and controlfiles back to the original location ( or even to a new location , incase your restoring to another host or cloning).
If you are doing a consistent mode restoration, there is no recovery needed.
Recovery is a process where those restored datafiles and controlfiles are made consistent with each other and synchronized and should be be done before the database is 'opened'. So when you do an
incomplete recovery (TSPITR) you are just bringing the database to some point in time.
For this particular operation, you need archived logs.
So archived logs are scanned back and forth. Every single transaction will be redone (or done again), until
the point-in-time or SCN that was requested is reached.
Previous Topic: how i recover my old table with data
Next Topic: Can I run an import without drop and recreate schema ?
Goto Forum:
  


Current Time: Fri Mar 29 02:41:42 CDT 2024