| Recovery using RMAN Backup after OS Crash [message #267484] |
Thu, 13 September 2007 08:05  |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
Dear Tim,
On windows 2000 i have 9i release 2
i have installed os and oracle s/w at c: drive
i have all datafiles ,redo log files and control files at d: drive
i have archive files on e: drive
i have taken RMAN backup on drive c: with the following script
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\oracle\backup\CONTROLFILE_RMAN_BACKUP_%F.bak';
RUN
{
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK MAXPIECESIZE = 1G FORMAT 'D:\oracle\backup\%D_RMAN_BACKUP_%U.bak';
backup database plus archivelog;
SQL "alter database backup controlfile to trace as ''D:\oracle\backup\Controlfile_Backup_Trace.trc''";
host 'copy C:\oracle\ora92\database\pwdorcl.ora e:\backup';
host 'copy C:\oracle\ora92\network\admin\tnsnames.ora e:\backup';
host 'copy C:\oracle\ora92\network\admin\listener.ora e:\backup';
RELEASE CHANNEL disk1;
}
This drive is always backup to tape (all backup files and archive files )
My OS had been crashed and e: drive is also crashed where my backups and archive lies
did anybody ever face this kind of problem?
can anybody help me in this regard ?
thanx in advance
|
|
|
|
|
|
|
|
| Re: Recovery using RMAN Backup after OS Crash [message #267511 is a reply to message #267493] |
Thu, 13 September 2007 10:16  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | i have taken RMAN backup on drive c: with the following script
|
Any Backup?
Guess your C drive would also crashed.
If not then before installation save backup some where else and perform disaster recovery.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
