| RMAN Recovery [message #62507] |
Sun, 25 July 2004 22:01 |
Pratap Zope
Messages: 23
Registered: July 2004
|
Junior Member |
|
|
Hi,
I have some major quesries related to RMAN backup and Recovery. (Oracle 9i on windows 2000)
Please suggest on that and help me!
Database Backup is taken with RMAN as
run{
allocate channel c1 device type disk;
allocate channel c2 device type disk;
backup database include current control file
backup database archivelog all;
}
1) Now, if tablespace is dropped while Database is online.
How can i recover it,
If it is not system tablespace, can i recover it online?
2) SPfile is dropped
How i can recover it
Can Pfile be included in Backup
Can Datafile be dropped while Database is Online(this i want to study recovery on dummy database)
When 'Reset Database' given after 'Open reset logs', whether earlier backup is useless?
if this is the case, how to remove ealier backup taken with RMAN?
Even while using recovery catalog created in other database server, the recovey catalog contains
only information of backup and not the actual backup.
If recovey catalog is not used the backup information (only) is kept in Production database.
So if major hardware problem is there with production database how the rman will be useful for
recovery.
Can we take rman backup on any other machine. (DAT/DLT not available)
If backup of database is taken as
run{
allocate channel c1 device type disk;
backup database include current control file
}
Here, the database is in archivelog mode when archivelog files are not included in rman
backup. Now after database crash, will ramn automatically find all archivelog from
controlfile and will apply to recover to present point of time
if this is the case :
then rman backup for full database excluding archiuvelog is taken on say 25 july and on
28 july at 12:00 database crashes which is in archivelog mode can i recover database till 12:00
of 28 july from backup on 25 july.
if redologs are lost then we have to go for incomplete recovery?
or only open database with resetlogs option.
since rman does not support backup of online redologs if redologs size is bigger and we lost
online redolog files and unfortunately the redologs are not archived then all data in the redolog
will be lost, right?
Thanks,
Regards,
Pratap
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
