Make_recovery -a

[Gulam Mohiuddin]

Before applying some patches I would like to make the backup tape with make_recovery -a.

On the server we have lots of Oracle database instances running. Do I need to shutdown all database instances before running the make_recovery -a command.

Can I run the make_recovery -a command while all Oracle database instances are up and running, will it effects our make_recovery process in any way.

We have HP-UX 11.0

Thanks,

[Vincenzo Restuccia]

If you have Oracle installed in vg00:
1) shutdown Oracle
2) you can backup entire vg00 with make_recovery -A.

[Gulam Mohiuddin]

No our Oracle is not installed on vg00. It is on separate Volume group vg11.

Thanks,

[Vincenzo Restuccia]

Then use fbackup for vg01,beaucose make_recovery is only for vg00.

[Rob Smith]

You don't have to shut down Oracle while making a recovery tape. But if there are a lot of users on the system it can slow things down and the process can take up to an hour depending on the size of your root volume group. I prefer to kick everybody off and shut down the databases while I make a recovery tape and do other system maintenance. But I know that is not an option for some people.

Rob

[boley janowski · Accepted solution]

i have a server running oracle and run make_recovery tapes with the database in both states off&on. Due to some hardware problems I have had to use my make_recovery and did not have any issues with the data base, infact all the other servers we run different databases on due to production we cant afford to bring the databases down every time we want to run a make_recovery (we always run two incase of tape/hardware failure) but have not had any problems with the recovery tapes either. good luck!!