RMAN Backup Problem.

Printable View

06-18-2001, 10:21 AM
Diggers12

Hello I am trying to create an online backup of a database using RMAN in archivelog mode but I get the following error.

RMAN> RUN {
2> ALLOCATE CHANNEL CH1 TYPE DISK;
3> BACKUP DATABASE;
4> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
5> }

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: CH1
RMAN-08500: channel CH1: sid=10 devtype=DISK

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel CH1: starting full datafile backupset
RMAN-08502: set_count=3 set_stamp=432749787 creation_time=18-JUN-01
RMAN-08010: channel CH1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=00007 name=D:\ORACLEDATA\PCS_RT_INDXS.DBF
RMAN-08522: input datafile fno=00008 name=D:\ORACLEDATA\PCS_RT_DATA.DBF
RMAN-08522: input datafile fno=00010 name=D:\ORACLEDATA\PCS_CARE_INDXS.DBF
RMAN-08522: input datafile fno=00009 name=D:\ORACLEDATA\PCS_CARE_DATA.DBF
RMAN-08522: input datafile fno=00012 name=D:\ORACLEDATA\PCS_COMMON_INDXS.DBF
RMAN-08522: input datafile fno=00001 name=C:\ORACLE\ORA817\DATABASE\SYSPICIS.ORA
RMAN-08011: including current controlfile in backupset
RMAN-08522: input datafile fno=00002 name=C:\ORACLE\ORA817\DATABASE\PCS_TEMP01.DBF
RMAN-08522: input datafile fno=00011 name=D:\ORACLEDATA\PCS_COMMON_DATA.DBF
RMAN-08522: input datafile fno=00013 name=D:\ORACLEDATA\PCS_LABS_INDXS.DBF
RMAN-08522: input datafile fno=00014 name=D:\ORACLEDATA\PCS_LABS_DATA.DBF
RMAN-08522: input datafile fno=00015 name=D:\ORACLEDATA\PCS_PREOP_DATA.DBF
RMAN-08522: input datafile fno=00016 name=D:\ORACLEDATA\PCS_PREOP_INDXS.DBF
RMAN-08522: input datafile fno=00017 name=D:\ORACLEDATA\PCS_EXTERNAL_DATA.DBF
RMAN-08522: input datafile fno=00018 name=D:\ORACLEDATA\PCS_EXTERNAL_INDXS.DBF
RMAN-08522: input datafile fno=00019 name=D:\ORACLEDATA\RMANDATA01.DBF
RMAN-08522: input datafile fno=00003 name=C:\ORACLE\ORA817\DATABASE\PCS_RBS_01.DBF
RMAN-08522: input datafile fno=00004 name=C:\ORACLE\ORA817\DATABASE\PCS_RBS_02.DBF
RMAN-08522: input datafile fno=00005 name=C:\ORACLE\ORA817\DATABASE\PCS_RBS_03.DBF
RMAN-08522: input datafile fno=00006 name=C:\ORACLE\ORA817\DATABASE\PCS_RBS_04.DBF
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel CH1
RMAN-10035: exception raised in RPC: ORA-19504: failed to create file "03csmf6r_1_1
ORA-27044: unable to write the header block of file
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 112) There is not enough space on the disk.
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

Any ideas please?
06-18-2001, 10:26 AM
dknight

At the bottom of your printout:

O/S-Error: (OS 112) There is not enough space on the disk.
06-18-2001, 10:28 AM
Diggers12

I see that but on drive c: I have 1.4 gig of free space and on d: I have 3.5 gig.
06-18-2001, 10:34 AM
kgb

And what the size of your database?
Try to save your backup on D:\

RUN {
ALLOCATE CHANNEL CH1 TYPE DISK;
BACKUP
format='D:\temp\%t.%d.%s.%p'
DATABASE;
release channel CH1;
}

Quote:

Originally posted by Diggers12
I see that but on drive c: I have 1.4 gig of free space and on d: I have 3.5 gig.
06-18-2001, 11:05 AM
Diggers12

Thanks,

that worked, I got a backup file called 96T.96D.96S.96P. Now how do I restore thsi file. I tried with a script from the pracle manual and got the following.

RMAN> run {
2> allocate channel ch1 type disk;
3> restore database;
4> }

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: ch1
RMAN-08500: channel ch1: sid=10 devtype=DISK

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel ch1: starting datafile backupset restore
RMAN-08502: set_count=4 set_stamp=432750962 creation_time=18-JUN-01
RMAN-08089: channel ch1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00001 to C:\ORACLE\ORA817\DATABASE\SYSPICIS.ORA
RMAN-08523: restoring datafile 00002 to C:\ORACLE\ORA817\DATABASE\PCS_TEMP01.DBF
RMAN-08523: restoring datafile 00003 to C:\ORACLE\ORA817\DATABASE\PCS_RBS_01.DBF
RMAN-08523: restoring datafile 00004 to C:\ORACLE\ORA817\DATABASE\PCS_RBS_02.DBF
RMAN-08523: restoring datafile 00005 to C:\ORACLE\ORA817\DATABASE\PCS_RBS_03.DBF
RMAN-08523: restoring datafile 00006 to C:\ORACLE\ORA817\DATABASE\PCS_RBS_04.DBF
RMAN-08523: restoring datafile 00007 to D:\ORACLEDATA\PCS_RT_INDXS.DBF
RMAN-08523: restoring datafile 00008 to D:\ORACLEDATA\PCS_RT_DATA.DBF
RMAN-08523: restoring datafile 00009 to D:\ORACLEDATA\PCS_CARE_DATA.DBF
RMAN-08523: restoring datafile 00010 to D:\ORACLEDATA\PCS_CARE_INDXS.DBF
RMAN-08523: restoring datafile 00011 to D:\ORACLEDATA\PCS_COMMON_DATA.DBF
RMAN-08523: restoring datafile 00012 to D:\ORACLEDATA\PCS_COMMON_INDXS.DBF
RMAN-08523: restoring datafile 00013 to D:\ORACLEDATA\PCS_LABS_INDXS.DBF
RMAN-08523: restoring datafile 00014 to D:\ORACLEDATA\PCS_LABS_DATA.DBF
RMAN-08523: restoring datafile 00015 to D:\ORACLEDATA\PCS_PREOP_DATA.DBF
RMAN-08523: restoring datafile 00016 to D:\ORACLEDATA\PCS_PREOP_INDXS.DBF
RMAN-08523: restoring datafile 00017 to D:\ORACLEDATA\PCS_EXTERNAL_DATA.DBF
RMAN-08523: restoring datafile 00018 to D:\ORACLEDATA\PCS_EXTERNAL_INDXS.DBF
RMAN-08523: restoring datafile 00019 to D:\ORACLEDATA\RMANDATA01.DBF
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03006: non-retryable error occurred during execution of command: IRESTORE
RMAN-07004: unhandled exception during command execution on channel ch1
RMAN-10035: exception raised in RPC: ORA-19573: cannot obtain exclusive enqueue for datafile 7
RMAN-10031: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE

Any ideas, thanks
06-18-2001, 12:36 PM
kgb

1) mount database;
2) run {
allocate channel ch1 type disk;
restore database;
recover database;
sql 'ALTER DATABASE OPEN';
release channel ch1;
}
Best wishes!

Quote:

Originally posted by Diggers12
Thanks,
that worked, I got a backup file called 96T.96D.96S.96P. Now how do I restore thsi file. I tried with a script from the pracle manual and got the following.
RMAN> run {
2> allocate channel ch1 type disk;
3> restore database;
4> }
06-18-2001, 01:15 PM
Diggers12

Hi,

where do I mount the database from RMAN or svrmgr?

thanks
06-18-2001, 02:26 PM
sambavan

in the RMAN, issue

startup mount on your target database

i.e

startup mount pfile=$ORACLE_HOME/admin/SID/pfile/initSID.ora

Refer the below mentioned link for more details on learning how to do backup and recovery using RMAN.

http://technet.oracle.com/doc/oracle...a76990/toc.htm

Sam
06-19-2001, 12:23 PM
Diggers12

I have tried to enter the command you gave me but I get the following.

RMAN> startup mount PFILE=c:\oracle\ora817\database\init.PICIS.ora;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06171: not connected to target database
06-19-2001, 12:33 PM
kgb

Look that:

http://www.oradoc.com/ora817/server.817/a76993/toc.htm