| Reg RMAN Concept (merged) [message #319197] |
Fri, 09 May 2008 05:36  |
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,
|
|
|
|
|
|
| Reg RMAN Concept [message #321122 is a reply to message #319197] |
Mon, 19 May 2008 02:46  |
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 #321211 is a reply to message #321205] |
Mon, 19 May 2008 07:55 |
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 #321456 is a reply to message #321381] |
Tue, 20 May 2008 05:45 |
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 #321462 is a reply to message #321459] |
Tue, 20 May 2008 06:01 |
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 #321496 is a reply to message #321466] |
Tue, 20 May 2008 08:19 |
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 #321655 is a reply to message #319216] |
Tue, 20 May 2008 23:41 |
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 |
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 |
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 #321680 is a reply to message #321671] |
Wed, 21 May 2008 01:05 |
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 #321693 is a reply to message #321684] |
Wed, 21 May 2008 01:31 |
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 |
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 |
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,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
