Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Online incremental Backup oracle 9i

Asif_8
Regular Advisor

Online incremental Backup oracle 9i


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
8 REPLIES
Joseph Loo
Honored Contributor

Re: Online incremental Backup oracle 9i

hi,

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

regards.
what you do not see does not mean you should not believe
Volker Borowski
Honored Contributor

Re: Online incremental Backup oracle 9i

No !
Brian Crabtree
Honored Contributor

Re: Online incremental Backup oracle 9i

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
Honored Contributor

Re: Online incremental Backup oracle 9i

Hi,

without RMAN you can't do online incremental backup in oracle 8i/9i
never give up
Sanjay Kumar Suri
Honored Contributor

Re: Online incremental Backup oracle 9i

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
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.

Re: Online incremental Backup oracle 9i

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
Ghulam
Michael Schulte zur Sur
Honored Contributor

Re: Online incremental Backup oracle 9i

Hi GSM,

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

greetings,

Michael
Hari Kumar
Trusted Contributor

Re: Online incremental Backup oracle 9i

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.
Information is Wealth ; Knowledge is Power