Online incremental Backup oracle 9i

[Asif_8]

1.Can I do online incremental Backup of Oracle 9i without Rman ? If yes How

2. Can I do online Incremental backup of oracle 9i by open view Data protector without
RMAN configuratio and How

[Joseph Loo]

hi,

nope. you need RMAN to perform hot backup with or without Data Protector.

regards.

[Volker Borowski]

No !

[Brian Crabtree]

1. No. Because Oracle can track block changes, Rman can backup the changed blocks directly, without having to backup the unchanged blocks. Like all incremental backups, a full backup is required before the incremental can be used, and will be required for the restore. It is recommended to do incremental and cumulative backups if you are only doing a full backup once a week.

2. No. You must use Rman with a media manager (Omniback, Legato, etc) if you are going to go to a tape device. You can do backups to disk with Rman as well, although this would defeat the purpose in my opinion.

You CAN do backups directly to tape with Omnibackup without using Rman by placing the tablespaces into backup mode directly, and backing up the datafiles directly. This will be a straight backup only, not incremental, but will not require a recovery catalog.

Hope this helps,

Brian

[Ravi_8]

Hi,

without RMAN you can't do online incremental backup in oracle 8i/9i

[Sanjay Kumar Suri]

Dear Asif

RMAN is only tool available for taking incremental backups.

No cutdown on backup time (if needed) one can take one by one tablespace backup. However in case of recovery needed logs file must be available.

sks

[Ghulam Shabir Mallah_1]

I think so he can do online incremental backup.

1. Online FUll Hot Backup: For Example alter tablespace SYSTEM begin backup;
!fbackup -v -0i /path -f /dev/rmt/0m
alter tablespace SYSTEM end backup;

2.Online Incremental Hot Backup: For Exmaple
alter tablespace SYSTEM begin backup;
!fbackup -v -9i /path -f /dev/rmt/0m
alter tablespace SYSTEM end backup;

Any question on above.

-regds

GSM

[Michael Schulte zur Sur]

Hi GSM,

what you propose, isn't much of incremental, because you dump tablespace system completely twice. ;-)

greetings,

Michael

[Hari Kumar]

Hi,
The command you specify doesn't do the incremental backup at all.
You can refer to 9i RMAN docs for more on Incremental Online Backup and you need to integrate to with Omni(DP) or other to fulfill the rquirements.