-
What is the best way to take hot backup? I also wanted to know that If I took backup of each tablespace seperatly then will I face the problem of inconsistancy because I do not want to lose the single data.
suppose my data are in tablespace tbs1 and indexes are in ind_tbs1.
Please I need you suggestions
Thanks in Advance
Shailendra
-
Hi,
When you take HOT backups ,the backups are not consistent as these backups are taken when the database is open.You have to apply the redolog files in order to recover the database and make it consistent.You can take the hot backup by putting the tablespace in backup mode,backing up the datafiles and then putting the tablespace in end backup mode.Also you can take the HOT backup by implementing RMAN(Recovery Manager) as it provides with a lot of options and makes your backup and recovery very easy.When you want to take a HOT backup take the backup of all the datafiles,controlfiles and the archived-log files of the database.
Regards,
Rohit Nirkhe,Oracle/Apps DBA,OCP 8i
oracle-support@indiatimes.com
-
Do not afraid to do it, it is better to put tablespces in recovery mode one by one. I always do it and did not meet any problems.
Originally posted by shailendra
... If I took backup of each tablespace seperatly then will I face the problem of inconsistancy ...
Best wishes!
Dmitri
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|