Home » RDBMS Server » Backup & Recovery » RMAN tablespace backup and restore (Oracle 10g 10.2.0.1.0)
RMAN tablespace backup and restore [message #516728] Wed, 20 July 2011 05:11 Go to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

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 #516730 is a reply to message #516728] Wed, 20 July 2011 05:44 Go to previous messageGo to next message
Michel Cadot
Messages: 59145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is it possible to restore even after one year

Yes, if you have the archived logs since this time or if the tablespace was put in read-only mode before.

Quote:
Is retention period gonna play its role in this?

Yes, but
- if you didn't make another backup then the policy does not come into action
- if you did then you can always recatalog the backup to use it

Regards
Michel
Re: RMAN tablespace backup and restore [message #516733 is a reply to message #516730] Wed, 20 July 2011 06:10 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

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 #516738 is a reply to message #516733] Wed, 20 July 2011 07:07 Go to previous messageGo to next message
Michel Cadot
Messages: 59145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use Transportable Tablespace technic.

Regards
Michel

[Updated on: Wed, 20 July 2011 07:07]

Report message to a moderator

Re: RMAN tablespace backup and restore [message #516743 is a reply to message #516738] Wed, 20 July 2011 07:43 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

What if my database is in NO ARCHIVE MODE Sir?


Thanks
Deepak
Re: RMAN tablespace backup and restore [message #516744 is a reply to message #516743] Wed, 20 July 2011 08:08 Go to previous messageGo to next message
Michel Cadot
Messages: 59145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not possible.
No database should be in NOARCHIVELOG mode, no one except those you want to throw.

Regards
Michel
Re: RMAN tablespace backup and restore [message #516770 is a reply to message #516744] Wed, 20 July 2011 14:17 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

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 Go to previous messageGo to next message
Michel Cadot
Messages: 59145
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 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

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
Re: RMAN tablespace backup and restore [message #516797 is a reply to message #516775] Wed, 20 July 2011 23:23 Go to previous message
Michel Cadot
Messages: 59145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
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.


So, you can't.

Regards
Michel

[Updated on: Wed, 20 July 2011 23:24]

Report message to a moderator

Previous Topic: Recovery without backup
Next Topic: How can i recover my db
Goto Forum:
  


Current Time: Sat Sep 20 03:57:31 CDT 2014

Total time taken to generate the page: 0.06714 seconds