ChannelDB2

Darshan's Blog (2)

Some strange issue in Redirected restore... part-1

Ok so here is the scenario..



- Have database1 in db2inst1

- Took a offline (cold) backup of database1

- did redirected restore to clone database1 in to database2 in same instance

- set tablespace containers, worked just fine , no errors.

- roll forward database to end of logs and complete , worked fine no errors



Now problem starts. When app folks told me they are missing some data, which was simply not visible to me because I did cold backup and then… Continue

Added by darshan on August 5, 2009 at 11:09pm — No Comments

Stupid issue in accessing tables !!

Stupid me.. !! And I guess thats how I learn new things... !!



I got a request from our performance team that we have to move tables from default tablespace to new tablespace to improve performance.



So I did following



1. Created a duplicate tables

2. Preserved data by "insert into temp select * from main"

3. generated DDL with grants,aliases etc.

4. change the tablespace name in DDL

5. Drop main tables

6. Created new tablew with modified… Continue

Added by darshan on May 6, 2009 at 10:00am — 2 Comments

Featured Downloads

Try BLU Acceleration on Cloud

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service