- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle Recovery
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-22-2003 05:02 PM
тАО05-22-2003 05:02 PM
Oracle Recovery
I have online oracle backup.But somehow the controlfile are not backup.(Thanks to the DBA who have left the company).
Could I do something like this :
1) restore the online backup.
2) svrmgrl>connect internal
3) svrmgrl> startup nomount
4) svrmgrl>@rcf01 -- To recreate the control file.
5) svrmgrl> alter database mount
6) svrmgrl>recover database.
This is the content rcf01.sql file :
CREATE CONTROLFILE REUSE DATABASE "P716"
NORESETLOGS NOARCHIVELOG
MAXLOGFILES 50
MAXLOGMEMBERS 3
MAXDATAFILES 300
MAXINSTANCES 8
MAXLOGHISTORY 500
LOGFILE GROUP 1 '/u01/oracle/7.1.6/dbs/log1p716.dbf' SIZE 1M,
GROUP 2 '/u01/oracle/7.1.6/dbs/log2p716.dbf' SIZE 1M,
GROUP 3 '/u01/oracle/7.1.6/dbs/log3p716.dbf' SIZE 1M DATAFILE '/u01/oracle/7.1.6/dbs/systp716.dbf' SIZE 40M,
'/u01/oracle/7.1.6/dbs/tempp716.dbf' SIZE 1M,
'/u01/oracle/7.1.6/dbs/toolp716.dbf' SIZE 15M ;
Do you think this is workable ???
sorry to asked this question because I have no test system and actual system is about 6000KM from my place.
regards
mB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-22-2003 05:16 PM
тАО05-22-2003 05:16 PM
Re: Oracle Recovery
Bring down the database.
Copy all the files to another location.
Tar or otherwise transfer them to tapes.
Also very reliable is a hot or cold rman backup. Cold is easier to work with when restoring.
Your rman script can include the control files.
Your methology seems reasonable, but unorthodox.
Omniback also has facilities build into version 4 and up that will let you get solid oracle backups(uses rman) whether the database is up or down.
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
тАО05-22-2003 05:20 PM
тАО05-22-2003 05:20 PM
Re: Oracle Recovery
Oracle version number would help.
If this system is important, you probably WANT to cut archive logs.
If you suffer a disk crash, this will let you use rman or sqlplus and the logs to roll the database forward to just before the crash point, minimizing data loss.
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
тАО05-22-2003 05:25 PM
тАО05-22-2003 05:25 PM
Re: Oracle Recovery
Back to the question,yap we are running archive log,that's why we could do online backup.
Thanks and appreciate your input SEP...
Hey,is it midnight in US , for AsiaPac this is at 9:00 am.
regards
mB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-22-2003 07:13 PM
тАО05-22-2003 07:13 PM
Re: Oracle Recovery
Do you want to see some actual oracle backups scripts? I can download a few from work, tar them up and post them for you.
I was concerned about the archive log comments in that control file you are creating. Seems incompatible with a real oracle backup.
8.1.7.4.0 is the version to be at for HP-UX. Lots of good bug fixes, thats our production release.
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
тАО05-22-2003 09:03 PM
тАО05-22-2003 09:03 PM
Re: Oracle Recovery
1. To generate your control file, you can also use:
alter database backup controlfile to trace;
2. For our test recovery, we hired a server for one day from our support provider.
This was quite an easy task using RMAN.
Below an outline of the steps (using RMAN - disk backup).
BACKUP:
=========
rman target sys/manager rcvcat rman/rman@catalog_db msglog backup.log <
run {
allocate channel fs1 type disk format '/backup/rman/full/fs1/df_%u_%s_$t.%p';
allocate channel fs2 type disk format '/backup/rman/full/fs2/df_%u_%s_$t.%p';
allocate channel fs3 type disk format '/backup/rman/full/fs3/df_%u_%s_$t.%p';
set limit channel fs1 kbytes=750000;
set limit channel fs2 kbytes=750000;
set limit channel fs3 kbytes=750000;
#Backup the whole database
backup
tag Whole_database_hot
database;
#Switch out of the current logfile
sql 'alter system archive log current';
#Backup the archived logs
backup
archivelog all delete input
format '/backup/rman/full/fs1/al_%u.%p';
#Backup a copy of the controlfile that contains records for the
#other backups just made
backup
current controlfile
tag = cf1
format '/backup/rman/full/fs1/cf_%u.%p';
}
exit;
EOF
RESTORE:
=========
Step 1: Start the database nomount (using SQLPLUS - internal)
startup nomount pfile=initmydb.ora
Step 2: Restore the database
rman rcvcat rman/rman@catalog_db target internal/oracle@target_db;
run {
allocate channel fs1 type disk format '/backup/rman/full/fs1/df_%u_%s_$t.%p';
allocate channel fs2 type disk format '/backup/rman/full/fs2/df_%u_%s_$t.%p';
allocate channel fs3 type disk format '/backup/rman/full/fs3/df_%u_%s_$t.%p';
restore controlfile;
sql 'alter database mount';
restore database;
}
hope this helps!
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-22-2003 11:06 PM
тАО05-22-2003 11:06 PM
Re: Oracle Recovery
Do you mean above method will work.With additional to reset the log at the end.
regards
mB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-23-2003 12:20 AM
тАО05-23-2003 12:20 AM
Re: Oracle Recovery
Whatever steps u have specified will work. When u recreate the controfile there will be no SCN recorded in it..so the recovery will happen till the last SCN recorded in the datafile..provided u have all the archivelogs till that point.
rgds
BLADE
"Always Sharp"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-23-2003 02:19 AM
тАО05-23-2003 02:19 AM
Re: Oracle Recovery
Backup and recovery are very serious issues.
i suggest you do the recovery tests properly.
The first test i did was on a Windows 2000 platform with Oracle 8.1.7.4. At that time, we did not have the means to hire a "backup" server from our support provider.
I will also suggest that you perform all the recovery scenarios listed in the Recovery Manager User???s Guide and Reference page 6-34.
maybe you can do the same.
Then, you can try it on your HP-UX platform.
hope this helps too!
regards
Yogeeraj