RMAN

[former_member182034]

Dear All,

I have simply information about RMAN but don't know the usage there are some question related to RMAN.

How can i configure RMAN <which user and what Permission> ?

what is procedure of Backup and Restore a DB?

Here i am trying to run RMAN with SIDadm user and getting following errors.

RMAN> show all;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 04/20/2009 15:41:35
RMAN-06171: not connected to target database

RMAN>

while my System(DEV) have on Server 2003 64 bit Oracle 10.2 with ECC6.0 SR3.

thanks in advance

Regards,

majamil

[Former Member · Accepted solution]

Hi

Check this link for [RMAN|http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmquick.htm]

Regards

Uday

[former_member182034 · Accepted solution]

Hi Uday,

Thanks man for this link and i already awarded points but still there are remaining some points,

Now i have a Test system and i executed RMAN> backup DATABASE; and backup is running

status is:

RMAN> backup DATABASE;

Starting backup at 21-APR-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=52 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00029 name=F:\ORACLE\IDS\SAPDATA1\SR3_26\SR3.DATA26
input datafile fno=00030 name=F:\ORACLE\IDS\SAPDATA1\SR3_27\SR3.DATA27
input datafile fno=00031 name=F:\ORACLE\IDS\SAPDATA1\SR3_28\SR3.DATA28
input datafile fno=00033 name=F:\ORACLE\IDS\SAPDATA1\SR3_30\SR3.DATA30
input datafile fno=00043 name=F:\ORACLE\IDS\SAPDATA1\SR3_40\SR3.DATA40
input datafile fno=00051 name=F:\ORACLE\IDS\SAPDATA1\SR3_48\SR3.DATA48
input datafile fno=00050 name=F:\ORACLE\IDS\SAPDATA1\SR3_47\SR3.DATA47
input datafile fno=00053 name=F:\ORACLE\IDS\SAPDATA1\SR3_50\SR3.DATA50
input datafile fno=00059 name=F:\ORACLE\IDS\SAPDATA1\SR3_56\SR3.DATA56
input datafile fno=00045 name=F:\ORACLE\IDS\SAPDATA1\SR3_42\SR3.DATA42
input datafile fno=00057 name=F:\ORACLE\IDS\SAPDATA1\SR3_54\SR3.DATA54
input datafile fno=00058 name=F:\ORACLE\IDS\SAPDATA1\SR3_55\SR3.DATA55
input datafile fno=00049 name=F:\ORACLE\IDS\SAPDATA1\SR3_46\SR3.DATA46
input datafile fno=00056 name=F:\ORACLE\IDS\SAPDATA1\SR3_53\SR3.DATA53
input datafile fno=00039 name=F:\ORACLE\IDS\SAPDATA1\SR3_36\SR3.DATA36
input datafile fno=00004 name=F:\ORACLE\IDS\SAPDATA1\SR3_1\SR3.DATA1
input datafile fno=00023 name=F:\ORACLE\IDS\SAPDATA1\SR3_20\SR3.DATA20
input datafile fno=00017 name=F:\ORACLE\IDS\SAPDATA1\SR3_14\SR3.DATA14
input datafile fno=00078 name=F:\ORACLE\IDS\SAPDATA1\SR3700_19\SR3700.DATA19
input datafile fno=00005 name=F:\ORACLE\IDS\SAPDATA1\SR3_2\SR3.DATA2
input datafile fno=00025 name=F:\ORACLE\IDS\SAPDATA1\SR3_22\SR3.DATA22
input datafile fno=00037 name=F:\ORACLE\IDS\SAPDATA1\SR3_34\SR3.DATA34
input datafile fno=00021 name=F:\ORACLE\IDS\SAPDATA1\SR3_18\SR3.DATA18
input datafile fno=00034 name=F:\ORACLE\IDS\SAPDATA1\SR3_31\SR3.DATA31
input datafile fno=00006 name=F:\ORACLE\IDS\SAPDATA1\SR3_3\SR3.DATA3
input datafile fno=00009 name=F:\ORACLE\IDS\SAPDATA1\SR3_6\SR3.DATA6
input datafile fno=00010 name=F:\ORACLE\IDS\SAPDATA1\SR3_7\SR3.DATA7
input datafile fno=00073 name=F:\ORACLE\IDS\SAPDATA1\SR3700_14\SR3700.DATA14
input datafile fno=00076 name=F:\ORACLE\IDS\SAPDATA1\SR3700_17\SR3700.DATA17
input datafile fno=00012 name=F:\ORACLE\IDS\SAPDATA1\SR3_9\SR3.DATA9
input datafile fno=00011 name=F:\ORACLE\IDS\SAPDATA1\SR3_8\SR3.DATA8
input datafile fno=00015 name=F:\ORACLE\IDS\SAPDATA1\SR3_12\SR3.DATA12
input datafile fno=00075 name=F:\ORACLE\IDS\SAPDATA1\SR3700_16\SR3700.DATA16
input datafile fno=00014 name=F:\ORACLE\IDS\SAPDATA1\SR3_11\SR3.DATA11
input datafile fno=00081 name=F:\ORACLE\IDS\SAPDATA1\SR3700_22\SR3700.DATA22
input datafile fno=00083 name=F:\ORACLE\IDS\SAPDATA1\SR3700_24\SR3700.DATA24
input datafile fno=00085 name=F:\ORACLE\IDS\SAPDATA1\SR3700_26\SR3700.DATA26
input datafile fno=00087 name=F:\ORACLE\IDS\SAPDATA1\SR3700_28\SR3700.DATA28
input datafile fno=00089 name=F:\ORACLE\IDS\SAPDATA1\SR3700_30\SR3700.DATA30
input datafile fno=00091 name=F:\ORACLE\IDS\SAPDATA1\SR3700_32\SR3700.DATA32
input datafile fno=00093 name=F:\ORACLE\IDS\SAPDATA1\SR3700_34\SR3700.DATA34
input datafile fno=00095 name=F:\ORACLE\IDS\SAPDATA1\SR3700_36\SR3700.DATA36
input datafile fno=00097 name=F:\ORACLE\IDS\SAPDATA1\SR3700_38\SR3700.DATA38
input datafile fno=00099 name=F:\ORACLE\IDS\SAPDATA1\SR3700_40\SR3700.DATA40
input datafile fno=00062 name=F:\ORACLE\IDS\SAPDATA1\SR3700_3\SR3700.DATA3
input datafile fno=00064 name=F:\ORACLE\IDS\SAPDATA1\SR3700_5\SR3700.DATA5
input datafile fno=00069 name=F:\ORACLE\IDS\SAPDATA1\SR3700_10\SR3700.DATA10
input datafile fno=00071 name=F:\ORACLE\IDS\SAPDATA1\SR3700_12\SR3700.DATA12
input datafile fno=00066 name=F:\ORACLE\IDS\SAPDATA1\SR3700_7\SR3700.DATA7
input datafile fno=00068 name=F:\ORACLE\IDS\SAPDATA1\SR3700_9\SR3700.DATA9
input datafile fno=00003 name=F:\ORACLE\IDS\SAPDATA1\SYSAUX_1\SYSAUX.DATA1
channel ORA_DISK_1: starting piece 1 at 21-APR-09

its mean backup is running:

where this backup will be make its backup file?

what is best time for this backup mean Offline or online?

May i stop SAP from sapmmc before run RMAN?

Regards,

[lbreddemann · Accepted solution]

>

> Hi Uday,

> Thanks man for this link and i already awarded points but still there are remaining some points,

>

> Now i have a Test system and i executed RMAN> backup DATABASE; and backup is running

> status is:

Ok, you definitively want to read the RMAN documentation:

[http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/toc.htm]

> where this backup will be make its backup file?

You can configure this using the CONFIGURE command (obvious isn't it?).

If you did not change this, the default target location will be the "$ORACLE_HOME/dbs" or "%ORACLE_HOME%\database" folder

You can always display your current setup by using the

SHOW ALL

command.

> what is best time for this backup mean Offline or online?

Depends on what you want to do.

Since downtime is nothing you want to see for backups nowadays, I would consider online as the standard choice.

> May i stop SAP from sapmmc before run RMAN?

What for?

See, taking backups does not add value to your business (only having current backups does in case when a recovery is necessary).

Therefore you don't want to interfere too much with the business applications for taking backups.

By using RMAN you can accomplish that.

Take online backups, take incremental backups, validate the database - all this can be done online with RMAN.

It's not even necessary to use the BEGIN / END BACKUP commands anymore.

Well, finally to question is: why don't you just use the RMAN integration of the BRTOOLS?

With it you don't have to hassle around with all those command line stuff that isn't even integrated into the CCMS monitoring infrastructre.

regards,

Lars

[former_member182034 · Accepted solution]

thanks Lars for replying,

Dear i got following error:

input datafile fno=00066 name=F:\ORACLE\IDS\SAPDATA1\SR3700_7\SR3700.DATA7
input datafile fno=00068 name=F:\ORACLE\IDS\SAPDATA1\SR3700_9\SR3700.DATA9
input datafile fno=00003 name=F:\ORACLE\IDS\SAPDATA1\SYSAUX_1\SYSAUX.DATA1
channel ORA_DISK_1: starting piece 1 at 21-APR-09
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/21/2009 16:30:
01
ORA-19502: write error on file "E:\ORACLE\IDS\102\DATABASE\01KD1P1G_1_1", blockn
o 1309697 (blocksize=8192)
ORA-27072: File I/O error
OSD-04008: WriteFile() failure, unable to write to file
RMAN>

where is something wrong, would you tell me?

Regards,

majamil

[lbreddemann · Accepted solution]

>

> thanks Lars for replying,

> Dear i got following error:

> ORA-19502: write error on file "E:\ORACLE\IDS\102\DATABASE\01KD1P1G_1_1", blockn

> o 1309697 (blocksize=8192)

> ORA-27072: File I/O error

> OSD-04008: WriteFile() failure, unable to write to file

> RMAN>

>

> where is something wrong, would you tell me?

Well, look and read the error message and think about it.

You're taking a full backup of your database.

RMAN writes this backup to the Oracle-Home folder (just as I wrote) to a file named "01KD1P1G_1_1".

Now you're getting a WRITE ERROR.

I would bet that the disk that Oracle-Home is on is just about full.

Either configure a different standard target folder or provide a target together with the "backup database" command or use the BRTOOLS.

best regards,

Lars

[former_member182034 · Accepted solution]

Dear Lars;

why don't you just use the RMAN integration of the BRTOOLS?

How can i integrate RMAN with BRTOOLS?

Either configure a different standard target folder or provide a target together with the "backup database" command or use the BRTOOLS

mean if i change target folder then its change impacts would be show on both side(RMAN, BRTOOLS)

If I change any value then how i can set its default value like:

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'E:\ORACLE\IDS\102\DATABASE\SNCFIDS.ORA';
 # default

RMAN> CONFIGURE BACKUP OPTIMIZATION OFF;

new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION OFF;
new RMAN configuration parameters are successfully stored

i have much knowledge regarding these topics and i will be very grateful to u if you guide me further.

Regards,

[lbreddemann · Accepted solution]

> How can i integrate RMAN with BRTOOLS?

You do suffer from a bad allergy against documentation and sap notes, do you?

Otherwise you would have easily found notes like #420698 or the brtools documenation (help.sap.com!).

Just by searching for "BRBACKUP RMAN" in the upper right search box I got a whole lot of information.

> mean if i change target folder then its change impacts would be show on both side(RMAN, BRTOOLS)

No, the BRTOOLS always specify complete commands and thereby ignoring the default values.

Instead the settings from the BRTOOLS profile init<sid>.sap are used.

Otherwise it would make things so much more difficult.

> i have much knowledge regarding these topics and i will be very grateful to u if you guide me further.

Honestly I'd rather not teach you via this forum.

I pointed you to the right documentation - you've to read it yourself.

Otherwise you'll never know what the commands actually do.

sorry but <movie quote on> "I can only show you the door - you've to go through it yourself!" <movie quote off>.

Lars

[former_member182034 · Accepted solution]

Thanks Lars for this imp. information and i want to close this post becoz above 2 links are very useful.

Honestly I'd rather not teach you via this forum

reading is best solution.

we will met on next post. InshALLAH.

thanks and best Regards,

[Former Member]

try

rman target / (Remember to set environment variable ORACLE_SID)

or rman targer login/pwd@database

RMAN>show all;