- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Tablespace Backup/Restore test
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-05-2010 12:18 AM
тАО12-05-2010 12:18 AM
Tablespace Backup/Restore test
We have just installed the DP 06.11 on our servers and now want to test the backup/restore for our database.
The backup performed successfully but while trying to restore the file I am geeting some error message, request you to please review the backup/restore process below and suggest me if I am making some mistake in my steps.
SQL> create tablespace testtbs;
Tablespace created.
SQL> create table testtable (empid number(2))
2 tablespace testtbs;
Table created.
SQL> insert into testtable values(2);
1 row created.
SQL> insert into testtable values(3);
1 row created.
SQL> select * from testtable;
EMPID
----------
2
3
*Tablespace testtbs Backup Taken Successfully.
SQL> update testtable set empid=5 where empid=2;
1 row updated.
SQL> commit;
Commit complete.
SQL> select * from testtable;
EMPID
----------
5
3
SQL> alter tablespace testtbs offline;
Tablespace altered.
*Restore tablespace testtbs performed on DP successfully.
But while making tablespace testtbs online, I am getting below error message:
SQL> alter tablespace testtbs online;
alter tablespace testtbs online
*
ERROR at line 1:
ORA-01113: file 22 needs media recovery
ORA-01110: data file 22:
'/home/oracle/app/oracle/oradata/VIVADEV/datafile/o1_mf_testtbs_6hpg7g6y_.dbf'
Please suggest.
Regards,
Saurabh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-05-2010 01:17 AM
тАО12-05-2010 01:17 AM
Re: Tablespace Backup/Restore test
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1336426
This is another, similar.
http://forums.oracle.com/forums/thread.jspa?threadID=358621
Shibin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-05-2010 01:47 AM
тАО12-05-2010 01:47 AM
Re: Tablespace Backup/Restore test
a database is no filesystem.
While you backup the tablespace, the DB still writes to the tablespace. Thus, since the
backup takes a couple of time, your backup is not consistent.
After you restored it, it requires
RECOVERY to make it consistent again.
Do a google search to learn the difference
between restore and recovery in oracle language.
You will require the offline redologs to
recover your tablespace.
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-05-2010 01:56 AM
тАО12-05-2010 01:56 AM
Re: Tablespace Backup/Restore test
and while I review your scenario:
This looks like you want to set back the tablespace to an earlier timestamp.
THIS CAN NOT BE DONE as simple as you think.
It would make the entire DB inconsistent.
Partial "point-in-time" reset strategies
require a significant amount of action
and a proper and preplanned documentation,
to make sure nothing goes wrong.
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-06-2010 12:34 AM
тАО12-06-2010 12:34 AM
Re: Tablespace Backup/Restore test
Please find the attached steps which I followed during the TSPITR but failed,
please suggest if I am making some mistake in the process.
Your help is highly appreciated !!
Regards
Saurabh