- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: one confusion about oracle
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-29-2004 01:50 AM
тАО12-29-2004 01:50 AM
This time, I restore all files into exact directorys(datafiles,control files and online/offline redo logs) and the backup time is '2004-12-27:03:00:00'. So, I want to appply archieved logs until '2004-12-27:08:00:00' and met this error.
SQL> recover database until time '2004-12-27:08:00:00' using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/oracle/R3D/sapdata1/system_1/system.data1'
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/oracle/R3D/sapdata1/system_1/system.data1'
I notice, '2004-12-27:08:00:00' is before '2004-12-27:10:00:00' and how does oracle know when I open it with "resetlogs" ??
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-29-2004 02:29 AM
тАО12-29-2004 02:29 AM
Re: one confusion about oracle
Oracle archiving can only process recovery requests from the past to the future, not the opposite. As you said you've already done a "alter database open resetlogs" at 2004-12-27:10:00, so you can't do any recovery before this date and time with this open database.
But you can put all the backup files (datafiles, redologs and control) again in there place ready to recover (erasing the present database) and retry all the recover operation as you want until 2004-12-27:10:00.
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-29-2004 02:30 AM
тАО12-29-2004 02:30 AM
Re: one confusion about oracle
'/oracle/R3D/sapdata1/system_1/system.data1'
When you restored, you restored all control files? When you backed up was it hot or cold, rman or other methodology?
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-29-2004 02:33 AM
тАО12-29-2004 02:33 AM
Re: one confusion about oracle
"...and retry all the recover operation as you want until 2004-12-27:08:00."
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-29-2004 12:14 PM
тАО12-29-2004 12:14 PM
Re: one confusion about oracle
From you post I understand that
You have a database backup as of at 03:00 hours on 27-12-2004.
You recovered the database and applied the logs till 10:00 hours on 27-12-2004 and opened the database with resetlogs option.
Next time you wanted to recover the database as of 08:00 hours on 27-12-2004.
I agree with Eric that archive logs can be applied to recover an instance to a time in the future.
Now if you wanted to recover the database to 08:00 hours then you will have to shutdown the database that you opened earlier, and restore the datafiles, control files and redologs again into their respective directories and then issue the command
SQL> Recover database using backup contorlfile until time ├в 2004-12-27:08:00├в ;
You should be able to recover it and open the database. May be earlier you had the control files and datafiles belonging to different times.
I hope this helps
In
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-29-2004 02:55 PM
тАО12-29-2004 02:55 PM
Re: one confusion about oracle
seems like a problem with your control files.
i would recommend that you use RMAN for backup and restore. The management will be much easier.
Please refer to metalink note: 73974.1 - RMAN: Restoring an RMAN backup to another node.
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-29-2004 04:35 PM
тАО12-29-2004 04:35 PM
Re: one confusion about oracle
Also check the value of control_files in the parameter file.
sks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-29-2004 11:20 PM
тАО12-29-2004 11:20 PM
Re: one confusion about oracle
I guess I mislead you in some way.
I describe the situation in details.
1) I have cool backup at 2004.12.27 3:00.
That afternoon, I restore all files and done an incomplete recovery until 12.27 10:00 and open database with "resetlogs".
2) At 2004.12.19, another recovery must be done. I still restored those files(backuped at 2004.12.27 3:00) and want to do more time just as last time, only differece is that time-point is 8:00 not 10:00. but the error occured.
3) I use backup method provided by SAP.
I try more time and get it over.
a) restored all files.
b) recover database
c) recover database until '2004-12-27:08:00:00' using backup controlfile
d) alter database open resetlogs
All the best.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-29-2004 11:38 PM
тАО12-29-2004 11:38 PM
Re: one confusion about oracle
I want to say
2) At 2004.12.29, another recovery must be done. I still restored those files(backuped at 2004.12.27 3:00) and want to do more time just as last time, only differece is that time-point is 8:00 not 10:00. but the error occured.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-30-2004 01:10 AM
тАО12-30-2004 01:10 AM