| RMAN tablespace backup and restore [message #516728] |
Wed, 20 July 2011 05:11  |
|
|
Hi All,
I have taken the backup of a tablespace using the below mentioned command.
run
{
allocate channel c1 device type disk;
backup tablespace tcs_tbs;
}
Now I after even after one month or one year I want to restore the backup on my same database to bring the tablespace to the previous position.
Is it possible to restore even after one year, Is retention period gonna play its role in this?
What would be the script?
Thanks
DS
|
|
|
|
|
|
| Re: RMAN tablespace backup and restore [message #516733 is a reply to message #516730] |
Wed, 20 July 2011 06:10  |
|
|
Thanks for the reply Sir, let me explain you possibilities at my side, I just want to take the backup only once for a tablespace.
I want to restore the tablespace back to the earlier point using the backup, but there is no limit for the time.
I want that if I can restore it just the next day, next week, next month or may be after year.
What are all the requirement that I have to fulfill?
Thanks
Deepak
|
|
|
|
|
|
|
|
|
|
| Re: RMAN tablespace backup and restore [message #516770 is a reply to message #516744] |
Wed, 20 July 2011 14:17 |
|
|
No this is true Sir, I have database in No Archive Mode in my company, since the transaction are very high and there many developers who access that database for testing purpose so the archives will be generated in large quantity.
Now what I have the situation that I have created seperate tablespace for each client's data.So I want to take the backup of each tablespace once an keep it with me.
Later on I can do my testing work or anything on the database but I want that If I want to go back to previous stage when the backup was taken, I should be able to whether it is after a week, a month or after six months.
Whick approach should I follow Sir?
Thanks
Deepak
|
|
|
|
| Re: RMAN tablespace backup and restore [message #516772 is a reply to message #516770] |
Wed, 20 July 2011 14:41 |
 |
Michel Cadot
Messages: 54686
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Quote:since the transaction are very high and there many developers who access that database for testing purpose so the archives will be generated in large quantity.
1/ If it is a production database NO developer should access it
2/ If it is a development database then data is of no importance and so I don't see the reason to backup a tablespace and keep it 6 months.
3/ If it is a production database then it MUST be in ARCHIVELOG mode otherwise it means you don't care of your transactions.
Anyway, a NOARCHIVELOG mode database supports ONLY 1 backup type: full cold one and the only thing you can restore is a full database at time of backup.
Regards
Michel
[Updated on: Wed, 20 July 2011 14:43] Report message to a moderator |
|
|
|
| Re: RMAN tablespace backup and restore [message #516775 is a reply to message #516772] |
Wed, 20 July 2011 14:51 |
|
|
Yes Sir it is the development database.. we need to use it for testing purpose.. just for ourself.
I just want to take tke backup of individual tablespaces so that as per my requirement I can restore the respective tablespace.
How can I do this using RMAN?
Regards
Deepak
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
