| BACKUP & RECOVERY [message #171428] |
Tue, 09 May 2006 23:13  |
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 #171548 is a reply to message #171543] |
Wed, 10 May 2006 06:54  |
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 #171554 is a reply to message #171551] |
Wed, 10 May 2006 07:04 |
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 |
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 #171562 is a reply to message #171558] |
Wed, 10 May 2006 07:11 |
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 |
 |
Mahesh Rajendran
Messages: 10708
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
