Home » RDBMS Server » Backup & Recovery » where is the file in RMAN (oracle 9 )
where is the file in RMAN [message #423888] Tue, 29 September 2009 01:28 Go to next message
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 #423889 is a reply to message #423888] Tue, 29 September 2009 01:37 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

In 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;
Re: where is the file in RMAN [message #423910 is a reply to message #423889] Tue, 29 September 2009 04:04 Go to previous messageGo to next message
chuikingman
Messages: 90
Registered: August 2009
Member
Kamran Agayev wrote on Tue, 29 September 2009 14:37
In 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 #423912 is a reply to message #423888] Tue, 29 September 2009 04:09 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

You're not using binary spfile, so cann't backup it also

Try to backup datafile 3

RMAN>backup datafile 3;
Re: where is the file in RMAN [message #423921 is a reply to message #423912] Tue, 29 September 2009 05:01 Go to previous messageGo to next message
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 #423923 is a reply to message #423888] Tue, 29 September 2009 05:10 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

Because you're in NOARCHIVELOG mode. Switch to ARCHIVELOG mode

shutdown immediate
startup mount
alter database archivelog
alter database open

Then, connect to rman and take backup of that file
Re: where is the file in RMAN [message #424007 is a reply to message #423923] Tue, 29 September 2009 20:58 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: add sql_trace in rman instance
Next Topic: Rman recovery
Goto Forum:
  


Current Time: Sun Sep 25 09:28:01 CDT 2016

Total time taken to generate the page: 0.07938 seconds