HOT BACKUP and COLD BACKUP

HOT BACKUP and COLD BACKUP

HOT Backup:= without shutiing down DB we can do this

Alter tablespace users begin backup;
---copy datafiles on OS level

Alter tablespace users end backup;


select file_name from dba_data_file where table_space_name='USERS';

ALTER TABLESPACE USERS BEGIN BACKUP;
HOST
copy src dest
alter tablespace users end backup;


COLD BACKUP:= shutdown db first

select file_name from dba_data_files;
select 'cp'::filename ::'c:\oracle\pro\admin\ from dba_data_files;
set lines 130

spool mycopy.bat/
spool off

Help link in not working in Peoplesoft

Help link in not working :-

If help link is not working..Then navigate to peopletool --> Web Profile --> Web Profile configuration

and in place of URL place it in below format


http://webservername:port/PSOL/htmldoc/f1search.htm?ContextID=%CONTEXT_ID%&LangCD=%LANG_CD%

After which Bounce webservices and clear cache

Find the database/data files growth on a yearly basis

SQL> select name from v$database;

NAME
---------
RMPRD

SQL> select to_char(CREATION_TIME,'RRRR') year,to_char(CREATION_TIME,'MM') month,round(sum(bytes)/1024/1024/1024) gb
  2  from v$datafile group by to_char(CREATION_TIME,'RRRR'),to_char(CREATION_TIME,'MM') order by 1,2;

YEAR MO         GB
---- -- ----------
2011 03        196
2012 08          3
2013 03         94
2013 04          0
2013 08         22
2013 10         32
2014 01         11
2014 02          1

8 rows selected.

SQL>
-----------------------------------------------------
SQL> select name from v$database;

NAME
---------
FSPRD

SQL> select to_char(CREATION_TIME,'RRRR') year,to_char(CREATION_TIME,'MM') month,round(sum(bytes)/1024/1024/1024) gb
  2  from v$datafile group by to_char(CREATION_TIME,'RRRR'),to_char(CREATION_TIME,'MM') order by 1,2;

YEAR MO         GB
---- -- ----------
2009 06        548
2010 01         12
2010 04         15
2010 06         15
2010 09          9
2010 12         42
2011 05         12
2011 09         25
2011 12          6
2012 04         15
2012 05         19

YEAR MO         GB
---- -- ----------
2012 07         83
2012 09          2
2012 10         20
2013 07         28
2013 10        211
2014 01          2

17 rows selected.

SQL>
---------------------------------------------------------
SQL> select name from v$database;

NAME
---------
HRPRD

SQL> select to_char(CREATION_TIME,'RRRR') year,to_char(CREATION_TIME,'MM') month,round(sum(bytes)/1024/1024/1024) gb
  2  from v$datafile group by to_char(CREATION_TIME,'RRRR'),to_char(CREATION_TIME,'MM') order by 1,2;

YEAR MO         GB
---- -- ----------
2009 06        138
2013 05          0
2013 11          0

SQL>

IB issue fix today :-

we need to keep password for gateway which we use for administrator ID in advance properties in Encrypted form.it fixes so much of issue.

Start the refresh of environment with Back up of Production at particular time.

alter session set nls_date_format='YYYY-MM-DD:HH24:MI:SS';

select * from v$archived_log order by next_time desc