- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: restore the database
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
тАО05-15-2008 05:27 AM
тАО05-15-2008 05:27 AM
restore the database
my requirement is to restore and recover prod database in test box as of 4/26 9pm.
i did the following steps
1.created pfile and pwd file
2.started database in test box in nomount mode
3.restored the control file
RUN{set until time "to_date('2008-APR-26:21:00:00','yyyy-MON-dd:hh24:mi:ss')";
allocate channel c1 type 'sbt_tape' parms 'ENV=(NB_ORA_CLIENT=bsdwh01)';
restore controlfile to '/oracle/redo1/oradata/fdwp1/control01.ctl';
release channel c1;
}
4.copy the control file to the control file locations as defined in the pfile.
5.alter database mount-->database mounted fine.
6 while trying to restore the database with the below commands
RUN{set until time "to_date('2008-APR-26:21:00:00','yyyy-MON-dd:hh24:mi:ss')";
allocate channel c1 type 'sbt_tape' parms 'ENV=(NB_ORA_CLIENT=bsdwh01)';
restore database;
release channel c1;
}
rman searching for 19th full backup media.
Note:26th full backup media is loaded in the backup server.
my question is y rman searching for 19th full backup media instead of 26th full backup media.
Thanks,
Nirmal.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2008 06:16 AM
тАО05-15-2008 06:16 AM
Re: restore the database
i forgot to mention 2 points in my original post
1.i have restored control file by using recovery catalog
2.iam restoring the database without recovery catalog .
Thanks,
Nirmal.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2008 06:48 AM
тАО05-15-2008 06:48 AM
Re: restore the database
Cos if its the time the backup started it would make sense that rman wants to select the last full backup (presumably the one done 7 days previous on 19 Apr) and then roll forward from that point...
just a guess
Duncan
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2008 06:55 AM
тАО05-15-2008 06:55 AM
Re: restore the database
Thanks for the response.
The full backup completed on 26th Apr 2008 15:00 pm.iam trying restore this full backup only.But Rman searching for 19th backup.
Thanks,
Nirmal.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-15-2008 10:33 AM
тАО05-15-2008 10:33 AM
Re: restore the database
I'd have assumed something similar.
What Timezone are you in, so what is your UTC offset? What is you NLS Environment for backup shell and restore shell?
In case the backup is taken via cron, the timezone or NLS environment might not be set or missing in the environment and this would cause some offset to a recovery from a shell that has a timezone (or NLS) set.
So try to recover the 27th (28th), just to see, if it loads the 26th tape. If it takes the 26th you'll have a system-time/wrist watch missmatch, and most likely you'll need either to adjust TZ or choose another timestamp.
If it still loads the 19th (to recover the 27th) something else is wrong, may be related to then catalog/controlfile stuff,
or the backup taken on 26th was bad.
Anyway, if everything else goes wrong, restore the 19th and recover the logs ...
Good hunting
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-16-2008 03:35 AM
тАО05-16-2008 03:35 AM
Re: restore the database
Duncan and Volker above explained to you what might be happening.
Is your problem solved already?
revert!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-16-2008 03:48 AM
тАО05-16-2008 03:48 AM
Re: restore the database
Thanks for the response.
please find answers for ur questions:
Timezone of the restore server is PST(GMT-8:00) and backup server is CST(GMT-6:00).
Backups are not scheduled in cron ,it is scheduled in the backup server.
i have tried to restore by setting until time to 27/28th april 2008 in Rman.But still Rman searching for 19th backup not 26th backup.
26th backup is gud backup.
Hi yogeeraj,
Thanks for the response.
Issue is not resolved..
Thanks,
Nirmal
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-16-2008 11:18 AM
тАО05-16-2008 11:18 AM
Re: restore the database
concerning the Controlfile stuff:
To recover the 26th backup with the restored controlfile, the backup needs to be registered in that very special resotered controlfile (when trying to recover without a cataog). If that did not happen upon backup, the 26th backup is simply not seen as a recovery option.
Since I rarely do native rman stuff, I do not have the V$BACK... Table names ready, that you should query, to confirm,
that that backup is regisiterd in that controlfile.
Did you try to restore 26th with catalog ?
Volker