RMAN CONFIGURATION

All posts relating to Oracle database administration.

Moderator: Tim...

RMAN CONFIGURATION

Postby memood » Tue Dec 17, 2013 8:39 am

Dear Tim

i have attached external disk of size 500gb to my pc
i want to take full backup of xyz 250gb database using rman to that external disk
what parameters you suggest to configure in rman

best regards
memood
Member
 
Posts: 19
Joined: Mon Dec 02, 2013 10:58 am

Re: RMAN CONFIGURATION

Postby Tim... » Tue Dec 17, 2013 8:51 am

Hi.

Not sure why you keep asking me the same question. You've already seen my response...

viewtopic.php?f=1&t=14935&p=41303#p41303

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17936
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: RMAN CONFIGURATION

Postby memood » Sun Dec 22, 2013 8:04 am

Dear Mr Tim ..
as i told you earlier i have some problem with rman taking the backup of a specific database in a diff server

the problem is :

there is a disk has been attached to the server and configured as a shared folder

how can i make this shared folder read and write to my rman .. so rman can take the backup in this shared folder
note: rman server in a 192.168.101.2 and target database in 192.168.101.3
the shared folder appears to me like the following when i open my computer :

Network location
H(Z:)


thanx
memood
Member
 
Posts: 19
Joined: Mon Dec 02, 2013 10:58 am

Re: RMAN CONFIGURATION

Postby Tim... » Sun Dec 22, 2013 8:14 am

Hi.

Is the database running on your PC also, or are you asking me how to take a backup from a remote server and have the file placed on the external drive on your PC?

If you don't provide enough information, you can't expect an appropriate answer.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17936
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: RMAN CONFIGURATION

Postby memood » Sun Dec 22, 2013 9:23 am

dear tim .. answering your questions below :

Is the database running on your PC also ?
no the database is not running in my pc server

are you asking me how to take a backup from a remote server and have the file placed on the external drive on your PC?

yes .. but the external drive is in a different server

best regards
memood
Member
 
Posts: 19
Joined: Mon Dec 02, 2013 10:58 am

Re: RMAN CONFIGURATION

Postby memood » Sun Dec 22, 2013 9:35 am

Dear tim here also provided to you the configuration of the rman parameters

and the errors i have got

RMAN> backup incremental level =0 database tag='LEVEL0_SUND_DATE' ;

Starting backup at 22-DEC-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=43 device type=DISK
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=C:\APP\ORADATA\CDBJM\CDB_PROD_01.DBF
input datafile file number=00017 name=C:\APP\ORADATA\CDBJM\CDB_PROD_15.DBF
input datafile file number=00018 name=C:\APP\ORADATA\CDBJM\CDB_PROD_13.DBF
input datafile file number=00019 name=C:\APP\ORADATA\CDBJM\CDB_PROD_16.DBF
input datafile file number=00020 name=C:\APP\ORADATA\CDBJM\CDB_PROD_14.DBF
input datafile file number=00012 name=C:\APP\ORADATA\CDBJM\CDB_PROD_08.DBF
input datafile file number=00013 name=C:\APP\ORADATA\CDBJM\CDB_PROD_09.DBF
input datafile file number=00014 name=C:\APP\ORADATA\CDBJM\CDB_PROD_10.DBF
input datafile file number=00015 name=C:\APP\ORADATA\CDBJM\CDB_PROD_11.DBF
input datafile file number=00016 name=C:\APP\ORADATA\CDBJM\CDB_PROD_12.DBF
input datafile file number=00010 name=C:\APP\ORADATA\CDBJM\CDB_PROD_06.DBF
input datafile file number=00011 name=C:\APP\ORADATA\CDBJM\CDB_PROD_07.DBF
input datafile file number=00006 name=C:\APP\ORADATA\CDBJM\CDB_PROD_02.DBF
input datafile file number=00009 name=C:\APP\ORADATA\CDBJM\CDB_PROD_05.DBF
input datafile file number=00001 name=C:\APP\ORADATA\CDBJM\SYSTEM01.DBF
input datafile file number=00003 name=C:\APP\ORADATA\CDBJM\UNDOTBS01.DBF
input datafile file number=00002 name=C:\APP\ORADATA\CDBJM\SYSAUX01.DBF
input datafile file number=00008 name=C:\APP\ORADATA\CDBJM\CDB_PROD_04.DBF
input datafile file number=00004 name=C:\APP\ORADATA\CDBJM\USERS01.DBF
input datafile file number=00021 name=C:\APP\ORADATA\CDBJM\SYSTEM02.DBF
input datafile file number=00022 name=C:\APP\ORADATA\CDBJM\UNDOTBS02.DBF
input datafile file number=00023 name=C:\APP\ORADATA\CDBJM\SYSAUX02.DBF
input datafile file number=00007 name=C:\APP\ORADATA\CDBJM\CDB_PROD_03.DBF
channel ORA_DISK_1: starting piece 1 at 22-DEC-13
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 12/22/2013 12:00:15
ORA-19504: failed to create file "\\192.168.154.218\DBBACKUP\CDBBACK"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
notes :
\\192.168.111.213\DBBACKUP\ is the location of the shared drive ( which it is in a diff server )

regards .
memood
Member
 
Posts: 19
Joined: Mon Dec 02, 2013 10:58 am

Re: RMAN CONFIGURATION

Postby Tim... » Sun Dec 22, 2013 10:09 am

Hi.

So it looks like this is all on Windows right?

Have you tried writing to the share from the server running the backup? If it doesn't have permission to write, it's not going to work.

There are a number of problems with writing to shares from Windows. This isn't Oracle's fault, but an issue with the way Windows handles security. Typically, using UNC paths, like you've used, rather than mapped drive letters solves this. Obviously not in your case.

I don't have a great have a great deal of experience of Oracle on Windows in recent years. Everything I work with is on UNIX or Linux these days. I suggest you raise an SR with Oracle support.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17936
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: RMAN CONFIGURATION

Postby memood » Sun Feb 09, 2014 9:01 am

Hi there Mr Tim .. i have a question

what are the use of these tow configuration parameters
1)CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF DAYS;
2)CONFIGURE RETENTION POLICY TO REDUNDANCY ;

as i searched the internet and found so many links explaining the use of the above tow parameters .. so i need your experience in briefly and smoothly way to explain the use of them ..

best regards .
memood
Member
 
Posts: 19
Joined: Mon Dec 02, 2013 10:58 am

Re: RMAN CONFIGURATION

Postby Tim... » Mon Feb 10, 2014 8:34 am

Hi.

They just define how you handle clean up of backups. Using a recovery window says you will keep everything necessary to recovery to any point in time during the last X days. So in a recovery window of 7 days, I can recovery to a point in time anywhere from 7 days ago up to and including right now.

The redundancy says how many copied you will keep. Let's say I have a redundancy of 7 days, that sounds like the same as the previous example, but if I run 7 backups in one day, then I can not recovery to a point in time before today, because I've removed all the old backups...

http://www.oracle-base.com/articles/9i/ ... Parameters

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17936
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: RMAN CONFIGURATION

Postby memood » Sun Feb 23, 2014 8:52 am

Dear Tim
i am going to configure rman with RAC environment .. and it is my first time to configure rman with rac database .. please provide and advise about the things that should be configured in database and rman catalog ..

my best regards .
memood
Member
 
Posts: 19
Joined: Mon Dec 02, 2013 10:58 am

Re: RMAN CONFIGURATION

Postby Tim... » Sun Feb 23, 2014 3:38 pm

Hi.

There is no difference with RAC compared to a single instance database. Just register the database with the RMAN catalog (which is in another DB), then issue the RMAN commands.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17936
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: RMAN CONFIGURATION

Postby memood » Tue Mar 04, 2014 9:05 am

Dear Tim
regarding the RETENTION POLICY TO RECOVERY WINDOW
and the RETENTION POLICY TO REDUNDANCY ..
if set the recovery window of 3 days and toke backup three times in one day and if i came tomorrow and toke again backup is the last backup i taken is valid ?

and if i set the RETENTION POLICY TO REDUNDANCY to 3 .. and i toke backup in a same day 3 time and tomorrow i toke one backup .. is the last backup valid ?

thanx .
memood
Member
 
Posts: 19
Joined: Mon Dec 02, 2013 10:58 am

Re: RMAN CONFIGURATION

Postby Tim... » Tue Mar 04, 2014 2:27 pm

Hi.

With a retention policy of 3 days, if you took 1000 backups in one day, you would keep them all. Nothing is removed that is within the retention window.

If you did a redundancy of 3 backups, you would only ever keep the latest 3 backups, even if they are all on the same day.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17936
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 8 guests