| where is the file in RMAN [message #423888] |
Tue, 29 September 2009 01:28  |
chuikingman
Messages: 90
Registered: August 2009
|
Member |
|
|
Hi,
I have below configure for RMAN
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
RMAN configuration has no stored or default parameters
RMAN configuration has no stored or default parameters
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/9.2.0/dbs/snapcf_GCOTA.f'; # default
IT is set to disk .
So, where is the file stored , in which directory ?? how can I figure it out ???
|
|
|
|
|
|
| Re: where is the file in RMAN [message #423910 is a reply to message #423889] |
Tue, 29 September 2009 04:04  |
chuikingman
Messages: 90
Registered: August 2009
|
Member |
|
|
Kamran Agayev wrote on Tue, 29 September 2009 14:37In 10g, if you've configure Flash Recovery Area, then all backups will be craeted in that directory under specicif folder named with current date
But in 9i, if I'm not mistaken, default should be $ORACLE_HOME/dbs directory. You can try it by backing up spfile and then using list backup command to get information about backup location
RMAN>backup spfile;
RMAN>list backup;
Hi,
I try but fail ??any suggestion ???
[oracle@TSTgcota ~]$ rman target /
Recovery Manager: Release 9.2.0.7.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: GCOTA (DBID=541710963)
RMAN> backup spfile;
Starting backup at 29-SEP-09
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=10 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 09/29/2009 17:05:32
RMAN-06062: can not backup SPFILE because the instance was not started with SPFILE
RMAN>
|
|
|
|
|
|
| Re: where is the file in RMAN [message #423921 is a reply to message #423912] |
Tue, 29 September 2009 05:01 |
chuikingman
Messages: 90
Registered: August 2009
|
Member |
|
|
Hi,
I try but falure ??
Please advice .
RMAN> backup datafile 3;
Starting backup at 29-SEP-09
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=12 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/29/2009 18:01:46
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN>
|
|
|
|
|
|
| Re: where is the file in RMAN [message #424007 is a reply to message #423923] |
Tue, 29 September 2009 20:58 |
chuikingman
Messages: 90
Registered: August 2009
|
Member |
|
|
Hi,
So according below ,
the file stored in "/db/oradata2/GCOTA/TOOL_FRWK_001_00.dbf "
Is it right ???
--------------------------------------------
RMAN> backup datafile 3;
Starting backup at 30-SEP-09
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=10 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00003 name=/db/oradata2/GCOTA/TOOL_FRWK_001_00.dbf
channel ORA_DISK_1: starting piece 1 at 30-SEP-09
channel ORA_DISK_1: finished piece 1 at 30-SEP-09
piece handle=/opt/oracle/9.2.0/dbs/07kqhgav_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 30-SEP-09
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 64K DISK 00:00:06 30-SEP-09
BP Key: 1 Status: AVAILABLE Tag: TAG20090930T095647
Piece Name: /opt/oracle/9.2.0/dbs/07kqhgav_1_1
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 Full 18116072 30-SEP-09 /db/oradata2/GCOTA/TOOL_FRWK_001_00.dbf
|
|
|
|
| Re: where is the file in RMAN [message #424026 is a reply to message #423888] |
Tue, 29 September 2009 23:41 |
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
|
Senior Member |
|
|
NO
According to result file has been stored at
piece handle=/opt/oracle/9.2.0/dbs/07kqhgav_1_1 comment=NONE
In other words, file has stored at "dbs" folder in the $ORACLE_HOME
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
