-
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?
-
At the bottom of your printout:
O/S-Error: (OS 112) There is not enough space on the disk.
David Knight
OCP DBA 8i, 9i, 10g
-
I see that but on drive c: I have 1.4 gig of free space and on d: I have 3.5 gig.
-
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;
}
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.
-
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
-
1) mount database;
2) run {
allocate channel ch1 type disk;
restore database;
recover database;
sql 'ALTER DATABASE OPEN';
release channel ch1;
}
Best wishes!
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> }
-
Hi,
where do I mount the database from RMAN or svrmgr?
thanks
-
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
Thanx
Sam
Life is a journey, not a destination!
-
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
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|