- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- ALTER DATABASE OPEN RESETLOGS;
Operating System - HP-UX
1747986
Members
4498
Online
108756
Solutions
Forums
Categories
Company
Local Language
юдл
back
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
юдл
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- 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
тАО10-02-2003 02:17 AM
тАО10-02-2003 02:17 AM
ALTER DATABASE OPEN RESETLOGS;
Hello colleagues,
I perform the online backup of a database DBSNML and I copy the relevant files to another machine; here I've created another instance of a database DBSNML1 ...
After the creation, while the DB is empty, I perform the controfile backup by:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
After that I import the DBSNML datafiles, then I perform a startup nomount and a I create the new controlfile by setting the database name to DBSNML1
After that I try to startup the DB: it's ok, but when I open it it requires the recovery of the system.dbf ...
How can I solve this problem?
Enrico
I perform the online backup of a database DBSNML and I copy the relevant files to another machine; here I've created another instance of a database DBSNML1 ...
After the creation, while the DB is empty, I perform the controfile backup by:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
After that I import the DBSNML datafiles, then I perform a startup nomount and a I create the new controlfile by setting the database name to DBSNML1
After that I try to startup the DB: it's ok, but when I open it it requires the recovery of the system.dbf ...
How can I solve this problem?
Enrico
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-02-2003 02:23 AM
тАО10-02-2003 02:23 AM
Re: ALTER DATABASE OPEN RESETLOGS;
Have you done Shutdown cleanly, i mean Shutdown immediate,
You need to switch log files immediately after the point in time that you want to recover to. I believe that this will give you the last change that you are looking for ,
then u do clean shutdown and then follow again with all the procedure(copying all the files ), u have done with.
Hope u got,
Thanks
You need to switch log files immediately after the point in time that you want to recover to. I believe that this will give you the last change that you are looking for ,
then u do clean shutdown and then follow again with all the procedure(copying all the files ), u have done with.
Hope u got,
Thanks
Information is Wealth ; Knowledge is Power
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-02-2003 02:58 AM
тАО10-02-2003 02:58 AM
Re: ALTER DATABASE OPEN RESETLOGS;
If you are sure that the last shutdown was not normal or immediate, recovery is not required. Then you can "CREATE CONTROLFILE REUSE set DATABASE RESETLOGS" to recreate the database.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-03-2003 05:26 AM
тАО10-03-2003 05:26 AM
Re: ALTER DATABASE OPEN RESETLOGS;
Hi,
when you say, you copied relevant files, did you copy the recent archive logs that were generated after the hotbackup started. besides, are you switching logfiles at the end of your hotbackup script. if not then, thats the problem.
so do a hotbackup which has a switch logfile statement at the end of your backup script, copy all datafiles, archivelogs to the another machine.
startup nomount;
create controlfile set dbsnml1...restlogs...
recover database using backup controlfile
feed the necessary archivelogs
alter database open resetlogs.
hth,
Stan
when you say, you copied relevant files, did you copy the recent archive logs that were generated after the hotbackup started. besides, are you switching logfiles at the end of your hotbackup script. if not then, thats the problem.
so do a hotbackup which has a switch logfile statement at the end of your backup script, copy all datafiles, archivelogs to the another machine.
startup nomount;
create controlfile set dbsnml1...restlogs...
recover database using backup controlfile
feed the necessary archivelogs
alter database open resetlogs.
hth,
Stan
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP