Wikipedia

Search results

Copy_vs_Backup_controlfile

Copy_vs_Backup_controlfile

[odiadp202:oracle:CFOTRAC2]$ export ORACLE_SID=CFOTRAC2
[odiadp202:oracle:CFOTRAC2]$ rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Thu Oct 18 08:39:11 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: CFOTRAC (DBID=1919063961)

RMAN> copy current controlfile to '/database_backup/CFOTRAC_BACKUPS/20121017/c-CFOTRAC2-2148316285.cf';

Starting backup at 18-OCT-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1730 instance=CFOTRAC2 devtype=DISK
channel ORA_DISK_1: starting datafile copy
copying current control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/18/2012 08:39:24
ORA-01580: error creating control backup file /database_backup/CFOTRAC_BACKUPS/20121017/c-CFOTRAC2-2148316285.cf
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
Additional information: 1

RMAN> exit


Recovery Manager complete.
[odiadp202:oracle:CFOTRAC2]$ pwd
/database_backup/CFOTRAC_BACKUPS/20121017
[odiadp202:oracle:CFOTRAC2]$ ls -ltrh c-CFOTRAC2-2148316285.cf
ls: c-CFOTRAC2-2148316285.cf: No such file or directory
[odiadp202:oracle:CFOTRAC2]$ rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Thu Oct 18 08:39:47 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: CFOTRAC (DBID=1919063961)

RMAN> backup current controlfile format '/database_backup/CFOTRAC_BACKUPS/20121017/c-CFOTRAC2-2148316285.cf';

Starting backup at 18-OCT-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1847 instance=CFOTRAC2 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 18-OCT-12
channel ORA_DISK_1: finished piece 1 at 18-OCT-12
piece handle=/database_backup/CFOTRAC_BACKUPS/20121017/c-CFOTRAC2-2148316285.cf tag=TAG20121018T084037 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
Finished backup at 18-OCT-12

Starting Control File and SPFILE Autobackup at 18-OCT-12
piece handle=/app/oracle/product/10.2.0/dbs/c-1919063961-20121018-04 comment=NONE
Finished Control File and SPFILE Autobackup at 18-OCT-12

RMAN>

No comments:

Post a Comment