- 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-30-2004 02:01 AM
тАО12-30-2004 02:01 AM
Re: one confusion about oracle
COLD backup has the biggest disadvantage - DOWNTIME!
I still wonder why people still do COLD backup, when with HOT backup, we have uptime and recovery procedures are not too complicated and we can recover till the very last transaction...
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-30-2004 02:04 AM
тАО12-30-2004 02:04 AM
Re: one confusion about oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-30-2004 03:03 AM
тАО12-30-2004 03:03 AM
Re: one confusion about oracle
Your 2) subject is the same as in previous post.
If it worked at the first time for 10:00, it must work with 08:00 since the cold backup is from 03:00! You must have done something different the time...
Darren,
Here I desagree with Yogeeraj... I use cold backup since the very begining and had recover only once: I loosed 2 hours of work but that wasn't critical for my organization because those 2 hours of data will never cover the money and time will needed to spend to garantee them with archive logs!
So, you have to evaluate what are the essencial needs for your organization:
- Restore time;
- Maximum data you can loose (in hours);
- Downtime you can have;
- Database volatility (changing speed);
- Disk space available for archive logs and money available to buy more if they are needed, ...
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-30-2004 11:32 AM
тАО12-30-2004 11:32 AM
Re: one confusion about oracle
Thanks you for reply.
Really, another difference thing ignored is when I recover Oracle to 8:00 in the second time, I don't do "recover database" before "recover database using backup controlfile" and got that error. So, I do again following my last post, which is just like my recovery to 10:00 in the first time.
So, I have some confusion.
I believe doing "recover database" before "recover database using backup controlfile" seems to be insignificant.
Do you think?
---------------
About doing cold backup, you listed many factors concerned with and I take my side on you.
But you may neglect another important factor --- person.
I don't support COLD BACKUP.
In the beginning, I ONLINE backuped Oracle but an awful boss can destroy everything.
:-)
He made an opinionated decision that bakcup Oracle must be like backup AS/400(he is very skillful about AS/400.). I am new clerk and can't persuade him, which results in current situation directly.
Badly ~~~
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-30-2004 04:02 PM
тАО12-30-2004 04:02 PM
Re: one confusion about oracle
1. Complete recovery fails because an archived log is lost.
2. All unarchived redo log files and a datafile are lost.
3. User error
- An important table was dropped.
- Invalid data was committed in a table.
4. Current control file is lost and a backup control file must be used to open the database.
One need to give the following command only once for the recovery.
recover [automatic] database until time 'yyyy-mm-dd:hh:mm:ss' using backup controlfile.
A combination of Online/offline (cold) backups are used depending on the crticality of the database and 24x7 operations where database shutdown is not possible.
sks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-31-2004 02:22 AM
тАО12-31-2004 02:22 AM
Re: one confusion about oracle
If I own all files(data files and control files) and roll Oracle forward, I use "recover database " or "recover database using backup cotrolfile" ??
I found do "recover database until cancel", trace file tell me "Media recovery is not necessary" and do nothing.
And with the same files I do "recover database using backup controfile until cancel ", the database really roll forward.
Why? Who can tell me?
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-01-2005 12:48 AM
тАО01-01-2005 12:48 AM
Solution1. No need to open the database with resetlogs.
2. New incarnation of database does not happen.
3. A complete backup is not mandatory.
In case of incomplete recovery, one should always use "recover database until or using backup controlfile" and this process
1. Always need to open the database with resetlogs.
2. New incarnation of database happen.
3. A complete backup is mandatory (preferably cold).
The message "Media recovery is not necessary" in case of "recover database" comes beacause control file, database files and redo log files are all in sync and no recovery is required.
Whereas in case of "recover database until cancel using backup controfile", Oracle tries to simulate an incomplete recovery scenario (even though backup file is matches that of other files).
sks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-02-2005 08:17 PM
тАО01-02-2005 08:17 PM
Re: one confusion about oracle
In you specific situation, you must do:
- Restore all datafiles;
- Do not restore controlfiles and redolog files;
- Mount database (startup mount);
- recover database until time '2004-12-27:08:00:00';
- alter database resetlogs;
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-03-2005 05:35 PM
тАО01-03-2005 05:35 PM
Re: one confusion about oracle
I have found my way.
- « Previous
-
- 1
- 2
- Next »