How to make hot backup 1

[tomecki24]

Hello,

I've read posts about cold backup - it's really simple but I have to stop database. How to make backup without it? I mena without stopping database instance?

Thanks
Tomasz

 

[carp]

I would strongly recommend you read the sections in Oracle documentation that cover backup and recovery strategies, as well as practicing on a crash-and-burn database before you try this on your production DB. That said, the basic procedure is:

1. You MUST have archiving enabled.
2. Get a list of all of your datafiles as well as which tablespace they are allocated to.
3. For each tablespace, issue the command
ALTER TABLESPACE tablespace_name BEGIN BACKUP;
Then go to your operating system and copy the datafiles for that tablespace to wherever you want the backups to reside.
Finally, issue the command:
ALTER TABLESPACE tablespace_name END BACKUP;
4. Once all of your datafiles are copied, make a backup of the control file and init.ora file.

This entire procedure can be scripted or automated via RMAN. But you really need to play with it until you are familiar with all of the steps and concepts.

 

[tomecki24]

hi,

ok, thank you.

Tomasz