| restoration of coldback with archivelog [message #69746] |
Thu, 28 February 2002 22:31  |
r anand
Messages: 1
Registered: February 2002
|
Junior Member |
|
|
i have coldbackup of 25.02.2002 and archivelogs of 26.02.2002. i want to restore coldbackup of 25.02.2002 and apply the archivelogs so that my db will have all transactions of 26.02.2002 reflected after restoration.
please suggest how to go about it.
|
|
|
|
| Re: restoration of coldback with archivelog [message #69792 is a reply to message #69746] |
Wed, 06 March 2002 17:32  |
seng
Messages: 191
Registered: February 2002
|
Senior Member |
|
|
1. First, shutdown and backup the whole production database before restore and recover.
2. Restore back coldbackup into your database production. e.g datafile and controlfile
3. Recover database with archivelogs for 26.02.2002. when the database is startup until mount point only.
ALTER DATABASE RECOVER AUTOMATIC DATABASE; --- whole database recover until finish all archivelog files.
Note:
- backup whole production database before any restore and recover.
- the coldbackup must be whole copy after your database is set to archive mode.(this is must step when your database is changed to archive mode)
- makesure you don't lose any archivelog file.
- many recover scenario for archive mode.
Hope this is helping.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
