Home » RDBMS Server » Backup & Recovery » Reg RMAN Concept (merged)
Reg RMAN Concept (merged) [message #319197] Fri, 09 May 2008 05:36 Go to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
Can any one help me regarding the RMAN script , I need to take a backup of
1.A particular Datafile
2.A whole Database

Thanks,
Re: Reg RMAN Concept [message #319216 is a reply to message #319197] Fri, 09 May 2008 06:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Backup and Recovery Basics

Regards
Michel
Reg RMAN Concept [message #321122 is a reply to message #319197] Mon, 19 May 2008 02:46 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
Can anyone help me regarding the RMAN concept and its workflow ,why because i am new to this type of concept ,i need the clear explantion for the RMAN concept and its process

Thanks,
Re: Reg RMAN Concept [message #321128 is a reply to message #321122] Mon, 19 May 2008 03:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Backup and Recovery Basics

Regards
Michel
Re: Reg RMAN Concept [message #321135 is a reply to message #321128] Mon, 19 May 2008 03:45 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
Have to install any packages or any other to work in RMAN
concept

Thanks,
Re: Reg RMAN Concept [message #321136 is a reply to message #321135] Mon, 19 May 2008 03:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

Regards
Michel
Re: Reg RMAN Concept [message #321148 is a reply to message #321136] Mon, 19 May 2008 04:23 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
First Step of the RMAN is just to login as a sys or system

Thanks,
Re: Reg RMAN Concept [message #321151 is a reply to message #321148] Mon, 19 May 2008 04:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First step is to read the documentation then you know the answer to your question.

Regards
Michel
Re: Reg RMAN Concept [message #321159 is a reply to message #321135] Mon, 19 May 2008 05:04 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If you require an even more rudiment resource, check Backup and Recovery Quick Start Guide.
Re: Reg RMAN Concept [message #321205 is a reply to message #321122] Mon, 19 May 2008 07:28 Go to previous messageGo to next message
Rajabaskar Thangaraj
Messages: 13
Registered: March 2008
Location: CHENNAI
Junior Member
Refer the below link:

http://www.orafaq.com/papers/prman.pdf


Best regards
Rajabaskar Thangaraj
Re: Reg RMAN Concept [message #321211 is a reply to message #321205] Mon, 19 May 2008 07:55 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
The concept shows the full backup for the database , my questions are
1. Can we take backup for a particular datafile
2. Whether RMAN concept is used for only backups or we can use for any other purpose

Thanks,
Re: Reg RMAN Concept [message #321224 is a reply to message #321211] Mon, 19 May 2008 08:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1. Yes, this is explained in the doc.
2. For recovery... Smile

Regards
Michel
Re: Reg RMAN Concept [message #321346 is a reply to message #321224] Tue, 20 May 2008 00:24 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
I need to know the use and purpose of RMAN agruments

Thanks,
Re: Reg RMAN Concept [message #321361 is a reply to message #321346] Tue, 20 May 2008 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you read the 3 links we posted you?
Your answer is there.

Regards
Michel
Re: Reg RMAN Concept [message #321378 is a reply to message #321361] Tue, 20 May 2008 02:06 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
How to create a Catalog file in RMAN ,pls can any one help me regarding this

Thanks,
Re: Reg RMAN Concept [message #321381 is a reply to message #321378] Tue, 20 May 2008 02:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Tue, 20 May 2008 08:12
Did you read the 3 links we posted you?
Your answer is there.

Regards
Michel

There is no catalog file.

[Updated on: Tue, 20 May 2008 02:13]

Report message to a moderator

Re: Reg RMAN Concept [message #321449 is a reply to message #321381] Tue, 20 May 2008 05:22 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
I cannt able to understand why we are going for the CONFIGURE command , can u pls help me reg this

Thanks,
Re: Reg RMAN Concept [message #321456 is a reply to message #321381] Tue, 20 May 2008 05:45 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
I worked in RMAN concept now i get the following error

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;


Starting backup at 20-MAY-08
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=14 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=17 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=113 recid=1 stamp=655229266
channel ORA_DISK_1: starting piece 1 at 20-MAY-08
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 05/20/2008 16:07:49
ORA-19504: failed to create file "d:\oracle\orclbackup\ora_df655229267_s1_s1"
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.


Thanks,
Re: Reg RMAN Concept [message #321459 is a reply to message #321456] Tue, 20 May 2008 05:51 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Does the directory d:\oracle\orclbackup even exist?
Re: Reg RMAN Concept [message #321462 is a reply to message #321459] Tue, 20 May 2008 06:01 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
yes the directory is wrong, now i cleared and took the whole database backup


RMAN> BACKUP DATABASE PLUS ARCHIVELOG;


Starting backup at 20-MAY-08
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=14 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=17 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=113 recid=1 stamp=655229266
channel ORA_DISK_1: starting piece 1 at 20-MAY-08
channel ORA_DISK_2: starting archive log backupset
channel ORA_DISK_2: specifying archive log(s) in backup set
input archive log thread=1 sequence=114 recid=2 stamp=655229991
channel ORA_DISK_2: starting piece 1 at 20-MAY-08
channel ORA_DISK_1: finished piece 1 at 20-MAY-08
piece handle=D:\ORACLE\ORABACKUP\ORA_DF655229991_S2_S1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
channel ORA_DISK_2: finished piece 1 at 20-MAY-08
piece handle=D:\ORACLE\ORABACKUP\ORA_DF655229991_S3_S1 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:05
Finished backup at 20-MAY-08

Starting backup at 20-MAY-08
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00018 name=D:\ORACLE\ORADATA\SAMPLE1\TSTMDMNDX_DAT01.ORA
input datafile fno=00015 name=D:\ORACLE\ORADATA\SAMPLE1\TSTSMLTBS_DAT01.ORA
input datafile fno=00017 name=D:\ORACLE\ORADATA\SAMPLE1\TSTSMLNDX_DAT01.ORA
input datafile fno=00010 name=D:\ORACLE\ORADATA\RAMANAN\XDB01.DBF
input datafile fno=00006 name=D:\ORACLE\ORADATA\RAMANAN\INDX01.DBF
input datafile fno=00009 name=D:\ORACLE\ORADATA\RAMANAN\USERS01.DBF
input datafile fno=00004 name=D:\ORACLE\ORADATA\RAMANAN\DRSYS01.DBF
input datafile fno=00011 name=D:\ORACLE\ORADATA\SAMPLE\FXDEMOSMLTS_DAT01.ORA
input datafile fno=00013 name=D:\ORACLE\ORADATA\SAMPLE\TEMP1_DAT01.ORA
input datafile fno=00008 name=D:\ORACLE\ORADATA\RAMANAN\TOOLS01.DBF
channel ORA_DISK_1: starting piece 1 at 20-MAY-08
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\ORADATA\RAMANAN\SYSTEM01.DBF
input datafile fno=00002 name=D:\ORACLE\ORADATA\RAMANAN\UNDOTBS01.DBF
input datafile fno=00016 name=D:\ORACLE\ORADATA\SAMPLE1\TSTMDMTBS_DAT01.ORA
input datafile fno=00005 name=D:\ORACLE\ORADATA\RAMANAN\EXAMPLE01.DBF
input datafile fno=00003 name=D:\ORACLE\ORADATA\RAMANAN\CWMLITE01.DBF
input datafile fno=00007 name=D:\ORACLE\ORADATA\RAMANAN\ODM01.DBF
input datafile fno=00012 name=D:\ORACLE\ORADATA\SAMPLETEMP1_DAT01.ORA
input datafile fno=00014 name=D:\ORACLE\ORADATA\SAMPLE\TEMPL_DAT01.ORA
input datafile fno=00019 name=D:\ORACLE\ORADATA\RAMANAN\RMAN01.DBF
channel ORA_DISK_2: starting piece 1 at 20-MAY-08
channel ORA_DISK_1: finished piece 1 at 20-MAY-08
piece handle=D:\ORACLE\ORABACKUP\ORA_DF655229996_S4_S1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:31
channel ORA_DISK_2: finished piece 1 at 20-MAY-08
piece handle=D:\ORACLE\ORABACKUP\ORA_DF655229997_S5_S1 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:02:25
Finished backup at 20-MAY-08

Starting backup at 20-MAY-08
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=115 recid=3 stamp=655230143
channel ORA_DISK_1: starting piece 1 at 20-MAY-08
channel ORA_DISK_1: finished piece 1 at 20-MAY-08
piece handle=D:\ORACLE\ORABACKUP\ORA_DF655230143_S6_S1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 20-MAY-08

Starting Control File and SPFILE Autobackup at 20-MAY-08
piece handle=D:\ORACLE\ORABACKUP\ORA_CFC-3720747608-20080520-00 comment=NONE
Finished Control File and SPFILE Autobackup at 20-MAY-08


Now it has been saved in the directory and then how can i again restore the backup any idea

Thanks,
Re: Reg RMAN Concept [message #321466 is a reply to message #321462] Tue, 20 May 2008 06:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
restore database;

But this is in the documentation you provided you and you refuse to reas it.
Oracle is not a toy you can use without reading the doc, just wasting others' time.

Regards
Michel
Re: Reg RMAN Concept [message #321496 is a reply to message #321466] Tue, 20 May 2008 08:19 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
While Restoring and Recovering the whole database backup
i get the following error

RMAN> run {
2>   shutdown immediate; # use abort if this fails
3>   startup mount;
4>   restore database;
5>   recover database;
6>   alter database open;
7> }

database closed
database dismounted
Oracle instance shut down

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area     135338868 bytes

Fixed Size                      453492 bytes
Variable Size                109051904 bytes
Database Buffers              25165824 bytes
Redo Buffers                    667648 bytes

Starting restore at 20-MAY-08

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/20/2008 18:46:16
RMAN-12010: automatic channel allocation initialization failed
RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connecte
d to ORACLE


pls note on this

Thanks,
Re: Reg RMAN Concept [message #321498 is a reply to message #321496] Tue, 20 May 2008 08:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
rman nocatalog target ...

Regards
Michel
Re: Reg RMAN Concept [message #321500 is a reply to message #321498] Tue, 20 May 2008 08:45 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
No its in catalog mode u could find the above message how i created the catalog and took whole database

Thanks,
Re: Reg RMAN Concept [message #321501 is a reply to message #321500] Tue, 20 May 2008 08:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"u" is not a member of this forum.
What is the state of your database? Do you have control file?

Regards
Michel
Re: Reg RMAN Concept [message #321655 is a reply to message #319216] Tue, 20 May 2008 23:41 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
Is it Possible to take backup and restore it for a specific Schema in a database, if means can u help regarding this

Thanks,
Re: Reg RMAN Concept [message #321664 is a reply to message #319216] Wed, 21 May 2008 00:13 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
When I tried to connect for a specific schema through RMAN,it throws following error

D:\>rman target system/simple@ramanan

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges


Thanks,
Re: Reg RMAN Concept [message #321669 is a reply to message #321205] Wed, 21 May 2008 00:28 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
Is it Possible to take backup and recovery using RMAN for a specific schema ,if means help on this but when i tried to connect RMAN for specific schema i got the following error


D:\>rman target system/simple@ramanan

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges


Thanks,
Re: Reg RMAN Concept [message #321670 is a reply to message #321655] Wed, 21 May 2008 00:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ram anand wrote on Wed, 21 May 2008 06:41
Hi,
Is it Possible to take backup and restore it for a specific Schema in a database, if means can u help regarding this

Thanks,


No. RMAN is physical backup/restore. Schema is a logical notion.

Regards
Michel
Re: Reg RMAN Concept [message #321671 is a reply to message #321664] Wed, 21 May 2008 00:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
rman target system/simple@ramanan

Only SYSDBA users can connect through RMAN.

Regards
Michel
Re: Reg RMAN Concept [message #321680 is a reply to message #321671] Wed, 21 May 2008 01:05 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
I have one question ,my question is
1.Can we login as SYSDBA and take backup for a specific schema
2.Is it possible to give a LOG file while taking backup of a whole database,if means pls tell me how its possible

Thanks,
Re: Reg RMAN Concept [message #321684 is a reply to message #321680] Wed, 21 May 2008 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I merged your topics then we will not have to answer twice to the same questions. By the way, thanks to give the same title to yuor topics then it is easier to find those to merge.

1. No
2. Yes, answer in the documentation we posted you.

Regards
Michel
Re: Reg RMAN Concept [message #321693 is a reply to message #321684] Wed, 21 May 2008 01:31 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
Thanks a lot for your reply's ,now i am working on RMAN with your documents and guides ,If any issue i get in touch with u

Thanks,
Re: Reg RMAN Concept [message #321839 is a reply to message #321684] Wed, 21 May 2008 08:11 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
I get the following error after taking backup while restoring and recovering the database using recovery catalog


D:\>rman target="sys/simple@ramanan" catalog="rmancat/rman@ramanan"

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: RAMANAN (DBID=3720747608)
connected to recovery catalog database

RMAN> run
2> {
3> shutdown immediate;
4> startup force mount;
5> restore database;
6> recover database;
7> alter database open;
8> }

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of shutdown command at 05/21/2008 18:40:39
RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connecte
d to ORACLE


pls note on this and guide me resolve the issue

I have questions on this

1.how to restore to the database using Catalog as mentioned above this message
2.when i exit from rman and again login into the rman with catalog recovery it shows the following error

D:\>rman target="sys/simple@ramanan" catalog="rmancat/rman@ramanan"

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: RAMANAN (DBID=3720747608)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-01033: ORACLE initializati
on or shutdown in progress


Thanks,

[Updated on: Wed, 21 May 2008 10:29]

Report message to a moderator

Re: Reg RMAN Concept [message #321986 is a reply to message #321684] Thu, 22 May 2008 01:08 Go to previous message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
I cannt able to restore the database in catalog mode after taking full backup i get following error


RMAN> startup force mount;

Oracle instance started
database mounted

Total System Global Area     135338868 bytes

Fixed Size                      453492 bytes
Variable Size                109051904 bytes
Database Buffers              25165824 bytes
Redo Buffers                    667648 bytes

RMAN> run
2> {
3> restore database;
4> recover database;
5> }

Starting restore at 22-MAY-08

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/22/2008 11:32:13
RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connecte
d to ORACLE


need possible help from u ,this could be my first experience in RMAN concept

Thanks,
Previous Topic: RMAN Confusion
Next Topic: how to pronounce 'RMAN'
Goto Forum:
  


Current Time: Sun Dec 04 00:30:43 CST 2016

Total time taken to generate the page: 0.16012 seconds