Home » RDBMS Server » Backup & Recovery » Flash Recovery Area 9i (Oracle DB 9i,Windows2003)
Flash Recovery Area 9i [message #508479] Sun, 22 May 2011 00:20 Go to next message
Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt
Member

Hello guys,
I want to change backup location for Oracle 9i Database
there is no flash recovery area in 9i, so i want the parameter which i can use to modify backup location to anywhere i want.
Thank u in advance,
Regards,
Sami
Re: Flash Recovery Area 9i [message #508481 is a reply to message #508479] Sun, 22 May 2011 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 59122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
RMAN command CONFIGURE.

Regards
Michel

[Edit: Add link to doc]

[Updated on: Sun, 22 May 2011 01:05]

Report message to a moderator

Re: Flash Recovery Area 9i [message #508482 is a reply to message #508481] Sun, 22 May 2011 01:09 Go to previous messageGo to next message
Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt
Member

Thanks Michel
show all;
and that was the result :
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
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\10.2.0\TEST\DATABASE\S
NCFSOC.ORA'; # default

I could not find any backup locations here?

Re: Flash Recovery Area 9i [message #508483 is a reply to message #508482] Sun, 22 May 2011 01:27 Go to previous messageGo to next message
John Watson
Messages: 4557
Registered: January 2010
Location: Global Village
Senior Member
Quote:
I could not find any backup locations here?

THat's because you haven't configured any. Try

configure channel.....
Re: Flash Recovery Area 9i [message #508521 is a reply to message #508483] Sun, 22 May 2011 17:30 Go to previous message
Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt
Member

Thanks john
I configured it
Previous Topic: Redo Log Volume
Next Topic: RMAN recovery
Goto Forum:
  


Current Time: Thu Sep 18 02:53:39 CDT 2014

Total time taken to generate the page: 1.11477 seconds